Data360 Analyze

 View Only

  • 1.  JSON node - how do i use it

    Posted 01-19-2022 13: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

     



  • 2.  RE: JSON node - how do i use it

    Posted 01-20-2022 02:53

    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.



  • 3.  RE: JSON node - how do i use it

    Posted 01-20-2022 07:28

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