API - Update records in the table via Zapier

[JacoStander]

Hi,

I've created a REST API POST request in Zapier (webhook) to update the user table with the information I receive from the CRM platform (PipeDrive). I need to insert the assigned agent in the user table under assigned_agent. I get the agent name from my CRM, and I then feed the info via the API call to Caspio.

I us https://xxxxxxxx.caspio.com/rest/v2/tables/pt_tbl_users/records?q.where='email=xxxxxxxxxx'

in my body, I use

{ "assigned_agent":"Agent Name" }

This, however, inserts the value of "Agent Name" in a new blank row and not in the same row as the user's email address.

Any ideas why this could happen? Maybe I misunderstand something...

Many thanks

 

UPDATE: I think I found my mistake; the WHERE clause is not recognized by adding it to the URL in Zapier. So it is now treated as INSERT and not PUT.

Does anyone have any idea on how to provide the WHERE clause in ZAPIER?

 

[Tubby]

Try changing the Method type to "PUT" instead of "POST". If you check via SwaggerUI, update queries are all using "PUT" as the method.

If you changed it to PUT, it might give you a field for the WHERE statement.

[JacoStander]

Many thanks for the reply; let me try that out tomorrow, and I will provide feedback.

[Aether]

Hello Everyone, have you already checked this new feature of Caspio called "Webhooks"?
This is kind of similar to Zapier which automates integrations between different applications.
For further details check it here. https://howto.caspio.com/webhooks/webhooks-overview/

[Aether]

Hello! Caspio releases another new enhancement to the WebHooks feature, refer below: 

• Ability to send webhooks for tables with triggered actions 
• Ability to send webhooks based on changes in tables caused by triggered actions and application tasks
• REST API access to the count of created messages, calls, and received errors for webhooks from the past 30 days

Source: https://howto.caspio.com/release-notes/caspio-41-0/#:~:text=Enhancements to-,Caspio Webhooks,-(Beta)