LastExportDateTime When Endpoint Doesn't Support It?

Integrator.io
1

I am working with a new app called Hotjar which captures survey responses. It appears that the API does not support date/time filtering, so I don't believe running a Delta export is going to work. Do I have any options for only grabbing the new data since the last run, or will I need to effectively ExportAll each day?

https://help.hotjar.com/hc/en-us/articles/12244109929751-Hotjar-API-Reference

2

I am not very familiar with Hotjar but:
What if you use a webhook from Hotjar to Celigo to receive data only when new responses are submitted?

https://help.hotjar.com/hc/en-us/articles/13052816995991-Webhooks-Reference

3

If the volume isn’t too high and the API response includes an “Edited/Entry time” field, you can configure an output filter at the export step using Edited time > lastExportDateTime, and set the export type to “All” for the flow.

4

Thanks Nuri for the suggestion. Originally this is how I designed it, but the kind of survey we have didn’t allow for the webhook unfortunately.

Thanks again for the suggestion!

1 Like
5

Thanks Yash! I ended up doing an output filter where SurveyCreateDateTime > lastExportDateTime and that worked!

1 Like