Material Master Data
The material master data web service allows creating and updating materials and price conditions.
Note:
- Retrieve the WSDL to get an overview of the general options. The JSON requests correspond to the SOAP XML requests as you can see in the examples below.
- The shelves are identified either by the Import ID or Fabasoft Cloud ID.
- The materials are identified by the Material Number or Fabasoft Cloud ID.
- The price conditions are identified by the Price Condition ID or Fabasoft Cloud ID.
- The sales organizations are identified by the Company Code (the field has to be enabled in the contact management configuration) or Fabasoft Cloud ID.
- If a property (short reference) is defined in FSCMATERIALMASTERDATA_1_1001_overridekeys, empty values are taken over and lists are overwritten.
- lscode supports ISO codes like en, de or de-at of available languages.
SOAP and WSDL
The WSDL can be retrieved via following URL:
https://<host>/<vdir>/fscdav/wsdl?WEBSVC=FSCMATERIALMASTERDATA_1_1001_MasterialMasterDataWebService
Example:
https://at.cloud.fabasoft.com/folio/fscdav/wsdl?WEBSVC=FSCMATERIALMASTERDATA_1_1001_MasterialMasterDataWebService: new window
JSON
You can call the operations the following way:
https://<host>/<vdir>/wsjson/ FSCMATERIALMASTERDATA_1_1001_MasterialMasterDataWebService/<operation>
Example:
https://at.cloud.fabasoft.com/folio/wsjson/FSCMATERIALMASTERDATA_1_1001_MasterialMasterDataWebService/UpdateMaterial: new window
Available Operations
The material master data web service provides following operations:
- UpdateMaterial
Creates a new material or updates an existing one. - UpdatePriceCondition
Creates a new price condition or updates an existing one.
Examples
The following chapters provide several contact management web service examples.
UpdateMaterial
In the following example the material Mat-16-A (Material Number) is imported with a German and English name and two sales organizations are assigned. Not that the properties mdmaterialname and mdownersalesorganization are defined as override keys. This way the empty value for mdownersalesorganization will be considered and the mdmaterialname list is overwritten (instead of adding new entries to existing ones).
Example |
---|
SOAP Request <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:fsc="http://schemas.fabasoft.com/websvc/ FSCMATERIALMASTERDATA_1_1001_MasterialMasterDataWebService/"> <soapenv:Header/> <soapenv:Body> <fsc:UpdateMaterial> <fsc:data> <fsc:FSCMATERIALMASTERDATA_1_1001_mdmaterialroomid>MR1 </fsc:FSCMATERIALMASTERDATA_1_1001_mdmaterialroomid> <fsc:FSCMATERIALMASTERDATA_1_1001_mdmaterialnumber>Mat-16-A </fsc:FSCMATERIALMASTERDATA_1_1001_mdmaterialnumber> <fsc:FSCMATERIALMASTERDATA_1_1001_mdmaterialname> <fsc:FSCOWSSTDSERVICES_1_1001_LangStr> <fsc:FSCOWSSTDSERVICES_1_1001_lscode>de </fsc:FSCOWSSTDSERVICES_1_1001_lscode> <fsc:FSCOWSSTDSERVICES_1_1001_lsstr>Schraube 16-A </fsc:FSCOWSSTDSERVICES_1_1001_lsstr> </fsc:FSCOWSSTDSERVICES_1_1001_LangStr> <fsc:FSCOWSSTDSERVICES_1_1001_LangStr> <fsc:FSCOWSSTDSERVICES_1_1001_lscode>en </fsc:FSCOWSSTDSERVICES_1_1001_lscode> <fsc:FSCOWSSTDSERVICES_1_1001_lsstr>Screw 16-A </fsc:FSCOWSSTDSERVICES_1_1001_lsstr> </fsc:FSCOWSSTDSERVICES_1_1001_LangStr> </fsc:FSCMATERIALMASTERDATA_1_1001_mdmaterialname> <fsc:FSCMATERIALMASTERDATA_1_1001_mdownersalesorganization> </fsc:FSCMATERIALMASTERDATA_1_1001_mdownersalesorganization> <fsc:FSCMATERIALMASTERDATA_1_1001_mdsalesorganizations> <fsc:string>C1242</fsc:string> <fsc:string>C3421</fsc:string> </fsc:FSCMATERIALMASTERDATA_1_1001_mdsalesorganizations> <fsc:FSCMATERIALMASTERDATA_1_1001_overridekeys> <fsc:string>mdmaterialname</fsc:string> <fsc:string>mdownersalesorganization</fsc:string> </fsc:FSCMATERIALMASTERDATA_1_1001_overridekeys> </fsc:data> </fsc:UpdateMaterial> </soapenv:Body> </soapenv:Envelope> JSON Request { "data": { "mdmaterialroomid": "MR1", "mdmaterialnumber": "Mat-16-A", "mdmaterialname": [ { "lscode": "de", "lsstr": "Schraube 16-A" }, { "lscode": "en", "lsstr": "Screw 16-A" } ], "mdownersalesorganization": null, "mdsalesorganizations": [ "C1242", "C3421" ], "overridekeys": [ "mdmaterialname", "mdownersalesorganization" ] } } |
UpdatePriceCondition
In the following example the price condition PR-23 (Price Condition ID) is imported. The material Mat-16-A (Material Number) and the sales organization C1242 (Company Code) is assigned. Additionally, the valid period is defined. objvalidfrom is defined as override key, so that an empty value will be considered.
Example |
---|
SOAP Request <soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:fsc="http://schemas.fabasoft.com/websvc/ FSCMATERIALMASTERDATA_1_1001_MasterialMasterDataWebService/"> <soap:Header/> <soap:Body> <fsc:UpdatePriceCondition> <fsc:data> <fsc:FSCMATERIALMASTERDATA_1_1001_pcdpriceconditionroomid>PR1 </fsc:FSCMATERIALMASTERDATA_1_1001_pcdpriceconditionroomid> <fsc:FSCMATERIALMASTERDATA_1_1001_pcdidentification>PR-23 </fsc:FSCMATERIALMASTERDATA_1_1001_pcdidentification> <fsc:FSCMATERIALMASTERDATA_1_1001_pcdmaterialnumber>Mat-16-A </fsc:FSCMATERIALMASTERDATA_1_1001_pcdmaterialnumber> <fsc:FSCMATERIALMASTERDATA_1_1001_pcdsalesorganization>C1242 </fsc:FSCMATERIALMASTERDATA_1_1001_pcdsalesorganization> <fsc:COOSYSTEM_1_1_objvalidfrom>2024-06-23 </fsc:COOSYSTEM_1_1_objvalidfrom> <fsc:COOSYSTEM_1_1_objvalidto>2025-06-23 </fsc:COOSYSTEM_1_1_objvalidto> <fsc:FSCMATERIALMASTERDATA_1_1001_overridekeys> <fsc:string>objvalidfrom</fsc:string> </fsc:FSCMATERIALMASTERDATA_1_1001_overridekeys> </fsc:data> </fsc:UpdatePriceCondition> </soap:Body> </soap:Envelope> JSON Request { "data": { "pcdpriceconditionroomid": "PR1", "pcdidentification": "PR-23", "pcdmaterialnumber": "Mat-16-A", "pcdsalesorganization": "C1242", "objvalidfrom": "2024-06-23", "objvalidto": "2025-06-23", "overridekeys": [ "objvalidfrom" ] } } |