Delete Assembly BOM records using API, web service, or AL code

(0) Share

Report

Posted on by tjk

I would like to delete the Assembly BOM records for a given Parent_Item_No. I looked at using OData services with a DELETE request and receive a message "'DELETE' requests for 'AssemblyBOM' of EdmType 'Collection' are not allowed within Dynamics 365 Business Central OData web services.

So it appears the AssemblyBOM OData web service does not allow delete requests. Is there any way around this?

I also looked for an API for the Assembly BOM table but that does not seem to exist. Could someone please confirm this?

I have started looking at creating a custom API with AL code to perform the delete. I believe I have found a guide to create a custom codeunit API, however, I can't figure out the AL code required to actually delete the BOM records based on a Parent_Item_No parameter. Any guidance?

All responses (1)

Answers (0)

JAngle 159 on at

Like (0)

Report
Copy link

Link copied!

Even though it’s a few years old now it’s still a handy guide for using each command: community.dynamics.com/.../how-to-create-custom-apis-for-business-central-even-from-macos

I usually ensure deletion by adding the property for that in the api page. When testing make sure you set the If-Match property for the http call. A wild card is fine in your case. The ondelete trigger of the page will need extra logic to find the extra records. If this is troublesome I would try this method instead: joshanglesea.wordpress.com/.../

It’s more stand alone as the codeunit will take regular logic like check the item has a BOM if it does then delete all the lines