Elasticsearch

elastic search endpoint url https //api coresignal com/cdapi/v2/member/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 find employee records of john smith first example curl x 'post' \\ 'https //api coresignal com/cdapi/v2/member/search/es dsl?version=1' \\ h 'accept application/json' \\ h 'apikey {api key}' \\ h 'content type application/json' \\ d '{ "query" { "match" { "name" { "query" "john smith", "operator" "and" } } } }' find developers in germany second example curl x 'post' \\ 'https //api coresignal com/cdapi/v2/member/search/es dsl?version=1' \\ h 'accept application/json' \\ h 'apikey {api key}' \\ h 'content type application/json' \\ d '{ "query" { "bool" { "must" \[ { "match" { "title" { "query" "developer", "operator" "and" } } }, { "match" { "location" { "query" "germany", "operator" "and" } } } ] } } }' find developers in the united states working at it company third example curl x 'post' \\ 'https //api coresignal com/cdapi/v2/member/search/es dsl?version=1' \\ h 'accept application/json' \\ h 'apikey {api key}' \\ 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" } } ] } } } } ] } } }' find anything related to python fourth example curl x 'post' \\ 'https //api coresignal com/cdapi/v2/member/search/es dsl?version=1' \\ h 'accept application/json' \\ h 'apikey {api key}' \\ 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" } } ] } } } } ] } } }' f ind former employees of a s pecific company ( id 9073671) who ended their employment between january 2023 to april 2023 fifth example curl x 'post' \\ 'https //api coresignal com/cdapi/v2/member/search/es dsl?version=1' \\ h 'accept application/json' \\ h 'apikey {api key}' \\ 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" } } ] } } } } ] } } }' find active employees sixth example curl x 'post' \\ 'https //api coresignal com/cdapi/v2/member/search/es dsl?version=1' \\ h 'accept application/json' \\ h 'apikey {api key}' \\ 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" } } ] } } } } }' find founders of a specific company ( id 9073671 ) seventh example curl x 'post' \\ 'https //api coresignal com/cdapi/v2/member/search/es dsl?version=1' \\ h 'accept application/json' \\ h 'apikey {api key}' \\ 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" } } ] } } } } }' find records with a specific job title using regexp values eight example curl x 'post' \\ 'https //api coresignal com/cdapi/v2/member/search/es dsl?version=1' \\ h 'accept application/json' \\ h 'apikey {api key}' \\ 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" } } ] } } } } ] } } }' find apple employees who are not in c level positions ninth example curl x 'post' \\ 'https //api coresignal com/cdapi/v2/member/search/es dsl?version=1' \\ h 'accept application/json' \\ h 'apikey {api key}' \\ 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" } } } ] } } } } ] } } }' f ind a profile of john doe, who is based in the united kingdom , with previous/current experience working for it company between august 2018 and december 2021 tenth example curl x 'post' \\ 'https //api coresignal com/cdapi/v2/member/search/es dsl?version=1' \\ h 'accept application/json' \\ h 'apikey {api key}' \\ 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" } } } ] } } } } ] } } }'