JSON parse tool (Error Message)

[tjamal1]

Hello

I am trying to create a table from JSON  i got from calling an API but the problem is that when i use JSON parse Tool  , I got his error

ConvError: JSON Parse (16): Error message: Invalid value. at character position: 0

I need 4 fields in table format

City , Longitude , Latitude 

Is there anyway to get this output

I have attached my workflow 

[GiuseppeC]

Hi @tjamal1,

it's just an oversight in the configuration of the JSON tool, you are making it parse the queryforjson field rather than the DonwloadData field, which contains the actual data to parse.

It works fine on my end after applying the change.

Hope this helps!

Giuseppe

[tjamal1]

Oh , I should have rechecked that 

Thanks for letting me know

Can you change these fields from json parse tool  to column so that i could get a table format  ?

City, Longitude , Latitude 

[GiuseppeC · Accepted solution]

@tjamal1, sure!

I've used the Multirow formula to calculate a record id (noticed that 'standard.prov' json tag would be the beginning of a new record) then Transposed the data and used Select to narrow down the fields to what's interesting for you.

See below and attached.

Hope this helps!

Giuseppe