Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

CompanyID is not returning from Business central for BC API Companies

Hello all,

 

 

 

I have multiple companies in the Microsoft Dynamics 365 Business Central environment, so i want to pull all of those company IDs using REST API for automating some processes. So I went through the API documentation of Microsoft to get the companies list with IDs.

GET companies - Business Central | Microsoft Learn

 

In the API response, it's mentioned that it will return the companyId for each company. So I implemented the same using Fabric Data Pipeline, but am not getting the CompanyID from the API response. Is there any reason? I'm using Bearer token authentication only but still am not seeing the CompanyID in api response

 

Pipeline

 

 

Actual API response coming from data pipeline

 

 

Expected API Response from Microsoft

 

 

Is there any other way to pull the CompanyIDs of Business Central companies using Fabric data pipelines. Am i missing anything can anyone suggest me please and help me in resolving it.

 

 

Thanks in advance, any help is really appreciated.

data engineering
data pipeline
environment
User Data Functions
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi nilendraFabric 

     

    Thanks, am able to get the CompanyID information from Postman and even with Spark notebooks also, not sure why pipelines is not returning the CompanyID.

     

    I implemented the Bearer token authentication approach in notebook and loading the data to fabric lakehouse in config table from there am referencing it for my needs.