JiwaAPI

IN_TransferReasonsQuery

The following routes are available for this service:
GET	/Queries/IN_TransferReasons	Retrieves a list of stock transfer reasons.

**IN_TransferReasonsQuery** Parameters:
Name	Parameter	Data Type	Required
RecID	query	string	No
RecIDStartsWith	query	string	No
RecIDEndsWith	query	string	No
RecIDContains	query	string	No
RecIDLike	query	string	No
RecIDBetween	query	string[]	No
RecIDIn	query	string[]	No
Name	query	string	No
NameStartsWith	query	string	No
NameEndsWith	query	string	No
NameContains	query	string	No
NameLike	query	string	No
NameBetween	query	string[]	No
NameIn	query	string[]	No
WriteOffAccountOverride	query	bool?	No
WriteOffAccountID	query	string	No
WriteOffAccountIDStartsWith	query	string	No
WriteOffAccountIDEndsWith	query	string	No
WriteOffAccountIDContains	query	string	No
WriteOffAccountIDLike	query	string	No
WriteOffAccountIDBetween	query	string[]	No
WriteOffAccountIDIn	query	string[]	No
WriteOnAccountOverride	query	bool?	No
WriteOnAccountID	query	string	No
WriteOnAccountIDStartsWith	query	string	No
WriteOnAccountIDEndsWith	query	string	No
WriteOnAccountIDContains	query	string	No
WriteOnAccountIDLike	query	string	No
WriteOnAccountIDBetween	query	string[]	No
WriteOnAccountIDIn	query	string[]	No
DefaultReason	query	bool?	No
ReadOnly	query	bool?	No
CreatedDateTime	query	DateTime?	No
CreatedDateTimeGreaterThanOrEqualTo	query	DateTime?	No
CreatedDateTimeGreaterThan	query	DateTime?	No
CreatedDateTimeLessThan	query	DateTime?	No
CreatedDateTimeLessThanOrEqualTo	query	DateTime?	No
CreatedDateTimeNotEqualTo	query	DateTime?	No
CreatedDateTimeBetween	query	Nullable<DateTime>[]	No
CreatedDateTimeIn	query	Nullable<DateTime>[]	No
CreatedByStaffID	query	string	No
CreatedByStaffIDStartsWith	query	string	No
CreatedByStaffIDEndsWith	query	string	No
CreatedByStaffIDContains	query	string	No
CreatedByStaffIDLike	query	string	No
CreatedByStaffIDBetween	query	string[]	No
CreatedByStaffIDIn	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
LastSavedByStaffID	query	string	No
LastSavedByStaffIDStartsWith	query	string	No
LastSavedByStaffIDEndsWith	query	string	No
LastSavedByStaffIDContains	query	string	No
LastSavedByStaffIDLike	query	string	No
LastSavedByStaffIDBetween	query	string[]	No
LastSavedByStaffIDIn	query	string[]	No
ItemNo	query	int?	No
ItemNoGreaterThanOrEqualTo	query	int?	No
ItemNoGreaterThan	query	int?	No
ItemNoLessThan	query	int?	No
ItemNoLessThanOrEqualTo	query	int?	No
ItemNoNotEqualTo	query	int?	No
ItemNoBetween	query	Nullable<Int32>[]	No
ItemNoIn	query	Nullable<Int32>[]	No
RowHash	query	byte[]	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_TransferReasons** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
Name	form	string	No
WriteOffAccountOverride	form	bool?	No
WriteOffAccountID	form	string	No
WriteOnAccountOverride	form	bool?	No
WriteOnAccountID	form	string	No
DefaultReason	form	bool?	No
ReadOnly	form	bool?	No
CreatedDateTime	form	DateTime?	No
CreatedByStaffID	form	string	No
LastSavedDateTime	form	DateTime?	No
LastSavedByStaffID	form	string	No
ItemNo	form	int?	No
RowHash	form	byte[]	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_TransferReasons HTTP/1.1 
Host: millers.jiwa.com.au 
Accept: text/csv

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

{"Results":[{"RecID":"String","Name":"String","WriteOffAccountOverride":false,"WriteOffAccountID":"String","WriteOnAccountOverride":false,"WriteOnAccountID":"String","DefaultReason":false,"ReadOnly":false,"CreatedDateTime":"0001-01-01T00:00:00.0000000","CreatedByStaffID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","LastSavedByStaffID":"String","ItemNo":0,"RowHash":"AA=="}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}