JSON node - how do i use it

Follow

Sarita Gerbig

• January 19, 2022 20:55

I am trying to import the output from an api query that i dropped into a file but just can't understand how to set the node up correctly.

<Ideally I like to pull this data from inside d360>

the output can be found using this link:

https://opendata.usac.org/resource/96rf-xd57.json/?funding_year=2019

 

0

• 

  John Taylor

  • January 20, 2022 09:52

  So grab the JSON using the HTTP node in analyze and then connect the output/response to the JSON node.

  Set the Field setting to accept "Data from Field" and use the Hamburger menu to Select the response field. You don't have to define the schema, the JSON node takes care of in and output a table for you, the trick is to make sure you have that field setting to being "Json from Dataset" and selecting the response field.

  0

  Comment actions Permalink
• 

  Sarita Gerbig

  • January 20, 2022 14:28

  John - thank you! and thank you for a quick response.  I'm running now!

  0

  Comment actions Permalink

Please sign in to leave a comment.