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 ...
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.

     

     

nilendraFabric's avatar
nilendraFabric
Super User
1 year ago

Hi Anonymous 

 

Ensure your Bearer token has adequate permissions by checking the Azure AD app registration and its role assignments in Business Central

 

Use tools like Postman or Power Query to directly test the API endpoint and confirm whether `CompanyID` is returned outside of Fabric Data Pipeline

If the issue persists, consider using Power Query or Spark Notebooks within Fabric to extract data directly from Business Central APIs

Anonymous's avatar
Anonymous
Not applicable
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.