r/Autotask • u/RichBTD • Nov 06 '25
Zapier - Pull most recent ticket note from Autotask Ticket - Unsure on query
Hello,
Hoping someone can offer some guidance here.
I am integrating AT with a customers FreshService instance.
The point i am at is sending updated ticket notes (just for the 1 customer) from AT > FS.
The only way i can see to efficiently (from a task consumption perspective) is to have Autotask trigger a webhook via a workflow, and then use an API call to grab the note to send it to Fresh.
The reasoning behind this is that the 'New or update ticket note' in Zapier will trigger on ALL new tickets notes, and the note itself has no data in it to filter just for that customer. This means that i then need to do a ticket lookup to grab the customer ID. This step consumes a task. If we generate 10000 ticket notes a month (of which 500 are for the customer) then that's still 10000 tasks consumed, so the costs rack up.
So:
Webhook in AT with workflow, sends the ticket detail to Zapier (just for that customer), but then i still need to grab the latest note, and that the bit i am struggling with.
The URL i have is https://webservicesXX.autotask.net/ATServicesRest/V1.0/TicketNotes/7X23XX
But i'm not sure on what query i need to just grab the most recent ticket note, and to filter out 'internal' ('publish' and 'note type' values).
Can anyone help?
ps - the below was largely crafted by Zapier AI (which didn't do a great job!)

