Small and medium business | Business Central, N...

Business Central - Get Record (v3) Row Id

(0) Share

Report

Posted on by fran2105

416

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 Dataverse table and therefore I can pass it dynamically by choosing it from the Dynamic Content. But, whether I choose it from the Dynamic Content of 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!

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

What you need to use there us the SystemID field from within Business Central. That is not the same as the GUID from dataverse.

This is the $systemId field (field 2000000000) for a record, it is a GUID but will be read fine as text.

You can find this value for a given Business Central record by inspecting the page (Ctrl+Alt+F1) and scrolling down the fields until you see the $systemId field. It is a non-editible field that is unique to every record in Business Central.

Was this reply helpful? Yes No
fran2105 416 on at

Like (0)

Report

Hi Inge M. Bruvik

I am indeed using the systemId field (2000000000) of the record - I am keeping the BC GUID (System ID) in a custom field in my Dataverse table so that I can refer to it.

Any other suggestions, maybe?

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

I just did a test myself to confirm. And it works fine when i use the correct systemID. So my suggestion is that you do not use the correct id.

Was this reply helpful? Yes No
fran2105 416 on at

Like (0)

Report

Hi there, thank you for your reply.

I am using the correct ID - see below;

Do I maybe need to wrap the GUID in curly brackets or quotes?

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

I did not wrap them in curly brackets.

There must be something missing in your config. Can your get record task be connected to the incorrect BC tenant or enviornment?

Was this reply helpful? Yes No
James McCullough 377 on at

Like (0)

Report

I REALLY hate to necro-bump but did you ever find an answer to this? I've had an issue with customerPayments doing the same thing. The 2000000 ID matches, but the record just will not show, even if I tickle it with Postman, no dice.

Was this reply helpful? Yes No
Y_A 395 on at

Like (0)

Report

Hi James McCullough - yes, the issue was solved because we were missing the OdataKeyField property.

In our case, we did a custom API page and just added the below line;

ODataKeyFields = SystemId;

Hope the above solved your issue!

Was this reply helpful? Yes No