***Note from Migration:***
Original Title was: usinf FME with SuperStars Open Data API (as used by the UK Gov's DWP Stat-Xplore site)
FME 2019 file
API Call the the UK Governement Department of Works & Pensions Stat Xplore cross tabluation system (documentation). This is based on a API stystem by WingARC in Australia (documentation).
you need to log in and get an API key to use it
then you need to use Stat XPlore as usual, to build the table you want.
when ready, choose Open Data API (JSON) from the Download Table options
this will give you the JSON Query string, copy and paste that into the Upload Body parameter of the HTTP_Caller, along with the API Key in the Header section.
In this example, you will get the National Insurance Registrations each Barnsley and surrounding local authorities, for the last 18 years.
Hopefully you'll find it useful as a starter for 10 for your own API Calls.
things you might find helpful:
- it builds a dymanic JSON query string to get the data out of the massive multi-level array, in the correct too.
- it accepts JSON and outputs a tabular format, useful for writing to databases etc
