Hello, Iโve been struggling with API Integration for these few days. I am trying to make a copy of data I add to a table automatically, means when I add a new row on โA Tableโ I also want that data to be copied automatically to on โB Tableโ. I follow the Documentation and try to figure it out BUT I still canโt get any result. Could Appsheet Team or anyone please help me to solve it? Thank so much.
Hi, could you describe how you are doing this? Are you using a workflow rule with a webhook? @Philip_Garrett_Appsh
I can investigate if you provide: 1. Your account id 2. Your app name 3. The table names of the source and destination tables. 4. A description of what you are currently trying. 5. A description of the error or problem you are seeing.
Thank Praveen and Philip. I actually used workflow rule with a webhook. I read the documentation on how to integrate API with workflow rule and I also followed the example there by enabling IN integration and use the App ID and also access key to put in webhook setting. And I also try to configure a JSON body template too but after a few days trying I still canโt get any result.
The best way to diagnose problems with webhooks and the API is to use the Audit History. The Audit history will show you exactly what is going wrong.
See these two articles:
help.appsheet.com - Troubleshooting Webhooks
https://help.appsheet.com/integrations/api/troubleshooting-api-calls
In your case the problem is the webhook JSON body. You should do two things:
Thank, but I still wonder if โlocalโ, โlocationโ, โtimezoneโ cause any problems that make the API doesnโt work.?
If possible, could you make a video explain how to configure it, that will be wonderful. Thank.
The Audit History indicates that you most recent API call at 11/13/2018 8:48:02 AM is failing with the error โRow having key โLWKYvMiAโ not foundโ. Does table โแแทแแแแแแแโ have a record with that key value?
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |