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 |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |