JiwaAPI

IN_SOHQuery

The following routes are available for this service:
GET	/Queries/IN_SOH	Retrieves a list of inventory stock transactionrecords.

**IN_SOHQuery** Parameters:
Name	Parameter	Data Type	Required
LinkID	query	string	No
LinkIDStartsWith	query	string	No
LinkIDEndsWith	query	string	No
LinkIDContains	query	string	No
LinkIDLike	query	string	No
LinkIDBetween	query	string[]	No
LinkIDIn	query	string[]	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
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
DateIn	query	DateTime?	No
DateInGreaterThanOrEqualTo	query	DateTime?	No
DateInGreaterThan	query	DateTime?	No
DateInLessThan	query	DateTime?	No
DateInLessThanOrEqualTo	query	DateTime?	No
DateInNotEqualTo	query	DateTime?	No
DateInBetween	query	Nullable<DateTime>[]	No
DateInIn	query	Nullable<DateTime>[]	No
QuantityIn	query	decimal?	No
QuantityInGreaterThanOrEqualTo	query	decimal?	No
QuantityInGreaterThan	query	decimal?	No
QuantityInLessThan	query	decimal?	No
QuantityInLessThanOrEqualTo	query	decimal?	No
QuantityInNotEqualTo	query	decimal?	No
QuantityInBetween	query	Nullable<Decimal>[]	No
QuantityInIn	query	Nullable<Decimal>[]	No
LCostIn	query	decimal?	No
LCostInGreaterThanOrEqualTo	query	decimal?	No
LCostInGreaterThan	query	decimal?	No
LCostInLessThan	query	decimal?	No
LCostInLessThanOrEqualTo	query	decimal?	No
LCostInNotEqualTo	query	decimal?	No
LCostInBetween	query	Nullable<Decimal>[]	No
LCostInIn	query	Nullable<Decimal>[]	No
SCostIn	query	decimal?	No
SCostInGreaterThanOrEqualTo	query	decimal?	No
SCostInGreaterThan	query	decimal?	No
SCostInLessThan	query	decimal?	No
SCostInLessThanOrEqualTo	query	decimal?	No
SCostInNotEqualTo	query	decimal?	No
SCostInBetween	query	Nullable<Decimal>[]	No
SCostInIn	query	Nullable<Decimal>[]	No
SpecialPrice	query	decimal?	No
SpecialPriceGreaterThanOrEqualTo	query	decimal?	No
SpecialPriceGreaterThan	query	decimal?	No
SpecialPriceLessThan	query	decimal?	No
SpecialPriceLessThanOrEqualTo	query	decimal?	No
SpecialPriceNotEqualTo	query	decimal?	No
SpecialPriceBetween	query	Nullable<Decimal>[]	No
SpecialPriceIn	query	Nullable<Decimal>[]	No
QuantityLeft	query	decimal?	No
QuantityLeftGreaterThanOrEqualTo	query	decimal?	No
QuantityLeftGreaterThan	query	decimal?	No
QuantityLeftLessThan	query	decimal?	No
QuantityLeftLessThanOrEqualTo	query	decimal?	No
QuantityLeftNotEqualTo	query	decimal?	No
QuantityLeftBetween	query	Nullable<Decimal>[]	No
QuantityLeftIn	query	Nullable<Decimal>[]	No
SerialNo	query	string	No
SerialNoStartsWith	query	string	No
SerialNoEndsWith	query	string	No
SerialNoContains	query	string	No
SerialNoLike	query	string	No
SerialNoBetween	query	string[]	No
SerialNoIn	query	string[]	No
TaxPaid	query	decimal?	No
TaxPaidGreaterThanOrEqualTo	query	decimal?	No
TaxPaidGreaterThan	query	decimal?	No
TaxPaidLessThan	query	decimal?	No
TaxPaidLessThanOrEqualTo	query	decimal?	No
TaxPaidNotEqualTo	query	decimal?	No
TaxPaidBetween	query	Nullable<Decimal>[]	No
TaxPaidIn	query	Nullable<Decimal>[]	No
Ref	query	string	No
RefStartsWith	query	string	No
RefEndsWith	query	string	No
RefContains	query	string	No
RefLike	query	string	No
RefBetween	query	string[]	No
RefIn	query	string[]	No
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
HistoryText	query	string	No
HistoryTextStartsWith	query	string	No
HistoryTextEndsWith	query	string	No
HistoryTextContains	query	string	No
HistoryTextLike	query	string	No
HistoryTextBetween	query	string[]	No
HistoryTextIn	query	string[]	No
QuantityAllocated	query	decimal?	No
QuantityAllocatedGreaterThanOrEqualTo	query	decimal?	No
QuantityAllocatedGreaterThan	query	decimal?	No
QuantityAllocatedLessThan	query	decimal?	No
QuantityAllocatedLessThanOrEqualTo	query	decimal?	No
QuantityAllocatedNotEqualTo	query	decimal?	No
QuantityAllocatedBetween	query	Nullable<Decimal>[]	No
QuantityAllocatedIn	query	Nullable<Decimal>[]	No
IN_LogicalID	query	string	No
IN_LogicalIDStartsWith	query	string	No
IN_LogicalIDEndsWith	query	string	No
IN_LogicalIDContains	query	string	No
IN_LogicalIDLike	query	string	No
IN_LogicalIDBetween	query	string[]	No
IN_LogicalIDIn	query	string[]	No
BinLocationDesc	query	string	No
BinLocationDescStartsWith	query	string	No
BinLocationDescEndsWith	query	string	No
BinLocationDescContains	query	string	No
BinLocationDescLike	query	string	No
BinLocationDescBetween	query	string[]	No
BinLocationDescIn	query	string[]	No
ExpiryDate	query	DateTime?	No
ExpiryDateGreaterThanOrEqualTo	query	DateTime?	No
ExpiryDateGreaterThan	query	DateTime?	No
ExpiryDateLessThan	query	DateTime?	No
ExpiryDateLessThanOrEqualTo	query	DateTime?	No
ExpiryDateNotEqualTo	query	DateTime?	No
ExpiryDateBetween	query	Nullable<DateTime>[]	No
ExpiryDateIn	query	Nullable<DateTime>[]	No
SY_Forms_ClassName	query	string	No
SY_Forms_ClassNameStartsWith	query	string	No
SY_Forms_ClassNameEndsWith	query	string	No
SY_Forms_ClassNameContains	query	string	No
SY_Forms_ClassNameLike	query	string	No
SY_Forms_ClassNameBetween	query	string[]	No
SY_Forms_ClassNameIn	query	string[]	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

**IN_SOH** Parameters:
Name	Parameter	Data Type	Required
LinkID	form	string	No
LastSavedDateTime	form	DateTime?	No
InventoryID	form	string	No
DateIn	form	DateTime?	No
QuantityIn	form	decimal?	No
LCostIn	form	decimal?	No
SCostIn	form	decimal?	No
SpecialPrice	form	decimal?	No
QuantityLeft	form	decimal?	No
SerialNo	form	string	No
TaxPaid	form	decimal?	No
Ref	form	string	No
SourceID	form	string	No
HistoryText	form	string	No
QuantityAllocated	form	decimal?	No
IN_LogicalID	form	string	No
BinLocationDesc	form	string	No
ExpiryDate	form	DateTime?	No
SY_Forms_ClassName	form	string	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/IN_SOH HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv

HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"Results":[{"LinkID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","InventoryID":"String","DateIn":"0001-01-01T00:00:00.0000000","QuantityIn":0,"LCostIn":0,"SCostIn":0,"SpecialPrice":0,"QuantityLeft":0,"SerialNo":"String","TaxPaid":0,"Ref":"String","SourceID":"String","HistoryText":"String","QuantityAllocated":0,"IN_LogicalID":"String","BinLocationDesc":"String","ExpiryDate":"0001-01-01T00:00:00.0000000","SY_Forms_ClassName":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}