Question

Taking an API response with multiple rows of data and sending each row to Zendesk and only once

  • 6 February 2024
  • 1 reply
  • 26 views

Hi there, trying to figure out if this is even possible in Zapier, all pointers gratefully received!

I need to take the API results from our APP and periodically update the related tickets in Zendesk. Unfortunately right now i can only get ALL the results - where each ticket would be a row. [think Ticket ID, Key value pair]

Each row has a unique ID (which is the Ticket ID) and a result and will be in JSON lines format.

I can see that i can update a ticket using the Zendesk App Update ticket event - so i need to be able to iterate/loop through each row and update the related ticket. BUT i am going to need to track which ID’s have been updated so that at the next scheduled time (lets say daily) i retrieve “ALL” results again but i only send the new entries, i want to avoid just updating records with no changes.

I have seen digests and possible store as a means to hold some interim dataset - but need pointers on how this might all be achieved. 

 

thanks

Mitch


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @mitchwh 

Try using the Looping app: https://zapier.com/apps/looping/help

Perhaps try using Zapier Tables to log/check: https://zapier.com/apps/zapier-tables/integrations#triggers-and-actions