Zum Inhalt

WebConnector Documentation

Item

Item

Items (articles) can be read and updated by various ways within the WebConnector. The item services are to read one specific or filter multiple items by different criteria. Please also see Item Transfer

Service Endpoint

The base Endpoint is:

ItemIISWebService/ItemIISWebService

API Methods

Here are the available methods for the Item Service:

Create
Read
Read Multiple
Update
Update Multiple

Read Sample

Request

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" 
   xmlns:item="http://tempuri.org/ItemIISWebService/">
   <soap:Header xmlns:wsa="http://www.w3.org/2005/08/addressing">
      <wsa:Action>http://tempuri.org/ItemIISWebService/ItemIISWebService/Read</wsa:Action>
   </soap:Header>
   <soap:Body>
      <item:Read>
         <item:No>70000</item:No>
      </item:Read>
   </soap:Body>
</soap:Envelope>

Response

<s:Envelope xmlns:s="http://www.w3.org/2003/05/soap-envelope" xmlns:a="http://www.w3.org/2005/08/addressing">
   <s:Header>
      <a:Action s:mustUnderstand="1">http://tempuri.org/ItemIISWebService/ItemIISWebService/ReadResponse</a:Action>
   </s:Header>
   <s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <ReadResponse xmlns="http://tempuri.org/ItemIISWebService/">
         <ReadResult>
            <Key xmlns="urn:microsoft-dynamics-schemas/page/item">24;GwAAAAJ7BTcAMAAwADAAMA==6;4599100;</Key>
            <No xmlns="urn:microsoft-dynamics-schemas/page/item">70000</No>
            <Description xmlns="urn:microsoft-dynamics-schemas/page/item">Seitenwand</Description>
            <Search_Description xmlns="urn:microsoft-dynamics-schemas/page/item">SEITENWAND</Search_Description>
            <Base_Unit_of_Measure xmlns="urn:microsoft-dynamics-schemas/page/item">STÜCK</Base_Unit_of_Measure>
        <Sales_Unit_of_Measure xmlns="urn:microsoft-dynamics-schemas/page/item">STÜCK</Sales_Unit_of_Measure>            
            <Gross_Weight xmlns="urn:microsoft-dynamics-schemas/page/item">2.65</Gross_Weight>
            <Net_Weight xmlns="urn:microsoft-dynamics-schemas/page/item">2.3</Net_Weight>
            <Unit_Volume xmlns="urn:microsoft-dynamics-schemas/page/item">0.04</Unit_Volume>

            <Blocked xmlns="urn:microsoft-dynamics-schemas/page/item">false</Blocked>
            <Last_Date_Modified xmlns="urn:microsoft-dynamics-schemas/page/item">2015-09-16</Last_Date_Modified>
            <Price_Includes_VAT xmlns="urn:microsoft-dynamics-schemas/page/item">false</Price_Includes_VAT>
            <Gen_Prod_Posting_Group xmlns="urn:microsoft-dynamics-schemas/page/item">ROHMAT</Gen_Prod_Posting_Group>
            <VAT_Prod_Posting_Group xmlns="urn:microsoft-dynamics-schemas/page/item">VAT19</VAT_Prod_Posting_Group>
            <Webshop_Item xmlns="urn:microsoft-dynamics-schemas/page/item">false</Webshop_Item>
        <Invoice_Disc_Code xmlns="urn:microsoft-dynamics-schemas/page/customer">10000</Invoice_Disc_Code>

         </ReadResult>
      </ReadResponse>
   </s:Body>
</s:Envelope>

Read Multiple Sample

Request

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" 
   xmlns:item="http://tempuri.org/ItemIISWebService/" 
   xmlns:item1="urn:microsoft-dynamics-schemas/page/item">
   <soap:Header xmlns:wsa="http://www.w3.org/2005/08/addressing">
      <wsa:Action>http://tempuri.org/ItemIISWebService/ItemIISWebService/ReadMultiple</wsa:Action>
   </soap:Header>
   <soap:Body>
      <item:ReadMultiple>
         <!--Optional:-->
         <item:filter>
            <!--Zero or more repetitions:-->
            <item:Item_Filter>
               <item1:Field>No</item1:Field>            
               <item1:Criteria>1..</item1:Criteria>
            </item:Item_Filter>         
         </item:filter>
         <!--Optional:-->
         <item:bookmarkKey/>
         <item:setSize>1000</item:setSize>
      </item:ReadMultiple>
   </soap:Body>
</soap:Envelope>

Response

<s:Envelope xmlns:s="http://www.w3.org/2003/05/soap-envelope" xmlns:a="http://www.w3.org/2005/08/addressing">
   <s:Header>
      <a:Action s:mustUnderstand="1">http://tempuri.org/ItemIISWebService/ItemIISWebService/ReadMultipleResponse</a:Action>
   </s:Header>
   <s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <ReadMultipleResponse xmlns="http://tempuri.org/ItemIISWebService/">
         <ReadMultipleResult>
            <Item>
               <Key xmlns="urn:microsoft-dynamics-schemas/page/item">20;GwAAAAJ7BDEAMAAwADA=8;250601300;</Key>
               <No xmlns="urn:microsoft-dynamics-schemas/page/item">1000</No>
               <Description xmlns="urn:microsoft-dynamics-schemas/page/item">Tourenrad</Description>
               <Search_Description xmlns="urn:microsoft-dynamics-schemas/page/item">TOURENRAD</Search_Description>
               <Base_Unit_of_Measure xmlns="urn:microsoft-dynamics-schemas/page/item">STÜCK</Base_Unit_of_Measure>
               <Sales_Unit_of_Measure xmlns="urn:microsoft-dynamics-schemas/page/item">STÜCK</Sales_Unit_of_Measure>
               <Gross_Weight xmlns="urn:microsoft-dynamics-schemas/page/item">0</Gross_Weight>
               <Net_Weight xmlns="urn:microsoft-dynamics-schemas/page/item">0</Net_Weight>
               <Unit_Volume xmlns="urn:microsoft-dynamics-schemas/page/item">0</Unit_Volume>
               <Blocked xmlns="urn:microsoft-dynamics-schemas/page/item">false</Blocked>
               <Last_Date_Modified xmlns="urn:microsoft-dynamics-schemas/page/item">2016-02-22</Last_Date_Modified>
               <Price_Includes_VAT xmlns="urn:microsoft-dynamics-schemas/page/item">false</Price_Includes_VAT>
               <Gen_Prod_Posting_Group xmlns="urn:microsoft-dynamics-schemas/page/item">HANDEL</Gen_Prod_Posting_Group>
               <VAT_Prod_Posting_Group xmlns="urn:microsoft-dynamics-schemas/page/item">VAT19</VAT_Prod_Posting_Group>
               <Webshop_Item xmlns="urn:microsoft-dynamics-schemas/page/item">false</Webshop_Item>
            </Item>
            <Item>
               <Key xmlns="urn:microsoft-dynamics-schemas/page/item">20;GwAAAAJ7BDEAMAAwADE=8;250601310;</Key>
               <No xmlns="urn:microsoft-dynamics-schemas/page/item">1001</No>
               <Description xmlns="urn:microsoft-dynamics-schemas/page/item">Rennrad</Description>
               <Search_Description xmlns="urn:microsoft-dynamics-schemas/page/item">RENNRAD</Search_Description>
               <Base_Unit_of_Measure xmlns="urn:microsoft-dynamics-schemas/page/item">STÜCK</Base_Unit_of_Measure>
               <Sales_Unit_of_Measure xmlns="urn:microsoft-dynamics-schemas/page/item">STÜCK</Sales_Unit_of_Measure>
               <Gross_Weight xmlns="urn:microsoft-dynamics-schemas/page/item">0</Gross_Weight>
               <Net_Weight xmlns="urn:microsoft-dynamics-schemas/page/item">0</Net_Weight>
               <Unit_Volume xmlns="urn:microsoft-dynamics-schemas/page/item">0</Unit_Volume>
               <Blocked xmlns="urn:microsoft-dynamics-schemas/page/item">false</Blocked>
               <Last_Date_Modified xmlns="urn:microsoft-dynamics-schemas/page/item">2016-02-22</Last_Date_Modified>
               <Price_Includes_VAT xmlns="urn:microsoft-dynamics-schemas/page/item">false</Price_Includes_VAT>
               <Gen_Prod_Posting_Group xmlns="urn:microsoft-dynamics-schemas/page/item">HANDEL</Gen_Prod_Posting_Group>
               <VAT_Prod_Posting_Group xmlns="urn:microsoft-dynamics-schemas/page/item">VAT19</VAT_Prod_Posting_Group>
               <Webshop_Item xmlns="urn:microsoft-dynamics-schemas/page/item">false</Webshop_Item>
            </Item>
         </ReadMultipleResult>
      </ReadMultipleResponse>
   </s:Body>
</s:Envelope>

Field Information

Item Field Information

Name	Description	Type	max. Length	Occurance
🔑 No	Primary Key of the item table. Contains the Item Number.	String	20	1..1
No_2	Secondary Item Number.	String	20	0..1
Description	Primary item description	String	50	0..1
Description_2	Secondary item description	String	50	0..1
Search_Description	Search description. This value is generated in NAV/Business Central for indexing purposes.	String	50	0..1
Base_Unit_of_Measure	The Base UOM is used to indicate the base unit of the item. i.E. 'STÜCK'. Get a list of codes from the Master Data Service	String	10	1..1
Sales_Unit_of_Measure	The Base UOM is used to indicate the sales unit of the item. i.E. 'KARTON'. Get a list of codes from the Master Data Service	String	10	1..1
Country_Region_Purchased_Code	Specifies a code for the country/region in which the item was produced or processed. Get a list of codes from the Master Data Service	String	10	0..1
Country_Region_of_Origin_Code	Specifies a code for the country/region in which the item was produced or processed. Get a list of codes from the Master Data Service	String	10	0..1
Freight_Type	Specifies how the item is shipped.	String	10	0..1
Gross_Weight	Specifies the gross weight of the item.	Decimal		0..1
Net_Weight	Specifies the net weight of the item.	Decimal		0..1
Unit_Volume	Specifies the volume of one unit of the item.	Decimal		0..1
Blocked	Specifies whether an item is blocked	Boolean		0..1
Last_Date_Modified	Shows when the item card was last modified.	Datetime		0..1
Price_Includes_VAT	Indicates item's price included VAT.	Boolean		0..1
Gen_Prod_Posting_Group		String	10	0..1
VAT_Prod_Posting_Group	Specifies the VAT product posting group to which this item belongs.	String	10	0..1
VAT_Bus_Posting_Gr_Price	Specifies a VAT business posting group for customers for whom you want the item price including VAT, as shown in the Unit Price field, to apply.	String	10	0..1
Tax_Group_Code	Specifies the sales tax group code to which this item belongs.	String	10	0..1
Manufacturer_Code	Specifies the code that identifies the manufacturer of the item.	String	10	0..1
Item_Category_Code	Contains the item category code for the item. Get a list of codes from the Master Data Service	String	10	0..1
Product_Group_Code	Contains a product group code that relates to the item category that is assigned to the item. Get a list of codes from the Master Data Service	String	10	0..1
Webshop_Item	Indicates whether this item sold in the web shop.	Boolean		0..1
Created from non stock Item	Indicates whether this item is created from non stock.	Boolean		0..1
Item Disc. Group	Specifies the item discount group code.	isc		0..1