Azure Data Factory Writing to Business Central

(6) Share

Report

Posted on by KO-29041810-0

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)

All responses (1)

Answers (0)

Suggested answer

SA-05110627-0 25 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No