SBX - Search With Button

SBX - Forum Post Title

Parameter No in method Read in service 'SOAP Endpoint' is null!

Microsoft Dynamics NAV Forum

Koya Temitope asked a question on 21 Feb 2019 6:37 AM

Question Status

Verified

Hi everybody,

I added a custom field on the item card 'product id' which is the product id in dynamics crm, i also made this field a key on the item table.

I created an Item web service but i cannot query/get an item using the 'product id' field

Below are screenshot of steps carried out and response i got

When i query using the 'Item no' field, the response return an item:


When i query using the 'product id' field, the response is 'Parameter No in method Read in service AstItem_Service is null!'





My aim is to have an azure function that will get the product id from crm and query the item card field 'product id' to get the item

Reply
Suggested Answer

For the Item web service you mention, are you using the Item List page or the Item Card page? Is the field available on that page?

Reply
Koya Temitope responded on 22 Feb 2019 4:24 AM

Thank you Stefano for your response

I have tried both Item Card page and Item List page, the field is also available on the page.

Reply
Suggested Answer

Are you using SOAP web services? If the field is added to a page exposed as web service, you absolutely can see it. Have you refreshed your web service reference? Can you check the WSDL?

Reply
Koya Temitope responded on 22 Feb 2019 6:49 AM

yes i am using SOAP web service, the field is added to the page exposed in the web service

Reply
Suggested Answer

Please check the WSDL and maybe post it here.

Reply
Koya Temitope responded on 23 Feb 2019 5:49 AM
I have highlighted the product id field in red, kindly see below
 
<definitions xmlns="schemas.xmlsoap.org/wsdl" xmlns:tns="urn:microsoft-dynamics-schemas/page/astitem" targetNamespace="urn:microsoft-dynamics-schemas/page/astitem">
"); vertical-align: bottom; height: 10px;"><types>
"); vertical-align: bottom; height: 10px;"><xsd:schema xmlns:xsd="www.w3.org/.../XMLSchema" elementFormDefault="qualified" targetNamespace="urn:microsoft-dynamics-schemas/page/astitem">
"); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Type">
"); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
<xsd:enumeration value="Inventory"/>
<xsd:enumeration value="Service"/>
</xsd:restriction>
</xsd:simpleType>
"); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Unit_Group">
"); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
<xsd:enumeration value="Microsoft"/>
<xsd:enumeration value="Cyberoam"/>
<xsd:enumeration value="Sophos"/>
</xsd:restriction>
</xsd:simpleType>
"); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Sector">
"); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
<xsd:enumeration value="Academic"/>
<xsd:enumeration value="Government"/>
<xsd:enumeration value="Corporate"/>
<xsd:enumeration value="Education"/>
</xsd:restriction>
</xsd:simpleType>
"); vertical-align: bottom; height: 10px;"><xsd:simpleType name="StockoutWarningDefaultYes">
"); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
<xsd:enumeration value="Default"/>
<xsd:enumeration value="No"/>
<xsd:enumeration value="Yes"/>
</xsd:restriction>
</xsd:simpleType>
"); vertical-align: bottom; height: 10px;"><xsd:simpleType name="PreventNegInventoryDefaultYes">
"); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
<xsd:enumeration value="Default"/>
<xsd:enumeration value="No"/>
<xsd:enumeration value="Yes"/>
</xsd:restriction>
</xsd:simpleType>
"); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Costing_Method">
"); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
<xsd:enumeration value="FIFO"/>
<xsd:enumeration value="LIFO"/>
<xsd:enumeration value="Specific"/>
<xsd:enumeration value="Average"/>
<xsd:enumeration value="Standard"/>
</xsd:restriction>
</xsd:simpleType>
"); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Price_Profit_Calculation">
"); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
<xsd:enumeration value="Profit_x003D_Price_Cost"/>
<xsd:enumeration value="Price_x003D_Cost_x002B_Profit"/>
<xsd:enumeration value="No_Relationship"/>
</xsd:restriction>
</xsd:simpleType>
"); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Replenishment_System">
"); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
<xsd:enumeration value="Purchase"/>
<xsd:enumeration value="Prod_Order"/>
<xsd:enumeration value="Assembly"/>
</xsd:restriction>
</xsd:simpleType>
"); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Manufacturing_Policy">
"); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
<xsd:enumeration value="Make_to_Stock"/>
<xsd:enumeration value="Make_to_Order"/>
</xsd:restriction>
</xsd:simpleType>
"); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Flushing_Method">
"); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
<xsd:enumeration value="Manual"/>
<xsd:enumeration value="Forward"/>
<xsd:enumeration value="Backward"/>
<xsd:enumeration value="Pick__x002B__Forward"/>
<xsd:enumeration value="Pick__x002B__Backward"/>
</xsd:restriction>
</xsd:simpleType>
"); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Assembly_Policy">
"); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
<xsd:enumeration value="Assemble_to_Stock"/>
<xsd:enumeration value="Assemble_to_Order"/>
</xsd:restriction>
</xsd:simpleType>
"); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Reordering_Policy">
"); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
<xsd:enumeration value="_blank_"/>
<xsd:enumeration value="Fixed_Reorder_Qty"/>
<xsd:enumeration value="Maximum_Qty"/>
<xsd:enumeration value="Order"/>
<xsd:enumeration value="Lot_for_Lot"/>
</xsd:restriction>
</xsd:simpleType>
"); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Reserve">
"); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
<xsd:enumeration value="Never"/>
<xsd:enumeration value="Optional"/>
<xsd:enumeration value="Always"/>
</xsd:restriction>
</xsd:simpleType>
"); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Order_Tracking_Policy">
"); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
<xsd:enumeration value="None"/>
<xsd:enumeration value="Tracking_Only"/>
<xsd:enumeration value="Tracking__x0026__Action_Msg"/>
</xsd:restriction>
</xsd:simpleType>
"); vertical-align: bottom; height: 10px;"><xsd:complexType name="AstItem">
"); vertical-align: bottom; height: 10px;"><xsd:sequence>
<xsd:element minOccurs="0" maxOccurs="1" name="Key" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="No" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Description" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Blocked" type="xsd:boolean"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Type" type="tns:Type"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Base_Unit_of_Measure" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Last_Date_Modified" type="xsd:date"/>
<xsd:element minOccurs="0" maxOccurs="1" name="GTIN" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Item_Category_Code" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Product_Group_Code" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Service_Item_Group" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Unit_Group" type="tns:Unit_Group"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Sector" type="tns:Sector"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Product_ID" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Full_Description" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Automatic_Ext_Texts" type="xsd:boolean"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Shelf_No" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Created_From_Nonstock_Item" type="xsd:boolean"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Search_Description" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Inventory" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Purch_Order" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Prod_Order" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Component_Lines" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Sales_Order" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Service_Order" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Job_Order" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Assembly_Order" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Asm_Component" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="StockoutWarningDefaultYes" type="tns:StockoutWarningDefaultYes"/>
<xsd:element minOccurs="0" maxOccurs="1" name="PreventNegInventoryDefaultYes" type="tns:PreventNegInventoryDefaultYes"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Net_Weight" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Gross_Weight" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Unit_Volume" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Costing_Method" type="tns:Costing_Method"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Standard_Cost" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Unit_Cost" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Indirect_Cost_Percent" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Last_Direct_Cost" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Net_Invoiced_Qty" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Cost_is_Adjusted" type="xsd:boolean"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Cost_is_Posted_to_G_L" type="xsd:boolean"/>
<xsd:element minOccurs="0" maxOccurs="1" name="SpecialPurchPricesAndDiscountsTxt" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Gen_Prod_Posting_Group" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="VAT_Prod_Posting_Group" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Inventory_Posting_Group" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Default_Deferral_Template_Code" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Tariff_No" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Country_Region_of_Origin_Code" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Unit_Price" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="CalcUnitPriceExclVAT" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Price_Includes_VAT" type="xsd:boolean"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Price_Profit_Calculation" type="tns:Price_Profit_Calculation"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Profit_Percent" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="SpecialPricesAndDiscountsTxt" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Allow_Invoice_Disc" type="xsd:boolean"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Item_Disc_Group" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Sales_Unit_of_Measure" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Application_Wksh_User_ID" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="VAT_Bus_Posting_Gr_Price" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Replenishment_System" type="tns:Replenishment_System"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Lead_Time_Calculation" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Vendor_No" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Vendor_Item_No" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Purch_Unit_of_Measure" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Manufacturing_Policy" type="tns:Manufacturing_Policy"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Routing_No" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Production_BOM_No" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Rounding_Precision" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Flushing_Method" type="tns:Flushing_Method"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Overhead_Rate" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Scrap_Percent" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Lot_Size" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Assembly_Policy" type="tns:Assembly_Policy"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Assembly_BOM" type="xsd:boolean"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Reordering_Policy" type="tns:Reordering_Policy"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Reserve" type="tns:Reserve"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Order_Tracking_Policy" type="tns:Order_Tracking_Policy"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Stockkeeping_Unit_Exists" type="xsd:boolean"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Dampener_Period" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Dampener_Quantity" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Critical" type="xsd:boolean"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Safety_Lead_Time" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Safety_Stock_Quantity" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Include_Inventory" type="xsd:boolean"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Lot_Accumulation_Period" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Rescheduling_Period" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Reorder_Point" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Reorder_Quantity" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Maximum_Inventory" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Overflow_Level" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Time_Bucket" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Minimum_Order_Quantity" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Maximum_Order_Quantity" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Order_Multiple" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Item_Tracking_Code" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Serial_Nos" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Lot_Nos" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Expiration_Calculation" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Warehouse_Class_Code" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Special_Equipment_Code" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Put_away_Template_Code" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Put_away_Unit_of_Measure_Code" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Phys_Invt_Counting_Period_Code" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Last_Phys_Invt_Date" type="xsd:date"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Last_Counting_Period_Update" type="xsd:date"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Next_Counting_Start_Date" type="xsd:date"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Next_Counting_End_Date" type="xsd:date"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Identifier_Code" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Use_Cross_Docking" type="xsd:boolean"/>
</xsd:sequence>
</xsd:complexType>
"); vertical-align: bottom; height: 10px;"><xsd:complexType name="AstItem_List">
"); vertical-align: bottom; height: 10px;"><xsd:sequence>
<xsd:element minOccurs="1" maxOccurs="unbounded" name="AstItem" type="tns:AstItem"/>
</xsd:sequence>
</xsd:complexType>
"); vertical-align: bottom; height: 10px;"><xsd:simpleType name="AstItem_Fields">
"); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
<xsd:enumeration value="No"/>
<xsd:enumeration value="Description"/>
<xsd:enumeration value="Blocked"/>
<xsd:enumeration value="Type"/>
<xsd:enumeration value="Base_Unit_of_Measure"/>
<xsd:enumeration value="Last_Date_Modified"/>
<xsd:enumeration value="GTIN"/>
<xsd:enumeration value="Item_Category_Code"/>
<xsd:enumeration value="Product_Group_Code"/>
<xsd:enumeration value="Service_Item_Group"/>
<xsd:enumeration value="Unit_Group"/>
<xsd:enumeration value="Sector"/>
<xsd:enumeration value="Product_ID"/>
<xsd:enumeration value="Full_Description"/>
<xsd:enumeration value="Automatic_Ext_Texts"/>
<xsd:enumeration value="Shelf_No"/>
<xsd:enumeration value="Created_From_Nonstock_Item"/>
<xsd:enumeration value="Search_Description"/>
<xsd:enumeration value="Inventory"/>
<xsd:enumeration value="Qty_on_Purch_Order"/>
<xsd:enumeration value="Qty_on_Prod_Order"/>
<xsd:enumeration value="Qty_on_Component_Lines"/>
<xsd:enumeration value="Qty_on_Sales_Order"/>
<xsd:enumeration value="Qty_on_Service_Order"/>
<xsd:enumeration value="Qty_on_Job_Order"/>
<xsd:enumeration value="Qty_on_Assembly_Order"/>
<xsd:enumeration value="Qty_on_Asm_Component"/>
<xsd:enumeration value="StockoutWarningDefaultYes"/>
<xsd:enumeration value="PreventNegInventoryDefaultYes"/>
<xsd:enumeration value="Net_Weight"/>
<xsd:enumeration value="Gross_Weight"/>
<xsd:enumeration value="Unit_Volume"/>
<xsd:enumeration value="Costing_Method"/>
<xsd:enumeration value="Standard_Cost"/>
<xsd:enumeration value="Unit_Cost"/>
<xsd:enumeration value="Indirect_Cost_Percent"/>
<xsd:enumeration value="Last_Direct_Cost"/>
<xsd:enumeration value="Net_Invoiced_Qty"/>
<xsd:enumeration value="Cost_is_Adjusted"/>
<xsd:enumeration value="Cost_is_Posted_to_G_L"/>
<xsd:enumeration value="SpecialPurchPricesAndDiscountsTxt"/>
<xsd:enumeration value="Gen_Prod_Posting_Group"/>
<xsd:enumeration value="VAT_Prod_Posting_Group"/>
<xsd:enumeration value="Inventory_Posting_Group"/>
<xsd:enumeration value="Default_Deferral_Template_Code"/>
<xsd:enumeration value="Tariff_No"/>
<xsd:enumeration value="Country_Region_of_Origin_Code"/>
<xsd:enumeration value="Unit_Price"/>
<xsd:enumeration value="CalcUnitPriceExclVAT"/>
<xsd:enumeration value="Price_Includes_VAT"/>
<xsd:enumeration value="Price_Profit_Calculation"/>
<xsd:enumeration value="Profit_Percent"/>
<xsd:enumeration value="SpecialPricesAndDiscountsTxt"/>
<xsd:enumeration value="Allow_Invoice_Disc"/>
<xsd:enumeration value="Item_Disc_Group"/>
<xsd:enumeration value="Sales_Unit_of_Measure"/>
<xsd:enumeration value="Application_Wksh_User_ID"/>
<xsd:enumeration value="VAT_Bus_Posting_Gr_Price"/>
<xsd:enumeration value="Replenishment_System"/>
<xsd:enumeration value="Lead_Time_Calculation"/>
<xsd:enumeration value="Vendor_No"/>
<xsd:enumeration value="Vendor_Item_No"/>
<xsd:enumeration value="Purch_Unit_of_Measure"/>
<xsd:enumeration value="Manufacturing_Policy"/>
<xsd:enumeration value="Routing_No"/>
<xsd:enumeration value="Production_BOM_No"/>
<xsd:enumeration value="Rounding_Precision"/>
<xsd:enumeration value="Flushing_Method"/>
<xsd:enumeration value="Overhead_Rate"/>
<xsd:enumeration value="Scrap_Percent"/>
<xsd:enumeration value="Lot_Size"/>
<xsd:enumeration value="Assembly_Policy"/>
<xsd:enumeration value="Assembly_BOM"/>
<xsd:enumeration value="Reordering_Policy"/>
<xsd:enumeration value="Reserve"/>
<xsd:enumeration value="Order_Tracking_Policy"/>
<xsd:enumeration value="Stockkeeping_Unit_Exists"/>
<xsd:enumeration value="Dampener_Period"/>
<xsd:enumeration value="Dampener_Quantity"/>
<xsd:enumeration value="Critical"/>
<xsd:enumeration value="Safety_Lead_Time"/>
<xsd:enumeration value="Safety_Stock_Quantity"/>
<xsd:enumeration value="Include_Inventory"/>
<xsd:enumeration value="Lot_Accumulation_Period"/>
<xsd:enumeration value="Rescheduling_Period"/>
<xsd:enumeration value="Reorder_Point"/>
<xsd:enumeration value="Reorder_Quantity"/>
<xsd:enumeration value="Maximum_Inventory"/>
<xsd:enumeration value="Overflow_Level"/>
<xsd:enumeration value="Time_Bucket"/>
<xsd:enumeration value="Minimum_Order_Quantity"/>
<xsd:enumeration value="Maximum_Order_Quantity"/>
<xsd:enumeration value="Order_Multiple"/>
<xsd:enumeration value="Item_Tracking_Code"/>
<xsd:enumeration value="Serial_Nos"/>
<xsd:enumeration value="Lot_Nos"/>
<xsd:enumeration value="Expiration_Calculation"/>
<xsd:enumeration value="Warehouse_Class_Code"/>
<xsd:enumeration value="Special_Equipment_Code"/>
<xsd:enumeration value="Put_away_Template_Code"/>
<xsd:enumeration value="Put_away_Unit_of_Measure_Code"/>
<xsd:enumeration value="Phys_Invt_Counting_Period_Code"/>
<xsd:enumeration value="Last_Phys_Invt_Date"/>
<xsd:enumeration value="Last_Counting_Period_Update"/>
<xsd:enumeration value="Next_Counting_Start_Date"/>
<xsd:enumeration value="Next_Counting_End_Date"/>
<xsd:enumeration value="Identifier_Code"/>
<xsd:enumeration value="Use_Cross_Docking"/>
</xsd:restriction>
</xsd:simpleType>
Reply
Verified Answer

If you're using Read, it wants a primary key (so Item No).

To retrieve Items via your Product ID field (custom) you need to filter the Items for that field and then retrieve who matches the filters. Something like described here for Customers:

docs.microsoft.com/.../readmultiple-operation

Reply
Koya Temitope responded on 6 Mar 2019 12:38 PM

Thank you very much Stefano, i was able to get the item using the "productid" field

Below code did the magic:

static async Task Main(string[] args)

       {
           

           var cred = clientCred();

           try

           {

               var itemFilterList = new List<it.AstItem_Filter>();

               var itemFilter = new it.AstItem_Filter()

               {

                   Field = it.AstItem_Fields.Product_Id,

                   //The productid value is passed into the criteria to get the nav item

                   Criteria = "eca123e6-23dc-4649-94bf-b26c4dda22cb"

               };

               itemFilterList.Add(itemFilter);

               var asrr = itemFilterList.ToArray();

               var astItm = await cred.ReadMultipleAsync(new it.ReadMultiple(asrr, null, 0));

               Console.WriteLine(astItm.ReadMultiple_Result1);

               var navItem = astItm.ReadMultiple_Result1;

               for (int i = 0; i < navItem.Length; i++)

               {

                   string itemDes = navItem[i].Description;

                   Console.WriteLine(itemDes);

                   itemNo = navItem[i].No;

                   Console.WriteLine(itemNo);

                   string itemPID = navItem[i].Product_Id;

                   Console.WriteLine(itemPID);

                   var so = createSOrder();

               }

               Console.ReadLine();

           }

           catch (Exception ex)

           {

               var msg = ex.StackTrace;

               Console.WriteLine(msg);

               Console.ReadLine();

           }

           return;

       }
Reply
Verified Answer

If you're using Read, it wants a primary key (so Item No).

To retrieve Items via your Product ID field (custom) you need to filter the Items for that field and then retrieve who matches the filters. Something like described here for Customers:

docs.microsoft.com/.../readmultiple-operation

Reply
Suggested Answer

For the Item web service you mention, are you using the Item List page or the Item Card page? Is the field available on that page?

Reply
Suggested Answer

Are you using SOAP web services? If the field is added to a page exposed as web service, you absolutely can see it. Have you refreshed your web service reference? Can you check the WSDL?

Reply
Suggested Answer

Please check the WSDL and maybe post it here.

Reply

SBX - Two Col Forum

SBX - Migrated JS