JiwaAPI

<back to all web services

IN_MainQuery

Requires Authentication
The following routes are available for this service:
GET/Queries/IN_MainRetrieves a list of inventory items.
IN_MainQuery Parameters:
NameParameterData TypeRequiredDescription
InventoryIDquerystringNo
InventoryIDStartsWithquerystringNo
InventoryIDEndsWithquerystringNo
InventoryIDContainsquerystringNo
InventoryIDLikequerystringNo
InventoryIDBetweenquerystring[]No
InventoryIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryNullable<DateTime>[]No
LastSavedDateTimeInqueryNullable<DateTime>[]No
PartNoquerystringNo
PartNoStartsWithquerystringNo
PartNoEndsWithquerystringNo
PartNoContainsquerystringNo
PartNoLikequerystringNo
PartNoBetweenquerystring[]No
PartNoInquerystring[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
UnitsquerystringNo
UnitsStartsWithquerystringNo
UnitsEndsWithquerystringNo
UnitsContainsquerystringNo
UnitsLikequerystringNo
UnitsBetweenquerystring[]No
UnitsInquerystring[]No
PhysicalItemquerybool?No
Discountablequerybool?No
DirectTaxquerydecimal?No
DirectTaxGreaterThanOrEqualToquerydecimal?No
DirectTaxGreaterThanquerydecimal?No
DirectTaxLessThanquerydecimal?No
DirectTaxLessThanOrEqualToquerydecimal?No
DirectTaxNotEqualToquerydecimal?No
DirectTaxBetweenqueryNullable<Decimal>[]No
DirectTaxInqueryNullable<Decimal>[]No
Catagory1IDquerystringNo
Catagory1IDStartsWithquerystringNo
Catagory1IDEndsWithquerystringNo
Catagory1IDContainsquerystringNo
Catagory1IDLikequerystringNo
Catagory1IDBetweenquerystring[]No
Catagory1IDInquerystring[]No
Catagory2IDquerystringNo
Catagory2IDStartsWithquerystringNo
Catagory2IDEndsWithquerystringNo
Catagory2IDContainsquerystringNo
Catagory2IDLikequerystringNo
Catagory2IDBetweenquerystring[]No
Catagory2IDInquerystring[]No
Catagory3IDquerystringNo
Catagory3IDStartsWithquerystringNo
Catagory3IDEndsWithquerystringNo
Catagory3IDContainsquerystringNo
Catagory3IDLikequerystringNo
Catagory3IDBetweenquerystring[]No
Catagory3IDInquerystring[]No
Catagory4IDquerystringNo
Catagory4IDStartsWithquerystringNo
Catagory4IDEndsWithquerystringNo
Catagory4IDContainsquerystringNo
Catagory4IDLikequerystringNo
Catagory4IDBetweenquerystring[]No
Catagory4IDInquerystring[]No
Catagory5IDquerystringNo
Catagory5IDStartsWithquerystringNo
Catagory5IDEndsWithquerystringNo
Catagory5IDContainsquerystringNo
Catagory5IDLikequerystringNo
Catagory5IDBetweenquerystring[]No
Catagory5IDInquerystring[]No
ClassificationIDquerystringNo
ClassificationIDStartsWithquerystringNo
ClassificationIDEndsWithquerystringNo
ClassificationIDContainsquerystringNo
ClassificationIDLikequerystringNo
ClassificationIDBetweenquerystring[]No
ClassificationIDInquerystring[]No
Statusqueryshort?No
StatusGreaterThanOrEqualToqueryshort?No
StatusGreaterThanqueryshort?No
StatusLessThanqueryshort?No
StatusLessThanOrEqualToqueryshort?No
StatusNotEqualToqueryshort?No
StatusBetweenqueryshort[]No
StatusInqueryshort[]No
DefaultPricequerydecimal?No
DefaultPriceGreaterThanOrEqualToquerydecimal?No
DefaultPriceGreaterThanquerydecimal?No
DefaultPriceLessThanquerydecimal?No
DefaultPriceLessThanOrEqualToquerydecimal?No
DefaultPriceNotEqualToquerydecimal?No
DefaultPriceBetweenqueryNullable<Decimal>[]No
DefaultPriceInqueryNullable<Decimal>[]No
RRPPricequerydecimal?No
RRPPriceGreaterThanOrEqualToquerydecimal?No
RRPPriceGreaterThanquerydecimal?No
RRPPriceLessThanquerydecimal?No
RRPPriceLessThanOrEqualToquerydecimal?No
RRPPriceNotEqualToquerydecimal?No
RRPPriceBetweenqueryNullable<Decimal>[]No
RRPPriceInqueryNullable<Decimal>[]No
LCostquerydecimal?No
LCostGreaterThanOrEqualToquerydecimal?No
LCostGreaterThanquerydecimal?No
LCostLessThanquerydecimal?No
LCostLessThanOrEqualToquerydecimal?No
LCostNotEqualToquerydecimal?No
LCostBetweenqueryNullable<Decimal>[]No
LCostInqueryNullable<Decimal>[]No
SCostquerydecimal?No
SCostGreaterThanOrEqualToquerydecimal?No
SCostGreaterThanquerydecimal?No
SCostLessThanquerydecimal?No
SCostLessThanOrEqualToquerydecimal?No
SCostNotEqualToquerydecimal?No
SCostBetweenqueryNullable<Decimal>[]No
SCostInqueryNullable<Decimal>[]No
DecimalPlacesqueryshort?No
DecimalPlacesGreaterThanOrEqualToqueryshort?No
DecimalPlacesGreaterThanqueryshort?No
DecimalPlacesLessThanqueryshort?No
DecimalPlacesLessThanOrEqualToqueryshort?No
DecimalPlacesNotEqualToqueryshort?No
DecimalPlacesBetweenqueryNullable<Int16>[]No
DecimalPlacesInqueryNullable<Int16>[]No
MinimumGPquerydecimal?No
MinimumGPGreaterThanOrEqualToquerydecimal?No
MinimumGPGreaterThanquerydecimal?No
MinimumGPLessThanquerydecimal?No
MinimumGPLessThanOrEqualToquerydecimal?No
MinimumGPNotEqualToquerydecimal?No
MinimumGPBetweenqueryNullable<Decimal>[]No
MinimumGPInqueryNullable<Decimal>[]No
Weightquerydecimal?No
WeightGreaterThanOrEqualToquerydecimal?No
WeightGreaterThanquerydecimal?No
WeightLessThanquerydecimal?No
WeightLessThanOrEqualToquerydecimal?No
WeightNotEqualToquerydecimal?No
WeightBetweenqueryNullable<Decimal>[]No
WeightInqueryNullable<Decimal>[]No
Cubicquerydecimal?No
CubicGreaterThanOrEqualToquerydecimal?No
CubicGreaterThanquerydecimal?No
CubicLessThanquerydecimal?No
CubicLessThanOrEqualToquerydecimal?No
CubicNotEqualToquerydecimal?No
CubicBetweenqueryNullable<Decimal>[]No
CubicInqueryNullable<Decimal>[]No
UseSerialNoquerybool?No
Aux1querystringNo
Aux1StartsWithquerystringNo
Aux1EndsWithquerystringNo
Aux1ContainsquerystringNo
Aux1LikequerystringNo
Aux1Betweenquerystring[]No
Aux1Inquerystring[]No
Aux2querystringNo
Aux2StartsWithquerystringNo
Aux2EndsWithquerystringNo
Aux2ContainsquerystringNo
Aux2LikequerystringNo
Aux2Betweenquerystring[]No
Aux2Inquerystring[]No
Aux3querystringNo
Aux3StartsWithquerystringNo
Aux3EndsWithquerystringNo
Aux3ContainsquerystringNo
Aux3LikequerystringNo
Aux3Betweenquerystring[]No
Aux3Inquerystring[]No
Aux4querystringNo
Aux4StartsWithquerystringNo
Aux4EndsWithquerystringNo
Aux4ContainsquerystringNo
Aux4LikequerystringNo
Aux4Betweenquerystring[]No
Aux4Inquerystring[]No
Aux5querystringNo
Aux5StartsWithquerystringNo
Aux5EndsWithquerystringNo
Aux5ContainsquerystringNo
Aux5LikequerystringNo
Aux5Betweenquerystring[]No
Aux5Inquerystring[]No
BackOrderablequerybool?No
LedgerInvValuequerystringNo
LedgerInvValueStartsWithquerystringNo
LedgerInvValueEndsWithquerystringNo
LedgerInvValueContainsquerystringNo
LedgerInvValueLikequerystringNo
LedgerInvValueBetweenquerystring[]No
LedgerInvValueInquerystring[]No
LedgerMovement_COGquerystringNo
LedgerMovement_COGStartsWithquerystringNo
LedgerMovement_COGEndsWithquerystringNo
LedgerMovement_COGContainsquerystringNo
LedgerMovement_COGLikequerystringNo
LedgerMovement_COGBetweenquerystring[]No
LedgerMovement_COGInquerystring[]No
LedgerExpAssetquerystringNo
LedgerExpAssetStartsWithquerystringNo
LedgerExpAssetEndsWithquerystringNo
LedgerExpAssetContainsquerystringNo
LedgerExpAssetLikequerystringNo
LedgerExpAssetBetweenquerystring[]No
LedgerExpAssetInquerystring[]No
LedgerExpLiabquerystringNo
LedgerExpLiabStartsWithquerystringNo
LedgerExpLiabEndsWithquerystringNo
LedgerExpLiabContainsquerystringNo
LedgerExpLiabLikequerystringNo
LedgerExpLiabBetweenquerystring[]No
LedgerExpLiabInquerystring[]No
LedgerDelAssetquerystringNo
LedgerDelAssetStartsWithquerystringNo
LedgerDelAssetEndsWithquerystringNo
LedgerDelAssetContainsquerystringNo
LedgerDelAssetLikequerystringNo
LedgerDelAssetBetweenquerystring[]No
LedgerDelAssetInquerystring[]No
LedgerDelLiabquerystringNo
LedgerDelLiabStartsWithquerystringNo
LedgerDelLiabEndsWithquerystringNo
LedgerDelLiabContainsquerystringNo
LedgerDelLiabLikequerystringNo
LedgerDelLiabBetweenquerystring[]No
LedgerDelLiabInquerystring[]No
SalesManCostquerydecimal?No
SalesManCostGreaterThanOrEqualToquerydecimal?No
SalesManCostGreaterThanquerydecimal?No
SalesManCostLessThanquerydecimal?No
SalesManCostLessThanOrEqualToquerydecimal?No
SalesManCostNotEqualToquerydecimal?No
SalesManCostBetweenqueryNullable<Decimal>[]No
SalesManCostInqueryNullable<Decimal>[]No
LedgerAssignedValuequerystringNo
LedgerAssignedValueStartsWithquerystringNo
LedgerAssignedValueEndsWithquerystringNo
LedgerAssignedValueContainsquerystringNo
LedgerAssignedValueLikequerystringNo
LedgerAssignedValueBetweenquerystring[]No
LedgerAssignedValueInquerystring[]No
LedgerCogVariancequerystringNo
LedgerCogVarianceStartsWithquerystringNo
LedgerCogVarianceEndsWithquerystringNo
LedgerCogVarianceContainsquerystringNo
LedgerCogVarianceLikequerystringNo
LedgerCogVarianceBetweenquerystring[]No
LedgerCogVarianceInquerystring[]No
LedgerInvSalesquerystringNo
LedgerInvSalesStartsWithquerystringNo
LedgerInvSalesEndsWithquerystringNo
LedgerInvSalesContainsquerystringNo
LedgerInvSalesLikequerystringNo
LedgerInvSalesBetweenquerystring[]No
LedgerInvSalesInquerystring[]No
LedgerAccumulatorquerystringNo
LedgerAccumulatorStartsWithquerystringNo
LedgerAccumulatorEndsWithquerystringNo
LedgerAccumulatorContainsquerystringNo
LedgerAccumulatorLikequerystringNo
LedgerAccumulatorBetweenquerystring[]No
LedgerAccumulatorInquerystring[]No
LedgerPurchasesquerystringNo
LedgerPurchasesStartsWithquerystringNo
LedgerPurchasesEndsWithquerystringNo
LedgerPurchasesContainsquerystringNo
LedgerPurchasesLikequerystringNo
LedgerPurchasesBetweenquerystring[]No
LedgerPurchasesInquerystring[]No
LedgerShipCompletequerystringNo
LedgerShipCompleteStartsWithquerystringNo
LedgerShipCompleteEndsWithquerystringNo
LedgerShipCompleteContainsquerystringNo
LedgerShipCompleteLikequerystringNo
LedgerShipCompleteBetweenquerystring[]No
LedgerShipCompleteInquerystring[]No
LedgerWriteOnquerystringNo
LedgerWriteOnStartsWithquerystringNo
LedgerWriteOnEndsWithquerystringNo
LedgerWriteOnContainsquerystringNo
LedgerWriteOnLikequerystringNo
LedgerWriteOnBetweenquerystring[]No
LedgerWriteOnInquerystring[]No
LedgerWriteOffquerystringNo
LedgerWriteOffStartsWithquerystringNo
LedgerWriteOffEndsWithquerystringNo
LedgerWriteOffContainsquerystringNo
LedgerWriteOffLikequerystringNo
LedgerWriteOffBetweenquerystring[]No
LedgerWriteOffInquerystring[]No
LedgerCostPriceAdjquerystringNo
LedgerCostPriceAdjStartsWithquerystringNo
LedgerCostPriceAdjEndsWithquerystringNo
LedgerCostPriceAdjContainsquerystringNo
LedgerCostPriceAdjLikequerystringNo
LedgerCostPriceAdjBetweenquerystring[]No
LedgerCostPriceAdjInquerystring[]No
BOMObjectqueryshort?No
BOMObjectGreaterThanOrEqualToqueryshort?No
BOMObjectGreaterThanqueryshort?No
BOMObjectLessThanqueryshort?No
BOMObjectLessThanOrEqualToqueryshort?No
BOMObjectNotEqualToqueryshort?No
BOMObjectBetweenqueryshort[]No
BOMObjectInqueryshort[]No
UseExpiryDatequerybool?No
UseStandardCostquerybool?No
StandardCostquerydecimal?No
StandardCostGreaterThanOrEqualToquerydecimal?No
StandardCostGreaterThanquerydecimal?No
StandardCostLessThanquerydecimal?No
StandardCostLessThanOrEqualToquerydecimal?No
StandardCostNotEqualToquerydecimal?No
StandardCostBetweenqueryNullable<Decimal>[]No
StandardCostInqueryNullable<Decimal>[]No
WebEnabledquerybool?No
GSTInwardsIDquerystringNo
GSTInwardsIDStartsWithquerystringNo
GSTInwardsIDEndsWithquerystringNo
GSTInwardsIDContainsquerystringNo
GSTInwardsIDLikequerystringNo
GSTInwardsIDBetweenquerystring[]No
GSTInwardsIDInquerystring[]No
GSTOutwardsIDquerystringNo
GSTOutwardsIDStartsWithquerystringNo
GSTOutwardsIDEndsWithquerystringNo
GSTOutwardsIDContainsquerystringNo
GSTOutwardsIDLikequerystringNo
GSTOutwardsIDBetweenquerystring[]No
GSTOutwardsIDInquerystring[]No
GSTAdjustmentsINIDquerystringNo
GSTAdjustmentsINIDStartsWithquerystringNo
GSTAdjustmentsINIDEndsWithquerystringNo
GSTAdjustmentsINIDContainsquerystringNo
GSTAdjustmentsINIDLikequerystringNo
GSTAdjustmentsINIDBetweenquerystring[]No
GSTAdjustmentsINIDInquerystring[]No
GSTAdjustmentsOUTIDquerystringNo
GSTAdjustmentsOUTIDStartsWithquerystringNo
GSTAdjustmentsOUTIDEndsWithquerystringNo
GSTAdjustmentsOUTIDContainsquerystringNo
GSTAdjustmentsOUTIDLikequerystringNo
GSTAdjustmentsOUTIDBetweenquerystring[]No
GSTAdjustmentsOUTIDInquerystring[]No
SellPriceIncTaxquerybool?No
StyleIDquerystringNo
StyleIDStartsWithquerystringNo
StyleIDEndsWithquerystringNo
StyleIDContainsquerystringNo
StyleIDLikequerystringNo
StyleIDBetweenquerystring[]No
StyleIDInquerystring[]No
ColourIDquerystringNo
ColourIDStartsWithquerystringNo
ColourIDEndsWithquerystringNo
ColourIDContainsquerystringNo
ColourIDLikequerystringNo
ColourIDBetweenquerystring[]No
ColourIDInquerystring[]No
SizeIDquerystringNo
SizeIDStartsWithquerystringNo
SizeIDEndsWithquerystringNo
SizeIDContainsquerystringNo
SizeIDLikequerystringNo
SizeIDBetweenquerystring[]No
SizeIDInquerystring[]No
PartEncodeOrderqueryshort?No
PartEncodeOrderGreaterThanOrEqualToqueryshort?No
PartEncodeOrderGreaterThanqueryshort?No
PartEncodeOrderLessThanqueryshort?No
PartEncodeOrderLessThanOrEqualToqueryshort?No
PartEncodeOrderNotEqualToqueryshort?No
PartEncodeOrderBetweenqueryNullable<Int16>[]No
PartEncodeOrderInqueryNullable<Int16>[]No
TypeStylequerybool?No
MatrixDescriptionquerystringNo
MatrixDescriptionStartsWithquerystringNo
MatrixDescriptionEndsWithquerystringNo
MatrixDescriptionContainsquerystringNo
MatrixDescriptionLikequerystringNo
MatrixDescriptionBetweenquerystring[]No
MatrixDescriptionInquerystring[]No
SecondaryCostquerydecimal?No
SecondaryCostGreaterThanOrEqualToquerydecimal?No
SecondaryCostGreaterThanquerydecimal?No
SecondaryCostLessThanquerydecimal?No
SecondaryCostLessThanOrEqualToquerydecimal?No
SecondaryCostNotEqualToquerydecimal?No
SecondaryCostBetweenqueryNullable<Decimal>[]No
SecondaryCostInqueryNullable<Decimal>[]No
PricingGroupIDquerystringNo
PricingGroupIDStartsWithquerystringNo
PricingGroupIDEndsWithquerystringNo
PricingGroupIDContainsquerystringNo
PricingGroupIDLikequerystringNo
PricingGroupIDBetweenquerystring[]No
PricingGroupIDInquerystring[]No
ShipWithPhysicalItemquerybool?No
RowHashquerybyte[]No
Picturequerybyte[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
IN_Main Parameters:
NameParameterData TypeRequiredDescription
InventoryIDformstringNo
LastSavedDateTimeformDateTime?No
PartNoformstringNo
DescriptionformstringNo
UnitsformstringNo
PhysicalItemformboolNo
DiscountableformboolNo
DirectTaxformdecimal?No
Catagory1IDformstringNo
Catagory2IDformstringNo
Catagory3IDformstringNo
Catagory4IDformstringNo
Catagory5IDformstringNo
ClassificationIDformstringNo
StatusformshortNo
DefaultPriceformdecimal?No
RRPPriceformdecimal?No
LCostformdecimal?No
SCostformdecimal?No
DecimalPlacesformshort?No
MinimumGPformdecimal?No
Weightformdecimal?No
Cubicformdecimal?No
UseSerialNoformboolNo
Aux1formstringNo
Aux2formstringNo
Aux3formstringNo
Aux4formstringNo
Aux5formstringNo
BackOrderableformboolNo
LedgerInvValueformstringNo
LedgerMovement_COGformstringNo
LedgerExpAssetformstringNo
LedgerExpLiabformstringNo
LedgerDelAssetformstringNo
LedgerDelLiabformstringNo
SalesManCostformdecimal?No
LedgerAssignedValueformstringNo
LedgerCogVarianceformstringNo
LedgerInvSalesformstringNo
LedgerAccumulatorformstringNo
LedgerPurchasesformstringNo
LedgerShipCompleteformstringNo
LedgerWriteOnformstringNo
LedgerWriteOffformstringNo
LedgerCostPriceAdjformstringNo
BOMObjectformshortNo
UseExpiryDateformboolNo
UseStandardCostformboolNo
StandardCostformdecimal?No
WebEnabledformboolNo
GSTInwardsIDformstringNo
GSTOutwardsIDformstringNo
GSTAdjustmentsINIDformstringNo
GSTAdjustmentsOUTIDformstringNo
SellPriceIncTaxformboolNo
StyleIDformstringNo
ColourIDformstringNo
SizeIDformstringNo
PartEncodeOrderformshort?No
TypeStyleformbool?No
MatrixDescriptionformstringNo
SecondaryCostformdecimal?No
PricingGroupIDformstringNo
ShipWithPhysicalItemformbool?No
RowHashformbyte[]No
Pictureformbyte[]No
QueryResponse<T> Parameters:
NameParameterData TypeRequiredDescription
OffsetformintNo
TotalformintNo
ResultsformList<T>No
MetaformDictionary<string, string>No
ResponseStatusformResponseStatusNo

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: api.jiwa.com.au 
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"}}}