Azure Data Factory Writing to Business Central

(1) 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