Elasticsearch DSL: Company Posts API

Data type:

Query type:

URL:

Company Posts

Elasticsearch DSL

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

---

Overview

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

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

General Elasticsearch DSL information and usage tips

Elasticsearch schema

Elasticsearch schema

Elastic schema

{
    "mappings": {
        "properties": {
            "id": {
                "type": "keyword"
            },
            "url": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword"
                    }
                }
            },
            "company_id": {
                "type": "long"
            },
            "company_source_id": {
                "type": "long"
            },
            "company_name": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword"
                    }
                }
            },
            "company_url": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword"
                    }
                }
            },
            "company_headline": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword"
                    }
                }
            },
            "date_published": {
                "type": "date",
                "format": "yyyy-MM-dd"
            },
            "created_at": {
                "type": "date",
                "format": "yyyy-MM-dd HH:mm:ss"
            },
            "article_body": {
                "type": "text"
            },
            "image_url": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword"
                    }
                }
            },
            "hashtags": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword"
                    }
                }
            },
            "mentions": {
                "type": "nested",
                "properties": {
                    "full_name": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword"
                            }
                        }
                    },
                    "url": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword"
                            }
                        }
                    }
                }
            },
            "reaction_count": {
                "type": "long"
            },
            "comment_count": {
                "type": "long"
            },
            "comments": {
                "type": "nested",
                "properties": {
                    "full_name": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword"
                            }
                        }
                    },
                    "headline": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword"
                            }
                        }
                    },
                    "follower_count": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword"
                            }
                        }
                    },
                    "profile_url": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword"
                            }
                        }
                    },
                    "body": {
                        "type": "text"
                    },
                    "reaction_count": {
                        "type": "long"
                    },
                    "date_published": {
                        "type": "date",
                        "format": "yyyy-MM-dd"
                    }
                }
            },
            "reshared_post": {
                "type": "nested",
                "properties": {
                    "id": {
                        "type": "keyword"
                    },
                    "url": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword"
                            }
                        }
                    },
                    "author_name": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword"
                            }
                        }
                    },
                    "author_profile_url": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword"
                            }
                        }
                    },
                    "author_headline": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword"
                            }
                        }
                    },
                    "article_body": {
                        "type": "text"
                    },
                    "image_url": {
                        "type": "text",
                        "index": false
                    },
                    "hashtags": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword"
                            }
                        }
                    },
                    "date_published": {
                        "type": "date",
                        "format": "yyyy-MM-dd"
                    },
                    "company_id": {
                        "type": "long"
                    }
                }
            }
        }
    }
}

Sample request

Request example

curl -X 'POST' \
'https://api.coresignal.com/cdapi/v2/company_post/search/es_dsl' \
  -H 'accept: application/json' \
  -H 'apikey: {API Key}' \
  -H 'Content-Type: application/json' \
  -d '{
   "query":{
      "match":{
         "company_name":{
            "query":"Tesla",
            "operator":"and"
         }
      }
   }
}'

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":"Tesla",
            "operator":"and"
         }
      }
   },
    "sort": [
        "id"
    ]
}

Sort by score

Sort by score

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