Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

API dimensionSetLines extract all contents

(0) ShareShare
ReportReport
Posted on by 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 ?

  • Andrea Castagno Profile Picture
    Andrea Castagno 10 on at
    RE: API dimensionSetLines extract all contents

    thanks

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    RE: API dimensionSetLines extract all contents

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans