JiwaAPI

<back to all web services

PO_LinesQuery

Requires Authentication
PO_LinesQuery Parameters:
NameParameterData TypeRequiredDescription
OrderLineIDquerystringNo
OrderLineIDStartsWithquerystringNo
OrderLineIDEndsWithquerystringNo
OrderLineIDContainsquerystringNo
OrderLineIDLikequerystringNo
OrderLineIDBetweenquerystring[]No
OrderLineIDInquerystring[]No
OrderIDquerystringNo
OrderIDStartsWithquerystringNo
OrderIDEndsWithquerystringNo
OrderIDContainsquerystringNo
OrderIDLikequerystringNo
OrderIDBetweenquerystring[]No
OrderIDInquerystring[]No
InventoryIDquerystringNo
InventoryIDStartsWithquerystringNo
InventoryIDEndsWithquerystringNo
InventoryIDContainsquerystringNo
InventoryIDLikequerystringNo
InventoryIDBetweenquerystring[]No
InventoryIDInquerystring[]No
Quantityquerydecimal?No
QuantityGreaterThanOrEqualToquerydecimal?No
QuantityGreaterThanquerydecimal?No
QuantityLessThanquerydecimal?No
QuantityLessThanOrEqualToquerydecimal?No
QuantityNotEqualToquerydecimal?No
QuantityBetweenqueryNullable<Decimal>[]No
QuantityInqueryNullable<Decimal>[]No
SuppliersCostquerydecimal?No
SuppliersCostGreaterThanOrEqualToquerydecimal?No
SuppliersCostGreaterThanquerydecimal?No
SuppliersCostLessThanquerydecimal?No
SuppliersCostLessThanOrEqualToquerydecimal?No
SuppliersCostNotEqualToquerydecimal?No
SuppliersCostBetweenqueryNullable<Decimal>[]No
SuppliersCostInqueryNullable<Decimal>[]No
DeliveryDatequeryDateTime?No
DeliveryDateGreaterThanOrEqualToqueryDateTime?No
DeliveryDateGreaterThanqueryDateTime?No
DeliveryDateLessThanqueryDateTime?No
DeliveryDateLessThanOrEqualToqueryDateTime?No
DeliveryDateNotEqualToqueryDateTime?No
DeliveryDateBetweenqueryNullable<DateTime>[]No
DeliveryDateInqueryNullable<DateTime>[]No
Deliveredquerydecimal?No
DeliveredGreaterThanOrEqualToquerydecimal?No
DeliveredGreaterThanquerydecimal?No
DeliveredLessThanquerydecimal?No
DeliveredLessThanOrEqualToquerydecimal?No
DeliveredNotEqualToquerydecimal?No
DeliveredBetweenqueryNullable<Decimal>[]No
DeliveredInqueryNullable<Decimal>[]No
DecimalPlacesqueryshort?No
DecimalPlacesGreaterThanOrEqualToqueryshort?No
DecimalPlacesGreaterThanqueryshort?No
DecimalPlacesLessThanqueryshort?No
DecimalPlacesLessThanOrEqualToqueryshort?No
DecimalPlacesNotEqualToqueryshort?No
DecimalPlacesBetweenqueryNullable<Int16>[]No
DecimalPlacesInqueryNullable<Int16>[]No
OrderLineNoqueryshort?No
OrderLineNoGreaterThanOrEqualToqueryshort?No
OrderLineNoGreaterThanqueryshort?No
OrderLineNoLessThanqueryshort?No
OrderLineNoLessThanOrEqualToqueryshort?No
OrderLineNoNotEqualToqueryshort?No
OrderLineNoBetweenqueryNullable<Int16>[]No
OrderLineNoInqueryNullable<Int16>[]No
SuppPartNoquerystringNo
SuppPartNoStartsWithquerystringNo
SuppPartNoEndsWithquerystringNo
SuppPartNoContainsquerystringNo
SuppPartNoLikequerystringNo
SuppPartNoBetweenquerystring[]No
SuppPartNoInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryNullable<DateTime>[]No
LastSavedDateTimeInqueryNullable<DateTime>[]No
HistoryText_CommentquerystringNo
HistoryText_CommentStartsWithquerystringNo
HistoryText_CommentEndsWithquerystringNo
HistoryText_CommentContainsquerystringNo
HistoryText_CommentLikequerystringNo
HistoryText_CommentBetweenquerystring[]No
HistoryText_CommentInquerystring[]No
OrderUnitsquerydecimal?No
OrderUnitsGreaterThanOrEqualToquerydecimal?No
OrderUnitsGreaterThanquerydecimal?No
OrderUnitsLessThanquerydecimal?No
OrderUnitsLessThanOrEqualToquerydecimal?No
OrderUnitsNotEqualToquerydecimal?No
OrderUnitsBetweenqueryNullable<Decimal>[]No
OrderUnitsInqueryNullable<Decimal>[]No
LineTypequeryshort?No
LineTypeGreaterThanOrEqualToqueryshort?No
LineTypeGreaterThanqueryshort?No
LineTypeLessThanqueryshort?No
LineTypeLessThanOrEqualToqueryshort?No
LineTypeNotEqualToqueryshort?No
LineTypeBetweenqueryNullable<Int16>[]No
LineTypeInqueryNullable<Int16>[]No
PartNoquerystringNo
PartNoStartsWithquerystringNo
PartNoEndsWithquerystringNo
PartNoContainsquerystringNo
PartNoLikequerystringNo
PartNoBetweenquerystring[]No
PartNoInquerystring[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
DeliveryDaysqueryshort?No
DeliveryDaysGreaterThanOrEqualToqueryshort?No
DeliveryDaysGreaterThanqueryshort?No
DeliveryDaysLessThanqueryshort?No
DeliveryDaysLessThanOrEqualToqueryshort?No
DeliveryDaysNotEqualToqueryshort?No
DeliveryDaysBetweenqueryNullable<Int16>[]No
DeliveryDaysInqueryNullable<Int16>[]No
ClassificationIDquerystringNo
ClassificationIDStartsWithquerystringNo
ClassificationIDEndsWithquerystringNo
ClassificationIDContainsquerystringNo
ClassificationIDLikequerystringNo
ClassificationIDBetweenquerystring[]No
ClassificationIDInquerystring[]No
ClassDescriptionquerystringNo
ClassDescriptionStartsWithquerystringNo
ClassDescriptionEndsWithquerystringNo
ClassDescriptionContainsquerystringNo
ClassDescriptionLikequerystringNo
ClassDescriptionBetweenquerystring[]No
ClassDescriptionInquerystring[]No
TaxAmountquerydecimal?No
TaxAmountGreaterThanOrEqualToquerydecimal?No
TaxAmountGreaterThanquerydecimal?No
TaxAmountLessThanquerydecimal?No
TaxAmountLessThanOrEqualToquerydecimal?No
TaxAmountNotEqualToquerydecimal?No
TaxAmountBetweenqueryNullable<Decimal>[]No
TaxAmountInqueryNullable<Decimal>[]No
TaxIDquerystringNo
TaxIDStartsWithquerystringNo
TaxIDEndsWithquerystringNo
TaxIDContainsquerystringNo
TaxIDLikequerystringNo
TaxIDBetweenquerystring[]No
TaxIDInquerystring[]No
TaxRatequerydecimal?No
TaxRateGreaterThanOrEqualToquerydecimal?No
TaxRateGreaterThanquerydecimal?No
TaxRateLessThanquerydecimal?No
TaxRateLessThanOrEqualToquerydecimal?No
TaxRateNotEqualToquerydecimal?No
TaxRateBetweenqueryNullable<Decimal>[]No
TaxRateInqueryNullable<Decimal>[]No
HomeSuppliersCostquerydecimal?No
HomeSuppliersCostGreaterThanOrEqualToquerydecimal?No
HomeSuppliersCostGreaterThanquerydecimal?No
HomeSuppliersCostLessThanquerydecimal?No
HomeSuppliersCostLessThanOrEqualToquerydecimal?No
HomeSuppliersCostNotEqualToquerydecimal?No
HomeSuppliersCostBetweenqueryNullable<Decimal>[]No
HomeSuppliersCostInqueryNullable<Decimal>[]No
CurrencyRateUsedquerydecimal?No
CurrencyRateUsedGreaterThanOrEqualToquerydecimal?No
CurrencyRateUsedGreaterThanquerydecimal?No
CurrencyRateUsedLessThanquerydecimal?No
CurrencyRateUsedLessThanOrEqualToquerydecimal?No
CurrencyRateUsedNotEqualToquerydecimal?No
CurrencyRateUsedBetweenqueryNullable<Decimal>[]No
CurrencyRateUsedInqueryNullable<Decimal>[]No
POClassIDquerystringNo
POClassIDStartsWithquerystringNo
POClassIDEndsWithquerystringNo
POClassIDContainsquerystringNo
POClassIDLikequerystringNo
POClassIDBetweenquerystring[]No
POClassIDInquerystring[]No
IncPricequerydecimal?No
IncPriceGreaterThanOrEqualToquerydecimal?No
IncPriceGreaterThanquerydecimal?No
IncPriceLessThanquerydecimal?No
IncPriceLessThanOrEqualToquerydecimal?No
IncPriceNotEqualToquerydecimal?No
IncPriceBetweenqueryNullable<Decimal>[]No
IncPriceInqueryNullable<Decimal>[]No
LineTotalquerydecimal?No
LineTotalGreaterThanOrEqualToquerydecimal?No
LineTotalGreaterThanquerydecimal?No
LineTotalLessThanquerydecimal?No
LineTotalLessThanOrEqualToquerydecimal?No
LineTotalNotEqualToquerydecimal?No
LineTotalBetweenqueryNullable<Decimal>[]No
LineTotalInqueryNullable<Decimal>[]No
FxDecimalPlacesqueryshort?No
FxDecimalPlacesGreaterThanOrEqualToqueryshort?No
FxDecimalPlacesGreaterThanqueryshort?No
FxDecimalPlacesLessThanqueryshort?No
FxDecimalPlacesLessThanOrEqualToqueryshort?No
FxDecimalPlacesNotEqualToqueryshort?No
FxDecimalPlacesBetweenqueryNullable<Int16>[]No
FxDecimalPlacesInqueryNullable<Int16>[]No
AUDDecimalPlacesqueryshort?No
AUDDecimalPlacesGreaterThanOrEqualToqueryshort?No
AUDDecimalPlacesGreaterThanqueryshort?No
AUDDecimalPlacesLessThanqueryshort?No
AUDDecimalPlacesLessThanOrEqualToqueryshort?No
AUDDecimalPlacesNotEqualToqueryshort?No
AUDDecimalPlacesBetweenqueryNullable<Int16>[]No
AUDDecimalPlacesInqueryNullable<Int16>[]No
FxTotalquerydecimal?No
FxTotalGreaterThanOrEqualToquerydecimal?No
FxTotalGreaterThanquerydecimal?No
FxTotalLessThanquerydecimal?No
FxTotalLessThanOrEqualToquerydecimal?No
FxTotalNotEqualToquerydecimal?No
FxTotalBetweenqueryNullable<Decimal>[]No
FxTotalInqueryNullable<Decimal>[]No
IN_SupplierWarehouse_RecIDquerystringNo
IN_SupplierWarehouse_RecIDStartsWithquerystringNo
IN_SupplierWarehouse_RecIDEndsWithquerystringNo
IN_SupplierWarehouse_RecIDContainsquerystringNo
IN_SupplierWarehouse_RecIDLikequerystringNo
IN_SupplierWarehouse_RecIDBetweenquerystring[]No
IN_SupplierWarehouse_RecIDInquerystring[]No
UnitquerystringNo
UnitStartsWithquerystringNo
UnitEndsWithquerystringNo
UnitContainsquerystringNo
UnitLikequerystringNo
UnitBetweenquerystring[]No
UnitInquerystring[]No
UserDefinedDate3queryDateTime?No
UserDefinedDate3GreaterThanOrEqualToqueryDateTime?No
UserDefinedDate3GreaterThanqueryDateTime?No
UserDefinedDate3LessThanqueryDateTime?No
UserDefinedDate3LessThanOrEqualToqueryDateTime?No
UserDefinedDate3NotEqualToqueryDateTime?No
UserDefinedDate3BetweenqueryNullable<DateTime>[]No
UserDefinedDate3InqueryNullable<DateTime>[]No
UserDefinedString1querystringNo
UserDefinedString1StartsWithquerystringNo
UserDefinedString1EndsWithquerystringNo
UserDefinedString1ContainsquerystringNo
UserDefinedString1LikequerystringNo
UserDefinedString1Betweenquerystring[]No
UserDefinedString1Inquerystring[]No
UserDefinedString2querystringNo
UserDefinedString2StartsWithquerystringNo
UserDefinedString2EndsWithquerystringNo
UserDefinedString2ContainsquerystringNo
UserDefinedString2LikequerystringNo
UserDefinedString2Betweenquerystring[]No
UserDefinedString2Inquerystring[]No
UserDefinedString3querystringNo
UserDefinedString3StartsWithquerystringNo
UserDefinedString3EndsWithquerystringNo
UserDefinedString3ContainsquerystringNo
UserDefinedString3LikequerystringNo
UserDefinedString3Betweenquerystring[]No
UserDefinedString3Inquerystring[]No
UserDefinedFloat1querydecimal?No
UserDefinedFloat1GreaterThanOrEqualToquerydecimal?No
UserDefinedFloat1GreaterThanquerydecimal?No
UserDefinedFloat1LessThanquerydecimal?No
UserDefinedFloat1LessThanOrEqualToquerydecimal?No
UserDefinedFloat1NotEqualToquerydecimal?No
UserDefinedFloat1BetweenqueryNullable<Decimal>[]No
UserDefinedFloat1InqueryNullable<Decimal>[]No
UserDefinedFloat2querydecimal?No
UserDefinedFloat2GreaterThanOrEqualToquerydecimal?No
UserDefinedFloat2GreaterThanquerydecimal?No
UserDefinedFloat2LessThanquerydecimal?No
UserDefinedFloat2LessThanOrEqualToquerydecimal?No
UserDefinedFloat2NotEqualToquerydecimal?No
UserDefinedFloat2BetweenqueryNullable<Decimal>[]No
UserDefinedFloat2InqueryNullable<Decimal>[]No
UserDefinedFloat3querydecimal?No
UserDefinedFloat3GreaterThanOrEqualToquerydecimal?No
UserDefinedFloat3GreaterThanquerydecimal?No
UserDefinedFloat3LessThanquerydecimal?No
UserDefinedFloat3LessThanOrEqualToquerydecimal?No
UserDefinedFloat3NotEqualToquerydecimal?No
UserDefinedFloat3BetweenqueryNullable<Decimal>[]No
UserDefinedFloat3InqueryNullable<Decimal>[]No
UserDefinedDate1queryDateTime?No
UserDefinedDate1GreaterThanOrEqualToqueryDateTime?No
UserDefinedDate1GreaterThanqueryDateTime?No
UserDefinedDate1LessThanqueryDateTime?No
UserDefinedDate1LessThanOrEqualToqueryDateTime?No
UserDefinedDate1NotEqualToqueryDateTime?No
UserDefinedDate1BetweenqueryNullable<DateTime>[]No
UserDefinedDate1InqueryNullable<DateTime>[]No
UserDefinedDate2queryDateTime?No
UserDefinedDate2GreaterThanOrEqualToqueryDateTime?No
UserDefinedDate2GreaterThanqueryDateTime?No
UserDefinedDate2LessThanqueryDateTime?No
UserDefinedDate2LessThanOrEqualToqueryDateTime?No
UserDefinedDate2NotEqualToqueryDateTime?No
UserDefinedDate2BetweenqueryNullable<DateTime>[]No
UserDefinedDate2InqueryNullable<DateTime>[]No
SM_Task_RecIDquerystringNo
SM_Task_RecIDStartsWithquerystringNo
SM_Task_RecIDEndsWithquerystringNo
SM_Task_RecIDContainsquerystringNo
SM_Task_RecIDLikequerystringNo
SM_Task_RecIDBetweenquerystring[]No
SM_Task_RecIDInquerystring[]No
JB_JobStages_RecIDquerystringNo
JB_JobStages_RecIDStartsWithquerystringNo
JB_JobStages_RecIDEndsWithquerystringNo
JB_JobStages_RecIDContainsquerystringNo
JB_JobStages_RecIDLikequerystringNo
JB_JobStages_RecIDBetweenquerystring[]No
JB_JobStages_RecIDInquerystring[]No
LineTotalExTaxquerydecimal?No
LineTotalExTaxGreaterThanOrEqualToquerydecimal?No
LineTotalExTaxGreaterThanquerydecimal?No
LineTotalExTaxLessThanquerydecimal?No
LineTotalExTaxLessThanOrEqualToquerydecimal?No
LineTotalExTaxNotEqualToquerydecimal?No
LineTotalExTaxBetweenquerydecimal[]No
LineTotalExTaxInquerydecimal[]No
IN_UnitOfMeasure_RecIDqueryGuid?No
IN_UnitOfMeasure_RecIDInqueryNullable<Guid>[]No
UnitChangedquerybool?No
FXChangedquerybool?No
ExChangedquerybool?No
TaxRateChangedquerybool?No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
PO_Lines Parameters:
NameParameterData TypeRequiredDescription
OrderLineIDformstringNo
OrderIDformstringNo
InventoryIDformstringNo
Quantityformdecimal?No
SuppliersCostformdecimal?No
DeliveryDateformDateTime?No
Deliveredformdecimal?No
DecimalPlacesformshort?No
OrderLineNoformshort?No
SuppPartNoformstringNo
LastSavedDateTimeformDateTime?No
HistoryText_CommentformstringNo
OrderUnitsformdecimal?No
LineTypeformshort?No
PartNoformstringNo
DescriptionformstringNo
DeliveryDaysformshort?No
ClassificationIDformstringNo
ClassDescriptionformstringNo
TaxAmountformdecimal?No
TaxIDformstringNo
TaxRateformdecimal?No
HomeSuppliersCostformdecimal?No
CurrencyRateUsedformdecimal?No
POClassIDformstringNo
IncPriceformdecimal?No
LineTotalformdecimal?No
FxDecimalPlacesformshort?No
AUDDecimalPlacesformshort?No
FxTotalformdecimal?No
IN_SupplierWarehouse_RecIDformstringNo
UnitformstringNo
UserDefinedDate3formDateTime?No
UserDefinedString1formstringNo
UserDefinedString2formstringNo
UserDefinedString3formstringNo
UserDefinedFloat1formdecimal?No
UserDefinedFloat2formdecimal?No
UserDefinedFloat3formdecimal?No
UserDefinedDate1formDateTime?No
UserDefinedDate2formDateTime?No
SM_Task_RecIDformstringNo
JB_JobStages_RecIDformstringNo
LineTotalExTaxformdecimalNo
IN_UnitOfMeasure_RecIDformGuid?No
UnitChangedformbool?No
FXChangedformbool?No
ExChangedformbool?No
TaxRateChangedformbool?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 .csv suffix or ?format=csv

HTTP + CSV

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

POST /csv/reply/PO_LinesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"OrderLineID":"String","OrderLineIDStartsWith":"String","OrderLineIDEndsWith":"String","OrderLineIDContains":"String","OrderLineIDLike":"String","OrderLineIDBetween":["String"],"OrderLineIDIn":["String"],"OrderID":"String","OrderIDStartsWith":"String","OrderIDEndsWith":"String","OrderIDContains":"String","OrderIDLike":"String","OrderIDBetween":["String"],"OrderIDIn":["String"],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"Quantity":0,"QuantityGreaterThanOrEqualTo":0,"QuantityGreaterThan":0,"QuantityLessThan":0,"QuantityLessThanOrEqualTo":0,"QuantityNotEqualTo":0,"QuantityBetween":[0],"QuantityIn":[0],"SuppliersCost":0,"SuppliersCostGreaterThanOrEqualTo":0,"SuppliersCostGreaterThan":0,"SuppliersCostLessThan":0,"SuppliersCostLessThanOrEqualTo":0,"SuppliersCostNotEqualTo":0,"SuppliersCostBetween":[0],"SuppliersCostIn":[0],"DeliveryDate":"0001-01-01T00:00:00.0000000","DeliveryDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","DeliveryDateGreaterThan":"0001-01-01T00:00:00.0000000","DeliveryDateLessThan":"0001-01-01T00:00:00.0000000","DeliveryDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","DeliveryDateNotEqualTo":"0001-01-01T00:00:00.0000000","DeliveryDateBetween":["0001-01-01T00:00:00.0000000"],"DeliveryDateIn":["0001-01-01T00:00:00.0000000"],"Delivered":0,"DeliveredGreaterThanOrEqualTo":0,"DeliveredGreaterThan":0,"DeliveredLessThan":0,"DeliveredLessThanOrEqualTo":0,"DeliveredNotEqualTo":0,"DeliveredBetween":[0],"DeliveredIn":[0],"DecimalPlaces":0,"DecimalPlacesGreaterThanOrEqualTo":0,"DecimalPlacesGreaterThan":0,"DecimalPlacesLessThan":0,"DecimalPlacesLessThanOrEqualTo":0,"DecimalPlacesNotEqualTo":0,"DecimalPlacesBetween":[0],"DecimalPlacesIn":[0],"OrderLineNo":0,"OrderLineNoGreaterThanOrEqualTo":0,"OrderLineNoGreaterThan":0,"OrderLineNoLessThan":0,"OrderLineNoLessThanOrEqualTo":0,"OrderLineNoNotEqualTo":0,"OrderLineNoBetween":[0],"OrderLineNoIn":[0],"SuppPartNo":"String","SuppPartNoStartsWith":"String","SuppPartNoEndsWith":"String","SuppPartNoContains":"String","SuppPartNoLike":"String","SuppPartNoBetween":["String"],"SuppPartNoIn":["String"],"LastSavedDateTime":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeBetween":["0001-01-01T00:00:00.0000000"],"LastSavedDateTimeIn":["0001-01-01T00:00:00.0000000"],"HistoryText_Comment":"String","HistoryText_CommentStartsWith":"String","HistoryText_CommentEndsWith":"String","HistoryText_CommentContains":"String","HistoryText_CommentLike":"String","HistoryText_CommentBetween":["String"],"HistoryText_CommentIn":["String"],"OrderUnits":0,"OrderUnitsGreaterThanOrEqualTo":0,"OrderUnitsGreaterThan":0,"OrderUnitsLessThan":0,"OrderUnitsLessThanOrEqualTo":0,"OrderUnitsNotEqualTo":0,"OrderUnitsBetween":[0],"OrderUnitsIn":[0],"LineType":0,"LineTypeGreaterThanOrEqualTo":0,"LineTypeGreaterThan":0,"LineTypeLessThan":0,"LineTypeLessThanOrEqualTo":0,"LineTypeNotEqualTo":0,"LineTypeBetween":[0],"LineTypeIn":[0],"PartNo":"String","PartNoStartsWith":"String","PartNoEndsWith":"String","PartNoContains":"String","PartNoLike":"String","PartNoBetween":["String"],"PartNoIn":["String"],"Description":"String","DescriptionStartsWith":"String","DescriptionEndsWith":"String","DescriptionContains":"String","DescriptionLike":"String","DescriptionBetween":["String"],"DescriptionIn":["String"],"DeliveryDays":0,"DeliveryDaysGreaterThanOrEqualTo":0,"DeliveryDaysGreaterThan":0,"DeliveryDaysLessThan":0,"DeliveryDaysLessThanOrEqualTo":0,"DeliveryDaysNotEqualTo":0,"DeliveryDaysBetween":[0],"DeliveryDaysIn":[0],"ClassificationID":"String","ClassificationIDStartsWith":"String","ClassificationIDEndsWith":"String","ClassificationIDContains":"String","ClassificationIDLike":"String","ClassificationIDBetween":["String"],"ClassificationIDIn":["String"],"ClassDescription":"String","ClassDescriptionStartsWith":"String","ClassDescriptionEndsWith":"String","ClassDescriptionContains":"String","ClassDescriptionLike":"String","ClassDescriptionBetween":["String"],"ClassDescriptionIn":["String"],"TaxAmount":0,"TaxAmountGreaterThanOrEqualTo":0,"TaxAmountGreaterThan":0,"TaxAmountLessThan":0,"TaxAmountLessThanOrEqualTo":0,"TaxAmountNotEqualTo":0,"TaxAmountBetween":[0],"TaxAmountIn":[0],"TaxID":"String","TaxIDStartsWith":"String","TaxIDEndsWith":"String","TaxIDContains":"String","TaxIDLike":"String","TaxIDBetween":["String"],"TaxIDIn":["String"],"TaxRate":0,"TaxRateGreaterThanOrEqualTo":0,"TaxRateGreaterThan":0,"TaxRateLessThan":0,"TaxRateLessThanOrEqualTo":0,"TaxRateNotEqualTo":0,"TaxRateBetween":[0],"TaxRateIn":[0],"HomeSuppliersCost":0,"HomeSuppliersCostGreaterThanOrEqualTo":0,"HomeSuppliersCostGreaterThan":0,"HomeSuppliersCostLessThan":0,"HomeSuppliersCostLessThanOrEqualTo":0,"HomeSuppliersCostNotEqualTo":0,"HomeSuppliersCostBetween":[0],"HomeSuppliersCostIn":[0],"CurrencyRateUsed":0,"CurrencyRateUsedGreaterThanOrEqualTo":0,"CurrencyRateUsedGreaterThan":0,"CurrencyRateUsedLessThan":0,"CurrencyRateUsedLessThanOrEqualTo":0,"CurrencyRateUsedNotEqualTo":0,"CurrencyRateUsedBetween":[0],"CurrencyRateUsedIn":[0],"POClassID":"String","POClassIDStartsWith":"String","POClassIDEndsWith":"String","POClassIDContains":"String","POClassIDLike":"String","POClassIDBetween":["String"],"POClassIDIn":["String"],"IncPrice":0,"IncPriceGreaterThanOrEqualTo":0,"IncPriceGreaterThan":0,"IncPriceLessThan":0,"IncPriceLessThanOrEqualTo":0,"IncPriceNotEqualTo":0,"IncPriceBetween":[0],"IncPriceIn":[0],"LineTotal":0,"LineTotalGreaterThanOrEqualTo":0,"LineTotalGreaterThan":0,"LineTotalLessThan":0,"LineTotalLessThanOrEqualTo":0,"LineTotalNotEqualTo":0,"LineTotalBetween":[0],"LineTotalIn":[0],"FxDecimalPlaces":0,"FxDecimalPlacesGreaterThanOrEqualTo":0,"FxDecimalPlacesGreaterThan":0,"FxDecimalPlacesLessThan":0,"FxDecimalPlacesLessThanOrEqualTo":0,"FxDecimalPlacesNotEqualTo":0,"FxDecimalPlacesBetween":[0],"FxDecimalPlacesIn":[0],"AUDDecimalPlaces":0,"AUDDecimalPlacesGreaterThanOrEqualTo":0,"AUDDecimalPlacesGreaterThan":0,"AUDDecimalPlacesLessThan":0,"AUDDecimalPlacesLessThanOrEqualTo":0,"AUDDecimalPlacesNotEqualTo":0,"AUDDecimalPlacesBetween":[0],"AUDDecimalPlacesIn":[0],"FxTotal":0,"FxTotalGreaterThanOrEqualTo":0,"FxTotalGreaterThan":0,"FxTotalLessThan":0,"FxTotalLessThanOrEqualTo":0,"FxTotalNotEqualTo":0,"FxTotalBetween":[0],"FxTotalIn":[0],"IN_SupplierWarehouse_RecID":"String","IN_SupplierWarehouse_RecIDStartsWith":"String","IN_SupplierWarehouse_RecIDEndsWith":"String","IN_SupplierWarehouse_RecIDContains":"String","IN_SupplierWarehouse_RecIDLike":"String","IN_SupplierWarehouse_RecIDBetween":["String"],"IN_SupplierWarehouse_RecIDIn":["String"],"Unit":"String","UnitStartsWith":"String","UnitEndsWith":"String","UnitContains":"String","UnitLike":"String","UnitBetween":["String"],"UnitIn":["String"],"UserDefinedDate3":"0001-01-01T00:00:00.0000000","UserDefinedDate3GreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate3GreaterThan":"0001-01-01T00:00:00.0000000","UserDefinedDate3LessThan":"0001-01-01T00:00:00.0000000","UserDefinedDate3LessThanOrEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate3NotEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate3Between":["0001-01-01T00:00:00.0000000"],"UserDefinedDate3In":["0001-01-01T00:00:00.0000000"],"UserDefinedString1":"String","UserDefinedString1StartsWith":"String","UserDefinedString1EndsWith":"String","UserDefinedString1Contains":"String","UserDefinedString1Like":"String","UserDefinedString1Between":["String"],"UserDefinedString1In":["String"],"UserDefinedString2":"String","UserDefinedString2StartsWith":"String","UserDefinedString2EndsWith":"String","UserDefinedString2Contains":"String","UserDefinedString2Like":"String","UserDefinedString2Between":["String"],"UserDefinedString2In":["String"],"UserDefinedString3":"String","UserDefinedString3StartsWith":"String","UserDefinedString3EndsWith":"String","UserDefinedString3Contains":"String","UserDefinedString3Like":"String","UserDefinedString3Between":["String"],"UserDefinedString3In":["String"],"UserDefinedFloat1":0,"UserDefinedFloat1GreaterThanOrEqualTo":0,"UserDefinedFloat1GreaterThan":0,"UserDefinedFloat1LessThan":0,"UserDefinedFloat1LessThanOrEqualTo":0,"UserDefinedFloat1NotEqualTo":0,"UserDefinedFloat1Between":[0],"UserDefinedFloat1In":[0],"UserDefinedFloat2":0,"UserDefinedFloat2GreaterThanOrEqualTo":0,"UserDefinedFloat2GreaterThan":0,"UserDefinedFloat2LessThan":0,"UserDefinedFloat2LessThanOrEqualTo":0,"UserDefinedFloat2NotEqualTo":0,"UserDefinedFloat2Between":[0],"UserDefinedFloat2In":[0],"UserDefinedFloat3":0,"UserDefinedFloat3GreaterThanOrEqualTo":0,"UserDefinedFloat3GreaterThan":0,"UserDefinedFloat3LessThan":0,"UserDefinedFloat3LessThanOrEqualTo":0,"UserDefinedFloat3NotEqualTo":0,"UserDefinedFloat3Between":[0],"UserDefinedFloat3In":[0],"UserDefinedDate1":"0001-01-01T00:00:00.0000000","UserDefinedDate1GreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate1GreaterThan":"0001-01-01T00:00:00.0000000","UserDefinedDate1LessThan":"0001-01-01T00:00:00.0000000","UserDefinedDate1LessThanOrEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate1NotEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate1Between":["0001-01-01T00:00:00.0000000"],"UserDefinedDate1In":["0001-01-01T00:00:00.0000000"],"UserDefinedDate2":"0001-01-01T00:00:00.0000000","UserDefinedDate2GreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate2GreaterThan":"0001-01-01T00:00:00.0000000","UserDefinedDate2LessThan":"0001-01-01T00:00:00.0000000","UserDefinedDate2LessThanOrEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate2NotEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate2Between":["0001-01-01T00:00:00.0000000"],"UserDefinedDate2In":["0001-01-01T00:00:00.0000000"],"SM_Task_RecID":"String","SM_Task_RecIDStartsWith":"String","SM_Task_RecIDEndsWith":"String","SM_Task_RecIDContains":"String","SM_Task_RecIDLike":"String","SM_Task_RecIDBetween":["String"],"SM_Task_RecIDIn":["String"],"JB_JobStages_RecID":"String","JB_JobStages_RecIDStartsWith":"String","JB_JobStages_RecIDEndsWith":"String","JB_JobStages_RecIDContains":"String","JB_JobStages_RecIDLike":"String","JB_JobStages_RecIDBetween":["String"],"JB_JobStages_RecIDIn":["String"],"LineTotalExTax":0,"LineTotalExTaxGreaterThanOrEqualTo":0,"LineTotalExTaxGreaterThan":0,"LineTotalExTaxLessThan":0,"LineTotalExTaxLessThanOrEqualTo":0,"LineTotalExTaxNotEqualTo":0,"LineTotalExTaxBetween":[0],"LineTotalExTaxIn":[0],"IN_UnitOfMeasure_RecID":"00000000000000000000000000000000","IN_UnitOfMeasure_RecIDIn":["00000000000000000000000000000000"],"UnitChanged":false,"FXChanged":false,"ExChanged":false,"TaxRateChanged":false,"Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}
HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"Results":[{"OrderLineID":"String","OrderID":"String","InventoryID":"String","Quantity":0,"SuppliersCost":0,"DeliveryDate":"0001-01-01T00:00:00.0000000","Delivered":0,"DecimalPlaces":0,"OrderLineNo":0,"SuppPartNo":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","HistoryText_Comment":"String","OrderUnits":0,"LineType":0,"PartNo":"String","Description":"String","DeliveryDays":0,"ClassificationID":"String","ClassDescription":"String","TaxAmount":0,"TaxID":"String","TaxRate":0,"HomeSuppliersCost":0,"CurrencyRateUsed":0,"POClassID":"String","IncPrice":0,"LineTotal":0,"FxDecimalPlaces":0,"AUDDecimalPlaces":0,"FxTotal":0,"IN_SupplierWarehouse_RecID":"String","Unit":"String","UserDefinedDate3":"0001-01-01T00:00:00.0000000","UserDefinedString1":"String","UserDefinedString2":"String","UserDefinedString3":"String","UserDefinedFloat1":0,"UserDefinedFloat2":0,"UserDefinedFloat3":0,"UserDefinedDate1":"0001-01-01T00:00:00.0000000","UserDefinedDate2":"0001-01-01T00:00:00.0000000","SM_Task_RecID":"String","JB_JobStages_RecID":"String","IN_UnitOfMeasure_RecID":"00000000000000000000000000000000","UnitChanged":false,"FXChanged":false,"ExChanged":false,"TaxRateChanged":false}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}