Elasticsearch DSL

data type employee (multi source) query type elasticsearch domain specific language (es dsl) url https //api coresignal com/cdapi /v2/employee multi source/search/es dsl overview use the /v2/employee multi source/search/es dsl endpoint to find company data matching your specifications elasticsearch schema allows you to use more sophisticated queries like fuzzy and wildcard queries additionally, the endpoint allows you to operate filters that mimic our multi source data elasticsearch dsl docid\ qzmazc 0jhe 7mxzxgxlr refer to the multi source elasticsearch schema elasticsearch dsl docid\ qzmazc 0jhe 7mxzxgxlr information about possible sorting options elasticsearch dsl docid\ qzmazc 0jhe 7mxzxgxlr information about the endpoint limitations elasticsearch schema data dictionary multi source employee api docid\ hlhfj7rhi6exxwv1bpl95 see the data points available in our multi source employee api response codes docid\ nvms2ixhof8gd7xbwxj6e see the list of possible error codes elasticsearch structure maps directly to our multi source employee data points endpoint schema { "mappings" { "properties" { "id" { "type" "long" }, "parent id" { "type" "long" }, "created at" { "type" "date" }, "updated at" { "type" "date" }, "checked at" { "type" "date" }, "changed at" { "type" "date" }, "experience change last identified at" { "type" "date" }, "is deleted" { "type" "byte" }, "is parent" { "type" "byte" }, "public profile id" { "type" "long" }, "professional network url" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "professional network shorthand names" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "historical ids" { "type" "text" }, "full name" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "first name" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "first name initial" { "type" "keyword", "index" false, "doc values" false }, "middle name" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "middle name initial" { "type" "keyword", "index" false, "doc values" false }, "last name" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "last name initial" { "type" "keyword", "index" false, "doc values" false }, "headline" { "type" "text" }, "summary" { "type" "text" }, "picture url" { "type" "keyword", "index" false, "doc values" false }, "location country" { "type" "keyword", "null value" "null" }, "location country iso2" { "type" "keyword", "null value" "null" }, "location country iso3" { "type" "keyword", "null value" "null" }, "location full" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "location regions" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "interests" { "type" "text" }, "inferred skills" { "type" "text" }, "historical skills" { "type" "text" }, "connections count" { "type" "long" }, "followers count" { "type" "long" }, "services" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "primary professional email" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "primary professional email status" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "professional emails collection" { "type" "nested", "properties" { "professional email" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "professional email status" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "order of priority" { "type" "short" } } }, "is working" { "type" "byte" }, "active experience company id" { "type" "long" }, "active experience title" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "active experience description" { "type" "text" }, "active experience department" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "active experience management level" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "is decision maker" { "type" "byte" }, "total experience duration months" { "type" "long" }, "total experience duration months breakdown department" { "type" "nested", "properties" { "department" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "total experience duration months" { "type" "long" } } }, "total experience duration months breakdown management level" { "type" "nested", "properties" { "management level" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "total experience duration months" { "type" "long" } } }, "experience" { "type" "nested", "properties" { "active experience" { "type" "byte" }, "position title" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "department" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "management level" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "location" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "description" { "type" "text" }, "date from" { "type" "date", "format" "mmmm uuuu||uuuu", "locale" "en", "ignore malformed" true }, "date from year" { "type" "short" }, "date from month" { "type" "byte" }, "date to" { "type" "date", "format" "mmmm uuuu||uuuu", "locale" "en", "ignore malformed" true }, "date to year" { "type" "short" }, "date to month" { "type" "byte" }, "duration months" { "type" "short" }, "company id" { "type" "long" }, "company name" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "company type" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "company founded year" { "type" "short" }, "company followers count" { "type" "long" }, "company website" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" }, "domain only" { "type" "text" } } }, "company facebook url" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "company twitter url" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "company professional network url" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "company size range" { "type" "keyword", "null value" "null" }, "company employees count" { "type" "long" }, "company industry" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "company categories and keywords" { "type" "text" }, "company annual revenue source 5" { "type" "long" }, "company annual revenue currency source 5" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "company annual revenue source 1" { "type" "double" }, "company annual revenue currency source 1" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "company employees count change yearly percentage" { "type" "double" }, "company last funding round date" { "type" "date" }, "company last funding round amount raised" { "type" "long" }, "company hq full address" { "type" "text" }, "company hq country" { "type" "keyword" }, "company hq regions" { "type" "text" }, "company hq country iso2" { "type" "keyword" }, "company hq country iso3" { "type" "keyword" }, "company hq city" { "type" "text" }, "company hq state" { "type" "text" }, "company hq street" { "type" "text" }, "company hq zipcode" { "type" "text" }, "company last updated at" { "type" "date" }, "company stock ticker" { "type" "nested", "properties" { "exchange" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "ticker" { "type" "keyword" } } }, "company is b2b" { "type" "byte" }, "order in profile" { "type" "integer" } } }, "projected base salary p25" { "type" "double", "index" false, "doc values" false }, "projected base salary median" { "type" "double", "index" false, "doc values" false }, "projected base salary p75" { "type" "double", "index" false, "doc values" false }, "projected base salary period" { "type" "keyword", "index" false, "doc values" false }, "projected base salary currency" { "type" "keyword", "index" false, "doc values" false }, "projected base salary updated at" { "type" "date", "index" false, "doc values" false }, "projected additional salary" { "type" "nested", "properties" { "projected additional salary type" { "type" "keyword", "index" false, "doc values" false }, "projected additional salary p25" { "type" "double", "index" false, "doc values" false }, "projected additional salary median" { "type" "double", "index" false, "doc values" false }, "projected additional salary p75" { "type" "double", "index" false, "doc values" false } } }, "projected additional salary period" { "type" "keyword", "index" false, "doc values" false }, "projected additional salary currency" { "type" "keyword", "index" false, "doc values" false }, "projected additional salary updated at" { "type" "date", "index" false, "doc values" false }, "projected total salary p25" { "type" "double", "index" false, "doc values" false }, "projected total salary median" { "type" "double", "index" false, "doc values" false }, "projected total salary p75" { "type" "double", "index" false, "doc values" false }, "projected total salary period" { "type" "keyword", "index" false, "doc values" false }, "projected total salary currency" { "type" "keyword", "index" false, "doc values" false }, "projected total salary updated at" { "type" "date", "index" false, "doc values" false }, "last graduation date" { "type" "short" }, "education degrees" { "type" "text" }, "education" { "type" "nested", "properties" { "degree" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "description" { "type" "text" }, "institution url" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" }, "domain only" { "type" "text" } } }, "institution name" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "institution full address" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "institution country iso2" { "type" "keyword" }, "institution country iso3" { "type" "keyword" }, "institution regions" { "type" "text" }, "institution city" { "type" "text" }, "institution state" { "type" "text" }, "institution street" { "type" "text" }, "institution zipcode" { "type" "text" }, "date from year" { "type" "short" }, "date to year" { "type" "short" }, "activities and societies" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "order in profile" { "type" "integer" } } }, "recommendations count" { "type" "long" }, "recommendations" { "type" "nested", "properties" { "recommendation" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "referee full name" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "referee url" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" }, "domain only" { "type" "text" } } }, "order in profile" { "type" "integer" } } }, "activity" { "type" "nested", "properties" { "activity url" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" }, "domain only" { "type" "text" } } }, "title" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "action" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "order in profile" { "type" "integer" } } }, "awards" { "type" "nested", "properties" { "title" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "issuer" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "description" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "date" { "type" "date", "format" "mmmm uuuu||uuuu", "locale" "en", "ignore malformed" true }, "date year" { "type" "integer" }, "date month" { "type" "integer" }, "order in profile" { "type" "integer" } } }, "courses" { "type" "nested", "properties" { "organizer" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "title" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "order in profile" { "type" "integer" } } }, "certifications" { "type" "nested", "properties" { "title" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "issuer" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "issuer url" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" }, "domain only" { "type" "text" } } }, "credential id" { "type" "keyword" }, "certificate url" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" }, "domain only" { "type" "text" } } }, "date from" { "type" "date", "format" "mmmm uuuu||uuuu", "locale" "en", "ignore malformed" true }, "date from year" { "type" "integer" }, "date from month" { "type" "integer" }, "date to" { "type" "date", "format" "mmmm uuuu||uuuu", "locale" "en", "ignore malformed" true }, "date to year" { "type" "integer" }, "date to month" { "type" "integer" }, "order in profile" { "type" "integer" } } }, "languages" { "type" "nested", "properties" { "language" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "proficiency" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "order in profile" { "type" "integer" } } }, "patents count" { "type" "long" }, "patents topics" { "type" "text" }, "patents" { "type" "nested", "properties" { "title" { "type" "text" }, "status" { "type" "text" }, "description" { "type" "text" }, "patent url" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" }, "domain only" { "type" "text" } } }, "date" { "type" "date", "format" "mmmm uuuu||uuuu", "locale" "en", "ignore malformed" true }, "date year" { "type" "short" }, "date month" { "type" "byte" }, "patent number" { "type" "keyword" }, "order in profile" { "type" "integer" } } }, "publications count" { "type" "long" }, "publications topics" { "type" "text" }, "publications" { "type" "nested", "properties" { "title" { "type" "text" }, "description" { "type" "text" }, "publication url" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" }, "domain only" { "type" "text" } } }, "publisher names" { "type" "text" }, "date" { "type" "date", "format" "mmmm uuuu||uuuu", "locale" "en", "ignore malformed" true }, "date year" { "type" "short" }, "date month" { "type" "short" }, "order in profile" { "type" "long" } } }, "projects count" { "type" "long" }, "projects topics" { "type" "text" }, "projects" { "type" "nested", "properties" { "name" { "type" "text" }, "description" { "type" "text" }, "project url" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" }, "domain only" { "type" "text" } } }, "date from" { "type" "date", "format" "mmmm uuuu||uuuu", "locale" "en", "ignore malformed" true }, "date from year" { "type" "short" }, "date from month" { "type" "byte" }, "date to" { "type" "date", "format" "mmmm uuuu||uuuu", "locale" "en", "ignore malformed" true }, "date to year" { "type" "short" }, "date to month" { "type" "byte" }, "order in profile" { "type" "integer" } } }, "organizations" { "type" "nested", "properties" { "organization name" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "position" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "description" { "type" "text" }, "date from" { "type" "date", "format" "mmmm uuuu||uuuu", "locale" "en", "ignore malformed" true }, "date from year" { "type" "short" }, "date from month" { "type" "byte" }, "date to" { "type" "date", "format" "mmmm uuuu||uuuu", "locale" "en", "ignore malformed" true }, "date to year" { "type" "short" }, "date to month" { "type" "byte" }, "order in profile" { "type" "integer" } } }, "profile root field changes summary" { "type" "nested", "properties" { "field name" { "type" "keyword" }, "change type" { "type" "keyword" }, "last changed at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss ssssss" } } }, "profile collection field changes summary" { "type" "nested", "properties" { "field name" { "type" "keyword" }, "last changed at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss ssssss" } } }, "experience recently started" { "type" "nested", "properties" { "company id" { "type" "long" }, "company name" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "company url" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" }, "domain only" { "type" "text" } } }, "company shorthand name" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "date from" { "type" "date", "format" "mmm uuuu||uuuu", "locale" "en", "ignore malformed" true }, "date to" { "type" "date", "format" "mmm uuuu||uuuu", "locale" "en", "ignore malformed" true }, "title" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "identification date" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss ssssss" } } }, "experience recently closed" { "type" "nested", "properties" { "company id" { "type" "long" }, "company name" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "company url" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" }, "domain only" { "type" "text" } } }, "company shorthand name" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "date from" { "type" "date", "format" "mmm uuuu||uuuu", "locale" "en", "ignore malformed" true }, "date to" { "type" "date", "format" "mmm uuuu||uuuu", "locale" "en", "ignore malformed" true }, "title" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "identification date" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss ssssss" } } } } } } sorting options you can choose between two sorting options sort by id or score if you omit the sort part entirely, the sorting will be by id by default sorting by score enables you to view search results in order of relevance, with the most relevant items appearing first sorting by id arranges the list of ids in ascending order, starting from the smallest value and progressing to the largest choose the sorting type in the sort section of the endpoint payload endpoint payload { "query" {}, "sort" \[ null ] } sort by score { "query" { "match" { "company name" { "query" "google", "operator" "and" } } }, "sort" \[ " score" ] } sort by id { "query" { "match" { "company name" { "query" "google", "operator" "and" } } }, "sort" \[ "id" ] } limitations we do not own the functions and syntax that this endpoint operates in for all specific elasticsearch dsl information, please refer to their official documentation the endpoint accepts the query object of a standard elasticsearch request no matter the content of the query, the search only returns record ids (like all other search endpoints) queries in this endpoint are limited to 15,000 characters the maximum number of clauses a booleanquery can contain (number of boolean operators within the query) is 1024 more information on elasticsearch dsl do your elasticsearch dsl endpoints support analytics features? no, the analytics features are not supported in our elasticsearch dsl endpoints is it possible to search for a boolean value? yes the elastic search query itself includes a parameter bool that indicates to return results if they meet the criteria is there a way to exclude results? use an elastic search boolean query with a must not clause