Hi,
I am using workflow rule to trigger Webhook so that i can copy the updated record to another table.
I have been following the instruction from this document:
https://help.appsheet.com/en/articles/2393264-example-copying-updated-records
However, the workflow rules did not copy the updated record to another table.
What could go wrong? Is there any sample app i can follow or any video tutorial which can help me solve this?
This is my JSON body template where i insert it in a google word that i created in โBody Templateโ.
{
โActionโ: โEditโ,
โPropertiesโ: {
โLocaleโ: โen-UK,
โLocationโ: โ47.623098, -122.330184โ,
โTimezoneโ: โPacific Standard Timeโ,
โUserSettingsโ: {
โOption 1โ: โvalue1โ,
โOption 2โ: โvalue2โ
}
},
โRowsโ: [
{
โSewing Order Details IDโ: โ<<[Sewing Order Details ID]>>โ
โSubCon": โ<<[SubCon]>>โ
}
]
}
I think youโre missing a comma
Screenshot_20190807-211707|281x500
MultiTech_Visions Thanks, that is a good catch.
However the webhook is still unable to run properly.
When i look at the Log of this workflow rule, it shows this error:
Error:
โWebhook HTTP post request failed with exception {โMessageโ:โREST API invoke request failed: Web API is not enabled for this application.โ} The remote server returned an error: (403) Forbidden.โ
What does it mean?
What plan do you have? It may be because that account is not a Business Plan.
The app is still under prototype stage.
Hi @Bellave_Jayaram thank you for all your help on many posts of this community. Could you confirm if the rest API only works on deployed apps?
Thanks in advance!
I do not think so. To be sure, if it is not working in prototype mode for you, you can check with support@appsheet.com by giving details of your account and app. Good luck.
Thankyou so much for your answer @Bellave_Jayaram
Have you enabled the API as described here https://help.appsheet.com/en/articles/1979976-enabling-the-api
Yes i have enabled it.
That error is only reported when the web API is not enabled.
Is it enabled on the app that is the target of the webhook?
My web API is working fine now.
I recreate a new spreadsheet and start to test with one column which works.
When the Web API is successful to add data to the new spreadsheet then only i add the rest of the column to the new spread sheet.
I get the following error with my webhook while trying to make an api call:
โErrorsโ: โError: Workflow rule โOn Change in Asset Protectionโ โBodyโ template properties could not be obtained due to Illegal characters in path. โ Filepath contains invalid path character: Filepath argument โ{ โActionโ: โAddโ, โPropertiesโ: { โLocaleโ: โen-USโ, โLocationโ: โ47.623098, -122.330184โ, โTimezoneโ: โPacific Standard Timeโ, โRowsโ: { โCustomerโ: โ<<[CustNbr]>>โ, โStatusโ: โ<<[Status]>>โ, โTimestampโ: โ<<[Now()]>>โ } } }โ passed to method โIdMappingFileProvider.translatePathโ contains an invalid path character 'โโ, โ0022โ. Error: Workflow rule โOn Change in Asset Protectionโ โBodyโ template could not be read due to FileMimeType โโ is unexpectedโฆ",
It looks like you may have entered the Body template value into the Body Template property. The Body template value should go into the Body property. The Body Template property should contain the file name of the Body Template file, if you have one.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |