JiwaAPI

<back to all web services

RE_LinesQuery

Requires Authentication
RE_LinesQuery Parameters:
NameParameterData TypeRequiredDescription
SourceIDquerystringNo
SourceIDStartsWithquerystringNo
SourceIDEndsWithquerystringNo
SourceIDContainsquerystringNo
SourceIDLikequerystringNo
SourceIDBetweenquerystring[]No
SourceIDInquerystring[]No
PackSlipIDquerystringNo
PackSlipIDStartsWithquerystringNo
PackSlipIDEndsWithquerystringNo
PackSlipIDContainsquerystringNo
PackSlipIDLikequerystringNo
PackSlipIDBetweenquerystring[]No
PackSlipIDInquerystring[]No
OrderIDquerystringNo
OrderIDStartsWithquerystringNo
OrderIDEndsWithquerystringNo
OrderIDContainsquerystringNo
OrderIDLikequerystringNo
OrderIDBetweenquerystring[]No
OrderIDInquerystring[]No
OrderLineIDquerystringNo
OrderLineIDStartsWithquerystringNo
OrderLineIDEndsWithquerystringNo
OrderLineIDContainsquerystringNo
OrderLineIDLikequerystringNo
OrderLineIDBetweenquerystring[]No
OrderLineIDInquerystring[]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
InventoryIDquerystringNo
InventoryIDStartsWithquerystringNo
InventoryIDEndsWithquerystringNo
InventoryIDContainsquerystringNo
InventoryIDLikequerystringNo
InventoryIDBetweenquerystring[]No
InventoryIDInquerystring[]No
PartNoquerystringNo
PartNoStartsWithquerystringNo
PartNoEndsWithquerystringNo
PartNoContainsquerystringNo
PartNoLikequerystringNo
PartNoBetweenquerystring[]No
PartNoInquerystring[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
SuppPartNoquerystringNo
SuppPartNoStartsWithquerystringNo
SuppPartNoEndsWithquerystringNo
SuppPartNoContainsquerystringNo
SuppPartNoLikequerystringNo
SuppPartNoBetweenquerystring[]No
SuppPartNoInquerystring[]No
LineTypequeryshort?No
LineTypeGreaterThanOrEqualToqueryshort?No
LineTypeGreaterThanqueryshort?No
LineTypeLessThanqueryshort?No
LineTypeLessThanOrEqualToqueryshort?No
LineTypeNotEqualToqueryshort?No
LineTypeBetweenqueryNullable<Int16>[]No
LineTypeInqueryNullable<Int16>[]No
DecimalPlacesqueryshort?No
DecimalPlacesGreaterThanOrEqualToqueryshort?No
DecimalPlacesGreaterThanqueryshort?No
DecimalPlacesLessThanqueryshort?No
DecimalPlacesLessThanOrEqualToqueryshort?No
DecimalPlacesNotEqualToqueryshort?No
DecimalPlacesBetweenqueryNullable<Int16>[]No
DecimalPlacesInqueryNullable<Int16>[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryNullable<DateTime>[]No
LastSavedDateTimeInqueryNullable<DateTime>[]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
PostedToWIPquerybool?No
JobChargequerydecimal?No
JobChargeGreaterThanOrEqualToquerydecimal?No
JobChargeGreaterThanquerydecimal?No
JobChargeLessThanquerydecimal?No
JobChargeLessThanOrEqualToquerydecimal?No
JobChargeNotEqualToquerydecimal?No
JobChargeBetweenquerydecimal[]No
JobChargeInquerydecimal[]No
LineNumberqueryint?No
LineNumberGreaterThanOrEqualToqueryint?No
LineNumberGreaterThanqueryint?No
LineNumberLessThanqueryint?No
LineNumberLessThanOrEqualToqueryint?No
LineNumberNotEqualToqueryint?No
LineNumberBetweenqueryNullable<Int32>[]No
LineNumberInqueryNullable<Int32>[]No
JB_JobStages_RecIDquerystringNo
JB_JobStages_RecIDStartsWithquerystringNo
JB_JobStages_RecIDEndsWithquerystringNo
JB_JobStages_RecIDContainsquerystringNo
JB_JobStages_RecIDLikequerystringNo
JB_JobStages_RecIDBetweenquerystring[]No
JB_JobStages_RecIDInquerystring[]No
FXDecimalPlacesqueryshort?No
FXDecimalPlacesGreaterThanOrEqualToqueryshort?No
FXDecimalPlacesGreaterThanqueryshort?No
FXDecimalPlacesLessThanqueryshort?No
FXDecimalPlacesLessThanOrEqualToqueryshort?No
FXDecimalPlacesNotEqualToqueryshort?No
FXDecimalPlacesBetweenqueryNullable<Int16>[]No
FXDecimalPlacesInqueryNullable<Int16>[]No
HomeDecimalPlacesqueryshort?No
HomeDecimalPlacesGreaterThanOrEqualToqueryshort?No
HomeDecimalPlacesGreaterThanqueryshort?No
HomeDecimalPlacesLessThanqueryshort?No
HomeDecimalPlacesLessThanOrEqualToqueryshort?No
HomeDecimalPlacesNotEqualToqueryshort?No
HomeDecimalPlacesBetweenqueryNullable<Int16>[]No
HomeDecimalPlacesInqueryNullable<Int16>[]No
LineTotalExTaxquerydecimal?No
LineTotalExTaxGreaterThanOrEqualToquerydecimal?No
LineTotalExTaxGreaterThanquerydecimal?No
LineTotalExTaxLessThanquerydecimal?No
LineTotalExTaxLessThanOrEqualToquerydecimal?No
LineTotalExTaxNotEqualToquerydecimal?No
LineTotalExTaxBetweenquerydecimal[]No
LineTotalExTaxInquerydecimal[]No
UnitIncTaxquerydecimal?No
UnitIncTaxGreaterThanOrEqualToquerydecimal?No
UnitIncTaxGreaterThanquerydecimal?No
UnitIncTaxLessThanquerydecimal?No
UnitIncTaxLessThanOrEqualToquerydecimal?No
UnitIncTaxNotEqualToquerydecimal?No
UnitIncTaxBetweenquerydecimal[]No
UnitIncTaxInquerydecimal[]No
LineTotalIncTaxquerydecimal?No
LineTotalIncTaxGreaterThanOrEqualToquerydecimal?No
LineTotalIncTaxGreaterThanquerydecimal?No
LineTotalIncTaxLessThanquerydecimal?No
LineTotalIncTaxLessThanOrEqualToquerydecimal?No
LineTotalIncTaxNotEqualToquerydecimal?No
LineTotalIncTaxBetweenquerydecimal[]No
LineTotalIncTaxInquerydecimal[]No
FXLineTotalExTaxquerydecimal?No
FXLineTotalExTaxGreaterThanOrEqualToquerydecimal?No
FXLineTotalExTaxGreaterThanquerydecimal?No
FXLineTotalExTaxLessThanquerydecimal?No
FXLineTotalExTaxLessThanOrEqualToquerydecimal?No
FXLineTotalExTaxNotEqualToquerydecimal?No
FXLineTotalExTaxBetweenquerydecimal[]No
FXLineTotalExTaxInquerydecimal[]No
UnitChangedquerybool?No
FXChangedquerybool?No
ExChangedquerybool?No
TaxRateChangedquerybool?No
ChangeSourceIsFromPurchaseOrderLinequerybool?No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
RE_Lines Parameters:
NameParameterData TypeRequiredDescription
SourceIDformstringNo
PackSlipIDformstringNo
OrderIDformstringNo
OrderLineIDformstringNo
Quantityformdecimal?No
SuppliersCostformdecimal?No
InventoryIDformstringNo
PartNoformstringNo
DescriptionformstringNo
SuppPartNoformstringNo
LineTypeformshort?No
DecimalPlacesformshort?No
LastSavedDateTimeformDateTime?No
ClassificationIDformstringNo
ClassDescriptionformstringNo
TaxAmountformdecimal?No
TaxIDformstringNo
TaxRateformdecimal?No
HomeSuppliersCostformdecimal?No
CurrencyRateUsedformdecimal?No
POClassIDformstringNo
PostedToWIPformboolNo
JobChargeformdecimalNo
LineNumberformint?No
JB_JobStages_RecIDformstringNo
FXDecimalPlacesformshort?No
HomeDecimalPlacesformshort?No
LineTotalExTaxformdecimalNo
UnitIncTaxformdecimalNo
LineTotalIncTaxformdecimalNo
FXLineTotalExTaxformdecimalNo
UnitChangedformbool?No
FXChangedformbool?No
ExChangedformbool?No
TaxRateChangedformbool?No
ChangeSourceIsFromPurchaseOrderLineformbool?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.

POST /json/reply/RE_LinesQuery HTTP/1.1 
Host: localhost 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"SourceID":"String","SourceIDStartsWith":"String","SourceIDEndsWith":"String","SourceIDContains":"String","SourceIDLike":"String","SourceIDBetween":["String"],"SourceIDIn":["String"],"PackSlipID":"String","PackSlipIDStartsWith":"String","PackSlipIDEndsWith":"String","PackSlipIDContains":"String","PackSlipIDLike":"String","PackSlipIDBetween":["String"],"PackSlipIDIn":["String"],"OrderID":"String","OrderIDStartsWith":"String","OrderIDEndsWith":"String","OrderIDContains":"String","OrderIDLike":"String","OrderIDBetween":["String"],"OrderIDIn":["String"],"OrderLineID":"String","OrderLineIDStartsWith":"String","OrderLineIDEndsWith":"String","OrderLineIDContains":"String","OrderLineIDLike":"String","OrderLineIDBetween":["String"],"OrderLineIDIn":["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],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"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"],"SuppPartNo":"String","SuppPartNoStartsWith":"String","SuppPartNoEndsWith":"String","SuppPartNoContains":"String","SuppPartNoLike":"String","SuppPartNoBetween":["String"],"SuppPartNoIn":["String"],"LineType":0,"LineTypeGreaterThanOrEqualTo":0,"LineTypeGreaterThan":0,"LineTypeLessThan":0,"LineTypeLessThanOrEqualTo":0,"LineTypeNotEqualTo":0,"LineTypeBetween":[0],"LineTypeIn":[0],"DecimalPlaces":0,"DecimalPlacesGreaterThanOrEqualTo":0,"DecimalPlacesGreaterThan":0,"DecimalPlacesLessThan":0,"DecimalPlacesLessThanOrEqualTo":0,"DecimalPlacesNotEqualTo":0,"DecimalPlacesBetween":[0],"DecimalPlacesIn":[0],"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"],"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"],"PostedToWIP":false,"JobCharge":0,"JobChargeGreaterThanOrEqualTo":0,"JobChargeGreaterThan":0,"JobChargeLessThan":0,"JobChargeLessThanOrEqualTo":0,"JobChargeNotEqualTo":0,"JobChargeBetween":[0],"JobChargeIn":[0],"LineNumber":0,"LineNumberGreaterThanOrEqualTo":0,"LineNumberGreaterThan":0,"LineNumberLessThan":0,"LineNumberLessThanOrEqualTo":0,"LineNumberNotEqualTo":0,"LineNumberBetween":[0],"LineNumberIn":[0],"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"],"FXDecimalPlaces":0,"FXDecimalPlacesGreaterThanOrEqualTo":0,"FXDecimalPlacesGreaterThan":0,"FXDecimalPlacesLessThan":0,"FXDecimalPlacesLessThanOrEqualTo":0,"FXDecimalPlacesNotEqualTo":0,"FXDecimalPlacesBetween":[0],"FXDecimalPlacesIn":[0],"HomeDecimalPlaces":0,"HomeDecimalPlacesGreaterThanOrEqualTo":0,"HomeDecimalPlacesGreaterThan":0,"HomeDecimalPlacesLessThan":0,"HomeDecimalPlacesLessThanOrEqualTo":0,"HomeDecimalPlacesNotEqualTo":0,"HomeDecimalPlacesBetween":[0],"HomeDecimalPlacesIn":[0],"LineTotalExTax":0,"LineTotalExTaxGreaterThanOrEqualTo":0,"LineTotalExTaxGreaterThan":0,"LineTotalExTaxLessThan":0,"LineTotalExTaxLessThanOrEqualTo":0,"LineTotalExTaxNotEqualTo":0,"LineTotalExTaxBetween":[0],"LineTotalExTaxIn":[0],"UnitIncTax":0,"UnitIncTaxGreaterThanOrEqualTo":0,"UnitIncTaxGreaterThan":0,"UnitIncTaxLessThan":0,"UnitIncTaxLessThanOrEqualTo":0,"UnitIncTaxNotEqualTo":0,"UnitIncTaxBetween":[0],"UnitIncTaxIn":[0],"LineTotalIncTax":0,"LineTotalIncTaxGreaterThanOrEqualTo":0,"LineTotalIncTaxGreaterThan":0,"LineTotalIncTaxLessThan":0,"LineTotalIncTaxLessThanOrEqualTo":0,"LineTotalIncTaxNotEqualTo":0,"LineTotalIncTaxBetween":[0],"LineTotalIncTaxIn":[0],"FXLineTotalExTax":0,"FXLineTotalExTaxGreaterThanOrEqualTo":0,"FXLineTotalExTaxGreaterThan":0,"FXLineTotalExTaxLessThan":0,"FXLineTotalExTaxLessThanOrEqualTo":0,"FXLineTotalExTaxNotEqualTo":0,"FXLineTotalExTaxBetween":[0],"FXLineTotalExTaxIn":[0],"UnitChanged":false,"FXChanged":false,"ExChanged":false,"TaxRateChanged":false,"ChangeSourceIsFromPurchaseOrderLine":false,"Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}

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

{"Results":[{"SourceID":"String","PackSlipID":"String","OrderID":"String","OrderLineID":"String","Quantity":0,"SuppliersCost":0,"InventoryID":"String","PartNo":"String","Description":"String","SuppPartNo":"String","LineType":0,"DecimalPlaces":0,"LastSavedDateTime":"0001-01-01T00:00:00.0000000","ClassificationID":"String","ClassDescription":"String","TaxAmount":0,"TaxID":"String","TaxRate":0,"HomeSuppliersCost":0,"CurrencyRateUsed":0,"POClassID":"String","LineNumber":0,"JB_JobStages_RecID":"String","FXDecimalPlaces":0,"HomeDecimalPlaces":0,"UnitChanged":false,"FXChanged":false,"ExChanged":false,"TaxRateChanged":false,"ChangeSourceIsFromPurchaseOrderLine":false}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}