I looked at your most recent invocation of the rule “Rent RCVD Webhook”.
It occurred at 10/5/2018 8:07:46 AM UTC in the Audit History as the result of an update that occurred at 10/5/2018 8:07:32 AM UTC.
UserId: 708906, EventTimeStamp: 10/5/2018 8:07:46 AM +00:00, TraceId: 74840360-f488-4475-a0b8-cf2893c3245c, AppTemplateName: ‘PropertyManagementApp-708906’, TableName: ‘Property’ Properties
AppTemplateVersion: ‘1.001352’ Using version 1.001352 rather than current version 1.001382
RuleName: ‘Rent RCVD Webhook’
Operation: ‘Change workflow rule’
EventMatch: ‘Workflow event successfully matched’
Actions: ‘Created 1 Actions’
Url: ‘https://api.appsheet.com/api/v1/apps/f30c709c-224b-43f2-90ff-2fcd917618f2/tables/Rent Received/Action’
Errors: 'Error: The webhook url ‘https://api.appsheet.com/api/v1/apps/f30c709c-224b-43f2-90ff-2fcd917618f2/tables/Rent Received/Action is not well formed Error: Workflow rule ‘Rent RCVD Webhook’ ‘Body’ template properties could not be obtained due to Accessing deleted file ‘Rent RCVD Webhook_BodyTemplate_20181005_025112.json’… Error: Workflow rule ‘Rent RCVD Webhook’ ‘Body’ template could not be read due to FileMimeType ‘’ is unexpected…’
Warnings: ‘Warning: App version 1.001352, which is the latest version, is not marked deployable so the web hook is not being invoked. This web hook would have been posted to ‘https://api.appsheet.com/api/v1/apps/f30c709c-224b-43f2-90ff-2fcd917618f2/tables/Rent Received/Action’.’
It has a number of problems listed in the audit record.
I suspect that at some point you replaced the Body Template with a new one but you have not gone back to your workflow rule and updated it to refer to the latest Body Template file. Instead, it appears to be referring to an older version of the file that you have deleted. Be aware that Google refers to files by their Doc Id, not their name. If you replace a template file it will have a new Doc Id. You must go back to the AppSheet Editor and update the JSON Body Template to ensure it refers to the latest template file.
Do this by: 1. Opening the webhook workflow rule in the editor. 2. Clicking the icon at the far right of the “JSON Body Template” and selecting your current JSON body template file.
It appears that at some point you updated rule “Rent RCVD Webhook” to be triggered on “ADD_ONLY”. You have not added any records to table “Property” recently, so the rule is not being triggered.
You app is not deployed, so the webhook will not be invoked.
I suggest you fix these problems and then try the rule again. When you do that, wait a minute or two for the rule to show up in Audit History. Then see what the Audit History tells you. Using the Audit History is the best way to diagnose problems. That is exactly what I do.
We do not adjust dates or times based on the Timezone in Properties. We simply use the Date and DateTime values you specify when we add or update the record.
In one of your JSON Bodies, you specified the expression UNIQUEID(). If you are adding a record with a key that specifies an InitialValue of UNIQUEID() , you should omit the field from JSON. We automatically initialize the key field based on its InitialValue. This is explained in this
paragraph which says:
Each individual Row value must normally include the key field values of the record to be added. However, if the key field contains an “Initial value”, you can omit the key field value. For example, you should omit the key field value when the key field has an “Initial value” of UNIQUEID() or RandBetween(). The system will initialize the key field to the “Initial value”.
See this article https://help.appsheet.com/integrations/api/adding-records-to-a-table