Search Results for: Aerated water
value": } }, { "tank": "tank ", "watertemp": { "time": " - - : gmt", "value": } }, { "tank": "tank ", "watertemp": { "time": " - - : gmt", "value": } }, { "tank": "tank ", "watertemp": { "time": " - - : gmt", "value": } } ] example: return nested json properties we are seeking to return the tank name, water
temperature timestamp, and water temperature value, separated in three columns in the spreadsheet. we can return nested json properties using a dot notation. for example: {{watertemp.value}} spreadsheet input a b c url template {{tank}} || {{watertemp.time}} || {{watertemp.value}} tank time temp (°f...
https://thisdavej.com/fetching-filtering-and-sorting-json-apis-in-google-sheets-the-missing-functions/