parse jason response from webhook

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 Solved
0 4 250
1 ACCEPTED 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

View solution in original post

4 REPLIES 4


@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. 

Top Labels in this Space