Forum Discussion

Qrew 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

MarkShnier__You

Qrew Legend

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

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
Qrew 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
  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
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    3 years ago
    Jeremy, It worked!! When I changed the sample schema I did not realize that I had to edit the markers that were being dropped into my fields. (or just to clear them and drag them again). I am not a programmer and this JSON is all new to me. But I think I'm finally starting to understand it. Thanks for hanging in there and helping me.
    
    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------