Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Business Central - Get Record (v3) Row Id

Hi everyone, 


I have created a custom table and the related API page in Business Central and I can successfully see them in Power Automate when I use the Business Central Connector. My issue is occurring when I try to use the Get Record (v3) action as it is failing with ErrorCode: BadRequest_NotFound Bad Request - Error in query syntax. 


This is my Get Record action




The GUID of the BC record is stored in my Dataverse table (in a custom field so that I can refer to it anytime) and therefore I can pass it dynamically by choosing it from the Dynamic Content. But, whether I choose it from the Dynamic Content or input the GUID manually, I still end up with the same error. 


If I use Create Record action for the same table, it works fine so I do not think it is an API issue.


Any ideas what could be wrong here, please? 


Thanks in advance!





Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,783)