Skip to main content

GET Source Items

Endpoint​

GET https://signals.sportmicro.com/football-source-items

Backing view​

signals.football_source_items

Purpose​

Use this endpoint to retrieve collected external content that has been attached to a football match.

Common filters​

  • match_id=eq.{match_id}
  • source=eq.x
  • source=eq.reddit
  • source=eq.google_news
  • published_at=gte.{timestamp}
  • published_at=lte.{timestamp}
  • external_id=eq.{external_id}
  • dedupe_hash=eq.{hash}

Returned fields​

  • id, match_id, source, external_id, url
  • title, content_snippet
  • author_name, author_handle, publisher
  • published_at, collected_at, language
  • engagement, teams, players, raw_payload
  • dedupe_hash, created_at, updated_at

Example​

curl "https://signals.sportmicro.com/football-source-items?match_id=eq.{match_id}&source=eq.x&order=published_at.desc"

Notes​

  • source is limited to x, reddit, and google_news.
  • engagement, teams, players, and raw_payload are JSON payloads.
  • The backing table enforces uniqueness on (source, external_id) and on dedupe_hash.