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!
Solved! Go to Solution.
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
@RedVox wrote: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?
AppSheet ignores any response by design. Fire and forget
Thanks. Sad, but I guess that explains it. So, since its a google service, I suppose I can execute an app script instead of a webhook, yes? (I've tried and still having problems getting it to provide a result, but I'll post a new msg about that.)
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
Thanks. I got it working.
User | Count |
---|---|
18 | |
11 | |
11 | |
8 | |
4 |