Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago

Fetch JSON from an array

I'm trying to Fetch JSON Weather data. I have read all the documentation I can locate and I'm close but not quite there. The API call returns JSON with what seems to be header type info and then a...
APIs and custom code
JeremyAnson's avatar
JeremyAnson
Qrew Cadet
Hi Mark,

We had a similar challenge and weren't able to resolve it, although it feels like it should be possible as it's not an uncommon requirement.

We wanted to iterate over one level of the JSON and pass the result to another step to iterate over a lower level (which we've done easily in ETL tools), but couldn't find a combination of built in steps to do this. The 'iterate over JSON records' step only allows input from a 'Fetch JSON' step - if it could accept input from any step that generates JSON I think the problem would be solved. I tried playing around with the Regex step, but it wasn't satisfactory and we stopped at that point. 


------------------------------
Jeremy Anson
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
Thx for that feedback.  I believe in my use case there is just one level of iteration,  unlike your use case.  I have also asked for help from Quickbase  Support and will post back with their response.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • JeremyAnson's avatar
    JeremyAnson
    Qrew Cadet
    3 years ago
    You could try replacing the schema with the content within the 'daily' node:

    {
    "dt": 1647795600,
    "sunrise": 1647775291,
    "sunset": 1647819010,
    "moonrise": 1647829920,
    "moonset": 1647779880,
    "moon_phase": 0.58,
    "temp": {
    "day": 2.76,
    "min": 0.32,
    "max": 5.41,
    "night": 1.07,
    "eve": 2.78,
    "morn": 0.8
    },
    "feels_like": {
    "day": -1.21,
    "night": -1.67,
    "eve": -0.94,
    "morn": -3.39
    },
    "pressure": 1012,
    "humidity": 86,
    "dew_point": 0.66,
    "wind_speed": 5.04,
    "wind_deg": 292,
    "wind_gust": 11.22,
    "weather": [
    {
    "id": 616,
    "main": "Snow",
    "description": "rain and snow",
    "icon": "13d"
    }
    ],
    "clouds": 100,
    "pop": 0.86,
    "rain": 0.28,
    "snow": 0.15,
    "uvi": 0
    }

    ... and keeping the path as /daily






    ------------------------------
    Jeremy Anson
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      3 years ago
      @Jeremy,
      Thank you for that suggestion and trying to help. But I still get the same result. Maybe Support will have an answer for me.  ​

      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------
      • JeremyAnson's avatar
        JeremyAnson
        Qrew Cadet
        3 years ago
        Hi Mark, Happy to try to help, even if it doesn't get you any closer!

        If you change the schema to only include the content in the daily node it should change the references in step C - b.daily.dt would I think become b.dt. 

        Kind regards,
        Jeremy

        ------------------------------
        Jeremy Anson
        ------------------------------