web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows How to load OData webs...

Power Automate - Building Flows

Unanswered

How to load OData webservice from dynamics business central

(0) Share

Report

Report

Posted on by SCoPeS

Hi,

I need to download data using a OData webservice created in business central.

When using the standard connector for API's, the webservice is not there.

In PowerBI desktop, it shows under 'Web Services'

Then the URL would be

https://api.businesscentral.dynamics.com/v2.0/<TenantID>/Production/ODataV4/Company('<CompanyName>')/Power_BI_Posted_Sales_Invoices

How can I load this URLin Automate and store it in SQL in 1 bulk, so not loop over the records?

Thanks

Johan

Categories:

Business Process Flows

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

developerAJ 4,598 on at

Like (0)

Report

How to load OData webservice from dynamics business central

if you are looking to do from Odata this should be done using HTTP action not the business central action

Business central action works only for the API pages built through AL code not webservices or Odata

If this solution helped you resolve your issue, kindly mark it as accepted — it makes it easier for others to find and also closes the discussion. If you found it useful, a Like ❤️ would be greatly appreciated!

🏷️ Please tag me @developerAJ if you still have any queries or issue persists

🤝 Let’s connect on LinkedIn

📘 Explore more on my articles

🐱‍💻 Github Link

💼👥 Looking for Jobs Power Platform & Microsoft Jobs Network

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Forum hierarchy changes arriving December 5th!

Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Leaderboard > Power Automate

#1

Tomac 489 Moderator

#2

Michael E. Gernaey 473 Super User 2025 Season 2

#3

chiaraalina 267

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans