Hi AppSheet Community,
Im encountering an issue with a webhook data action in my AppSheet app. When I trigger a webhook to update certain fields in my table, I receive the following error:
Error encountered in step with name [New step]: Error: 'Set Column Values' Data action ''Set Column Values' Data action 'New step Action - 1'' failed with exception 'Set Column Values' Data action 'New step Action - 1' failed because field '[Field Name]' in table '[Table Name]' could not be computed due to exception Error: Failed Webhook type translation: Conversion error.
The fields that I'm trying to update are of the Price type. The webhook successfully triggers a Google Apps Script function, which processes an image and returns a JSON response. However, it seems there's an issue with converting the returned data to the Price type fields in AppSheet.
Here is the structure of my webhook response:
{ "Field1": 468, "Field2": 60, "Field3": 9565, "Field4": 273, "Field5": 30, "Field6": 5870, "NetSales": 575.6 }
Each field in the response is intended to update a corresponding Price type field in my table.
Has anyone encountered a similar issue, or does anyone have suggestions on how to resolve this conversion error? Any help would be greatly appreciated.
Thanks!
LinkedIn
Twitter
