web
You’re offline. This is a read only version of the page.
close
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.

I have the same question (0)
  • YUN ZHU Profile Picture
    95,748 Super User 2025 Season 2 on at
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,092

#2
YUN ZHU Profile Picture

YUN ZHU 663 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 515

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans