'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Retrieve Business Central Data in Power Automate Using APIs
Question details
The user needs to retrieve records from a Dynamics 365 Business Central table within Power Automate but cannot locate a suitable built-in action.
- Product
- Microsoft Power Automate
- Device & OS
- not provided
- Scenario
- Building an automated workflow that fetches specific table records from Business Central via Power Automate.
- Observed behavior
- The built-in Power Automate actions for Business Central do not provide the specific table retrieval functionality required by the user.
Ensure you have the necessary administrative privileges and API access enabled for your Dynamics 365 Business Central environment before attempting to configure custom API connections in Power Automate.
Consult the Microsoft Power Automate Community
Since custom API endpoints in Business Central can be complex, reaching out to API specialists in the official community is the most effective way to get targeted guidance.
The built-in Business Central connector does not expose every single table by default. When you encounter limitations, the Power Automate community is an excellent resource for finding workarounds or specific API configurations.
Open your web browser and go to the official Microsoft Power Automate Community website.
Use the search bar to look for terms like 'Business Central API retrieve records' to see if other users have already solved your specific table integration issue.
If no existing solution matches, create a new post detailing the exact Business Central table you are trying to access and the API endpoints you have already considered.
Use the Premium HTTP Action to Call the API
If built-in Business Central connectors fall short, you can use Power Automate's premium HTTP action to call Business Central standard or custom APIs directly.
Boost Your Productivity with WPS Office
While you configure your advanced Microsoft Power Automate flows, consider WPS Office for your daily document needs. It is a highly compatible, free alternative to Microsoft Office that seamlessly handles Word, Excel, and PowerPoint files without the heavy subscription costs.
- 1. Visit the WPS Website: Go to the official WPS Office website to find the free download link.
- 2. Download the Installer: Click on 'Free Download' to get the installer for your Windows, Mac, or Linux device.
- 3. Install and Open: Run the installer, follow the on-screen instructions, and open WPS Office to start managing your documents seamlessly.
Frequently Asked Questions
Why can't I find my Business Central table in Power Automate?
Some custom tables or specific standard tables are not exposed by default in the built-in Business Central connector. You often need to publish a custom API page or Web Service in Business Central to make these tables accessible to external apps like Power Automate.
Is the HTTP action in Power Automate free to use?
No, the HTTP action is considered a premium connector in Power Automate. You will need a premium license or a per-flow plan to use it to call external Business Central APIs.
Can I use custom connectors for Business Central?
Yes. If the standard Business Central APIs do not meet your needs, you can create a Custom Connector in Power Automate that specifically targets the custom API routes you have built and published in Business Central.
