Jump to content
  • 0

API - Update records in the table via Zapier


JacoStander
 Share

Question

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.

image.thumb.png.29767880ef9453d226342ce4953c62e9.png

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?

image.thumb.png.17c628f6af50016ac6887c9165e03112.png

 

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

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.

Guest
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.

Loading...
 Share

×
×
  • Create New...