Elasticsearch

7min
Elasticsearch endpoint URL: https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl.
Overview
Unsure how to write a search request? This article contains several request examples you can refer to. 
cURL examples
All personal/company information mentioned within this context is entirely fictional and is solely intended for illustrative purposes.
First example
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
   "query":{
      "match":{
         "name":{
            "query":"John Smith",
            "operator":"and"
         }
      }
   }
}'
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
   "query":{
      "match":{
         "name":{
            "query":"John Smith",
            "operator":"and"
         }
      }
   }
}'
﻿
Second example
curl -X 'POST' \
  'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
   "query": {
      "bool": {
         "must": [
            {
               "match": {
                  "title": {
                     "query": "Developer",
                     "operator": "and"
                  }
               }
            },
            {
               "match": {
                  "location": {
                     "query": "Germany",
                     "operator": "and"
                  }
               }
            }
         ]
      }
   }
}'
curl -X 'POST' \
  'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
   "query": {
      "bool": {
         "must": [
            {
               "match": {
                  "title": {
                     "query": "Developer",
                     "operator": "and"
                  }
               }
            },
            {
               "match": {
                  "location": {
                     "query": "Germany",
                     "operator": "and"
                  }
               }
            }
         ]
      }
   }
}'
﻿
Third example
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
   "query": {
      "bool": {
         "must": [
            {
               "match": {
                  "title": {
                     "query": "Developer",
                     "operator": "and"
                  }
               }
            },
            {
               "match": {
                  "location": {
                     "query": "United States",
                     "operator": "and"
                  }
               }
            },
            {
               "nested": {
                  "path": "member_experience_collection",
                  "query": {
                     "bool": {
                        "must": [
                           {
                              "query_string": {
                                 "query": "IT Company",
                                 "default_field": "member_experience_collection.company_name",
                                 "default_operator": "and"
                              }
                           }
                        ]
                     }
                  }
               }
            }
         ]
      }
   }
}'
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
   "query": {
      "bool": {
         "must": [
            {
               "match": {
                  "title": {
                     "query": "Developer",
                     "operator": "and"
                  }
               }
            },
            {
               "match": {
                  "location": {
                     "query": "United States",
                     "operator": "and"
                  }
               }
            },
            {
               "nested": {
                  "path": "member_experience_collection",
                  "query": {
                     "bool": {
                        "must": [
                           {
                              "query_string": {
                                 "query": "IT Company",
                                 "default_field": "member_experience_collection.company_name",
                                 "default_operator": "and"
                              }
                           }
                        ]
                     }
                  }
               }
            }
         ]
      }
   }
}'
﻿
Fourth example
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
   "query":{
      "bool":{
         "should":[
            {
               "query_string":{
                  "query":"Python",
                  "default_field":"summary",
                  "default_operator":"and"
               }
            },
            {
               "query_string":{
                  "query":"Python",
                  "default_field":"industry",
                  "default_operator":"and"
               }
            },
            {
               "nested":{
                  "path":"member_experience_collection",
                  "query":{
                     "bool":{
                        "should":[
                           {
                              "query_string":{
                                 "query":"Python",
                                 "default_field":"member_experience_collection.description",
                                 "default_operator":"and"
                              }
                           },
                           {
                              "query_string":{
                                 "query":"Python",
                                 "default_field":"member_experience_collection.title",
                                 "default_operator":"and"
                              }
                           }
                        ]
                     }
                  }
               }
            },
            {
               "nested":{
                  "path":"member_skills_collection",
                  "query":{
                     "bool":{
                        "should":[
                           {
                              "query_string":{
                                 "query":"Python",
                                 "default_field":"member_skills_collection.member_skill_list.skill",
                                 "default_operator":"and"
                              }
                           }
                        ]
                     }
                  }
               }
            }
         ]
      }
   }
}'
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
   "query":{
      "bool":{
         "should":[
            {
               "query_string":{
                  "query":"Python",
                  "default_field":"summary",
                  "default_operator":"and"
               }
            },
            {
               "query_string":{
                  "query":"Python",
                  "default_field":"industry",
                  "default_operator":"and"
               }
            },
            {
               "nested":{
                  "path":"member_experience_collection",
                  "query":{
                     "bool":{
                        "should":[
                           {
                              "query_string":{
                                 "query":"Python",
                                 "default_field":"member_experience_collection.description",
                                 "default_operator":"and"
                              }
                           },
                           {
                              "query_string":{
                                 "query":"Python",
                                 "default_field":"member_experience_collection.title",
                                 "default_operator":"and"
                              }
                           }
                        ]
                     }
                  }
               }
            },
            {
               "nested":{
                  "path":"member_skills_collection",
                  "query":{
                     "bool":{
                        "should":[
                           {
                              "query_string":{
                                 "query":"Python",
                                 "default_field":"member_skills_collection.member_skill_list.skill",
                                 "default_operator":"and"
                              }
                           }
                        ]
                     }
                  }
               }
            }
         ]
      }
   }
}'
﻿
Fifth example
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
    "query": {
        "bool": {
            "must": [
                {
                    "nested": {
                        "path": "member_experience_collection",
                        "query": {
                            "bool": {
                                "must": [
                                    {
                                        "range": {
                                            "member_experience_collection.date_to": {
                                                "gt": "January 2022",
                                                "lt": "April 2023"
                                            }
                                        }
                                    }
                                ]
                            }
                        }
                    }
                },
                {
                    "nested": {
                        "path": "member_experience_collection",
                        "query": {
                            "bool": {
                                "must": [
                                    {
                                        "query_string": {
                                            "query": "9073671",
                                            "default_field": "member_experience_collection.company_id",
                                            "default_operator": "and"
                                        }
                                    }
                                ]
                            }
                        }
                    }
                }
            ]
        }
    }
}'
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
    "query": {
        "bool": {
            "must": [
                {
                    "nested": {
                        "path": "member_experience_collection",
                        "query": {
                            "bool": {
                                "must": [
                                    {
                                        "range": {
                                            "member_experience_collection.date_to": {
                                                "gt": "January 2022",
                                                "lt": "April 2023"
                                            }
                                        }
                                    }
                                ]
                            }
                        }
                    }
                },
                {
                    "nested": {
                        "path": "member_experience_collection",
                        "query": {
                            "bool": {
                                "must": [
                                    {
                                        "query_string": {
                                            "query": "9073671",
                                            "default_field": "member_experience_collection.company_id",
                                            "default_operator": "and"
                                        }
                                    }
                                ]
                            }
                        }
                    }
                }
            ]
        }
    }
}'
﻿
Sixth example
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
    "query": {
        "nested": {
            "path": "member_experience_collection",
            "query": {
                "bool": {
                    "must": [
                        {
                            "query_string": {
                                "query": "0",
                                "default_field": "member_experience_collection.deleted",
                                "default_operator": "and"
                            }
                        },
                        {
                            "query_string": {
                                "query": 1000,
                                "default_field": "member_experience_collection.date_to",
                                "default_operator": "and"
                            }
                        }
                    ]
                }
            }
        }
    }
}'
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
    "query": {
        "nested": {
            "path": "member_experience_collection",
            "query": {
                "bool": {
                    "must": [
                        {
                            "query_string": {
                                "query": "0",
                                "default_field": "member_experience_collection.deleted",
                                "default_operator": "and"
                            }
                        },
                        {
                            "query_string": {
                                "query": 1000,
                                "default_field": "member_experience_collection.date_to",
                                "default_operator": "and"
                            }
                        }
                    ]
                }
            }
        }
    }
}'
﻿
Seventh example
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
    "query": {
        "nested": {
            "path": "member_experience_collection",
            "query": {
                "bool": {
                    "must": [
                        {
                            "query_string": {
                                "query": 9073671,
                                "default_field": "member_experience_collection.company_id",
                                "default_operator": "and"
                            }
                        },
                        {
                            "query_string": {
                                "query": "Founder",
                                "default_field": "member_experience_collection.title",
                                "default_operator": "and"
                            }
                        },
                        {
                            "query_string": {
                                "query": "0",
                                "default_field": "member_experience_collection.deleted",
                                "default_operator": "and"
                            }
                        },
                        {
                            "query_string": {
                                "query": 1000,
                                "default_field": "member_experience_collection.date_to",
                                "default_operator": "and"
                            }
                        }
                    ]
                }
            }
        }
    }
}'
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
    "query": {
        "nested": {
            "path": "member_experience_collection",
            "query": {
                "bool": {
                    "must": [
                        {
                            "query_string": {
                                "query": 9073671,
                                "default_field": "member_experience_collection.company_id",
                                "default_operator": "and"
                            }
                        },
                        {
                            "query_string": {
                                "query": "Founder",
                                "default_field": "member_experience_collection.title",
                                "default_operator": "and"
                            }
                        },
                        {
                            "query_string": {
                                "query": "0",
                                "default_field": "member_experience_collection.deleted",
                                "default_operator": "and"
                            }
                        },
                        {
                            "query_string": {
                                "query": 1000,
                                "default_field": "member_experience_collection.date_to",
                                "default_operator": "and"
                            }
                        }
                    ]
                }
            }
        }
    }
}'
﻿
Eight example
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "member_experience_collection",
            "query": {
              "bool": {
                "must": [
                  {
                    "query_string": {
                      "query": 9422343,
                      "default_field": "member_experience_collection.company_id",
                      "default_operator": "and"
                    }
                  },
                  {
                    "regexp": {
                      "member_experience_collection.title": {
                        "value": "founder", 
                        "case_insensitive": true
                      }
                    }
                  },
                  {
                    "regexp": {
                      "member_experience_collection.title": {
                        "value": "ceo", 
                        "case_insensitive": true
                      }
                    }
                  },
                  {
                    "query_string": {
                      "query": 0,
                      "default_field": "member_experience_collection.deleted",
                      "default_operator": "and"
                    }
                  },
                  {
                    "query_string": {
                      "query": "1000",
                      "default_field": "member_experience_collection.date_to",
                      "default_operator": "and"
                    }
                  }
                ]
              }
            }
          }
        }
      ]
    }
  }
}'
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "member_experience_collection",
            "query": {
              "bool": {
                "must": [
                  {
                    "query_string": {
                      "query": 9422343,
                      "default_field": "member_experience_collection.company_id",
                      "default_operator": "and"
                    }
                  },
                  {
                    "regexp": {
                      "member_experience_collection.title": {
                        "value": "founder", 
                        "case_insensitive": true
                      }
                    }
                  },
                  {
                    "regexp": {
                      "member_experience_collection.title": {
                        "value": "ceo", 
                        "case_insensitive": true
                      }
                    }
                  },
                  {
                    "query_string": {
                      "query": 0,
                      "default_field": "member_experience_collection.deleted",
                      "default_operator": "and"
                    }
                  },
                  {
                    "query_string": {
                      "query": "1000",
                      "default_field": "member_experience_collection.date_to",
                      "default_operator": "and"
                    }
                  }
                ]
              }
            }
          }
        }
      ]
    }
  }
}'
﻿
Ninth example
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
    "query": {
        "bool": {
            "must": [
                {
                    "query_string": {
                        "query": "(United States) OR USA",
                        "default_field": "country",
                        "default_operator": "and"
                    }
                },
                {
                    "nested": {
                        "path": "member_experience_collection",
                        "query": {
                            "bool": {
                                "must": [
                                    {
                                        "bool": {
                                            "must_not": [
                                                {
                                                    "query_string": {
                                                        "query": "Owner OR Founder OR CEO OR (Chief Executive Officer) OR CFO OR (Chief Financial Officer) OR President OR COO OR (Chief Operating Officer) OR CIO OR (Chief Information Officer) OR CTO OR (Chief Technology Officer) OR CPO OR (Chief People Officer) OR CHRO OR (Chief Human Resources Officer) OR (Vice President Human Resources)",
                                                        "default_field": "member_experience_collection.title",
                                                        "default_operator": "and"
                                                    }
                                                }
                                            ]
                                        }
                                    },
                                    {
                                        "query_string": {
                                            "query": "IT Company",
                                            "default_field": "member_experience_collection.company_url_shorthand_name",
                                            "default_operator": "and"
                                        }
                                    },
                                    {
                                        "query_string": {
                                            "query": 1000,
                                            "default_field": "member_experience_collection.date_to",
                                            "default_operator": "and"
                                        }
                                    },
                                    {
                                        "match": {
                                            "member_experience_collection.deleted": {
                                                "query": "0"
                                            }
                                        }
                                    },
                                    {
                                        "range": {
                                            "member_experience_collection.date_from": {
                                                "gte": "1001"
                                            }
                                        }
                                    }
                                ]
                            }
                        }
                    }
                }
            ]
        }
    }
}'
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{
    "query": {
        "bool": {
            "must": [
                {
                    "query_string": {
                        "query": "(United States) OR USA",
                        "default_field": "country",
                        "default_operator": "and"
                    }
                },
                {
                    "nested": {
                        "path": "member_experience_collection",
                        "query": {
                            "bool": {
                                "must": [
                                    {
                                        "bool": {
                                            "must_not": [
                                                {
                                                    "query_string": {
                                                        "query": "Owner OR Founder OR CEO OR (Chief Executive Officer) OR CFO OR (Chief Financial Officer) OR President OR COO OR (Chief Operating Officer) OR CIO OR (Chief Information Officer) OR CTO OR (Chief Technology Officer) OR CPO OR (Chief People Officer) OR CHRO OR (Chief Human Resources Officer) OR (Vice President Human Resources)",
                                                        "default_field": "member_experience_collection.title",
                                                        "default_operator": "and"
                                                    }
                                                }
                                            ]
                                        }
                                    },
                                    {
                                        "query_string": {
                                            "query": "IT Company",
                                            "default_field": "member_experience_collection.company_url_shorthand_name",
                                            "default_operator": "and"
                                        }
                                    },
                                    {
                                        "query_string": {
                                            "query": 1000,
                                            "default_field": "member_experience_collection.date_to",
                                            "default_operator": "and"
                                        }
                                    },
                                    {
                                        "match": {
                                            "member_experience_collection.deleted": {
                                                "query": "0"
                                            }
                                        }
                                    },
                                    {
                                        "range": {
                                            "member_experience_collection.date_from": {
                                                "gte": "1001"
                                            }
                                        }
                                    }
                                ]
                            }
                        }
                    }
                }
            ]
        }
    }
}'
﻿
Tenth example
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{   
"query": {
        "bool": {
            "must": [
                {
                    "match": {
                        "name": {
                            "query": "John Doe",
                            "operator": "and"
                        }
                    }
                },
                {
                    "match": {
                        "location": {
                            "query": "United Kingdom",
                            "operator": "and"
                        }
                    }
                },
                {
                    "nested": {
                        "path": "member_experience_collection",
                        "query": {
                            "bool": {
                                "must": [
                                    {
                                        "query_string": {
                                            "query": "IT Company",
                                            "default_field": "member_experience_collection.company_name",
                                            "default_operator": "and"
                                        }
                                    },
                                    {
                                        "query_string": {
                                            "query": 0,
                                            "default_field": "member_experience_collection.deleted",
                                            "default_operator": "and"
                                        }
                                    },
                                    {
                                        "range": {
                                            "member_experience_collection.date_from": {
                                                "gte": "August 2018"
                                            }
                                        }
                                    },
                                    {
                                        "range": {
                                            "member_experience_collection.date_to": {
                                                "lte": "December 2021"
                                            }
                                        }
                                    }
                                ]
                            }
                        }
                    }
                }
            ]
        }
    }
}'
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v1/professional_network/employee/search/es_dsl?version=1' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer {JWT}' \
  -H 'Content-Type: application/json' \
  -d '{   
"query": {
        "bool": {
            "must": [
                {
                    "match": {
                        "name": {
                            "query": "John Doe",
                            "operator": "and"
                        }
                    }
                },
                {
                    "match": {
                        "location": {
                            "query": "United Kingdom",
                            "operator": "and"
                        }
                    }
                },
                {
                    "nested": {
                        "path": "member_experience_collection",
                        "query": {
                            "bool": {
                                "must": [
                                    {
                                        "query_string": {
                                            "query": "IT Company",
                                            "default_field": "member_experience_collection.company_name",
                                            "default_operator": "and"
                                        }
                                    },
                                    {
                                        "query_string": {
                                            "query": 0,
                                            "default_field": "member_experience_collection.deleted",
                                            "default_operator": "and"
                                        }
                                    },
                                    {
                                        "range": {
                                            "member_experience_collection.date_from": {
                                                "gte": "August 2018"
                                            }
                                        }
                                    },
                                    {
                                        "range": {
                                            "member_experience_collection.date_to": {
                                                "lte": "December 2021"
                                            }
                                        }
                                    }
                                ]
                            }
                        }
                    }
                }
            ]
        }
    }
}'
﻿
﻿
Updated 04 Nov 2024
Did this page help you?
Search Filters
Collect