JiwaAPI

WH_TransferQuery

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

**WH_TransferQuery** Parameters:
Name	Parameter	Data Type	Required
WH_TransferID	query	string	No
WH_TransferIDStartsWith	query	string	No
WH_TransferIDEndsWith	query	string	No
WH_TransferIDContains	query	string	No
WH_TransferIDLike	query	string	No
WH_TransferIDBetween	query	string[]	No
WH_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	DateTime[]	No
LastSavedDateTimeIn	query	DateTime[]	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	DateTime[]	No
TransferDateIn	query	DateTime[]	No
ActivateDate	query	DateTime?	No
ActivateDateGreaterThanOrEqualTo	query	DateTime?	No
ActivateDateGreaterThan	query	DateTime?	No
ActivateDateLessThan	query	DateTime?	No
ActivateDateLessThanOrEqualTo	query	DateTime?	No
ActivateDateNotEqualTo	query	DateTime?	No
ActivateDateBetween	query	DateTime[]	No
ActivateDateIn	query	DateTime[]	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	Nullable<Int16>[]	No
StatusIn	query	Nullable<Int16>[]	No
TransferBy	query	string	No
TransferByStartsWith	query	string	No
TransferByEndsWith	query	string	No
TransferByContains	query	string	No
TransferByLike	query	string	No
TransferByBetween	query	string[]	No
TransferByIn	query	string[]	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
Notes	query	string	No
NotesStartsWith	query	string	No
NotesEndsWith	query	string	No
NotesContains	query	string	No
NotesLike	query	string	No
NotesBetween	query	string[]	No
NotesIn	query	string[]	No
SourceType	query	short?	No
SourceTypeGreaterThanOrEqualTo	query	short?	No
SourceTypeGreaterThan	query	short?	No
SourceTypeLessThan	query	short?	No
SourceTypeLessThanOrEqualTo	query	short?	No
SourceTypeNotEqualTo	query	short?	No
SourceTypeBetween	query	Nullable<Int16>[]	No
SourceTypeIn	query	Nullable<Int16>[]	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
SrcIN_LogicalID	query	string	No
SrcIN_LogicalIDStartsWith	query	string	No
SrcIN_LogicalIDEndsWith	query	string	No
SrcIN_LogicalIDContains	query	string	No
SrcIN_LogicalIDLike	query	string	No
SrcIN_LogicalIDBetween	query	string[]	No
SrcIN_LogicalIDIn	query	string[]	No
DstIN_LogicalID	query	string	No
DstIN_LogicalIDStartsWith	query	string	No
DstIN_LogicalIDEndsWith	query	string	No
DstIN_LogicalIDContains	query	string	No
DstIN_LogicalIDLike	query	string	No
DstIN_LogicalIDBetween	query	string[]	No
DstIN_LogicalIDIn	query	string[]	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
InTransit	query	bool?	No
TransitNotes	query	string	No
TransitNotesStartsWith	query	string	No
TransitNotesEndsWith	query	string	No
TransitNotesContains	query	string	No
TransitNotesLike	query	string	No
TransitNotesBetween	query	string[]	No
TransitNotesIn	query	string[]	No
IN_TransitID	query	string	No
IN_TransitIDStartsWith	query	string	No
IN_TransitIDEndsWith	query	string	No
IN_TransitIDContains	query	string	No
IN_TransitIDLike	query	string	No
IN_TransitIDBetween	query	string[]	No
IN_TransitIDIn	query	string[]	No
AddedCost1	query	decimal?	No
AddedCost1GreaterThanOrEqualTo	query	decimal?	No
AddedCost1GreaterThan	query	decimal?	No
AddedCost1LessThan	query	decimal?	No
AddedCost1LessThanOrEqualTo	query	decimal?	No
AddedCost1NotEqualTo	query	decimal?	No
AddedCost1Between	query	decimal[]	No
AddedCost1In	query	decimal[]	No
AddedCost2	query	decimal?	No
AddedCost2GreaterThanOrEqualTo	query	decimal?	No
AddedCost2GreaterThan	query	decimal?	No
AddedCost2LessThan	query	decimal?	No
AddedCost2LessThanOrEqualTo	query	decimal?	No
AddedCost2NotEqualTo	query	decimal?	No
AddedCost2Between	query	decimal[]	No
AddedCost2In	query	decimal[]	No
AddedCost3	query	decimal?	No
AddedCost3GreaterThanOrEqualTo	query	decimal?	No
AddedCost3GreaterThan	query	decimal?	No
AddedCost3LessThan	query	decimal?	No
AddedCost3LessThanOrEqualTo	query	decimal?	No
AddedCost3NotEqualTo	query	decimal?	No
AddedCost3Between	query	decimal[]	No
AddedCost3In	query	decimal[]	No
PickedBy	query	string	No
PickedByStartsWith	query	string	No
PickedByEndsWith	query	string	No
PickedByContains	query	string	No
PickedByLike	query	string	No
PickedByBetween	query	string[]	No
PickedByIn	query	string[]	No
ReceivedBy	query	string	No
ReceivedByStartsWith	query	string	No
ReceivedByEndsWith	query	string	No
ReceivedByContains	query	string	No
ReceivedByLike	query	string	No
ReceivedByBetween	query	string[]	No
ReceivedByIn	query	string[]	No
Type	query	short?	No
TypeGreaterThanOrEqualTo	query	short?	No
TypeGreaterThan	query	short?	No
TypeLessThan	query	short?	No
TypeLessThanOrEqualTo	query	short?	No
TypeNotEqualTo	query	short?	No
TypeBetween	query	short[]	No
TypeIn	query	short[]	No
AddCostMethod	query	string	No
AddCostMethodStartsWith	query	string	No
AddCostMethodEndsWith	query	string	No
AddCostMethodContains	query	string	No
AddCostMethodLike	query	string	No
AddCostMethodBetween	query	string[]	No
AddCostMethodIn	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

**WH_Transfer** Parameters:
Name	Parameter	Data Type	Required
WH_TransferID	form	string	No
LastSavedDateTime	form	DateTime	No
TransferDate	form	DateTime	No
ActivateDate	form	DateTime	No
Status	form	short?	No
TransferBy	form	string	No
Ref	form	string	No
Notes	form	string	No
SourceType	form	short?	No
SourceID	form	string	No
SrcIN_LogicalID	form	string	No
DstIN_LogicalID	form	string	No
TransferNo	form	string	No
InTransit	form	bool	No
TransitNotes	form	string	No
IN_TransitID	form	string	No
AddedCost1	form	decimal	No
AddedCost2	form	decimal	No
AddedCost3	form	decimal	No
PickedBy	form	string	No
ReceivedBy	form	string	No
Type	form	short	No
AddCostMethod	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/WH_Transfer HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv

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

{"Results":[{"WH_TransferID":"String","Status":0,"TransferBy":"String","Ref":"String","Notes":"String","SourceType":0,"SourceID":"String","SrcIN_LogicalID":"String","DstIN_LogicalID":"String","TransferNo":"String","TransitNotes":"String","IN_TransitID":"String","PickedBy":"String","ReceivedBy":"String","AddCostMethod":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}