Jump to content
  • 0

API - Update records in the table via Zapier




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?



Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

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)

Link to comment
Share on other sites

  • 0

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...