JiwaAPI

RE_LinesQuery

The following routes are available for this service:
GET	/Queries/RE_Lines	Retrieves RE_Lines GRN line records

**RE_LinesQuery** Parameters:
Name	Parameter	Data Type	Required
SourceID	query	string	No
SourceIDStartsWith	query	string	No
SourceIDEndsWith	query	string	No
SourceIDContains	query	string	No
SourceIDLike	query	string	No
SourceIDBetween	query	string[]	No
SourceIDIn	query	string[]	No
PackSlipID	query	string	No
PackSlipIDStartsWith	query	string	No
PackSlipIDEndsWith	query	string	No
PackSlipIDContains	query	string	No
PackSlipIDLike	query	string	No
PackSlipIDBetween	query	string[]	No
PackSlipIDIn	query	string[]	No
OrderID	query	string	No
OrderIDStartsWith	query	string	No
OrderIDEndsWith	query	string	No
OrderIDContains	query	string	No
OrderIDLike	query	string	No
OrderIDBetween	query	string[]	No
OrderIDIn	query	string[]	No
OrderLineID	query	string	No
OrderLineIDStartsWith	query	string	No
OrderLineIDEndsWith	query	string	No
OrderLineIDContains	query	string	No
OrderLineIDLike	query	string	No
OrderLineIDBetween	query	string[]	No
OrderLineIDIn	query	string[]	No
Quantity	query	decimal?	No
QuantityGreaterThanOrEqualTo	query	decimal?	No
QuantityGreaterThan	query	decimal?	No
QuantityLessThan	query	decimal?	No
QuantityLessThanOrEqualTo	query	decimal?	No
QuantityNotEqualTo	query	decimal?	No
QuantityBetween	query	Nullable<Decimal>[]	No
QuantityIn	query	Nullable<Decimal>[]	No
SuppliersCost	query	decimal?	No
SuppliersCostGreaterThanOrEqualTo	query	decimal?	No
SuppliersCostGreaterThan	query	decimal?	No
SuppliersCostLessThan	query	decimal?	No
SuppliersCostLessThanOrEqualTo	query	decimal?	No
SuppliersCostNotEqualTo	query	decimal?	No
SuppliersCostBetween	query	Nullable<Decimal>[]	No
SuppliersCostIn	query	Nullable<Decimal>[]	No
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
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
SuppPartNo	query	string	No
SuppPartNoStartsWith	query	string	No
SuppPartNoEndsWith	query	string	No
SuppPartNoContains	query	string	No
SuppPartNoLike	query	string	No
SuppPartNoBetween	query	string[]	No
SuppPartNoIn	query	string[]	No
LineType	query	short?	No
LineTypeGreaterThanOrEqualTo	query	short?	No
LineTypeGreaterThan	query	short?	No
LineTypeLessThan	query	short?	No
LineTypeLessThanOrEqualTo	query	short?	No
LineTypeNotEqualTo	query	short?	No
LineTypeBetween	query	Nullable<Int16>[]	No
LineTypeIn	query	Nullable<Int16>[]	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
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
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
ClassDescription	query	string	No
ClassDescriptionStartsWith	query	string	No
ClassDescriptionEndsWith	query	string	No
ClassDescriptionContains	query	string	No
ClassDescriptionLike	query	string	No
ClassDescriptionBetween	query	string[]	No
ClassDescriptionIn	query	string[]	No
TaxAmount	query	decimal?	No
TaxAmountGreaterThanOrEqualTo	query	decimal?	No
TaxAmountGreaterThan	query	decimal?	No
TaxAmountLessThan	query	decimal?	No
TaxAmountLessThanOrEqualTo	query	decimal?	No
TaxAmountNotEqualTo	query	decimal?	No
TaxAmountBetween	query	Nullable<Decimal>[]	No
TaxAmountIn	query	Nullable<Decimal>[]	No
TaxID	query	string	No
TaxIDStartsWith	query	string	No
TaxIDEndsWith	query	string	No
TaxIDContains	query	string	No
TaxIDLike	query	string	No
TaxIDBetween	query	string[]	No
TaxIDIn	query	string[]	No
TaxRate	query	decimal?	No
TaxRateGreaterThanOrEqualTo	query	decimal?	No
TaxRateGreaterThan	query	decimal?	No
TaxRateLessThan	query	decimal?	No
TaxRateLessThanOrEqualTo	query	decimal?	No
TaxRateNotEqualTo	query	decimal?	No
TaxRateBetween	query	Nullable<Decimal>[]	No
TaxRateIn	query	Nullable<Decimal>[]	No
HomeSuppliersCost	query	decimal?	No
HomeSuppliersCostGreaterThanOrEqualTo	query	decimal?	No
HomeSuppliersCostGreaterThan	query	decimal?	No
HomeSuppliersCostLessThan	query	decimal?	No
HomeSuppliersCostLessThanOrEqualTo	query	decimal?	No
HomeSuppliersCostNotEqualTo	query	decimal?	No
HomeSuppliersCostBetween	query	Nullable<Decimal>[]	No
HomeSuppliersCostIn	query	Nullable<Decimal>[]	No
CurrencyRateUsed	query	decimal?	No
CurrencyRateUsedGreaterThanOrEqualTo	query	decimal?	No
CurrencyRateUsedGreaterThan	query	decimal?	No
CurrencyRateUsedLessThan	query	decimal?	No
CurrencyRateUsedLessThanOrEqualTo	query	decimal?	No
CurrencyRateUsedNotEqualTo	query	decimal?	No
CurrencyRateUsedBetween	query	Nullable<Decimal>[]	No
CurrencyRateUsedIn	query	Nullable<Decimal>[]	No
POClassID	query	string	No
POClassIDStartsWith	query	string	No
POClassIDEndsWith	query	string	No
POClassIDContains	query	string	No
POClassIDLike	query	string	No
POClassIDBetween	query	string[]	No
POClassIDIn	query	string[]	No
PostedToWIP	query	bool?	No
JobCharge	query	decimal?	No
JobChargeGreaterThanOrEqualTo	query	decimal?	No
JobChargeGreaterThan	query	decimal?	No
JobChargeLessThan	query	decimal?	No
JobChargeLessThanOrEqualTo	query	decimal?	No
JobChargeNotEqualTo	query	decimal?	No
JobChargeBetween	query	decimal[]	No
JobChargeIn	query	decimal[]	No
LineNumber	query	int?	No
LineNumberGreaterThanOrEqualTo	query	int?	No
LineNumberGreaterThan	query	int?	No
LineNumberLessThan	query	int?	No
LineNumberLessThanOrEqualTo	query	int?	No
LineNumberNotEqualTo	query	int?	No
LineNumberBetween	query	Nullable<Int32>[]	No
LineNumberIn	query	Nullable<Int32>[]	No
JB_JobStages_RecID	query	string	No
JB_JobStages_RecIDStartsWith	query	string	No
JB_JobStages_RecIDEndsWith	query	string	No
JB_JobStages_RecIDContains	query	string	No
JB_JobStages_RecIDLike	query	string	No
JB_JobStages_RecIDBetween	query	string[]	No
JB_JobStages_RecIDIn	query	string[]	No
FXDecimalPlaces	query	short?	No
FXDecimalPlacesGreaterThanOrEqualTo	query	short?	No
FXDecimalPlacesGreaterThan	query	short?	No
FXDecimalPlacesLessThan	query	short?	No
FXDecimalPlacesLessThanOrEqualTo	query	short?	No
FXDecimalPlacesNotEqualTo	query	short?	No
FXDecimalPlacesBetween	query	Nullable<Int16>[]	No
FXDecimalPlacesIn	query	Nullable<Int16>[]	No
HomeDecimalPlaces	query	short?	No
HomeDecimalPlacesGreaterThanOrEqualTo	query	short?	No
HomeDecimalPlacesGreaterThan	query	short?	No
HomeDecimalPlacesLessThan	query	short?	No
HomeDecimalPlacesLessThanOrEqualTo	query	short?	No
HomeDecimalPlacesNotEqualTo	query	short?	No
HomeDecimalPlacesBetween	query	Nullable<Int16>[]	No
HomeDecimalPlacesIn	query	Nullable<Int16>[]	No
LineTotalExTax	query	decimal?	No
LineTotalExTaxGreaterThanOrEqualTo	query	decimal?	No
LineTotalExTaxGreaterThan	query	decimal?	No
LineTotalExTaxLessThan	query	decimal?	No
LineTotalExTaxLessThanOrEqualTo	query	decimal?	No
LineTotalExTaxNotEqualTo	query	decimal?	No
LineTotalExTaxBetween	query	decimal[]	No
LineTotalExTaxIn	query	decimal[]	No
UnitIncTax	query	decimal?	No
UnitIncTaxGreaterThanOrEqualTo	query	decimal?	No
UnitIncTaxGreaterThan	query	decimal?	No
UnitIncTaxLessThan	query	decimal?	No
UnitIncTaxLessThanOrEqualTo	query	decimal?	No
UnitIncTaxNotEqualTo	query	decimal?	No
UnitIncTaxBetween	query	decimal[]	No
UnitIncTaxIn	query	decimal[]	No
LineTotalIncTax	query	decimal?	No
LineTotalIncTaxGreaterThanOrEqualTo	query	decimal?	No
LineTotalIncTaxGreaterThan	query	decimal?	No
LineTotalIncTaxLessThan	query	decimal?	No
LineTotalIncTaxLessThanOrEqualTo	query	decimal?	No
LineTotalIncTaxNotEqualTo	query	decimal?	No
LineTotalIncTaxBetween	query	decimal[]	No
LineTotalIncTaxIn	query	decimal[]	No
FXLineTotalExTax	query	decimal?	No
FXLineTotalExTaxGreaterThanOrEqualTo	query	decimal?	No
FXLineTotalExTaxGreaterThan	query	decimal?	No
FXLineTotalExTaxLessThan	query	decimal?	No
FXLineTotalExTaxLessThanOrEqualTo	query	decimal?	No
FXLineTotalExTaxNotEqualTo	query	decimal?	No
FXLineTotalExTaxBetween	query	decimal[]	No
FXLineTotalExTaxIn	query	decimal[]	No
UnitChanged	query	bool?	No
FXChanged	query	bool?	No
ExChanged	query	bool?	No
TaxRateChanged	query	bool?	No
ChangeSourceIsFromPurchaseOrderLine	query	bool?	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

**RE_Lines** Parameters:
Name	Parameter	Data Type	Required
SourceID	form	string	No
PackSlipID	form	string	No
OrderID	form	string	No
OrderLineID	form	string	No
Quantity	form	decimal?	No
SuppliersCost	form	decimal?	No
InventoryID	form	string	No
PartNo	form	string	No
Description	form	string	No
SuppPartNo	form	string	No
LineType	form	short?	No
DecimalPlaces	form	short?	No
LastSavedDateTime	form	DateTime?	No
ClassificationID	form	string	No
ClassDescription	form	string	No
TaxAmount	form	decimal?	No
TaxID	form	string	No
TaxRate	form	decimal?	No
HomeSuppliersCost	form	decimal?	No
CurrencyRateUsed	form	decimal?	No
POClassID	form	string	No
PostedToWIP	form	bool	No
JobCharge	form	decimal	No
LineNumber	form	int?	No
JB_JobStages_RecID	form	string	No
FXDecimalPlaces	form	short?	No
HomeDecimalPlaces	form	short?	No
LineTotalExTax	form	decimal	No
UnitIncTax	form	decimal	No
LineTotalIncTax	form	decimal	No
FXLineTotalExTax	form	decimal	No
UnitChanged	form	bool?	No
FXChanged	form	bool?	No
ExChanged	form	bool?	No
TaxRateChanged	form	bool?	No
ChangeSourceIsFromPurchaseOrderLine	form	bool?	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 .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.

GET /Queries/RE_Lines HTTP/1.1 
Host: apitrain.galipo.com.au 
Accept: text/csv

HTTP/1.1 200 OK
Content-Type: text/csv
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"}}}