Associations and filtering by a timestamp!!

Hi there HS community!
Is there a way to filter by a datetime stamp AND include associations from any endpoint for any object or engagement? (I’m trying my best to avoid having to make additional calls when syncing data in the integration and currently I don’t see any endpoint that supports both filtering by any date time stamp AND including associations…so as of now I’d have to search the CRM for any new/updated records for say companies in the past 10minutes since the last sync, and then grab all of those record IDs and make a second request PER RECORD for the associations, and then a 3rd request for the property values i’m wanting to pull into the original object to begin with. This is not only timely and inefficient but a huge hurdle to get this integration off the ground. Finally, I’ve found a workaround where i can only use the Search the CRM functionality and include associated record properties…but the ‘solution’ involves using workflows in the UI to leverage copying and setting property values from one ‘source’ object to a ‘destination’ object which works! But it won’t if the HS account in questions is free or a starter…as those tiers don’t have workflows…so i’m either limited by the API and have to build out functionality to make a single request for a max of 100-250 per page (which btw figuring out what the limits were for ‘limit’ and ‘count’ query parameters felt like pulling teeth…the documentation really needs to be updated to be clear about these vital details for your API) then 2 additional requests per record …i mean if a single enterprise level company uses this integration and they have system or app syncs the integration will timeout or fail or we’ll run into rate limiting issues.

Any thoughts or suggestions?

Hi @Bramos423,

Thank you for reaching out to the Community and for including these details!

I wanted to invite our subject matter experts to this conversation -- @LMeert, @louischausse, @klloyd__1 - Do you have any insight on this for @Bramos423?

Thank you!

Best,

Kristen