API with Custom Fields on OrderLine

(4) Share

Report

Posted on by GV-08111304-0

110

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

I have the same question (0)

All responses (6)

Answers (4)

Verified answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (3)

Report

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

Was this reply helpful? Yes No
Verified answer

TGirli 36 on at

Like (2)

Report

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

Was this reply helpful? Yes No
Verified answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (2)

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

Was this reply helpful? Yes No
Verified answer

GV-08111304-0 110 on at

Like (3)

Report

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!

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (2)

Report

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

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,603 Super User 2025 Season 2 on at

Like (2)

Report

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

Was this reply helpful? Yes No