JiwaAPI

<back to all web services

PI_LinesQuery

Requires Authentication
PI_LinesQuery Parameters:
NameParameterData TypeRequiredDescription
PI_LinesIDquerystringNo
PI_LinesIDStartsWithquerystringNo
PI_LinesIDEndsWithquerystringNo
PI_LinesIDContainsquerystringNo
PI_LinesIDLikequerystringNo
PI_LinesIDBetweenquerystring[]No
PI_LinesIDInquerystring[]No
PI_MainIDquerystringNo
PI_MainIDStartsWithquerystringNo
PI_MainIDEndsWithquerystringNo
PI_MainIDContainsquerystringNo
PI_MainIDLikequerystringNo
PI_MainIDBetweenquerystring[]No
PI_MainIDInquerystring[]No
RE_MainIDquerystringNo
RE_MainIDStartsWithquerystringNo
RE_MainIDEndsWithquerystringNo
RE_MainIDContainsquerystringNo
RE_MainIDLikequerystringNo
RE_MainIDBetweenquerystring[]No
RE_MainIDInquerystring[]No
RE_LinesIDquerystringNo
RE_LinesIDStartsWithquerystringNo
RE_LinesIDEndsWithquerystringNo
RE_LinesIDContainsquerystringNo
RE_LinesIDLikequerystringNo
RE_LinesIDBetweenquerystring[]No
RE_LinesIDInquerystring[]No
Quantityquerydecimal?No
QuantityGreaterThanOrEqualToquerydecimal?No
QuantityGreaterThanquerydecimal?No
QuantityLessThanquerydecimal?No
QuantityLessThanOrEqualToquerydecimal?No
QuantityNotEqualToquerydecimal?No
QuantityBetweenquerydecimal[]No
QuantityInquerydecimal[]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
InvoiceLineNoqueryshort?No
InvoiceLineNoGreaterThanOrEqualToqueryshort?No
InvoiceLineNoGreaterThanqueryshort?No
InvoiceLineNoLessThanqueryshort?No
InvoiceLineNoLessThanOrEqualToqueryshort?No
InvoiceLineNoNotEqualToqueryshort?No
InvoiceLineNoBetweenqueryNullable<Int16>[]No
InvoiceLineNoInqueryNullable<Int16>[]No
HomeSuppliersCostquerydecimal?No
HomeSuppliersCostGreaterThanOrEqualToquerydecimal?No
HomeSuppliersCostGreaterThanquerydecimal?No
HomeSuppliersCostLessThanquerydecimal?No
HomeSuppliersCostLessThanOrEqualToquerydecimal?No
HomeSuppliersCostNotEqualToquerydecimal?No
HomeSuppliersCostBetweenqueryNullable<Decimal>[]No
HomeSuppliersCostInqueryNullable<Decimal>[]No
TaxRatequerydecimal?No
TaxRateGreaterThanOrEqualToquerydecimal?No
TaxRateGreaterThanquerydecimal?No
TaxRateLessThanquerydecimal?No
TaxRateLessThanOrEqualToquerydecimal?No
TaxRateNotEqualToquerydecimal?No
TaxRateBetweenqueryNullable<Decimal>[]No
TaxRateInqueryNullable<Decimal>[]No
TaxIDquerystringNo
TaxIDStartsWithquerystringNo
TaxIDEndsWithquerystringNo
TaxIDContainsquerystringNo
TaxIDLikequerystringNo
TaxIDBetweenquerystring[]No
TaxIDInquerystring[]No
TaxAmountquerydecimal?No
TaxAmountGreaterThanOrEqualToquerydecimal?No
TaxAmountGreaterThanquerydecimal?No
TaxAmountLessThanquerydecimal?No
TaxAmountLessThanOrEqualToquerydecimal?No
TaxAmountNotEqualToquerydecimal?No
TaxAmountBetweenqueryNullable<Decimal>[]No
TaxAmountInqueryNullable<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
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
HomeDecimalPlacesqueryshort?No
HomeDecimalPlacesGreaterThanOrEqualToqueryshort?No
HomeDecimalPlacesGreaterThanqueryshort?No
HomeDecimalPlacesLessThanqueryshort?No
HomeDecimalPlacesLessThanOrEqualToqueryshort?No
HomeDecimalPlacesNotEqualToqueryshort?No
HomeDecimalPlacesBetweenqueryNullable<Int16>[]No
HomeDecimalPlacesInqueryNullable<Int16>[]No
UnitChangedquerybool?No
FXChangedquerybool?No
ExChangedquerybool?No
TaxRateChangedquerybool?No
LineTotalExTaxquerydecimal?No
LineTotalExTaxGreaterThanOrEqualToquerydecimal?No
LineTotalExTaxGreaterThanquerydecimal?No
LineTotalExTaxLessThanquerydecimal?No
LineTotalExTaxLessThanOrEqualToquerydecimal?No
LineTotalExTaxNotEqualToquerydecimal?No
LineTotalExTaxBetweenquerydecimal[]No
LineTotalExTaxInquerydecimal[]No
ChangeSourceIsFromGRNLinequerybool?No
FXLineTotalExTaxquerydecimal?No
FXLineTotalExTaxGreaterThanOrEqualToquerydecimal?No
FXLineTotalExTaxGreaterThanquerydecimal?No
FXLineTotalExTaxLessThanquerydecimal?No
FXLineTotalExTaxLessThanOrEqualToquerydecimal?No
FXLineTotalExTaxNotEqualToquerydecimal?No
FXLineTotalExTaxBetweenquerydecimal[]No
FXLineTotalExTaxInquerydecimal[]No
UnitCostIncTaxquerydecimal?No
UnitCostIncTaxGreaterThanOrEqualToquerydecimal?No
UnitCostIncTaxGreaterThanquerydecimal?No
UnitCostIncTaxLessThanquerydecimal?No
UnitCostIncTaxLessThanOrEqualToquerydecimal?No
UnitCostIncTaxNotEqualToquerydecimal?No
UnitCostIncTaxBetweenquerydecimal[]No
UnitCostIncTaxInquerydecimal[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
PI_Lines Parameters:
NameParameterData TypeRequiredDescription
PI_LinesIDformstringNo
PI_MainIDformstringNo
RE_MainIDformstringNo
RE_LinesIDformstringNo
QuantityformdecimalNo
SuppliersCostformdecimal?No
InventoryIDformstringNo
PartNoformstringNo
DescriptionformstringNo
SuppPartNoformstringNo
LineTypeformshort?No
DecimalPlacesformshort?No
LastSavedDateTimeformDateTime?No
InvoiceLineNoformshort?No
HomeSuppliersCostformdecimal?No
TaxRateformdecimal?No
TaxIDformstringNo
TaxAmountformdecimal?No
CurrencyRateUsedformdecimal?No
POClassIDformstringNo
LineTotalformdecimal?No
FXDecimalPlacesformshort?No
HomeDecimalPlacesformshort?No
UnitChangedformbool?No
FXChangedformbool?No
ExChangedformbool?No
TaxRateChangedformbool?No
LineTotalExTaxformdecimalNo
ChangeSourceIsFromGRNLineformbool?No
FXLineTotalExTaxformdecimalNo
UnitCostIncTaxformdecimalNo
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/PI_LinesQuery HTTP/1.1 
Host: localhost 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"PI_LinesID":"String","PI_LinesIDStartsWith":"String","PI_LinesIDEndsWith":"String","PI_LinesIDContains":"String","PI_LinesIDLike":"String","PI_LinesIDBetween":["String"],"PI_LinesIDIn":["String"],"PI_MainID":"String","PI_MainIDStartsWith":"String","PI_MainIDEndsWith":"String","PI_MainIDContains":"String","PI_MainIDLike":"String","PI_MainIDBetween":["String"],"PI_MainIDIn":["String"],"RE_MainID":"String","RE_MainIDStartsWith":"String","RE_MainIDEndsWith":"String","RE_MainIDContains":"String","RE_MainIDLike":"String","RE_MainIDBetween":["String"],"RE_MainIDIn":["String"],"RE_LinesID":"String","RE_LinesIDStartsWith":"String","RE_LinesIDEndsWith":"String","RE_LinesIDContains":"String","RE_LinesIDLike":"String","RE_LinesIDBetween":["String"],"RE_LinesIDIn":["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"],"InvoiceLineNo":0,"InvoiceLineNoGreaterThanOrEqualTo":0,"InvoiceLineNoGreaterThan":0,"InvoiceLineNoLessThan":0,"InvoiceLineNoLessThanOrEqualTo":0,"InvoiceLineNoNotEqualTo":0,"InvoiceLineNoBetween":[0],"InvoiceLineNoIn":[0],"HomeSuppliersCost":0,"HomeSuppliersCostGreaterThanOrEqualTo":0,"HomeSuppliersCostGreaterThan":0,"HomeSuppliersCostLessThan":0,"HomeSuppliersCostLessThanOrEqualTo":0,"HomeSuppliersCostNotEqualTo":0,"HomeSuppliersCostBetween":[0],"HomeSuppliersCostIn":[0],"TaxRate":0,"TaxRateGreaterThanOrEqualTo":0,"TaxRateGreaterThan":0,"TaxRateLessThan":0,"TaxRateLessThanOrEqualTo":0,"TaxRateNotEqualTo":0,"TaxRateBetween":[0],"TaxRateIn":[0],"TaxID":"String","TaxIDStartsWith":"String","TaxIDEndsWith":"String","TaxIDContains":"String","TaxIDLike":"String","TaxIDBetween":["String"],"TaxIDIn":["String"],"TaxAmount":0,"TaxAmountGreaterThanOrEqualTo":0,"TaxAmountGreaterThan":0,"TaxAmountLessThan":0,"TaxAmountLessThanOrEqualTo":0,"TaxAmountNotEqualTo":0,"TaxAmountBetween":[0],"TaxAmountIn":[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"],"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],"HomeDecimalPlaces":0,"HomeDecimalPlacesGreaterThanOrEqualTo":0,"HomeDecimalPlacesGreaterThan":0,"HomeDecimalPlacesLessThan":0,"HomeDecimalPlacesLessThanOrEqualTo":0,"HomeDecimalPlacesNotEqualTo":0,"HomeDecimalPlacesBetween":[0],"HomeDecimalPlacesIn":[0],"UnitChanged":false,"FXChanged":false,"ExChanged":false,"TaxRateChanged":false,"LineTotalExTax":0,"LineTotalExTaxGreaterThanOrEqualTo":0,"LineTotalExTaxGreaterThan":0,"LineTotalExTaxLessThan":0,"LineTotalExTaxLessThanOrEqualTo":0,"LineTotalExTaxNotEqualTo":0,"LineTotalExTaxBetween":[0],"LineTotalExTaxIn":[0],"ChangeSourceIsFromGRNLine":false,"FXLineTotalExTax":0,"FXLineTotalExTaxGreaterThanOrEqualTo":0,"FXLineTotalExTaxGreaterThan":0,"FXLineTotalExTaxLessThan":0,"FXLineTotalExTaxLessThanOrEqualTo":0,"FXLineTotalExTaxNotEqualTo":0,"FXLineTotalExTaxBetween":[0],"FXLineTotalExTaxIn":[0],"UnitCostIncTax":0,"UnitCostIncTaxGreaterThanOrEqualTo":0,"UnitCostIncTaxGreaterThan":0,"UnitCostIncTaxLessThan":0,"UnitCostIncTaxLessThanOrEqualTo":0,"UnitCostIncTaxNotEqualTo":0,"UnitCostIncTaxBetween":[0],"UnitCostIncTaxIn":[0],"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":[{"PI_LinesID":"String","PI_MainID":"String","RE_MainID":"String","RE_LinesID":"String","SuppliersCost":0,"InventoryID":"String","PartNo":"String","Description":"String","SuppPartNo":"String","LineType":0,"DecimalPlaces":0,"LastSavedDateTime":"0001-01-01T00:00:00.0000000","InvoiceLineNo":0,"HomeSuppliersCost":0,"TaxRate":0,"TaxID":"String","TaxAmount":0,"CurrencyRateUsed":0,"POClassID":"String","LineTotal":0,"FXDecimalPlaces":0,"HomeDecimalPlaces":0,"UnitChanged":false,"FXChanged":false,"ExChanged":false,"TaxRateChanged":false,"ChangeSourceIsFromGRNLine":false}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}