cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yabela
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

 

yabela_0-1647524095393.png

 

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!

 

 

 

0 REPLIES 0

Helpful resources

Announcements
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)