Answered

System IDs of Business Central table elements

(0) Share

Report

Posted on by OkanAbat

Hello,

I have created flow that gets item records from sharepoint and creates sales order in Business central. For now, I exported some of items and put their system IDs manually. I need to get all system IDs of my item list but I couldn't find a solution for that. When I try "Get records" action it asks for row ID. I'm stuck at this point. Is there a way to get all system IDs of relat table ?

Thanks in advance.

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

OkanAbat 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello all,

The issue is solved with using system apis. You can add "table=2000000138" after your link and reach the related table for apis and get the one you need. The standard web services do not bring the system ids, but this apis bring exactly what I needed.
Regards,

Okan Abat

Was this reply helpful? Yes No
st0rk 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@okanabat hello,

I am trying to do something very similar using BC API v2 endpoint. Are you able to see all the datasets in power automate? I am having issues creating purchase order, if I call this api endpoint in Postman I see that purchaseOrder table is present, but when I am trying to create a new item in that table i power automate flow, I don't see it listed there.

Thanks.

Was this reply helpful? Yes No
OkanAbat 16 on at

Like
a
(0)

Report
Copy link

Link copied!

@st0rk Hello,
I used the API V2 that I shared above for getting purchase order data via HTTP connector in Power Automate. In my case I used this method instead of standard get records (BC) action because I needed system IDs for the records.

If you use standard Create a Record (v3/v2) action for BC you may not see the fields that you expect to see. There should be custom api created for this type of need then you can select the custom API in related BC action in Power Automate.

Although I don't know exactly what you want to do, the workaround can be using HTTP action in Power Automate to POST/GET from BC.

I hope it is helpful. I am BC Functional Consultant and interested in Power Automate. I'm not an expert at Power Automate but If you have further question I'd be glad to answer.

Have a nice day.

Was this reply helpful? Yes No