JiwaAPI

v_Jiwa_Inventory_Item_ListQuery

The following routes are available for this service:
GET	/Queries/InventoryItemList	Retrieves a list of inventory items

**v_Jiwa_Inventory_Item_ListQuery** Parameters:
Name	Parameter	Data Type	Required
InventoryID	query	string	No
InventoryIDStartsWith	query	string	No
InventoryIDEndsWith	query	string	No
InventoryIDContains	query	string	No
InventoryIDLike	query	string	No
InventoryIDBetween	query	string[]	No
InventoryIDIn	query	string[]	No
PartNo	query	string	No
PartNoStartsWith	query	string	No
PartNoEndsWith	query	string	No
PartNoContains	query	string	No
PartNoLike	query	string	No
PartNoBetween	query	string[]	No
PartNoIn	query	string[]	No
Description	query	string	No
DescriptionStartsWith	query	string	No
DescriptionEndsWith	query	string	No
DescriptionContains	query	string	No
DescriptionLike	query	string	No
DescriptionBetween	query	string[]	No
DescriptionIn	query	string[]	No
Picture	query	byte[]	No
InventoryClassificationID	query	string	No
InventoryClassificationIDStartsWith	query	string	No
InventoryClassificationIDEndsWith	query	string	No
InventoryClassificationIDContains	query	string	No
InventoryClassificationIDLike	query	string	No
InventoryClassificationIDBetween	query	string[]	No
InventoryClassificationIDIn	query	string[]	No
ClassificationDescription	query	string	No
ClassificationDescriptionStartsWith	query	string	No
ClassificationDescriptionEndsWith	query	string	No
ClassificationDescriptionContains	query	string	No
ClassificationDescriptionLike	query	string	No
ClassificationDescriptionBetween	query	string[]	No
ClassificationDescriptionIn	query	string[]	No
Category1ID	query	string	No
Category1IDStartsWith	query	string	No
Category1IDEndsWith	query	string	No
Category1IDContains	query	string	No
Category1IDLike	query	string	No
Category1IDBetween	query	string[]	No
Category1IDIn	query	string[]	No
Category1Description	query	string	No
Category1DescriptionStartsWith	query	string	No
Category1DescriptionEndsWith	query	string	No
Category1DescriptionContains	query	string	No
Category1DescriptionLike	query	string	No
Category1DescriptionBetween	query	string[]	No
Category1DescriptionIn	query	string[]	No
Category2ID	query	string	No
Category2IDStartsWith	query	string	No
Category2IDEndsWith	query	string	No
Category2IDContains	query	string	No
Category2IDLike	query	string	No
Category2IDBetween	query	string[]	No
Category2IDIn	query	string[]	No
Category2Description	query	string	No
Category2DescriptionStartsWith	query	string	No
Category2DescriptionEndsWith	query	string	No
Category2DescriptionContains	query	string	No
Category2DescriptionLike	query	string	No
Category2DescriptionBetween	query	string[]	No
Category2DescriptionIn	query	string[]	No
Category3ID	query	string	No
Category3IDStartsWith	query	string	No
Category3IDEndsWith	query	string	No
Category3IDContains	query	string	No
Category3IDLike	query	string	No
Category3IDBetween	query	string[]	No
Category3IDIn	query	string[]	No
Category3Description	query	string	No
Category3DescriptionStartsWith	query	string	No
Category3DescriptionEndsWith	query	string	No
Category3DescriptionContains	query	string	No
Category3DescriptionLike	query	string	No
Category3DescriptionBetween	query	string[]	No
Category3DescriptionIn	query	string[]	No
Category4ID	query	string	No
Category4IDStartsWith	query	string	No
Category4IDEndsWith	query	string	No
Category4IDContains	query	string	No
Category4IDLike	query	string	No
Category4IDBetween	query	string[]	No
Category4IDIn	query	string[]	No
Category4Description	query	string	No
Category4DescriptionStartsWith	query	string	No
Category4DescriptionEndsWith	query	string	No
Category4DescriptionContains	query	string	No
Category4DescriptionLike	query	string	No
Category4DescriptionBetween	query	string[]	No
Category4DescriptionIn	query	string[]	No
Category5ID	query	string	No
Category5IDStartsWith	query	string	No
Category5IDEndsWith	query	string	No
Category5IDContains	query	string	No
Category5IDLike	query	string	No
Category5IDBetween	query	string[]	No
Category5IDIn	query	string[]	No
Category5Description	query	string	No
Category5DescriptionStartsWith	query	string	No
Category5DescriptionEndsWith	query	string	No
Category5DescriptionContains	query	string	No
Category5DescriptionLike	query	string	No
Category5DescriptionBetween	query	string[]	No
Category5DescriptionIn	query	string[]	No
IN_LogicalID	query	string	No
IN_LogicalIDStartsWith	query	string	No
IN_LogicalIDEndsWith	query	string	No
IN_LogicalIDContains	query	string	No
IN_LogicalIDLike	query	string	No
IN_LogicalIDBetween	query	string[]	No
IN_LogicalIDIn	query	string[]	No
LogicalWarehouseDescription	query	string	No
LogicalWarehouseDescriptionStartsWith	query	string	No
LogicalWarehouseDescriptionEndsWith	query	string	No
LogicalWarehouseDescriptionContains	query	string	No
LogicalWarehouseDescriptionLike	query	string	No
LogicalWarehouseDescriptionBetween	query	string[]	No
LogicalWarehouseDescriptionIn	query	string[]	No
IN_PhysicalID	query	string	No
IN_PhysicalIDStartsWith	query	string	No
IN_PhysicalIDEndsWith	query	string	No
IN_PhysicalIDContains	query	string	No
IN_PhysicalIDLike	query	string	No
IN_PhysicalIDBetween	query	string[]	No
IN_PhysicalIDIn	query	string[]	No
PhysicalWarehouseDescription	query	string	No
PhysicalWarehouseDescriptionStartsWith	query	string	No
PhysicalWarehouseDescriptionEndsWith	query	string	No
PhysicalWarehouseDescriptionContains	query	string	No
PhysicalWarehouseDescriptionLike	query	string	No
PhysicalWarehouseDescriptionBetween	query	string[]	No
PhysicalWarehouseDescriptionIn	query	string[]	No
AvailableStock	query	decimal?	No
AvailableStockGreaterThanOrEqualTo	query	decimal?	No
AvailableStockGreaterThan	query	decimal?	No
AvailableStockLessThan	query	decimal?	No
AvailableStockLessThanOrEqualTo	query	decimal?	No
AvailableStockNotEqualTo	query	decimal?	No
AvailableStockBetween	query	Nullable<Decimal>[]	No
AvailableStockIn	query	Nullable<Decimal>[]	No
SellPrice	query	decimal?	No
SellPriceGreaterThanOrEqualTo	query	decimal?	No
SellPriceGreaterThan	query	decimal?	No
SellPriceLessThan	query	decimal?	No
SellPriceLessThanOrEqualTo	query	decimal?	No
SellPriceNotEqualTo	query	decimal?	No
SellPriceBetween	query	Nullable<Decimal>[]	No
SellPriceIn	query	Nullable<Decimal>[]	No
RRPPrice	query	decimal?	No
RRPPriceGreaterThanOrEqualTo	query	decimal?	No
RRPPriceGreaterThan	query	decimal?	No
RRPPriceLessThan	query	decimal?	No
RRPPriceLessThanOrEqualTo	query	decimal?	No
RRPPriceNotEqualTo	query	decimal?	No
RRPPriceBetween	query	Nullable<Decimal>[]	No
RRPPriceIn	query	Nullable<Decimal>[]	No
LastSavedDateTime	query	DateTime?	No
LastSavedDateTimeGreaterThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeGreaterThan	query	DateTime?	No
LastSavedDateTimeLessThan	query	DateTime?	No
LastSavedDateTimeLessThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeNotEqualTo	query	DateTime?	No
LastSavedDateTimeBetween	query	Nullable<DateTime>[]	No
LastSavedDateTimeIn	query	Nullable<DateTime>[]	No

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**v_Jiwa_Inventory_Item_List** Parameters:
Name	Parameter	Data Type	Required
InventoryID	form	string	No
PartNo	form	string	No
Description	form	string	No
Picture	form	byte[]	No
InventoryClassificationID	form	string	No
ClassificationDescription	form	string	No
Category1ID	form	string	No
Category1Description	form	string	No
Category2ID	form	string	No
Category2Description	form	string	No
Category3ID	form	string	No
Category3Description	form	string	No
Category4ID	form	string	No
Category4Description	form	string	No
Category5ID	form	string	No
Category5Description	form	string	No
IN_LogicalID	form	string	No
LogicalWarehouseDescription	form	string	No
IN_PhysicalID	form	string	No
PhysicalWarehouseDescription	form	string	No
AvailableStock	form	decimal?	No
SellPrice	form	decimal?	No
RRPPrice	form	decimal?	No
LastSavedDateTime	form	DateTime?	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml

HTTP + XML

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

GET /Queries/InventoryItemList HTTP/1.1 
Host: localhost 
Accept: application/xml

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfv_Jiwa_Inventory_Item_List7kRqkrSv xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.servicestack.net/types">
  <Offset>0</Offset>
  <Total>0</Total>
  <Results xmlns:d2p1="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
    <d2p1:v_Jiwa_Inventory_Item_List>
      <d2p1:_x003C_AvailableStock_x003E_k__BackingField>0</d2p1:_x003C_AvailableStock_x003E_k__BackingField>
      <d2p1:_x003C_Category1Description_x003E_k__BackingField>String</d2p1:_x003C_Category1Description_x003E_k__BackingField>
      <d2p1:_x003C_Category1ID_x003E_k__BackingField>String</d2p1:_x003C_Category1ID_x003E_k__BackingField>
      <d2p1:_x003C_Category2Description_x003E_k__BackingField>String</d2p1:_x003C_Category2Description_x003E_k__BackingField>
      <d2p1:_x003C_Category2ID_x003E_k__BackingField>String</d2p1:_x003C_Category2ID_x003E_k__BackingField>
      <d2p1:_x003C_Category3Description_x003E_k__BackingField>String</d2p1:_x003C_Category3Description_x003E_k__BackingField>
      <d2p1:_x003C_Category3ID_x003E_k__BackingField>String</d2p1:_x003C_Category3ID_x003E_k__BackingField>
      <d2p1:_x003C_Category4Description_x003E_k__BackingField>String</d2p1:_x003C_Category4Description_x003E_k__BackingField>
      <d2p1:_x003C_Category4ID_x003E_k__BackingField>String</d2p1:_x003C_Category4ID_x003E_k__BackingField>
      <d2p1:_x003C_Category5Description_x003E_k__BackingField>String</d2p1:_x003C_Category5Description_x003E_k__BackingField>
      <d2p1:_x003C_Category5ID_x003E_k__BackingField>String</d2p1:_x003C_Category5ID_x003E_k__BackingField>
      <d2p1:_x003C_ClassificationDescription_x003E_k__BackingField>String</d2p1:_x003C_ClassificationDescription_x003E_k__BackingField>
      <d2p1:_x003C_Description_x003E_k__BackingField>String</d2p1:_x003C_Description_x003E_k__BackingField>
      <d2p1:_x003C_IN_LogicalID_x003E_k__BackingField>String</d2p1:_x003C_IN_LogicalID_x003E_k__BackingField>
      <d2p1:_x003C_IN_PhysicalID_x003E_k__BackingField>String</d2p1:_x003C_IN_PhysicalID_x003E_k__BackingField>
      <d2p1:_x003C_InventoryClassificationID_x003E_k__BackingField>String</d2p1:_x003C_InventoryClassificationID_x003E_k__BackingField>
      <d2p1:_x003C_InventoryID_x003E_k__BackingField>String</d2p1:_x003C_InventoryID_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_LogicalWarehouseDescription_x003E_k__BackingField>String</d2p1:_x003C_LogicalWarehouseDescription_x003E_k__BackingField>
      <d2p1:_x003C_PartNo_x003E_k__BackingField>String</d2p1:_x003C_PartNo_x003E_k__BackingField>
      <d2p1:_x003C_PhysicalWarehouseDescription_x003E_k__BackingField>String</d2p1:_x003C_PhysicalWarehouseDescription_x003E_k__BackingField>
      <d2p1:_x003C_Picture_x003E_k__BackingField>AA==</d2p1:_x003C_Picture_x003E_k__BackingField>
      <d2p1:_x003C_RRPPrice_x003E_k__BackingField>0</d2p1:_x003C_RRPPrice_x003E_k__BackingField>
      <d2p1:_x003C_SellPrice_x003E_k__BackingField>0</d2p1:_x003C_SellPrice_x003E_k__BackingField>
    </d2p1:v_Jiwa_Inventory_Item_List>
  </Results>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <ResponseStatus>
    <ErrorCode>String</ErrorCode>
    <Message>String</Message>
    <StackTrace>String</StackTrace>
    <Errors>
      <ResponseError>
        <ErrorCode>String</ErrorCode>
        <FieldName>String</FieldName>
        <Message>String</Message>
        <Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:KeyValueOfstringstring>
            <d5p1:Key>String</d5p1:Key>
            <d5p1:Value>String</d5p1:Value>
          </d5p1:KeyValueOfstringstring>
        </Meta>
      </ResponseError>
    </Errors>
    <Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:KeyValueOfstringstring>
        <d3p1:Key>String</d3p1:Key>
        <d3p1:Value>String</d3p1:Value>
      </d3p1:KeyValueOfstringstring>
    </Meta>
  </ResponseStatus>
</QueryResponseOfv_Jiwa_Inventory_Item_List7kRqkrSv>