How can I connect to BC365 data using REST API connector?

[useruserhi91]

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!

[Anonymous · Accepted solution]

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.