Skip to main content
Solved

Attempting to Configure API Json for FIrst Time

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

View original
Did this help you find an answer to your question?

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
Evangelist
  • takashiEvangelist
  • 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

C
  • cardiofaz
  • Author
  • August 23, 2020
takashi wrote:

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.

Reply


Helpful Members This Week

Community Stats

31,486
Posts
119,362
Replies
39,106
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.