About JoeMcFadden

JoeMcFadden · 06-21-2023

Hi All,I'm testing adding a few new automations, which need to call webhooks on an external API (turn.io - its a whatsapp bussiness service provider), with varying JSON body payloads pulling in data from appsheet, in order to send different whatsapp ...

JoeMcFadden · 06-21-2023

Sorry if I'm missing this somewhere in the help docs (I have looked), but can I check if LOOKUP() should perform an exact match against the column it is searching, or will it match if the search text is contained somewhere inside the column value? Fo...

JoeMcFadden · 06-16-2023

Hi everyoneI have a automation running using make.com (the new name for integromat), which creates a new record to in an appsheet app from a customer order in a woocommerce/wordpress site. It was working fine, but is now giving a REST API error from ...

JoeMcFadden · 04-20-2023

Hi all,I'm trying to use an external python script to call the appsheet API and update a single value in a table.The update is failing silently (i.e. the API call is reported as successful, but the field I want to update is not updated). When I call ...

JoeMcFadden · 04-05-2023

Hi all,I have a data change bot that is triggered when a new customer record is added to a sheet, which is done via the REST API. There is an order_date field that is not provided by the external system making the call to the AppSheet REST API, so I'...

JoeMcFadden · 08-07-2023

Just FYI for anyone finding this thread, I raised the issue with Appsheet support, who gave the solution of replacing <><> with an Appsheet If() expression. This worked in my case of a webhook posting a JSON Payload to an external API, so just sharin...

JoeMcFadden · 07-27-2023

Hi @Steven_Aung just wondering if you found a solution or workaround to this problem in a JSON template?I've encountered this issue with a Webhook POSTING JSON to a external API. I want to control the value of a specific JSON property based on the va...

JoeMcFadden · 06-28-2023

Hi Rifad, it took a long while to roll out it seems, but the option is now available for our Appsheet Core account. Thanks!

JoeMcFadden · 06-22-2023

Just to add to this, I've now read this help doc on using the return values from a webhook:https://support.google.com/appsheet/answer/12738438?hl=en&ref_topic=11446299&sjid=12383490113868360685-EUHowever when I configure the call a webhook task, I do...

JoeMcFadden · 06-21-2023

Thanks Simon for confirming how the match works, and thank you for sharing your fix formula as well - very helpful!

My Stats

JoeMcFadden's Bio

Badges JoeMcFadden Earned

Recent Activity

Any way to see the response body when you get a HTTP error from calling a webhook?

Does LOOKUP() perform an exact match?

DateTime field conversion error when using API to Add a record

API call to update a value in a row is failing when log says it has succeeded

how to get a bot to apply DST to now() when the trigger is a record added via API?

Re: JSON Expression Bug: <<If: true>> something <<EndIf>> will automatically

Re: JSON Expression Bug: <<If: true>> something <<EndIf>> will automatically

Re: Any way to see the response body when you get a HTTP error from calling a webhook?

Re: Any way to see the response body when you get a HTTP error from calling a webhook?

Re: Does LOOKUP() perform an exact match?