Skip to main content
  • EN

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

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

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

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


Community Stats

30,351
Posts
115,341
Replies
38,081
Members
Terms & ConditionsCookie 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.