# Elasticsearch DSL: Multi-source Employee API {% columns %} {% column width="16.666666666666664%" %} Data type: Query type: URL: {% endcolumn %} {% column %} Multi-source Employee Elasticsearch DSL {% endcolumn %} {% endcolumns %} *** ## Overview Use the `/v2/employee_multi_source/search/es_dsl` endpoint to find company data matching your specifications.
General Elasticsearch DSL information and usage tipsBroken link
## Elasticsearch schema
Elasticsearch schema Elasticsearch structure maps directly to our Multi-source Employee data fields: {% code title="Elasticsearch schema" expandable="true" %} ```json { "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" }, "profile_score": { "type": "double" }, "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" } } }, "professional_network_canonical_shorthand_name": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } }, "facebook_url": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } }, "twitter_url": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } }, "financial_website": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } }, "website": { "type": "text", "fields": { "domain_only": { "type": "text" }, "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_logo_url": { "type": "text", "index": false }, "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", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } }, "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" }, "institution_logo_url": { "type": "text", "index": false }, "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_count": { "type": "long" }, "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_count": { "type": "long" }, "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" } } }, "certificate_logo_url": { "type": "text", "index": false }, "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" } } }, "personal_investments": { "type": "nested", "properties": { "announced_date": { "type": "date", "format": "yyyy-MM-dd" }, "company_name": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } }, "lead_investor": { "type": "long" }, "funding_round": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } }, "amount_raised": { "type": "long" } } }, "partner_investments": { "type": "nested", "properties": { "announced_date": { "type": "date", "format": "yyyy-MM-dd" }, "company_name": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } }, "lead_investor": { "type": "long" }, "funding_round": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } }, "amount_raised": { "type": "long" }, "investor_name": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } } } }, "exits": { "type": "nested", "properties": { "company_name": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } }, "company_description": { "type": "text" } } }, "events": { "type": "nested", "properties": { "name": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } }, "role": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } }, "date": { "type": "date", "format": "yyyy-MM-dd" }, "location": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } } } }, "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" } } }, "location_city": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } }, "location_state": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } } } } } ``` {% endcode %}
{% hint style="success" %} #### Having trouble writing Elasticsearch queries on your own? Explore **AI query builder** feature available in Self-service [playground](https://dashboard.coresignal.com/apis/employees/playground). Write a prompt, and AI assistant will automatically convert it into a query. {% endhint %} ## Sample request {% code title="Request example" expandable="true" %} ```json curl -X 'POST' \ 'https://api.coresignal.com/cdapi/v2/employee_multi_source/search/es_dsl' \ -H 'accept: application/json' \ -H 'apikey: {API Key}' \ -H 'Content-Type: application/json' \ -d '{ "query":{ "match":{ "full_name":{ "query":"John Smith", "operator":"and" } } } }' ``` {% endcode %} ### Sorting options Find several examples of the available sorting options. All information about the sorting is in the general [Elasticsearch DSL](https://docs.coresignal.com/api-introduction/requests/elasticsearch-dsl#sorting-options) topic. {% tabs %} {% tab title="Sort by score" %} {% code title="Sort by score" %} ```json { "query": { "match":{ "company_name":{ "query":"Google", "operator":"and" } } }, "sort": [ "_score" ] } ``` {% endcode %} {% endtab %} {% tab title="Sort by id" %} {% code title="Sort by id" %} ```json { "query": { "match":{ "company_name":{ "query":"Google", "operator":"and" } } }, "sort": [ "id" ] } ``` {% endcode %} {% endtab %} {% endtabs %} #### Additional sorting fields Multi-source Employee API 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: * `profile_score` * `followers_count` --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.coresignal.com/employee-api/multi-source-employee-api/elasticsearch-dsl.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.