Extend fields Business Central piece can pull in

Need help
1

Hi, I am looking to pull more tables/fields in using the Microsoft Dynamics 365 Business Central piece, however, I don’t really know where to start. I have already created a V2 API to expose the table I need, but I’m not sure where to go next. Activepieces doesn’t seem to see the new API.

Any advice is super appreciated!

Thanks

2

Can you explain your use case a bit more? Are you trying to add/read rows in tables from the Business Central piece?

Also, does the action return any specific error for central piece?

3

The reason Activepieces doesn’t show your custom API in the dropdowns is just because the pre-built Business Central piece has its schemas hardcoded to Microsofts standard endpoints (like Customers, Items, etc.). It won’t query your custom API namespaces dynamically. Since you’ve already done the hard work of exposing the V2 custom API in BC, you can actually bypass the standard piece actions pretty easily using one of two workarounds:

Option 1: Use “Custom API Call” Check if the BC piece has a “Custom API Call” action. If it does, use that. It’ll automatically handle your OAuth2 authentication using your existing connection, and you just manually type in the the path the your custom API endpoint (e.g., /api/yourPublisher/yourGroup/v2.0/…

Option 2: Use the standard HTTP piece
If the BC piece doesn’t support custom calls, just use the standard HTTP piece. Set the action to “Send HTTP Request,” set the authentication to OAuth2 using your saved BC credentials, and make a direct GET request to your custom endpoint URL:

https://api.businesscentral.dynamics.com/v2.0/{tenant_id}/{environment}/api/{publisher}/{group}/v2.0/companies({company_id})/{yourCustomTable}

That bypasses the dropdown limits entirely and lets you pull whatever custom tables you want.
If you run into any issues mapping the OAuth2 headers or parsing the custom JSON payload on the Activpieces side, feel free to shoot me a DM! I build custom ERP integrations and would be happy to help you wire up a clean script or flow for this.