web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Azure Data Factory Wri...
Small and medium business | Business Central, N...
Suggested Answer

Azure Data Factory Writing to Business Central

(6) ShareShare
ReportReport
Posted on by KO-29041810-0 8
Hello, I am trying to write data from a blob storage to a temporary table in Business Central using Azure Data Factory. I have tried the OData option using a REST API option in Azure Data Factory. I have set up the linked service for both source and sink options, that works and I tested the connection. The issue now I am facing is passing the relative url as we have multiple companies in the the sandbox. How do I pass that dynamically in the pipeline? I have something like this in the relative url option in ADF companies({id})/purchaseInvoices. I want to be able to pass the company id in the pipeline so it knows what company it will be writing to. Please advise
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    SA-05110627-0 Profile Picture
    SA-05110627-0 25 on at

    If you're using linked services for integration, you're bound by their limitations and can't dynamically adjust parameters like companyid. However, if you're able to make direct web calls to the OData API, you can substitute the companyid variable at runtime.

    For on-premise setups, there's an alternative: you can set a default company on the NST by configuring the ServicesDefaultCompany parameter. This allows you to omit the company specification in the OData URI altogether.

    If you find this answer helpful please mark it as the suggested answer.

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

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

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. OussamaSabbouh 2,068 Super User 2026 Season 1

#2
Dhiren Nagar Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Dhiren Nagar 1,194 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. YUN ZHU 1,123 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans