Skip to main content
Solved

Attempting to Configure API Json for FIrst Time

  • August 22, 2020
  • 3 replies
  • 22 views
C

Hi all,

 

I am trying to use the following link to setup a json file and automated script to extract data. It is the first time I have attempted to do this and I have used the httpcaller and also tried the json reader to get an output.

 

I am just trying to tackle this one step at a time and very eager to get my first API working. In terms of the link I used https://api.coronavirus.data.gov.uk/v1/data which I added to the httpcaller. It did pick this up and then i was not able to get anything from the attributexposer. Can anyone assist with what they would recommend as next steps?

 

Link to dev guide - https://coronavirus.data.gov.uk/developers-guide

Best answer by takashi

Hi @cardiofaz​ , I would use the JSONFragmenter to fragment the JSON document into features for each date and also convert the pairs of name and value to feature attributes.

Example:

jsonfragmenter-example

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

C
  • cardiofaz
  • Author
  • August 23, 2020

I have made some progress with this now and have got the URL to work:

I am getting the data in following output with name and newcases in the same row and column.

What would you recommend to have Column 1 - Name and Column 2 NewCases. Then for the outputs to generate into rows? Would a list be the best possible solution?

 

newcases

takashi
Celebrity
  • takashiCelebrity
  • Best Answer
  • August 23, 2020

Hi @cardiofaz​ , I would use the JSONFragmenter to fragment the JSON document into features for each date and also convert the pairs of name and value to feature attributes.

Example:

jsonfragmenter-example

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
C
  • cardiofaz
  • Author
  • August 23, 2020

Hi @cardiofaz​ , I would use the JSONFragmenter to fragment the JSON document into features for each date and also convert the pairs of name and value to feature attributes.

Example:

jsonfragmenter-example

That is great, thanks for the suggestion for the httpcaller. That seems to have done the trick, much appreciated.

Community Stats

32,129
Posts
121,967
Replies
39,779
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.