You’re offline. This is a read only version of the page.
10
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.
#1
André Arnaud de Cal...
291,134
Super User 2024 Season 2
#2
Martin Dráb
229,928
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (