API: Error on update record with triggered action

[Jarias]

When updating a record using the REST API, I encounter the following error:

"Code":"TriggerRuntimeError","Message":"Data change cannot be performed due to triggered action failed. Please contact administrator."

The table has a triggered action to send an email anytime a record is updated or inserted.

The really strange part is that everything works perfectly fine when using chrome.  The error is only thrown in mozilla and only thrown when updating a record.  Inserting a record works as expected.

I am using php & curl to make the requests.

 

[MayMusic]

Which site your account is on and was this working before and stopped recently?

[Jarias]

Site 06 - b6.caspio.com

I cant say if it worked previously I just tested in firefox for the first time yesterday.  This is not actually in use yet.

[Jarias]

Update: This magically went away.  ¯\_(ツ)_/¯

[kpcollier]

57 minutes ago, Jarias said:

Update: This magically went away.  ¯\_(ツ)_/¯

The best kind of solutions. 

[autonumber]

Hi, just to update this post about this kind of error. 

Most likely your API profile doesn't have permissions to all affected tables. It should have at least read permissions to all tables that you are using in select in your trigger, and you need to have update/insert/delete permissions to the tables which are used in update/insert/delete actions. 

You can check the permissions by going to Account > Access Permissions > Web Services Profile, then selecting the Swagger profile you are using and clicking edit. Ensure that 'Enable access to all objects' and 'Profile can create objects' are enabled in the Permission section.

[EdwardG]

On 11/1/2021 at 9:25 AM, autonumber said:

Hi, just to update this post about this kind of error. 

Most likely your API profile doesn't have permissions to all affected tables. It should have at least read permissions to all tables that you are using in select in your trigger, and you need to have update/insert/delete permissions to the tables which are used in update/insert/delete actions. 

You can check the permissions by going to Account > Access Permissions > Web Services Profile, then selecting the Swagger profile you are using and clicking edit. Ensure that 'Enable access to all objects' and 'Profile can create objects' are enabled in the Permission section.

this started happening to us. It will happen randomly to batches. Sometimes 1 out of 10, sometimes 10 out of a 400 batch.

[RuisiHansamu]

Just to share my experience with this error, I always check if what kind of action,( GET, POST, etc) I am using before contacting support or any third-party support.  

https://howto.caspio.com/web-services-api/rest-api/special-considerations/

https://howto.caspio.com/web-services-api/rest-api/error-handling/