Elasticsearch DSL

6min
Data type: Job
Query type: Elasticsearch Domain Specific Language (ES DSL)
URL: /v1/professional_network/job/search/es_dsl.
Overview
Use the /v1/professional_network/job/search/es_dsl endpoint for more sophisticated queries.

For example, you can use fuzzy and wildcard queries in the endpoint. 

Additionally, the endpoint allows you to operate filters that mimic our job posting data, enabling you to write more sophisticated queries than using the 
/v1​/professional_network/job/search​/filter endpoint.
﻿Elasticsearch schema﻿
Refer to the Jobs Elasticsearch schema.
﻿Sorting options﻿
Information on possible sorting options.
﻿Limitations﻿
Information about the endpoint limitations. 
﻿Response codes﻿
See the list of possible error codes. 
Elastic schema
"mappings": {
        "properties": {
            "id": {
                "type": "long"
            },
            "created": {
                "type": "date",
                "format": "yyyy-MM-dd HH:mm:ss"
            },
            "last_updated": {
                "type": "date",
                "format": "yyyy-MM-dd HH:mm:ss"
            },
            "time_posted": {
                "type": "text",
                "index": false
            },
            "title": {
                "type": "text"
            },
            "description": {
                "type": "text"
            },
            "seniority": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword",
                        "null_value": "NULL"
                    }
                }
            },
            "employment_type": {
                "type": "text"
            },
            "location": {
                "type": "text"
            },
            "url": {
                "type": "text",
                "index": false
            },
            "hash": {
                "type": "text",
                "index": false
            },
            "company_id": {
                "type": "long"
            },
            "company_name": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword",
                        "null_value": "NULL"
                    }
                }
            },
            "external_url": {
                "type": "text"
            },
            "company_url": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword"
                    }
                }
            },
            "deleted": {
                "type": "byte"
            },
            "application_active": {
                "type": "byte"
            },
            "salary": {
                "type": "text",
                "index": false
            },
            "applicants_count": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword",
                        "null_value": "NULL"
                    }
                }
            },
            "professional_network_job_id": {
                "type": "long",
                "index": false
            },
            "country": {
                "type": "text"
            },
            "redirected_url": {
                "type": "text"
            },
            "job_industry_collection": {
                "type": "nested",
                "properties": {
                    "job_industry_list": {
                        "properties": {
                            "industry": {
                                "type": "text"
                            }
                        }
                    }
                }
            },
            "job_company_website": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword",
                        "null_value": "NULL"
                    },
                    "domain_only": {
                        "type": "text"
                    }
                }
            },
            "job_functions_collection": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword",
                        "null_value": "NULL"
                    }
                }
            }
        }
    }
"mappings": {
        "properties": {
            "id": {
                "type": "long"
            },
            "created": {
                "type": "date",
                "format": "yyyy-MM-dd HH:mm:ss"
            },
            "last_updated": {
                "type": "date",
                "format": "yyyy-MM-dd HH:mm:ss"
            },
            "time_posted": {
                "type": "text",
                "index": false
            },
            "title": {
                "type": "text"
            },
            "description": {
                "type": "text"
            },
            "seniority": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword",
                        "null_value": "NULL"
                    }
                }
            },
            "employment_type": {
                "type": "text"
            },
            "location": {
                "type": "text"
            },
            "url": {
                "type": "text",
                "index": false
            },
            "hash": {
                "type": "text",
                "index": false
            },
            "company_id": {
                "type": "long"
            },
            "company_name": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword",
                        "null_value": "NULL"
                    }
                }
            },
            "external_url": {
                "type": "text"
            },
            "company_url": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword"
                    }
                }
            },
            "deleted": {
                "type": "byte"
            },
            "application_active": {
                "type": "byte"
            },
            "salary": {
                "type": "text",
                "index": false
            },
            "applicants_count": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword",
                        "null_value": "NULL"
                    }
                }
            },
            "professional_network_job_id": {
                "type": "long",
                "index": false
            },
            "country": {
                "type": "text"
            },
            "redirected_url": {
                "type": "text"
            },
            "job_industry_collection": {
                "type": "nested",
                "properties": {
                    "job_industry_list": {
                        "properties": {
                            "industry": {
                                "type": "text"
                            }
                        }
                    }
                }
            },
            "job_company_website": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword",
                        "null_value": "NULL"
                    },
                    "domain_only": {
                        "type": "text"
                    }
                }
            },
            "job_functions_collection": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword",
                        "null_value": "NULL"
                    }
                }
            }
        }
    }
﻿
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.
All company information mentioned within this context is entirely fictional and is solely intended for illustrative purposes.
Choose the sorting type in the sort section of the endpoint payload:
Endpoint payload
Sort by ID
Sort by score
{
    "query": {
        "match": {
            "company_name": {
                "query": "Example Company",
                "operator": "and"
            }
        }
    },
    "sort": [
        "_score"
    ]
}
{
    "query": {
        "match": {
            "company_name": {
                "query": "Example Company",
                "operator": "and"
            }
        }
    },
    "sort": [
        "_score"
    ]
}
﻿
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. Please refer to the queries here.
No matter the content of the query, the search only returns the record ID (like all other Search endpoints).
Queries in this endpoint are limited to 15,000 characters.
Search returns 1000 results per page.
The maximum number of clauses a BooleanQuery can contain (number of boolean operators within the query) is 1024.
More information on Elasticsearch DSL
No, the analytics features are not supported in our Elasticsearch DSL endpoints.
Yes. The elastic search query 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. 
For example, the following query will search for all members with current or past experience in company ID 5181133 and exclude all members with experience in company ID 3252082.
Example query
{
    "query": {
        "nested": {
            "path": "member_experience_collection",
            "query": {
                "bool": {
                    "must": [
                        {
                            "query_string": {
                                "query": 5181133,
                                "default_field": "member_experience_collection.company_id",
                                "default_operator": "and"
                            }
                        },
                        {
                            "bool": {
                                "must_not": [
                                    {
                                        "query_string": {
                                            "query": 3252082,
                                            "default_field": "member_experience_collection.company_id",
                                            "default_operator": "and"
                                        }
                                    }
                                ]
                            }
                        }
                    ]
                }
            }
        }
    }
}
{
    "query": {
        "nested": {
            "path": "member_experience_collection",
            "query": {
                "bool": {
                    "must": [
                        {
                            "query_string": {
                                "query": 5181133,
                                "default_field": "member_experience_collection.company_id",
                                "default_operator": "and"
                            }
                        },
                        {
                            "bool": {
                                "must_not": [
                                    {
                                        "query_string": {
                                            "query": 3252082,
                                            "default_field": "member_experience_collection.company_id",
                                            "default_operator": "and"
                                        }
                                    }
                                ]
                            }
                        }
                    ]
                }
            }
        }
    }
}
﻿
﻿
Updated 30 Oct 2024
Did this page help you?
Postman Tutorial
Pagination
Elasticsearch DSL

Overview

Elasticsearch schema

Sorting options

Limitations

Elasticsearch schema

Response codes

Sorting options

Limitations

More information on Elasticsearch DSL

Do your Elasticsearch DSL endpoints support analytics features?

Is it possible to search for a boolean value?

Is there a way to exclude results?

Elasticsearch DSL

Overview

﻿Elasticsearch schema﻿

﻿Sorting options﻿

﻿Limitations﻿

Elasticsearch schema

﻿Response codes﻿

Sorting options

Limitations

More information on Elasticsearch DSL

Do your Elasticsearch DSL endpoints support analytics features?

Is it possible to search for a boolean value?

Is there a way to exclude results?

Elasticsearch schema

Sorting options

Limitations

Response codes
