Elasticsearch DSL

data type clean company query type elasticsearch domain specific language (es dsl) url https //api coresignal com/cdapi/v2/company clean/search/es dsl overview use the /v2/company clean/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 clean firmographic data schema elasticsearch dsl docid\ bmr0bifvigi57qahh3bnx refer to the clean company api company elasticsearch schema elasticsearch dsl docid\ bmr0bifvigi57qahh3bnx check what sorting options you can use with the elasticsearch endpoint elasticsearch dsl docid\ bmr0bifvigi57qahh3bnx read on the limitations of the elasticsearch endpoint elasticsearch schema endpoint schema "mappings" { "properties" { "id" { "type" "long" }, "name" { "type" "text" }, "type" { "type" "keyword", "null value" "null" }, "founded" { "type" "keyword" }, "followers" { "type" "long", "null value" 1 }, "websites main original" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" }, "domain only" { "type" "text" } } }, "websites main" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" }, "domain only" { "type" "text" } } }, "websites resolved" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" }, "domain only" { "type" "text" } } }, "websites facebook" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "websites twitter" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "websites professional network" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "size range" { "type" "keyword", "null value" "null" }, "size employees count" { "type" "long", "null value" 1 }, "industry" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "description" { "type" "text" }, "location hq raw address" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "location hq country" { "type" "keyword", "null value" "null" }, "location hq regions" { "type" "text" }, "last updated" { "type" "date", "format" "yyyy mm dd" }, "logo" { "type" "binary" }, "specialities" { "type" "text", "fields" { "exact" { "type" "keyword" } } }, "ticker" { "type" "keyword" }, "exchange" { "type" "keyword" }, "enriched summary" { "type" "text" }, "enriched keywords" { "type" "keyword" }, "enriched b2b" { "type" "long" }, "enriched category" { "type" "text", "fields" { "exact" { "type" "keyword", "null value" "null" } } }, "metadata title" { "type" "text" }, "metadata description" { "type" "text" }, "professional network source id" { "type" "keyword" }, "funding rounds" { "type" "nested", "properties" { "last round investors count" { "type" "long", "null value" 1 }, "total rounds count" { "type" "long", "null value" 1 }, "last round type" { "type" "keyword", "null value" "null" }, "last round date" { "type" "date", "format" "yyyy mm dd" }, "last round money raised" { "type" "long", "null value" 1 }, "financial website url" { "type" "keyword" } } }, "expired domain" { "type" "boolean" }, "unique domain" { "type" "boolean" }, "unique website" { "type" "boolean" }, "phone numbers" { "type" "keyword" }, "emails" { "type" "text" }, "pricing available" { "type" "boolean" }, "free trial available" { "type" "boolean" }, "demo available" { "type" "boolean" }, "is downloadable" { "type" "boolean" }, "mobile apps exist" { "type" "boolean" }, "online reviews exist" { "type" "boolean" }, "api docs exist" { "type" "boolean" }, "social discord urls" { "type" "text" }, "social facebook urls" { "type" "text" }, "social instagram urls" { "type" "text" }, "social professional network urls" { "type" "text" }, "social pinterest urls" { "type" "text" }, "social tiktok urls" { "type" "text" }, "social twitter urls" { "type" "text" }, "social x urls" { "type" "text" }, "social youtube urls" { "type" "text" }, "social github urls" { "type" "text" }, "social reddit urls" { "type" "text" }, "locations full" { "type" "nested", "properties" { "location address" { "type" "keyword", "null value" "null" }, "is primary" { "type" "boolean" } } }, "technologies" { "type" "nested", "properties" { "technology" { "type" "text" }, "first verified at" { "type" "date", "format" "yyyy mm dd" }, "last verified at" { "type" "date", "format" "yyyy mm dd" } } }, "updates" { "type" "nested", "properties" { "urn" { "type" "text" }, "followers" { "type" "long" }, "date" { "type" "text" }, "description" { "type" "text" }, "reactions count" { "type" "long" }, "comments count" { "type" "long" }, "reshared post author" { "type" "text" }, "reshared post author url" { "type" "text" }, "reshared post author headline" { "type" "text" }, "reshared post description" { "type" "text" }, "reshared post date" { "type" "text" }, "reshared post followers" { "type" "long" } } }, "created at" { "type" "date", "format" "yyyy mm dd" } } } sorting options pick between two sorting options sort by id or score if you omit the sort part entirely, the sorting will sort 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 sorting by id arranges the list of ids in ascending order, starting from the smallest value and progressing to the largest you can choose the sorting type in the sort section of the endpoint payload or r efer to the sorting examples below endpoint payload { "query" {}, "sort" \[ null ] } sort by score { "query" { "bool" { "must" \[ { "query string" { "query" "2023", "default field" "founded", "default operator" "and" } } ] } }, "sort" \[ " score" ] } sort by id { "query" { "bool" { "must" \[ { "query string" { "query" "2023", "default field" "founded", "default operator" "and" } } ] } }, "sort" \[ "id" ] } additional sorting fields clean company includes additional numerical sorting options sorting is made in descending order by a selected field if several fields have the same value, sorting is made by the last updated field if the last updated values are also the same, sorting is then done by the id field sorting fields are listed below followers , size employees count 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