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.