Hello,
I am currently developing a program that aims to synchronize our customer database with Klaviyo's, primarily focusing on syncing sms/email consent settings.
The synchronization from our database to Klaviyo has been successfully implemented, however, I am encountering difficulties when setting up the synchronization from Klaviyo back to our database. The main obstacle is retrieving the appropriate customers that we need to update.
I have attempted to use filters to retrieve profiles where the consent data was changed specifically within the past day. However, it seems the consent_timestamp is not available for JSON:API filtering.
So far, I have managed to filter profiles that have been updated in the past day. The downside of this approach is that it results in over 20,000 customers, of which I am sure only a small percentage actually need synchronization.
Does anyone have any insights or experience in generating a list of this nature? Any help would be greatly appreciated.
Thank you,
Dylan
