Search Results for: Water process
documented below. getjson function purpose retrieve json from a web api and render the results using a template usage =getjson(url, template, [takenum], [filterexpression]) note: square brackets denote optional parameters. parameters url - the web api url containing the json object or array of objects to process
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...
https://thisdavej.com/fetching-filtering-and-sorting-json-apis-in-google-sheets-the-missing-functions/