Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Azure Data Factory get Business Central General Ledger Entries

(1) ShareShare
ReportReport
Posted on by

I have created an OData LinkedService and connected it to Business Central as per screenshot:

 

Then when I run the pipeline or preview, I am getting the following error:

Operation on target Copy data1 failed: Failure happened on 'Source' side. ErrorCode=ODataRequestNotSucceeded,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Requesting response from path G_LEntries and query failed with status code NotFound and message {"error":{"code":"Internal_CompanyNotFound","message":"Cannot process the request because the default company cannot be found. You can specify a default company in the service configuration file, or specify one for each tenant, or you can add a query string in the form of "company=[name]". You can see the available companies by accessing the default OData web service, Company. For more information, see "OData Web Services" in Help. ,Source=Microsoft.DataTransfer.Runtime.ODataConnector,'

 

I don't know if this is the way to pass the parameters or whether it can be managed in another way. I have changed the parameter name multiple times, to Company, Companies, company, companies, companyname, defaultcompany but I continue to recieve the same error.

 

I need a redirection or a pointer, whether this is how to pass the parameters or if there is another way.

  • YUN ZHU Profile Picture
    85,819 Super User 2025 Season 1 on at
    Azure Data Factory get Business Central General Ledger Entries
    Hi, I suggest you try the following three methods first.
    In addition, it is displayed in the following way in Odata. You can check the URL of your environment in Web Services page.
     
     
    Hope this helps.
    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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans