JiwaAPI

IN_MainQuery

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

**IN_MainQuery** 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
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
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
Units	query	string	No
UnitsStartsWith	query	string	No
UnitsEndsWith	query	string	No
UnitsContains	query	string	No
UnitsLike	query	string	No
UnitsBetween	query	string[]	No
UnitsIn	query	string[]	No
PhysicalItem	query	bool?	No
Discountable	query	bool?	No
DirectTax	query	decimal?	No
DirectTaxGreaterThanOrEqualTo	query	decimal?	No
DirectTaxGreaterThan	query	decimal?	No
DirectTaxLessThan	query	decimal?	No
DirectTaxLessThanOrEqualTo	query	decimal?	No
DirectTaxNotEqualTo	query	decimal?	No
DirectTaxBetween	query	Nullable<Decimal>[]	No
DirectTaxIn	query	Nullable<Decimal>[]	No
Catagory1ID	query	string	No
Catagory1IDStartsWith	query	string	No
Catagory1IDEndsWith	query	string	No
Catagory1IDContains	query	string	No
Catagory1IDLike	query	string	No
Catagory1IDBetween	query	string[]	No
Catagory1IDIn	query	string[]	No
Catagory2ID	query	string	No
Catagory2IDStartsWith	query	string	No
Catagory2IDEndsWith	query	string	No
Catagory2IDContains	query	string	No
Catagory2IDLike	query	string	No
Catagory2IDBetween	query	string[]	No
Catagory2IDIn	query	string[]	No
Catagory3ID	query	string	No
Catagory3IDStartsWith	query	string	No
Catagory3IDEndsWith	query	string	No
Catagory3IDContains	query	string	No
Catagory3IDLike	query	string	No
Catagory3IDBetween	query	string[]	No
Catagory3IDIn	query	string[]	No
Catagory4ID	query	string	No
Catagory4IDStartsWith	query	string	No
Catagory4IDEndsWith	query	string	No
Catagory4IDContains	query	string	No
Catagory4IDLike	query	string	No
Catagory4IDBetween	query	string[]	No
Catagory4IDIn	query	string[]	No
Catagory5ID	query	string	No
Catagory5IDStartsWith	query	string	No
Catagory5IDEndsWith	query	string	No
Catagory5IDContains	query	string	No
Catagory5IDLike	query	string	No
Catagory5IDBetween	query	string[]	No
Catagory5IDIn	query	string[]	No
ClassificationID	query	string	No
ClassificationIDStartsWith	query	string	No
ClassificationIDEndsWith	query	string	No
ClassificationIDContains	query	string	No
ClassificationIDLike	query	string	No
ClassificationIDBetween	query	string[]	No
ClassificationIDIn	query	string[]	No
Status	query	short?	No
StatusGreaterThanOrEqualTo	query	short?	No
StatusGreaterThan	query	short?	No
StatusLessThan	query	short?	No
StatusLessThanOrEqualTo	query	short?	No
StatusNotEqualTo	query	short?	No
StatusBetween	query	short[]	No
StatusIn	query	short[]	No
DefaultPrice	query	decimal?	No
DefaultPriceGreaterThanOrEqualTo	query	decimal?	No
DefaultPriceGreaterThan	query	decimal?	No
DefaultPriceLessThan	query	decimal?	No
DefaultPriceLessThanOrEqualTo	query	decimal?	No
DefaultPriceNotEqualTo	query	decimal?	No
DefaultPriceBetween	query	Nullable<Decimal>[]	No
DefaultPriceIn	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
LCost	query	decimal?	No
LCostGreaterThanOrEqualTo	query	decimal?	No
LCostGreaterThan	query	decimal?	No
LCostLessThan	query	decimal?	No
LCostLessThanOrEqualTo	query	decimal?	No
LCostNotEqualTo	query	decimal?	No
LCostBetween	query	Nullable<Decimal>[]	No
LCostIn	query	Nullable<Decimal>[]	No
SCost	query	decimal?	No
SCostGreaterThanOrEqualTo	query	decimal?	No
SCostGreaterThan	query	decimal?	No
SCostLessThan	query	decimal?	No
SCostLessThanOrEqualTo	query	decimal?	No
SCostNotEqualTo	query	decimal?	No
SCostBetween	query	Nullable<Decimal>[]	No
SCostIn	query	Nullable<Decimal>[]	No
DecimalPlaces	query	short?	No
DecimalPlacesGreaterThanOrEqualTo	query	short?	No
DecimalPlacesGreaterThan	query	short?	No
DecimalPlacesLessThan	query	short?	No
DecimalPlacesLessThanOrEqualTo	query	short?	No
DecimalPlacesNotEqualTo	query	short?	No
DecimalPlacesBetween	query	Nullable<Int16>[]	No
DecimalPlacesIn	query	Nullable<Int16>[]	No
MinimumGP	query	decimal?	No
MinimumGPGreaterThanOrEqualTo	query	decimal?	No
MinimumGPGreaterThan	query	decimal?	No
MinimumGPLessThan	query	decimal?	No
MinimumGPLessThanOrEqualTo	query	decimal?	No
MinimumGPNotEqualTo	query	decimal?	No
MinimumGPBetween	query	Nullable<Decimal>[]	No
MinimumGPIn	query	Nullable<Decimal>[]	No
Weight	query	decimal?	No
WeightGreaterThanOrEqualTo	query	decimal?	No
WeightGreaterThan	query	decimal?	No
WeightLessThan	query	decimal?	No
WeightLessThanOrEqualTo	query	decimal?	No
WeightNotEqualTo	query	decimal?	No
WeightBetween	query	Nullable<Decimal>[]	No
WeightIn	query	Nullable<Decimal>[]	No
Cubic	query	decimal?	No
CubicGreaterThanOrEqualTo	query	decimal?	No
CubicGreaterThan	query	decimal?	No
CubicLessThan	query	decimal?	No
CubicLessThanOrEqualTo	query	decimal?	No
CubicNotEqualTo	query	decimal?	No
CubicBetween	query	Nullable<Decimal>[]	No
CubicIn	query	Nullable<Decimal>[]	No
UseSerialNo	query	bool?	No
Aux1	query	string	No
Aux1StartsWith	query	string	No
Aux1EndsWith	query	string	No
Aux1Contains	query	string	No
Aux1Like	query	string	No
Aux1Between	query	string[]	No
Aux1In	query	string[]	No
Aux2	query	string	No
Aux2StartsWith	query	string	No
Aux2EndsWith	query	string	No
Aux2Contains	query	string	No
Aux2Like	query	string	No
Aux2Between	query	string[]	No
Aux2In	query	string[]	No
Aux3	query	string	No
Aux3StartsWith	query	string	No
Aux3EndsWith	query	string	No
Aux3Contains	query	string	No
Aux3Like	query	string	No
Aux3Between	query	string[]	No
Aux3In	query	string[]	No
Aux4	query	string	No
Aux4StartsWith	query	string	No
Aux4EndsWith	query	string	No
Aux4Contains	query	string	No
Aux4Like	query	string	No
Aux4Between	query	string[]	No
Aux4In	query	string[]	No
Aux5	query	string	No
Aux5StartsWith	query	string	No
Aux5EndsWith	query	string	No
Aux5Contains	query	string	No
Aux5Like	query	string	No
Aux5Between	query	string[]	No
Aux5In	query	string[]	No
BackOrderable	query	bool?	No
LedgerInvValue	query	string	No
LedgerInvValueStartsWith	query	string	No
LedgerInvValueEndsWith	query	string	No
LedgerInvValueContains	query	string	No
LedgerInvValueLike	query	string	No
LedgerInvValueBetween	query	string[]	No
LedgerInvValueIn	query	string[]	No
LedgerMovement_COG	query	string	No
LedgerMovement_COGStartsWith	query	string	No
LedgerMovement_COGEndsWith	query	string	No
LedgerMovement_COGContains	query	string	No
LedgerMovement_COGLike	query	string	No
LedgerMovement_COGBetween	query	string[]	No
LedgerMovement_COGIn	query	string[]	No
LedgerExpAsset	query	string	No
LedgerExpAssetStartsWith	query	string	No
LedgerExpAssetEndsWith	query	string	No
LedgerExpAssetContains	query	string	No
LedgerExpAssetLike	query	string	No
LedgerExpAssetBetween	query	string[]	No
LedgerExpAssetIn	query	string[]	No
LedgerExpLiab	query	string	No
LedgerExpLiabStartsWith	query	string	No
LedgerExpLiabEndsWith	query	string	No
LedgerExpLiabContains	query	string	No
LedgerExpLiabLike	query	string	No
LedgerExpLiabBetween	query	string[]	No
LedgerExpLiabIn	query	string[]	No
LedgerDelAsset	query	string	No
LedgerDelAssetStartsWith	query	string	No
LedgerDelAssetEndsWith	query	string	No
LedgerDelAssetContains	query	string	No
LedgerDelAssetLike	query	string	No
LedgerDelAssetBetween	query	string[]	No
LedgerDelAssetIn	query	string[]	No
LedgerDelLiab	query	string	No
LedgerDelLiabStartsWith	query	string	No
LedgerDelLiabEndsWith	query	string	No
LedgerDelLiabContains	query	string	No
LedgerDelLiabLike	query	string	No
LedgerDelLiabBetween	query	string[]	No
LedgerDelLiabIn	query	string[]	No
SalesManCost	query	decimal?	No
SalesManCostGreaterThanOrEqualTo	query	decimal?	No
SalesManCostGreaterThan	query	decimal?	No
SalesManCostLessThan	query	decimal?	No
SalesManCostLessThanOrEqualTo	query	decimal?	No
SalesManCostNotEqualTo	query	decimal?	No
SalesManCostBetween	query	Nullable<Decimal>[]	No
SalesManCostIn	query	Nullable<Decimal>[]	No
LedgerAssignedValue	query	string	No
LedgerAssignedValueStartsWith	query	string	No
LedgerAssignedValueEndsWith	query	string	No
LedgerAssignedValueContains	query	string	No
LedgerAssignedValueLike	query	string	No
LedgerAssignedValueBetween	query	string[]	No
LedgerAssignedValueIn	query	string[]	No
LedgerCogVariance	query	string	No
LedgerCogVarianceStartsWith	query	string	No
LedgerCogVarianceEndsWith	query	string	No
LedgerCogVarianceContains	query	string	No
LedgerCogVarianceLike	query	string	No
LedgerCogVarianceBetween	query	string[]	No
LedgerCogVarianceIn	query	string[]	No
LedgerInvSales	query	string	No
LedgerInvSalesStartsWith	query	string	No
LedgerInvSalesEndsWith	query	string	No
LedgerInvSalesContains	query	string	No
LedgerInvSalesLike	query	string	No
LedgerInvSalesBetween	query	string[]	No
LedgerInvSalesIn	query	string[]	No
LedgerAccumulator	query	string	No
LedgerAccumulatorStartsWith	query	string	No
LedgerAccumulatorEndsWith	query	string	No
LedgerAccumulatorContains	query	string	No
LedgerAccumulatorLike	query	string	No
LedgerAccumulatorBetween	query	string[]	No
LedgerAccumulatorIn	query	string[]	No
LedgerPurchases	query	string	No
LedgerPurchasesStartsWith	query	string	No
LedgerPurchasesEndsWith	query	string	No
LedgerPurchasesContains	query	string	No
LedgerPurchasesLike	query	string	No
LedgerPurchasesBetween	query	string[]	No
LedgerPurchasesIn	query	string[]	No
LedgerShipComplete	query	string	No
LedgerShipCompleteStartsWith	query	string	No
LedgerShipCompleteEndsWith	query	string	No
LedgerShipCompleteContains	query	string	No
LedgerShipCompleteLike	query	string	No
LedgerShipCompleteBetween	query	string[]	No
LedgerShipCompleteIn	query	string[]	No
LedgerWriteOn	query	string	No
LedgerWriteOnStartsWith	query	string	No
LedgerWriteOnEndsWith	query	string	No
LedgerWriteOnContains	query	string	No
LedgerWriteOnLike	query	string	No
LedgerWriteOnBetween	query	string[]	No
LedgerWriteOnIn	query	string[]	No
LedgerWriteOff	query	string	No
LedgerWriteOffStartsWith	query	string	No
LedgerWriteOffEndsWith	query	string	No
LedgerWriteOffContains	query	string	No
LedgerWriteOffLike	query	string	No
LedgerWriteOffBetween	query	string[]	No
LedgerWriteOffIn	query	string[]	No
LedgerCostPriceAdj	query	string	No
LedgerCostPriceAdjStartsWith	query	string	No
LedgerCostPriceAdjEndsWith	query	string	No
LedgerCostPriceAdjContains	query	string	No
LedgerCostPriceAdjLike	query	string	No
LedgerCostPriceAdjBetween	query	string[]	No
LedgerCostPriceAdjIn	query	string[]	No
BOMObject	query	short?	No
BOMObjectGreaterThanOrEqualTo	query	short?	No
BOMObjectGreaterThan	query	short?	No
BOMObjectLessThan	query	short?	No
BOMObjectLessThanOrEqualTo	query	short?	No
BOMObjectNotEqualTo	query	short?	No
BOMObjectBetween	query	short[]	No
BOMObjectIn	query	short[]	No
UseExpiryDate	query	bool?	No
UseStandardCost	query	bool?	No
StandardCost	query	decimal?	No
StandardCostGreaterThanOrEqualTo	query	decimal?	No
StandardCostGreaterThan	query	decimal?	No
StandardCostLessThan	query	decimal?	No
StandardCostLessThanOrEqualTo	query	decimal?	No
StandardCostNotEqualTo	query	decimal?	No
StandardCostBetween	query	Nullable<Decimal>[]	No
StandardCostIn	query	Nullable<Decimal>[]	No
WebEnabled	query	bool?	No
GSTInwardsID	query	string	No
GSTInwardsIDStartsWith	query	string	No
GSTInwardsIDEndsWith	query	string	No
GSTInwardsIDContains	query	string	No
GSTInwardsIDLike	query	string	No
GSTInwardsIDBetween	query	string[]	No
GSTInwardsIDIn	query	string[]	No
GSTOutwardsID	query	string	No
GSTOutwardsIDStartsWith	query	string	No
GSTOutwardsIDEndsWith	query	string	No
GSTOutwardsIDContains	query	string	No
GSTOutwardsIDLike	query	string	No
GSTOutwardsIDBetween	query	string[]	No
GSTOutwardsIDIn	query	string[]	No
GSTAdjustmentsINID	query	string	No
GSTAdjustmentsINIDStartsWith	query	string	No
GSTAdjustmentsINIDEndsWith	query	string	No
GSTAdjustmentsINIDContains	query	string	No
GSTAdjustmentsINIDLike	query	string	No
GSTAdjustmentsINIDBetween	query	string[]	No
GSTAdjustmentsINIDIn	query	string[]	No
GSTAdjustmentsOUTID	query	string	No
GSTAdjustmentsOUTIDStartsWith	query	string	No
GSTAdjustmentsOUTIDEndsWith	query	string	No
GSTAdjustmentsOUTIDContains	query	string	No
GSTAdjustmentsOUTIDLike	query	string	No
GSTAdjustmentsOUTIDBetween	query	string[]	No
GSTAdjustmentsOUTIDIn	query	string[]	No
SellPriceIncTax	query	bool?	No
StyleID	query	string	No
StyleIDStartsWith	query	string	No
StyleIDEndsWith	query	string	No
StyleIDContains	query	string	No
StyleIDLike	query	string	No
StyleIDBetween	query	string[]	No
StyleIDIn	query	string[]	No
ColourID	query	string	No
ColourIDStartsWith	query	string	No
ColourIDEndsWith	query	string	No
ColourIDContains	query	string	No
ColourIDLike	query	string	No
ColourIDBetween	query	string[]	No
ColourIDIn	query	string[]	No
SizeID	query	string	No
SizeIDStartsWith	query	string	No
SizeIDEndsWith	query	string	No
SizeIDContains	query	string	No
SizeIDLike	query	string	No
SizeIDBetween	query	string[]	No
SizeIDIn	query	string[]	No
PartEncodeOrder	query	short?	No
PartEncodeOrderGreaterThanOrEqualTo	query	short?	No
PartEncodeOrderGreaterThan	query	short?	No
PartEncodeOrderLessThan	query	short?	No
PartEncodeOrderLessThanOrEqualTo	query	short?	No
PartEncodeOrderNotEqualTo	query	short?	No
PartEncodeOrderBetween	query	Nullable<Int16>[]	No
PartEncodeOrderIn	query	Nullable<Int16>[]	No
TypeStyle	query	bool?	No
MatrixDescription	query	string	No
MatrixDescriptionStartsWith	query	string	No
MatrixDescriptionEndsWith	query	string	No
MatrixDescriptionContains	query	string	No
MatrixDescriptionLike	query	string	No
MatrixDescriptionBetween	query	string[]	No
MatrixDescriptionIn	query	string[]	No
SecondaryCost	query	decimal?	No
SecondaryCostGreaterThanOrEqualTo	query	decimal?	No
SecondaryCostGreaterThan	query	decimal?	No
SecondaryCostLessThan	query	decimal?	No
SecondaryCostLessThanOrEqualTo	query	decimal?	No
SecondaryCostNotEqualTo	query	decimal?	No
SecondaryCostBetween	query	Nullable<Decimal>[]	No
SecondaryCostIn	query	Nullable<Decimal>[]	No
PricingGroupID	query	string	No
PricingGroupIDStartsWith	query	string	No
PricingGroupIDEndsWith	query	string	No
PricingGroupIDContains	query	string	No
PricingGroupIDLike	query	string	No
PricingGroupIDBetween	query	string[]	No
PricingGroupIDIn	query	string[]	No
ShipWithPhysicalItem	query	bool?	No
RowHash	query	byte[]	No
Picture	query	byte[]	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

**IN_Main** Parameters:
Name	Parameter	Data Type	Required
InventoryID	form	string	No
LastSavedDateTime	form	DateTime?	No
PartNo	form	string	No
Description	form	string	No
Units	form	string	No
PhysicalItem	form	bool	No
Discountable	form	bool	No
DirectTax	form	decimal?	No
Catagory1ID	form	string	No
Catagory2ID	form	string	No
Catagory3ID	form	string	No
Catagory4ID	form	string	No
Catagory5ID	form	string	No
ClassificationID	form	string	No
Status	form	short	No
DefaultPrice	form	decimal?	No
RRPPrice	form	decimal?	No
LCost	form	decimal?	No
SCost	form	decimal?	No
DecimalPlaces	form	short?	No
MinimumGP	form	decimal?	No
Weight	form	decimal?	No
Cubic	form	decimal?	No
UseSerialNo	form	bool	No
Aux1	form	string	No
Aux2	form	string	No
Aux3	form	string	No
Aux4	form	string	No
Aux5	form	string	No
BackOrderable	form	bool	No
LedgerInvValue	form	string	No
LedgerMovement_COG	form	string	No
LedgerExpAsset	form	string	No
LedgerExpLiab	form	string	No
LedgerDelAsset	form	string	No
LedgerDelLiab	form	string	No
SalesManCost	form	decimal?	No
LedgerAssignedValue	form	string	No
LedgerCogVariance	form	string	No
LedgerInvSales	form	string	No
LedgerAccumulator	form	string	No
LedgerPurchases	form	string	No
LedgerShipComplete	form	string	No
LedgerWriteOn	form	string	No
LedgerWriteOff	form	string	No
LedgerCostPriceAdj	form	string	No
BOMObject	form	short	No
UseExpiryDate	form	bool	No
UseStandardCost	form	bool	No
StandardCost	form	decimal?	No
WebEnabled	form	bool	No
GSTInwardsID	form	string	No
GSTOutwardsID	form	string	No
GSTAdjustmentsINID	form	string	No
GSTAdjustmentsOUTID	form	string	No
SellPriceIncTax	form	bool	No
StyleID	form	string	No
ColourID	form	string	No
SizeID	form	string	No
PartEncodeOrder	form	short?	No
TypeStyle	form	bool?	No
MatrixDescription	form	string	No
SecondaryCost	form	decimal?	No
PricingGroupID	form	string	No
ShipWithPhysicalItem	form	bool?	No
RowHash	form	byte[]	No
Picture	form	byte[]	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 .json suffix or ?format=json

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

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

GET /Queries/IN_Main HTTP/1.1 
Host: localhost 
Accept: application/json

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

{"Results":[{"InventoryID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","PartNo":"String","Description":"String","Units":"String","DirectTax":0,"Catagory1ID":"String","Catagory2ID":"String","Catagory3ID":"String","Catagory4ID":"String","Catagory5ID":"String","ClassificationID":"String","DefaultPrice":0,"RRPPrice":0,"LCost":0,"SCost":0,"DecimalPlaces":0,"MinimumGP":0,"Weight":0,"Cubic":0,"Aux1":"String","Aux2":"String","Aux3":"String","Aux4":"String","Aux5":"String","LedgerInvValue":"String","LedgerMovement_COG":"String","LedgerExpAsset":"String","LedgerExpLiab":"String","LedgerDelAsset":"String","LedgerDelLiab":"String","SalesManCost":0,"LedgerAssignedValue":"String","LedgerCogVariance":"String","LedgerInvSales":"String","LedgerAccumulator":"String","LedgerPurchases":"String","LedgerShipComplete":"String","LedgerWriteOn":"String","LedgerWriteOff":"String","LedgerCostPriceAdj":"String","StandardCost":0,"GSTInwardsID":"String","GSTOutwardsID":"String","GSTAdjustmentsINID":"String","GSTAdjustmentsOUTID":"String","StyleID":"String","ColourID":"String","SizeID":"String","PartEncodeOrder":0,"TypeStyle":false,"MatrixDescription":"String","SecondaryCost":0,"PricingGroupID":"String","ShipWithPhysicalItem":false,"RowHash":"AA==","Picture":"AA=="}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}