Company Data
...
Clean Company API
Endpoints
Elasticsearch DSL
6min
Data type: Clean Company Query type: Elasticsearch Domain Specific Language (ES DSL) URL: https://api.coresignal.com/cdapi/v1/professional_network/clean_company/search/es_dsl
Use the /v1/professional_network/clean_company/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 schema
Refer to the Clean Company API Company Elasticsearch schema.
Sorting options
Check what sorting options you can use with the Elasticsearch endpoint.
Limitations
Read on the limitations of the Elasticsearch endpoint.
Response Codes
Explore the list of possible response codes to learn about possible API errors.
Endpoint schema
1"mappings": {
2 "properties": {
3 "id": {
4 "type": "long"
5 },
6 "name": {
7 "type": "text"
8 },
9 "type": {
10 "type": "keyword",
11 "null_value": "NULL"
12 },
13 "founded": {
14 "type": "keyword"
15 },
16 "followers": {
17 "type": "long",
18 "null_value": -1
19 },
20 "websites_main_original": {
21 "type": "text",
22 "fields": {
23 "exact": {
24 "type": "keyword",
25 "null_value": "NULL"
26 },
27 "domain_only": {
28 "type": "text"
29 }
30 }
31 },
32 "websites_main": {
33 "type": "text",
34 "fields": {
35 "exact": {
36 "type": "keyword",
37 "null_value": "NULL"
38 },
39 "domain_only": {
40 "type": "text"
41 }
42 }
43 },
44 "websites_resolved": {
45 "type": "text",
46 "fields": {
47 "exact": {
48 "type": "keyword",
49 "null_value": "NULL"
50 },
51 "domain_only": {
52 "type": "text"
53 }
54 }
55 },
56 "websites_facebook": {
57 "type": "text",
58 "fields": {
59 "exact": {
60 "type": "keyword",
61 "null_value": "NULL"
62 }
63 }
64 },
65 "websites_twitter": {
66 "type": "text",
67 "fields": {
68 "exact": {
69 "type": "keyword",
70 "null_value": "NULL"
71 }
72 }
73 },
74 "websites_professional_network": {
75 "type": "text",
76 "fields": {
77 "exact": {
78 "type": "keyword",
79 "null_value": "NULL"
80 }
81 }
82 },
83 "size_range": {
84 "type": "keyword",
85 "null_value": "NULL"
86 },
87 "size_employees_count": {
88 "type": "long",
89 "null_value": -1
90 },
91 "industry": {
92 "type": "text",
93 "fields": {
94 "exact": {
95 "type": "keyword",
96 "null_value": "NULL"
97 }
98 }
99 },
100 "description": {
101 "type": "text"
102 },
103 "location_hq_raw_address": {
104 "type": "text",
105 "fields": {
106 "exact": {
107 "type": "keyword",
108 "null_value": "NULL"
109 }
110 }
111 },
112 "location_hq_country": {
113 "type": "keyword",
114 "null_value": "NULL"
115 },
116 "location_hq_regions": {
117 "type": "text"
118 },
119 "last_updated": {
120 "type": "date",
121 "format": "yyyy-MM-dd"
122 },
123 "logo": {
124 "type": "binary"
125 },
126 "specialities": {
127 "type": "text",
128 "fields": {
129 "exact": {
130 "type": "keyword"
131 }
132 }
133 },
134 "ticker": {
135 "type": "keyword"
136 },
137 "exchange": {
138 "type": "keyword"
139 },
140 "enriched_summary": {
141 "type": "text"
142 },
143 "enriched_keywords": {
144 "type": "keyword"
145 },
146 "enriched_b2b": {
147 "type": "long"
148 },
149 "enriched_category": {
150 "type": "text",
151 "fields": {
152 "exact": {
153 "type": "keyword",
154 "null_value": "NULL"
155 }
156 }
157 },
158 "metadata_title": {
159 "type": "text"
160 },
161 "metadata_description": {
162 "type": "text"
163 },
164 "source_id": {
165 "type": "keyword"
166 },
167 "funding_rounds": {
168 "type": "nested",
169 "properties": {
170 "last_round_investors_count": {
171 "type": "long",
172 "null_value": -1
173 },
174 "total_rounds_count": {
175 "type": "long",
176 "null_value": -1
177 },
178 "last_round_type": {
179 "type": "keyword",
180 "null_value": "NULL"
181 },
182 "last_round_date": {
183 "type": "date",
184 "format": "yyyy-MM-dd"
185 },
186 "last_round_money_raised": {
187 "type": "long",
188 "null_value": -1
189 },
190 "cb_url": {
191 "type": "keyword"
192 }
193 }
194 },
195 "expired_domain": {
196 "type": "boolean"
197 },
198 "unique_domain": {
199 "type": "boolean"
200 },
201 "unique_website": {
202 "type": "boolean"
203 },
204 "phone_numbers": {
205 "type": "keyword"
206 },
207 "emails": {
208 "type": "text"
209 },
210 "pricing_available": {
211 "type": "boolean"
212 },
213 "free_trial_available": {
214 "type": "boolean"
215 },
216 "demo_available": {
217 "type": "boolean"
218 },
219 "is_downloadable": {
220 "type": "boolean"
221 },
222 "mobile_apps_exist": {
223 "type": "boolean"
224 },
225 "online_reviews_exist": {
226 "type": "boolean"
227 },
228 "api_docs_exist": {
229 "type": "boolean"
230 },
231 "social_discord_urls": {
232 "type": "text"
233 },
234 "social_facebook_urls": {
235 "type": "text"
236 },
237 "social_instagram_urls": {
238 "type": "text"
239 },
240 "social_professional_network_urls": {
241 "type": "text"
242 },
243 "social_pinterest_urls": {
244 "type": "text"
245 },
246 "social_tiktok_urls": {
247 "type": "text"
248 },
249 "social_twitter_urls": {
250 "type": "text"
251 },
252 "social_x_urls": {
253 "type": "text"
254 },
255 "social_youtube_urls": {
256 "type": "text"
257 },
258 "social_github_urls": {
259 "type": "text"
260 },
261 "social_reddit_urls": {
262 "type": "text"
263 },
264 "locations_full": {
265 "type": "nested",
266 "properties": {
267 "location_address": {
268 "type": "keyword",
269 "null_value": "NULL"
270 },
271 "is_primary": {
272 "type": "boolean"
273 }
274 }
275 },
276 "technologies": {
277 "type": "nested",
278 "properties": {
279 "technology": {
280 "type": "text"
281 },
282 "first_verified_at": {
283 "type": "date",
284 "format": "yyyy-MM-dd"
285 },
286 "last_verified_at": {
287 "type": "date",
288 "format": "yyyy-MM-dd"
289 }
290 }
291 },
292 "updates": {
293 "type": "nested",
294 "properties": {
295 "urn": {
296 "type": "text"
297 },
298 "followers": {
299 "type": "long"
300 },
301 "date": {
302 "type": "text"
303 },
304 "description": {
305 "type": "text"
306 },
307 "reactions_count": {
308 "type": "long"
309 },
310 "comments_count": {
311 "type": "long"
312 },
313 "reshared_post_author": {
314 "type": "text"
315 },
316 "reshared_post_author_url": {
317 "type": "text"
318 },
319 "reshared_post_author_headline": {
320 "type": "text"
321 },
322 "reshared_post_description": {
323 "type": "text"
324 },
325 "reshared_post_date": {
326 "type": "text"
327 },
328 "reshared_post_followers": {
329 "type": "long"
330 }
331 }
332 },
333 "created_at": {
334 "type": "date",
335 "format": "yyyy-MM-dd"
336 }
337 }
338}

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.
You can choose the sorting type in the sort section of the endpoint payload.
Endpoint payload
1{
2 "query": {},
3 "sort": [
4 null
5 ]
6}

Refer to the sorting examples below:
Sort by score
Sort by id
1{
2 "query": {
3 "bool": {
4 "must": [
5 {
6 "query_string": {
7 "query": "2023",
8 "default_field": "founded",
9 "default_operator": "and"
10 }
11 }
12 ]
13 }
14 },
15 "sort": [
16 "_score"
17 ]
18}

- 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.
No, the analytics features are not supported in our Elasticsearch DSL endpoints.
Yes. The elastic search query itself includes a parameter bool that indicates to return results if they meet the criteria.
Use an elastic search boolean query with a must_not clause.

Updated 08 Apr 2025
Did this page help you?