Primary Keys Not Showing For Custom Page API In Power Automate

(2) Share

Report

Posted on by PM-15011520-0

Hi All,

I have created an Page API to expose Bank Acc. Reconciliation table which is not included in the API category (v 2.0) in Create Record (V3) action on Power Automate.

I have 5 fields in my Page API but only 3 are showing. Upon investigation, I realized that the primary keys of the Bank Acc. Reconciliation table are not showing.

Below is the Page API I created:

In power automate, Create Record (V3) action shows 3 parameters instead of the 5 fields in the Page API above:

Upon Investigating, I realized the other 2 fields are part of the primary keys of the table but I need those keys for insertion.

Any help getting those two keys to display in power automate? Thank you.

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (1)

Verified answer

Khushbu Rajvi. 9,235 Super User 2025 Season 1 on at

Like (1)

Report

Primary Keys Not Showing For Custom Page API In Power Automate

Adding more details: https://community.dynamics.com/blogs/post/?postid=97df1cea-ce9d-4e36-bd5c-a3fbab7d4ff7
Suggested answer

Ramiz 517 on at

Like (0)

Report

Primary Keys Not Showing For Custom Page API In Power Automate

As suggested by Tech-Lucky add the OdataKeyFields property.
Suggested answer

Tech-Lucky 838 on at

Like (0)

Report

Primary Keys Not Showing For Custom Page API In Power Automate

You can try 2 things:

1.) add a property of OdataKeyFields

2.) Include all fields in the same Group.