Delay in System Created Date When Fetching Data via BC API

(6) Share

Report

Posted on by _Hampus_

Hi,

I’m currently working on a Logic App flow that fetches data from a Business Central (BC) API and stores it in cloud storage. However, I’ve encountered an issue: when I make a GET request to the API, the systemCreatedAt timestamp in the response appears to be 1.5 to 2 hours behind the actual data I see when viewing the same table directly in the Business Central interface. I’m trying to extract data from a custom extension log table via an API query I’ve developed. I’ve searched online for explanations but haven’t found any solid answers. I also asked ChatGPT, and it suggested that the issue might be due to the underlying SQL database exposing only a snapshot of the table rather than a fully up-to-date version. Despite this hint, I haven’t been able to find any articles confirming that behavior.

Does anyone know if there’s a way to retrieve real-time data from the BC API or if this delay is a known limitation? (I haven't encounter this problem before) Any tips or references would be greatly appreciated.

Thanks in advance!

Categories:

Dynamics 365 Business Central

I have the same question (0)