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)

[FinTheHuman]

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

Caspio Webhooks allows your applications to communicate with third-party systems in real time when changes to data occur. 
In this release, we introduced the following updates:

• In non-HIPAA/Compliance accounts, webhooks logs now show the information sent and received.
• All accounts, including HIPAA/Compliance, now can:
  • Send webhooks based on table events initiated by triggered actions and tasks.
  • Configure webhooks for tables with triggered actions enabled for the same event as the webhook. 
• A single REST API call can be used to activate or deactivate all events for a selected webhook.

Source: https://howto.caspio.com/release-notes/caspio-47-0/#:~:text=Enhancements to Caspio Webhooks

[FinTheHuman]

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

Caspio Webhooks allows your applications to communicate with third-party systems in real-time when data changes occur.

The system now supports configuring multiple webhook events of the same type per table — whether for inserts, updates, or deletions. This enhancement removes the previous limitation where only one webhook event per action type could be set up for any table.

Source: https://howto.caspio.com/release-notes/caspio-49-0/#:~:text=Enhancements to Caspio Webhooks