Overview

JSON API backed by PostgreSQL. Article objects match the full MicroCap Go API field set.

Base URL	http://internalnews.ducksystems.co.uk
Auth header	X-Api-Key: 8ASD87SA0HEJKHWREKJ
Alt query	?api_key=8ASD87SA0HEJKHWREKJ
Format	JSON (UTF-8)

Article object fields

Every article includes:

article_id, publication_date, headline, deckline, byline, news, body, story_link,
symbol, symbol2, symbol3, symbol4,
tradingview_symbol, tradingview_symbol_2, tradingview_symbol_3, tradingview_symbol_4,
marketcap, price, volume, shares_x100, sharesoutstanding, subject_names

GET /api/newsfeed

Paginated articles, newest first by default.

date_from	YYYY-MM-DD (optional; default ~last 7 days)
date_to	YYYY-MM-DD (optional)
symbol	Comma-separated symbols (matches symbol–symbol4)
query	Substring search in body (ILIKE)
pageSize	Default 30, max 200
lastId	Keyset pagination cursor
sort	date_desc (default) or date_asc
include_body	0 to omit body in list for lighter payloads

curl -H "X-Api-Key: 8ASD87SA0HEJKHWREKJ" \
  "http://internalnews.ducksystems.co.uk/api/newsfeed?pageSize=25&sort=date_desc"

curl -H "X-Api-Key: 8ASD87SA0HEJKHWREKJ" \
  "http://internalnews.ducksystems.co.uk/api/newsfeed?date_from=2026-01-01&date_to=2026-01-31&symbol=AAPL"

Response envelope:

{
  "success": true,
  "data": {
    "newsFeed": [ /* Article */ ],
    "hasNextPage": true,
    "nextPageParams": { "lastId": 123, "lastValue": "..." }
  }
}

GET /api/article

Single article by ID.

article_id	Required integer

curl -H "X-Api-Key: 8ASD87SA0HEJKHWREKJ" \
  "http://internalnews.ducksystems.co.uk/api/article?article_id=740932"

{ "success": true, "data": { /* Article */ } }

GET /api/download

Download one article as a .json file (full raw article object).

article_id	Required integer

curl -OJ -H "X-Api-Key: 8ASD87SA0HEJKHWREKJ" \
  "http://internalnews.ducksystems.co.uk/api/download?article_id=740932"

GET /api/bulk-download

ZIP archive of one JSON file per article for a date range (optional symbol filter). Max 2000 articles.

date_from	Required YYYY-MM-DD
date_to	Required YYYY-MM-DD
symbol	Optional

curl -OJ -H "X-Api-Key: 8ASD87SA0HEJKHWREKJ" \
  "http://internalnews.ducksystems.co.uk/api/bulk-download?date_from=2026-01-01&date_to=2026-01-07"

Errors

401 { "error": "Unauthorized" }
400 { "error": "..." }
404 { "error": "..." }
500 { "error": "..." }