System IDs of Business Central table elements

[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.

[okanabat · Accepted solution]

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

[st0rk]

@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.

[okanabat]

@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.