Hi everybody,
I've a question: I must download all data from dimensionSetLines tables, with API I can extract all the data but for each "argument" like:
businesscentralPrefix/companies({id})/generalLedgerEntries({id})/dimensionSetLines({id})
This features means thet if I've 18000 records into generalLedgerEntries, I must call dimensionStelines 18.000 times.
This means that the extraction time increases a lot, for example for each API call it takes 2 seconds for 18,000 calls the time is about 10 hours.
It's possible execute entire download of table dimensionSetLines ?
thanks
Hi, Not sure if this can achieve your purpose, if you use the Expand method, you can get all the generalLedgerEntries and dimensionSetLines at once.
More details: https://yzhums.com/6117/#toc13
https://api.businesscentral.dynamics.com/v2.0/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox221/api/v2.0/companies(25333785-59e9-ed11-884d-6045bde998ec)/generalLedgerEntries?$expand=dimensionSetLines
Hope this can give you some hints.
Thanks.
ZHU
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156