Elasticsearch DSL

Data type:

Query type:

URL:

Base Jobs

Elasticsearch DSL

https://api.coresignal.com/cdapi/v2/job_base/search/es_dsl

---

Overview

Use the /v2/job_base/search/es_dsl endpoint for more sophisticated queries.

Additionally, the endpoint allows you to operate filters that mimic our job posting data, enabling you to write more sophisticated queries than using the /v2/job_base/search/filter endpoint.

General Elasticsearch DSL information and usage tips

Elasticsearch schema

Elasticsearch 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"
                    }
                }
            }
        }
    }

Having trouble writing Elasticsearch queries on your own?

Explore AI query builder feature available in Self-service playground. Write a prompt, and AI assistant will automatically convert it into a query.

Sorting options

Find several examples of the available sorting options. All information about the sorting is in the general Elasticsearch DSL topic.

Sort by ID

Sort by ID

{
    "query": {
        "match": {
            "company_name": {
                "query": "Apple",
                "operator": "and"
            }
        }
    },
    "sort": [
        "id"
    ]
}

Sort by score

Sort by score

{
    "query": {
        "match": {
            "company_name": {
                "query": "Apple",
                "operator": "and"
            }
        }
    },
    "sort": [
        "_score"
    ]
}