CSI - Add Current Materials/Item BOM to Item using REST

Legacy Contributor

We want to build and update Item BOMs (Current Materials) in Cloud Suite Industrial using REST. We are able to create items but can't find what methods to use to create the BOM structure. Has anyone done this with CSI or is there a resource for what methods exist for the various object types?

 

Example of successful new item:

POST https://<...removed...>/IDORequestService/MGRestService.svc/xml/SLItems/additems HTTP/1.1
Accept-Encoding: gzip,deflate
authorization: <...removed...>
ConfigGroup: <...removed...>
Configuration: <...removed...>
Content-Type: application/xml
Content-Length: 956
Host: <...removed...>
Connection: Keep-Alive
User-Agent: Apache-HttpClient/4.1.1 (java 1.5)

<?xml version="1.0"?>
&nbsp; &nbsp;<ArrayOfIDOUpdateItem xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">www.w3.org/.../XMLSchema"</a> xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">www.w3.org/.../XMLSchema-instance"</a> xmlns="<a href="http://www.infor.com">http://www.infor.com"></a>
&nbsp; &nbsp;&nbsp; &nbsp;<IDOUpdateItem>
&nbsp; &nbsp;&nbsp; &nbsp;<Action>Insert</Action>
&nbsp; &nbsp;&nbsp; &nbsp;<ItemId>PBT=[Items]</ItemId>
&nbsp; &nbsp;&nbsp; &nbsp;<Properties>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<UpdateProperty>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<IsNull>false</IsNull>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<Modified>true</Modified>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<Name>Item</Name>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<Value>0-APITEST-03</Value>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;</UpdateProperty>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<UpdateProperty>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<IsNull>false</IsNull>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<Modified>true</Modified>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<Name>Description</Name>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<Value>Add using RESTful Web Services API</Value>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;</UpdateProperty>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<UpdateProperty>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<IsNull>false</IsNull>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<Modified>true</Modified>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<Name>ProductCode</Name>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<Value>PPRT</Value>
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;</UpdateProperty>
&nbsp; &nbsp;&nbsp; &nbsp;</Properties>
&nbsp; &nbsp;</IDOUpdateItem>
</ArrayOfIDOUpdateItem>

 

We'd like something similar to add Item BOM structures (Current Materials). Any help in where to look is greatly appreciated.

</code><code>Thank you in advance!

Rees Howel

The relevant IDOs are SLJobmatls and SLJobRoutes. The tricky bit is that all types of job (Current, Estimate, Job etc) live in the same SQL tables and use the JobType property to distinguish the entries. Current BOMs also have Job Numbers just like any other type of BOM. If you open Current Operations, remove the filter and put it into design mode and look at the Costs tab you'll see the hidden fields. Obviously the form autonumbers everything for you and inputs the relevant JobType. If you are loading from outside CSI, you may have to work those bits out for yourself.



HTH