Hi,
We set up few workflows to export data from monday.com to external DB using GraphQL.
There are scenarios where we create items on board and deletes them later, but they will be export to Database using above work flow.
We need to identify deleted items from board and make sure they are deleted from DB as well.
I am trying to use below GraphQL to finidout the activity on board but it’s returning all types of events.
Is there a way to filter out using GraphQL and export only event=‘delete_pulse’ records ?
Can you please advise how we can alter below query to get only required event types.
Thanks & Regards,
Madhu Kolli
Hello there @madhusudhana.kolli,
You can not filter by the event. But you can filter by the item ID, so if you save the item IDs from the response you get when you delete them, you can query for the deletion event.
Cheers,
Matias
Thank you @Matias.Monday for your reply.
But we want to implement a data pipeline without any manual interaction.
People who works on Monday.com may not communicate those details to ETL team, it’s not fair to expect them to send list of ITEM_id’s etc.
Process should be able to identify deleted records and delete them from DB as well.
If we can’t just export delete events then we need to export all event activities and then filter required events outside of Monday.com.
Thanks & Regards,
Madhu Kolli
Why not use the webhooks to get notified of deletions in real time. You can also get notified of archives, or item creations, etc. Now you no longer have to poll the board and process the results. You’re reducing your entire process to a few handlers to add and remove the data from the DB, that process the webhooks.
Hello again @madhusudhana.kolli,
What Cody suggested is also a way of doing it. It could be either that, or polling the data with a cron every X amount of time to check the events in the activity logs against the IDs you have.
Cheers,
Matias
