JiwaAPI

IN_TransferQuery

The following routes are available for this service:
GET	/Queries/IN_Transfer	Retrieves a list of stock transfers.

**IN_TransferQuery** Parameters:
Name	Parameter	Data Type	Required
TransferID	query	string	No
TransferIDStartsWith	query	string	No
TransferIDEndsWith	query	string	No
TransferIDContains	query	string	No
TransferIDLike	query	string	No
TransferIDBetween	query	string[]	No
TransferIDIn	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
TransferNo	query	string	No
TransferNoStartsWith	query	string	No
TransferNoEndsWith	query	string	No
TransferNoContains	query	string	No
TransferNoLike	query	string	No
TransferNoBetween	query	string[]	No
TransferNoIn	query	string[]	No
TransferDate	query	DateTime?	No
TransferDateGreaterThanOrEqualTo	query	DateTime?	No
TransferDateGreaterThan	query	DateTime?	No
TransferDateLessThan	query	DateTime?	No
TransferDateLessThanOrEqualTo	query	DateTime?	No
TransferDateNotEqualTo	query	DateTime?	No
TransferDateBetween	query	Nullable<DateTime>[]	No
TransferDateIn	query	Nullable<DateTime>[]	No
Reference	query	string	No
ReferenceStartsWith	query	string	No
ReferenceEndsWith	query	string	No
ReferenceContains	query	string	No
ReferenceLike	query	string	No
ReferenceBetween	query	string[]	No
ReferenceIn	query	string[]	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
Status	query	short?	No
StatusGreaterThanOrEqualTo	query	short?	No
StatusGreaterThan	query	short?	No
StatusLessThan	query	short?	No
StatusLessThanOrEqualTo	query	short?	No
StatusNotEqualTo	query	short?	No
StatusBetween	query	short[]	No
StatusIn	query	short[]	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
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
IN_TransferReasons_RecID	query	string	No
IN_TransferReasons_RecIDStartsWith	query	string	No
IN_TransferReasons_RecIDEndsWith	query	string	No
IN_TransferReasons_RecIDContains	query	string	No
IN_TransferReasons_RecIDLike	query	string	No
IN_TransferReasons_RecIDBetween	query	string[]	No
IN_TransferReasons_RecIDIn	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_Transfer** Parameters:
Name	Parameter	Data Type	Required
TransferID	form	string	No
LastSavedDateTime	form	DateTime?	No
TransferNo	form	string	No
TransferDate	form	DateTime?	No
Reference	form	string	No
IN_LogicalID	form	string	No
Status	form	short	No
CreatedDateTime	form	DateTime?	No
CreatedByStaffID	form	string	No
LastSavedByStaffID	form	string	No
IN_TransferReasons_RecID	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_Transfer HTTP/1.1 
Host: localhost 
Accept: text/csv

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

{"Results":[{"TransferID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","TransferNo":"String","TransferDate":"0001-01-01T00:00:00.0000000","Reference":"String","IN_LogicalID":"String","CreatedDateTime":"0001-01-01T00:00:00.0000000","CreatedByStaffID":"String","LastSavedByStaffID":"String","IN_TransferReasons_RecID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}