API with Custom Fields on OrderLine

(3) Share

Report

Posted on by GV-08111304-0

Hi, I have a problem, we talk about purchase orders.

1) I created custom fields on the Purchase Line table.
2) I cloned the header Standard API with APIGroup and APIPublisher.
3) I cloned the order lines Standard API, I added the custom fields with the trigger on the OnValidate and extended the source table (Purch. Inv. Line Aggregate).

The GET call on Postman works, I see the fields, but the custom fields are not valued.
Is there any code to add to make them pass from the Purch. Inv. Line to the Purch. Inv. Line Aggregate?

I’m not clear on this point.

Thanks!

Categories:

Dynamics 365 Business Central

All responses (6)

Answers (4)

Suggested answer

Khushbu Rajvi. 14,482 Super User 2025 Season 1 on at

Like (1)

Report

API with Custom Fields on OrderLine

Hope this helps as well:https://www.youtube.com/watch?v=khVdeOwlJ90

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-develop-custom-api
Suggested answer

YUN ZHU 81,415 Super User 2025 Season 1 on at

Like (1)

Report

API with Custom Fields on OrderLine

Another option is to use WebService -> Odata directly, although the performance is not as good as APIs.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/web-services?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU
Verified answer

GV-08111304-0 93 on at

Like (2)

Report

API with Custom Fields on OrderLine

The mistake was very trivial and I thank you very much @Suresh Kulla for writing to check field no.

The error was in having given a different Field No. for the custom field between Purch. Inv. Line and Purch Inv. Line. Aggregate.
Now the values of the custom fields with the trigger on OnValidate with RegisterFieldSet are correctly read by the Purch. Inv. Line. Aggregate.

Thank you all!
Verified answer

Ramesh Kumar 3,298 on at

Like (1)

Report
API with Custom Fields on OrderLine

Below things which I would check is below

The custom fields on the Purchase Line are correctly written to the Purch. Inv. Line Aggregate (or any other related table).

Use code to transfer values between these tables, either in the OnValidate trigger or via a custom procedure

Ensure that field mapping is handled correctly during posting or invoicing

Thanks, Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
Verified answer

TGirli 36 on at

Like (1)

Report

API with Custom Fields on OrderLine

Since you've extended the Purch. Inv. Line Aggregate, the issue is likely that the data is not being transferred correctly from Purch. Inv. Line to Purch. Inv. Line Aggregate. Ensure the fields are mapped. You may need to explicitly map your custom fields in the API page extension. Try overriding the OnAfterGetRecord() trigger in your API page to manually pass values from Purch. Inv. Line to Purch. Inv. Line Aggregate.

Also make sure your API page extension actually includes the custom fields and that they are exposed with Field attributes.

If you have triggers on OnValidate, ensure they are actually firing when the API fetches data. You might need an event subscriber to transfer the values before they are fetched by the API. If you’re still stuck, try debugging by inserting sample values directly into the Purch. Inv. Line Aggregate table and checking if they appear via Postman
Verified answer

Suresh Kulla 46,926 on at

Like (2)

Report

API with Custom Fields on OrderLine

As long as you have the same field no. it should work but look at codeunit 5529, there are functions to transfer data.