We have a system (lets call it system X) which we have developed ourselves, and in this system, we display data from certain entities in CRM.
Up until now we have used the audit log to detect changes to certain entities, and then synchronized the nessecary tables to our own DB and system X reads the records from here.
I asked the devs why we do not fetch the data directly from CRM and they said that the Web API query times were too slow.
Now, since microsoft has changed the way audit logs work (moved them to azure cosmos DB), our synchronization fails, since the audit logs do not appear in order.
My question is, what would be your solution to this issue? Plugins, kingswaysoft, power automate with custom connector or other?
Is there a faster way to query CRM than to use the Web API or is there a way to optimize these queries?
Any advice would be appreciated. Thank you in advance