Distilla

Data sourcesStep 14 of 18

News articles

News articles on file, the only kind that sets title, summary, and url.

What it is

A News Article is an online article saved as a PDF. It is the only file type that sets title, summary, and url.

News rows have no time_period_id, so you reach them through the company, not a fiscal period. Sort published_at descending for the latest articles.

fileJoin company as companysource_type

How Entity file · Filter source_type = News Article · Join company as company

{
  "entity": "file",
  "select": [
    "id",
    "source_type",
    "published_at",
    "company.symbol",
    "title",
    "summary",
    "url"
  ],
  "filters": [
    {
      "field": "source_type",
      "op": "=",
      "value": "News Article"
    },
    {
      "field": "company.symbol",
      "op": "=",
      "value": "NVDA"
    }
  ],
  "joins": [
    {
      "relation": "company",
      "alias": "company"
    }
  ],
  "sort": [
    {
      "field": "published_at",
      "direction": "desc"
    }
  ],
  "limit": 5
}