Forum Discussion
How can I connect to BC365 data using REST API connector?
I have a custom/"advanced" API in BC365, and I want to pull all data from this API into my Fabric Warehouse (or Lakehouse).
I want to use the REST connection in Copy data activity within pipelines for this. For the "base URL" I provided the base URL (https://api.businesscentral.dynamics.com/v2.0/{{tenentid}}) and it seemed to work upon testing the connection:
I am lost on how to proceed from here with: What to provide for other parameters and how to get these parameters?
The data I specifically want to pull are salesInvoiceLines from BC365 custom API. I need to pull all the salesInvoiceLines. So something like this, I assume: https://api.businesscentral.dynamics.com/v2.0/{{tenentid}}/Production/api/{{anonymized}}/SalesInvoices/v2.0/companies(guid)/salesInvoiceLines(guid).
I'd appreciate specific instructions, thanks!
Hi useruserhi91
It sounds like you've successfully set up the base URL and tested the connection. You can refer to the method provided in the following link to configure:
Solved: Microsoft Fabric connection to REST API - Microsoft Fabric Community
And here is the detailed help provided by the official documentation:
Configure REST in a copy activity - Microsoft Fabric | Microsoft Learn
These should help you solve, if you have any questions you are welcome to continue to ask in this forum.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi useruserhi91
It sounds like you've successfully set up the base URL and tested the connection. You can refer to the method provided in the following link to configure:
Solved: Microsoft Fabric connection to REST API - Microsoft Fabric Community
And here is the detailed help provided by the official documentation:
Configure REST in a copy activity - Microsoft Fabric | Microsoft Learn
These should help you solve, if you have any questions you are welcome to continue to ask in this forum.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.