Employee Data
...
Clean Employee API
Endpoints
Elasticsearch DSL
6min
Data type: Clean Employee API Query type: Elasticsearch Domain Specific Language (ES DSL) URL: https://api.coresignal.com/cdapi/v1/professional_network/clean_member/search/es_dsl
Use the /v1/professional_network/clean_member/search/es_dsl endpoint to find employee IDs matching your specifications. Elasticsearch schema allows you to use more sophisticated queries like fuzzy and wildcard queries. Additionally, the endpoint allows you to use the Elasticsearch DSL schema that mimics our Clean Employee data.
Elasticsearch schema
Refer to the Clean Employee Elasticsearch schema.
Sorting options
Information about possible sorting options.
Limitations
Information about the endpoint limitations.
Response Codes
See the list of possible error codes.
Elasticsearch structure maps directly to our Clean Employee data.
Clean Employee Data
Endpoint schema
1 "mappings": {
2 "properties": {
3 "id": {
4 "type": "long"
5 },
6 "company_id": {
7 "type": "long"
8 },
9 "full_name": {
10 "type": "text",
11 "fields": {
12 "exact": {
13 "type": "keyword",
14 "null_value": "NULL"
15 }
16 }
17 },
18 "name_first": {
19 "type": "text",
20 "fields": {
21 "exact": {
22 "type": "keyword",
23 "null_value": "NULL"
24 }
25 }
26 },
27 "name_middle": {
28 "type": "text",
29 "fields": {
30 "exact": {
31 "type": "keyword",
32 "null_value": "NULL"
33 }
34 }
35 },
36 "name_last": {
37 "type": "text",
38 "fields": {
39 "exact": {
40 "type": "keyword",
41 "null_value": "NULL"
42 }
43 }
44 },
45 "websites_professional_network": {
46 "type": "text",
47 "fields": {
48 "exact": {
49 "type": "keyword",
50 "null_value": "NULL"
51 }
52 }
53 },
54 "description": {
55 "type": "text"
56 },
57 "job_title": {
58 "type": "text",
59 "fields": {
60 "exact": {
61 "type": "keyword",
62 "null_value": "NULL"
63 }
64 }
65 },
66 "management_level": {
67 "type": "keyword"
68 },
69 "department": {
70 "type": "keyword"
71 },
72 "is_decision_maker": {
73 "type": "byte"
74 },
75 "is_working": {
76 "type": "byte"
77 },
78 "job_description": {
79 "type": "text"
80 },
81 "activity": {
82 "type": "nested",
83 "properties": {
84 "activity_url": {
85 "type": "text",
86 "fields": {
87 "exact": {
88 "type": "keyword",
89 "null_value": "NULL"
90 }
91 }
92 },
93 "title": {
94 "type": "text",
95 "fields": {
96 "exact": {
97 "type": "keyword",
98 "null_value": "NULL"
99 }
100 }
101 },
102 "action": {
103 "type": "text",
104 "fields": {
105 "exact": {
106 "type": "keyword",
107 "null_value": "NULL"
108 }
109 }
110 },
111 "order_in_profile": {
112 "type": "integer"
113 }
114 }
115 },
116 "awards": {
117 "type": "nested",
118 "properties": {
119 "title": {
120 "type": "text",
121 "fields": {
122 "exact": {
123 "type": "keyword",
124 "null_value": "NULL"
125 }
126 }
127 },
128 "issuer": {
129 "type": "text",
130 "fields": {
131 "exact": {
132 "type": "keyword",
133 "null_value": "NULL"
134 }
135 }
136 },
137 "description": {
138 "type": "text",
139 "fields": {
140 "exact": {
141 "type": "keyword",
142 "null_value": "NULL"
143 }
144 }
145 },
146 "date": {
147 "type": "date"
148 },
149 "date_year": {
150 "type": "integer"
151 },
152 "date_month": {
153 "type": "integer"
154 },
155 "order_in_profile": {
156 "type": "integer"
157 }
158 }
159 },
160 "courses": {
161 "type": "nested",
162 "properties": {
163 "organizer": {
164 "type": "text",
165 "fields": {
166 "exact": {
167 "type": "keyword",
168 "null_value": "NULL"
169 }
170 }
171 },
172 "title": {
173 "type": "text",
174 "fields": {
175 "exact": {
176 "type": "keyword",
177 "null_value": "NULL"
178 }
179 }
180 },
181 "order_in_profile": {
182 "type": "integer"
183 }
184 }
185 },
186 "certifications": {
187 "type": "nested",
188 "properties": {
189 "title": {
190 "type": "text",
191 "fields": {
192 "exact": {
193 "type": "keyword",
194 "null_value": "NULL"
195 }
196 }
197 },
198 "issuer": {
199 "type": "text",
200 "fields": {
201 "exact": {
202 "type": "keyword",
203 "null_value": "NULL"
204 }
205 }
206 },
207 "credential_id": {
208 "type": "keyword"
209 },
210 "certificate_url": {
211 "type": "text",
212 "fields": {
213 "exact": {
214 "type": "keyword",
215 "null_value": "NULL"
216 }
217 }
218 },
219 "date_from": {
220 "type": "date"
221 },
222 "date_from_year": {
223 "type": "integer"
224 },
225 "date_from_month": {
226 "type": "integer"
227 },
228 "date_to": {
229 "type": "date"
230 },
231 "date_to_year": {
232 "type": "integer"
233 },
234 "date_to_month": {
235 "type": "integer"
236 },
237 "issuer_url": {
238 "type": "text",
239 "fields": {
240 "exact": {
241 "type": "keyword",
242 "null_value": "NULL"
243 }
244 }
245 },
246 "order_in_profile": {
247 "type": "integer"
248 }
249 }
250 },
251 "experience": {
252 "type": "nested",
253 "properties": {
254 "title": {
255 "type": "text",
256 "fields": {
257 "exact": {
258 "type": "keyword",
259 "null_value": "NULL"
260 }
261 }
262 },
263 "description": {
264 "type": "text"
265 },
266 "order_in_profile": {
267 "type": "integer"
268 },
269 "company_id": {
270 "type": "long"
271 },
272 "company_name": {
273 "type": "text",
274 "fields": {
275 "exact": {
276 "type": "keyword",
277 "null_value": "NULL"
278 }
279 }
280 },
281 "date_from": {
282 "type": "date"
283 },
284 "date_from_year": {
285 "type": "integer"
286 },
287 "date_from_month": {
288 "type": "integer"
289 },
290 "date_to": {
291 "type": "date"
292 },
293 "date_to_year": {
294 "type": "integer"
295 },
296 "date_to_month": {
297 "type": "integer"
298 },
299 "duration": {
300 "type": "text",
301 "fields": {
302 "exact": {
303 "type": "keyword",
304 "null_value": "NULL"
305 }
306 }
307 },
308 "duration_months": {
309 "type": "long"
310 },
311 "department": {
312 "type": "text",
313 "fields": {
314 "exact": {
315 "type": "keyword",
316 "null_value": "NULL"
317 }
318 }
319 },
320 "management_level": {
321 "type": "text",
322 "fields": {
323 "exact": {
324 "type": "keyword",
325 "null_value": "NULL"
326 }
327 }
328 },
329 "location": {
330 "type": "text",
331 "fields": {
332 "exact": {
333 "type": "keyword",
334 "null_value": "NULL"
335 }
336 }
337 },
338 "company_type": {
339 "type": "keyword"
340 },
341 "company_founded": {
342 "type": "text",
343 "fields": {
344 "exact": {
345 "type": "keyword",
346 "null_value": "NULL"
347 }
348 }
349 },
350 "company_followers_count": {
351 "type": "long"
352 },
353 "company_website": {
354 "type": "text",
355 "fields": {
356 "exact": {
357 "type": "keyword",
358 "null_value": "NULL"
359 },
360 "domain_only": {
361 "type": "text"
362 }
363 }
364 },
365 "company_facebook_url": {
366 "type": "text",
367 "fields": {
368 "exact": {
369 "type": "keyword",
370 "null_value": "NULL"
371 }
372 }
373 },
374 "company_twitter_url": {
375 "type": "text",
376 "fields": {
377 "exact": {
378 "type": "keyword",
379 "null_value": "NULL"
380 }
381 }
382 },
383 "company_professional_network_url": {
384 "type": "text",
385 "fields": {
386 "exact": {
387 "type": "keyword",
388 "null_value": "NULL"
389 }
390 }
391 },
392 "company_size_range": {
393 "type": "text",
394 "fields": {
395 "exact": {
396 "type": "keyword",
397 "null_value": "NULL"
398 }
399 }
400 },
401 "company_size_employees_count": {
402 "type": "long"
403 },
404 "company_industry": {
405 "type": "text",
406 "fields": {
407 "exact": {
408 "type": "keyword",
409 "null_value": "NULL"
410 }
411 }
412 },
413 "company_location_hq_full_address": {
414 "type": "text"
415 },
416 "company_location_hq_country": {
417 "type": "keyword"
418 },
419 "company_location_hq_regions": {
420 "type": "text"
421 },
422 "company_location_hq_country_iso2": {
423 "type": "text"
424 },
425 "company_location_hq_country_iso3": {
426 "type": "text"
427 },
428 "company_location_hq_city": {
429 "type": "text"
430 },
431 "company_location_hq_state": {
432 "type": "text"
433 },
434 "company_location_hq_street": {
435 "type": "text"
436 },
437 "company_location_hq_zipcode": {
438 "type": "text"
439 },
440 "company_last_updated": {
441 "type": "date"
442 },
443 "company_categories_and_keywords": {
444 "type": "text"
445 },
446 "company_stock_ticker": {
447 "type": "nested",
448 "properties": {
449 "exchange": {
450 "type": "text",
451 "fields": {
452 "exact": {
453 "type": "keyword",
454 "null_value": "NULL"
455 }
456 }
457 },
458 "ticker": {
459 "type": "keyword"
460 }
461 }
462 },
463 "company_is_b2b": {
464 "type": "byte"
465 },
466 "company_annual_revenue": {
467 "type": "long"
468 },
469 "company_annual_revenue_currency": {
470 "type": "text"
471 },
472 "company_employees_count_change_yearly_percentage": {
473 "type": "double"
474 },
475 "company_last_funding_round_announced_date": {
476 "type": "date"
477 },
478 "company_last_funding_round_amount_raised": {
479 "type": "long"
480 }
481 }
482 },
483 "education": {
484 "type": "nested",
485 "properties": {
486 "title": {
487 "type": "text",
488 "fields": {
489 "exact": {
490 "type": "keyword",
491 "null_value": "NULL"
492 }
493 }
494 },
495 "major": {
496 "type": "text",
497 "fields": {
498 "exact": {
499 "type": "keyword",
500 "null_value": "NULL"
501 }
502 }
503 },
504 "institution_url": {
505 "type": "text",
506 "fields": {
507 "exact": {
508 "type": "keyword",
509 "null_value": "NULL"
510 },
511 "domain_only": {
512 "type": "text"
513 }
514 }
515 },
516 "description": {
517 "type": "text",
518 "fields": {
519 "exact": {
520 "type": "keyword",
521 "null_value": "NULL"
522 }
523 }
524 },
525 "activities_and_societies": {
526 "type": "text",
527 "fields": {
528 "exact": {
529 "type": "keyword",
530 "null_value": "NULL"
531 }
532 }
533 },
534 "date_from": {
535 "type": "integer"
536 },
537 "date_to": {
538 "type": "integer"
539 }
540 }
541 },
542 "languages": {
543 "type": "nested",
544 "properties": {
545 "language": {
546 "type": "text",
547 "fields": {
548 "exact": {
549 "type": "keyword",
550 "null_value": "NULL"
551 }
552 }
553 },
554 "proficiency": {
555 "type": "text",
556 "fields": {
557 "exact": {
558 "type": "keyword",
559 "null_value": "NULL"
560 }
561 }
562 },
563 "order_in_profile": {
564 "type": "integer"
565 }
566 }
567 },
568 "recommendations": {
569 "type": "nested",
570 "properties": {
571 "recommendation": {
572 "type": "text",
573 "fields": {
574 "exact": {
575 "type": "keyword",
576 "null_value": "NULL"
577 }
578 }
579 },
580 "referee_name": {
581 "type": "text",
582 "fields": {
583 "exact": {
584 "type": "keyword",
585 "null_value": "NULL"
586 }
587 }
588 },
589 "referee_url": {
590 "type": "text",
591 "fields": {
592 "exact": {
593 "type": "keyword",
594 "null_value": "NULL"
595 }
596 }
597 },
598 "order_in_profile": {
599 "type": "integer"
600 }
601 }
602 },
603 "recommendations_count": {
604 "type": "integer"
605 },
606 "connections_count": {
607 "type": "integer"
608 },
609 "location_raw_address": {
610 "type": "text",
611 "fields": {
612 "exact": {
613 "type": "keyword",
614 "null_value": "NULL"
615 }
616 }
617 },
618 "location_country": {
619 "type": "keyword"
620 },
621 "location_regions": {
622 "type": "keyword"
623 },
624 "last_updated": {
625 "type": "date"
626 },
627 "is_deleted": {
628 "type": "byte"
629 },
630 "is_hidden": {
631 "type": "byte"
632 },
633 "follower_count": {
634 "type": "long"
635 },
636 "skills": {
637 "type": "text",
638 "fields": {
639 "exact": {
640 "type": "keyword",
641 "null_value": "NULL"
642 }
643 }
644 },
645 "shorthand_names": {
646 "type": "text",
647 "fields": {
648 "exact": {
649 "type": "keyword",
650 "null_value": "NULL"
651 }
652 }
653 },
654 "headline": {
655 "type": "text",
656 "fields": {
657 "exact": {
658 "type": "keyword",
659 "null_value": "NULL"
660 }
661 }
662 },
663 "generated_headline": {
664 "type": "text",
665 "fields": {
666 "exact": {
667 "type": "keyword",
668 "null_value": "NULL"
669 }
670 }
671 },
672 "picture_url": {
673 "type": "text"
674 },
675 "total_experience_duration": {
676 "type": "text",
677 "fields": {
678 "exact": {
679 "type": "keyword",
680 "null_value": "NULL"
681 }
682 }
683 },
684 "total_experience_duration_months": {
685 "type": "long"
686 }
687 }
688 }

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
Sort by score
Sort by ID
1{
2 "query": {},
3 "sort": [
4 null
5 ]
6}

- 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.