Solved: parse jason response from webhook - Page 2

RedVox · 10-18-2022 11:44 AM

I am trying to create a webhook task that will take an address and return a latlong for the address. Through my browser, I can send a request to https://maps.googleapis.com/maps/api/geocode and get back a json response. But i don't quite know what to do with this in appsheet. Appsheet seems to have ways for me to make a template for any outbound json in my request, but I don't see anything about managing the json response from a web api. How do I parse the json object I receive from the web api?

Thanks!

Dat1

Yes, you can with automation. We do this to execute a gmail parsing script on google a sheet. Our script puts the parsed information on tables to be used by the our app but you can return a value from the executed script.

https://support.google.com/appsheet/answer/12309564?hl=en&ref_topic=11997049

View solution in original post