Elasticsearch DSL

data type base employee query type elasticsearch domain specific language (es dsl) url https //api coresignal com/cdapi/v2/employee base/search/es dsl overview use the /v2/employee base/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 base employee data elasticsearch dsl docid\ yfre8nrflbrr2wcsgsln refer to the base employee elasticsearch schema elasticsearch dsl docid\ yfre8nrflbrr2wcsgsln information about possible sorting options elasticsearch dsl /#limitations information about the endpoint limitations elasticsearch schema response codes docid\ eegbe5xqblfigvmcnwsfb see the list of possible error codes a file of elastichsearch schema is available here https //archbee doc uploads s3 amazonaws com/aohzqyiaodrifcp3u9eju 9opbgnbe2egnx bxaj91f 20250403 071043 json elasticsearch structure maps directly to our base employee data points es dsl schema { "mappings" { "properties" { "id" { "type" "long" }, "parent id" { "type" "long" }, "is parent" { "type" "byte" }, "full name" { "type" "text" }, "first name" { "type" "text" }, "last name" { "type" "text" }, "headline" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "checked at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss" }, "received at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss" }, "public profile id" { "type" "text" }, "profile url" { "type" "text", "fields" { "exact" { "type" "keyword" } } }, "location" { "type" "text" }, "industry" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "summary" { "type" "text" }, "services" { "type" "text" }, "profile photo url" { "type" "keyword", "index" false, "doc values" false }, "country" { "type" "keyword", "null value" "null" }, "country iso 2" { "type" "keyword", "null value" "null" }, "country iso 3" { "type" "keyword", "null value" "null" }, "recommendations count" { "type" "long", "null value" 1 }, "connections count" { "type" "long", "null value" 1 }, "follower count" { "type" "long", "null value" 1 }, "experience count" { "type" "long", "null value" 1 }, "shorthand name" { "type" "keyword" }, "canonical shorthand name" { "type" "keyword" }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss" }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss" }, "deleted" { "type" "byte" }, "regions" { "type" "nested", "properties" { "region" { "type" "keyword" } } }, "shorthand names" { "type" "nested", "properties" { "shorthand name" { "type" "keyword" } } }, "historical ids" { "type" "nested", "properties" { "id" { "type" "long", "index" false, "doc values" false } } }, "also viewed" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "full name" { "type" "keyword", "index" false, "doc values" false }, "profile url" { "type" "keyword", "index" false, "doc values" false }, "headline" { "type" "keyword", "index" false, "doc values" false }, "location" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long", "index" false, "doc values" false }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte", "index" false, "doc values" false } } }, "awards" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "title" { "type" "text" }, "issuer" { "type" "text" }, "description" { "type" "text" }, "date" { "type" "date", "format" "mmm uuuu||uuuu", "locale" "en", "ignore malformed" true, "index" false, "doc values" false }, "date year" { "type" "long", "index" false, "doc values" false }, "date month" { "type" "long", "index" false, "doc values" false }, "date day" { "type" "long", "index" false, "doc values" false }, "order in profile" { "type" "long" }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte" } } }, "certifications" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "title" { "type" "text" }, "issuer" { "type" "text" }, "credential id" { "type" "keyword", "index" false, "doc values" false }, "certificate url" { "type" "keyword", "index" false, "doc values" false }, "issuer url" { "type" "text" }, "order in profile" { "type" "long" }, "date from" { "type" "keyword", "index" false, "doc values" false }, "date from year" { "type" "long", "index" false, "doc values" false }, "date from month" { "type" "long", "index" false, "doc values" false }, "date to" { "type" "keyword", "index" false, "doc values" false }, "date to year" { "type" "long", "index" false, "doc values" false }, "date to month" { "type" "long", "index" false, "doc values" false }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte" } } }, "courses" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "organizer" { "type" "text" }, "title" { "type" "text" }, "order in profile" { "type" "long" }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte" } } }, "course suggestions" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "title" { "type" "keyword", "index" false, "doc values" false }, "course url" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long", "index" false, "doc values" false }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte", "index" false, "doc values" false } } }, "education" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "institution" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "program" { "type" "text" }, "date from" { "type" "date", "format" "mmmm uuuu||uuuu", "locale" "en", "null value" "1000", "ignore malformed" true }, "date from year" { "type" "long" }, "date from month" { "type" "long" }, "date to" { "type" "date", "format" "mmmm uuuu||uuuu", "locale" "en", "null value" "1000", "ignore malformed" true }, "date to year" { "type" "long" }, "date to month" { "type" "long" }, "activities and societies" { "type" "text" }, "description" { "type" "text" }, "institution url" { "type" "text", "fields" { "exact" { "type" "keyword" } } }, "institution shorthand name" { "type" "keyword" }, "order in profile" { "type" "long" }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss" }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss" }, "deleted" { "type" "byte" } } }, "experience" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "title" { "type" "text" }, "location" { "type" "text" }, "company id" { "type" "long" }, "company source id" { "type" "long" }, "company name" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "company url" { "type" "text", "fields" { "exact" { "type" "keyword" } } }, "company url shorthand name" { "type" "keyword" }, "company url canonical shorthand name" { "type" "keyword" }, "company industry" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "company website" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" }, "domain only" { "type" "text" } } }, "company employees count" { "type" "long" }, "company size" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null", "ignore above" 256 } } }, "date from" { "type" "date", "format" "mmmm uuuu||uuuu", "locale" "en", "null value" "1000", "ignore malformed" true }, "date from year" { "type" "long" }, "date from month" { "type" "long" }, "date to" { "type" "date", "format" "mmmm uuuu||uuuu", "locale" "en", "null value" "1000", "ignore malformed" true }, "date to year" { "type" "long" }, "date to month" { "type" "long" }, "is current" { "type" "byte" }, "duration" { "type" "keyword" }, "description" { "type" "text" }, "order in profile" { "type" "long" }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss" }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss" }, "deleted" { "type" "byte" } } }, "groups" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "title" { "type" "text" }, "url" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long" }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte" } } }, "interests" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "interest" { "type" "text" }, "order in profile" { "type" "long" }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte" } } }, "languages" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "language" { "type" "text" }, "proficiency" { "type" "text" }, "order in profile" { "type" "long" }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte" } } }, "organizations" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "organization" { "type" "text" }, "position" { "type" "text" }, "description" { "type" "text" }, "date from" { "type" "keyword", "index" false, "doc values" false }, "date from year" { "type" "long", "index" false, "doc values" false }, "date from month" { "type" "long", "index" false, "doc values" false }, "date to" { "type" "keyword", "index" false, "doc values" false }, "date to year" { "type" "long", "index" false, "doc values" false }, "date to month" { "type" "long", "index" false, "doc values" false }, "order in profile" { "type" "long", "index" false, "doc values" false }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte" } } }, "patents" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "title" { "type" "text" }, "status" { "type" "text" }, "inventors" { "type" "nested", "properties" { "full name" { "type" "keyword", "index" false, "doc values" false }, "profile url" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long", "index" false, "doc values" false } } }, "date" { "type" "date", "format" "mmm uuuu||uuuu", "locale" "en", "ignore malformed" true, "index" false, "doc values" false }, "date year" { "type" "long", "index" false, "doc values" false }, "date month" { "type" "long", "index" false, "doc values" false }, "date day" { "type" "long", "index" false, "doc values" false }, "patent url" { "type" "keyword", "index" false, "doc values" false }, "description" { "type" "text" }, "patent or application number" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long" }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte" } } }, "posts see more urls" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "url" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long", "index" false, "doc values" false }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte", "index" false, "doc values" false } } }, "projects" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "name" { "type" "text" }, "project url" { "type" "keyword", "index" false, "doc values" false }, "description" { "type" "text" }, "date from" { "type" "keyword", "index" false, "doc values" false }, "date from year" { "type" "long", "index" false, "doc values" false }, "date from month" { "type" "long", "index" false, "doc values" false }, "date to" { "type" "keyword", "index" false, "doc values" false }, "date to year" { "type" "long", "index" false, "doc values" false }, "date to month" { "type" "long", "index" false, "doc values" false }, "team members" { "type" "nested", "properties" { "full name" { "type" "keyword", "index" false, "doc values" false }, "profile url" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long", "index" false, "doc values" false } } }, "order in profile" { "type" "long" }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte" } } }, "publications" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "title" { "type" "text" }, "publisher" { "type" "text" }, "date" { "type" "date", "format" "mmm uuuu||uuuu", "locale" "en", "ignore malformed" true, "index" false, "doc values" false }, "date year" { "type" "long", "index" false, "doc values" false }, "date month" { "type" "long", "index" false, "doc values" false }, "date day" { "type" "long", "index" false, "doc values" false }, "description" { "type" "text" }, "authors" { "type" "nested", "properties" { "full name" { "type" "keyword", "index" false, "doc values" false }, "profile url" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long", "index" false, "doc values" false } } }, "publication url" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long" }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte" } } }, "recommendations" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "recommendation" { "type" "text" }, "full name" { "type" "keyword", "index" false, "doc values" false }, "referee url" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long" }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte" } } }, "similar profiles" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "profile url" { "type" "keyword", "index" false, "doc values" false }, "full name" { "type" "keyword", "index" false, "doc values" false }, "headline" { "type" "keyword", "index" false, "doc values" false }, "location" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long", "index" false, "doc values" false }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte", "index" false, "doc values" false } } }, "others named" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "profile url" { "type" "keyword", "index" false, "doc values" false }, "full name" { "type" "keyword", "index" false, "doc values" false }, "headline" { "type" "keyword", "index" false, "doc values" false }, "location" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long", "index" false, "doc values" false }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte", "index" false, "doc values" false } } }, "skills" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "skill" { "type" "text" }, "order in profile" { "type" "long" }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte" } } }, "test scores" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "title" { "type" "text" }, "date" { "type" "date", "format" "mmm uuuu||uuuu", "locale" "en", "ignore malformed" true, "index" false, "doc values" false }, "date year" { "type" "long", "index" false, "doc values" false }, "date month" { "type" "long", "index" false, "doc values" false }, "date day" { "type" "long", "index" false, "doc values" false }, "description" { "type" "text" }, "score" { "type" "text" }, "order in profile" { "type" "long" }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte" } } }, "volunteering cares" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "care" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long", "index" false, "doc values" false }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte", "index" false, "doc values" false } } }, "volunteering opportunities" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "opportunity" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long", "index" false, "doc values" false }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte", "index" false, "doc values" false } } }, "volunteering positions" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "organization" { "type" "keyword", "index" false, "doc values" false }, "role" { "type" "keyword", "index" false, "doc values" false }, "cause" { "type" "keyword", "index" false, "doc values" false }, "date from" { "type" "keyword", "index" false, "doc values" false }, "date from year" { "type" "long", "index" false, "doc values" false }, "date from month" { "type" "long", "index" false, "doc values" false }, "date to" { "type" "keyword", "index" false, "doc values" false }, "date to year" { "type" "long", "index" false, "doc values" false }, "date to month" { "type" "long", "index" false, "doc values" false }, "duration" { "type" "keyword", "index" false, "doc values" false }, "description" { "type" "keyword", "index" false, "doc values" false }, "organization url" { "type" "keyword", "index" false, "doc values" false }, "organization shorthand name" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long", "index" false, "doc values" false }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte", "index" false, "doc values" false } } }, "volunteering supports" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "support" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long", "index" false, "doc values" false }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte", "index" false, "doc values" false } } }, "websites" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "personal website" { "type" "keyword", "index" false, "doc values" false }, "order in profile" { "type" "long", "index" false, "doc values" false }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte", "index" false, "doc values" false } } }, "activity" { "type" "nested", "properties" { "id" { "type" "keyword", "index" false, "doc values" false }, "activity url" { "type" "keyword", "index" false, "doc values" false }, "title" { "type" "text" }, "action" { "type" "text" }, "order in profile" { "type" "long" }, "created at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "updated at" { "type" "date", "format" "yyyy mm dd hh\ mm\ ss", "index" false, "doc values" false }, "deleted" { "type" "byte" } } }, "hidden details" { "type" "nested", "properties" { "hidden collection" { "type" "keyword" } } } } } } 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