JiwaAPI

<back to all web services

WH_TransferQuery

Requires Authentication
The following routes are available for this service:
GET/Queries/WH_TransferRetrieves a list of warehouse transfers.
WH_TransferQuery Parameters:
NameParameterData TypeRequiredDescription
WH_TransferIDquerystringNo
WH_TransferIDStartsWithquerystringNo
WH_TransferIDEndsWithquerystringNo
WH_TransferIDContainsquerystringNo
WH_TransferIDLikequerystringNo
WH_TransferIDBetweenquerystring[]No
WH_TransferIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryDateTime[]No
LastSavedDateTimeInqueryDateTime[]No
TransferDatequeryDateTime?No
TransferDateGreaterThanOrEqualToqueryDateTime?No
TransferDateGreaterThanqueryDateTime?No
TransferDateLessThanqueryDateTime?No
TransferDateLessThanOrEqualToqueryDateTime?No
TransferDateNotEqualToqueryDateTime?No
TransferDateBetweenqueryDateTime[]No
TransferDateInqueryDateTime[]No
ActivateDatequeryDateTime?No
ActivateDateGreaterThanOrEqualToqueryDateTime?No
ActivateDateGreaterThanqueryDateTime?No
ActivateDateLessThanqueryDateTime?No
ActivateDateLessThanOrEqualToqueryDateTime?No
ActivateDateNotEqualToqueryDateTime?No
ActivateDateBetweenqueryDateTime[]No
ActivateDateInqueryDateTime[]No
Statusqueryshort?No
StatusGreaterThanOrEqualToqueryshort?No
StatusGreaterThanqueryshort?No
StatusLessThanqueryshort?No
StatusLessThanOrEqualToqueryshort?No
StatusNotEqualToqueryshort?No
StatusBetweenqueryNullable<Int16>[]No
StatusInqueryNullable<Int16>[]No
TransferByquerystringNo
TransferByStartsWithquerystringNo
TransferByEndsWithquerystringNo
TransferByContainsquerystringNo
TransferByLikequerystringNo
TransferByBetweenquerystring[]No
TransferByInquerystring[]No
RefquerystringNo
RefStartsWithquerystringNo
RefEndsWithquerystringNo
RefContainsquerystringNo
RefLikequerystringNo
RefBetweenquerystring[]No
RefInquerystring[]No
NotesquerystringNo
NotesStartsWithquerystringNo
NotesEndsWithquerystringNo
NotesContainsquerystringNo
NotesLikequerystringNo
NotesBetweenquerystring[]No
NotesInquerystring[]No
SourceTypequeryshort?No
SourceTypeGreaterThanOrEqualToqueryshort?No
SourceTypeGreaterThanqueryshort?No
SourceTypeLessThanqueryshort?No
SourceTypeLessThanOrEqualToqueryshort?No
SourceTypeNotEqualToqueryshort?No
SourceTypeBetweenqueryNullable<Int16>[]No
SourceTypeInqueryNullable<Int16>[]No
SourceIDquerystringNo
SourceIDStartsWithquerystringNo
SourceIDEndsWithquerystringNo
SourceIDContainsquerystringNo
SourceIDLikequerystringNo
SourceIDBetweenquerystring[]No
SourceIDInquerystring[]No
SrcIN_LogicalIDquerystringNo
SrcIN_LogicalIDStartsWithquerystringNo
SrcIN_LogicalIDEndsWithquerystringNo
SrcIN_LogicalIDContainsquerystringNo
SrcIN_LogicalIDLikequerystringNo
SrcIN_LogicalIDBetweenquerystring[]No
SrcIN_LogicalIDInquerystring[]No
DstIN_LogicalIDquerystringNo
DstIN_LogicalIDStartsWithquerystringNo
DstIN_LogicalIDEndsWithquerystringNo
DstIN_LogicalIDContainsquerystringNo
DstIN_LogicalIDLikequerystringNo
DstIN_LogicalIDBetweenquerystring[]No
DstIN_LogicalIDInquerystring[]No
TransferNoquerystringNo
TransferNoStartsWithquerystringNo
TransferNoEndsWithquerystringNo
TransferNoContainsquerystringNo
TransferNoLikequerystringNo
TransferNoBetweenquerystring[]No
TransferNoInquerystring[]No
InTransitquerybool?No
TransitNotesquerystringNo
TransitNotesStartsWithquerystringNo
TransitNotesEndsWithquerystringNo
TransitNotesContainsquerystringNo
TransitNotesLikequerystringNo
TransitNotesBetweenquerystring[]No
TransitNotesInquerystring[]No
IN_TransitIDquerystringNo
IN_TransitIDStartsWithquerystringNo
IN_TransitIDEndsWithquerystringNo
IN_TransitIDContainsquerystringNo
IN_TransitIDLikequerystringNo
IN_TransitIDBetweenquerystring[]No
IN_TransitIDInquerystring[]No
AddedCost1querydecimal?No
AddedCost1GreaterThanOrEqualToquerydecimal?No
AddedCost1GreaterThanquerydecimal?No
AddedCost1LessThanquerydecimal?No
AddedCost1LessThanOrEqualToquerydecimal?No
AddedCost1NotEqualToquerydecimal?No
AddedCost1Betweenquerydecimal[]No
AddedCost1Inquerydecimal[]No
AddedCost2querydecimal?No
AddedCost2GreaterThanOrEqualToquerydecimal?No
AddedCost2GreaterThanquerydecimal?No
AddedCost2LessThanquerydecimal?No
AddedCost2LessThanOrEqualToquerydecimal?No
AddedCost2NotEqualToquerydecimal?No
AddedCost2Betweenquerydecimal[]No
AddedCost2Inquerydecimal[]No
AddedCost3querydecimal?No
AddedCost3GreaterThanOrEqualToquerydecimal?No
AddedCost3GreaterThanquerydecimal?No
AddedCost3LessThanquerydecimal?No
AddedCost3LessThanOrEqualToquerydecimal?No
AddedCost3NotEqualToquerydecimal?No
AddedCost3Betweenquerydecimal[]No
AddedCost3Inquerydecimal[]No
PickedByquerystringNo
PickedByStartsWithquerystringNo
PickedByEndsWithquerystringNo
PickedByContainsquerystringNo
PickedByLikequerystringNo
PickedByBetweenquerystring[]No
PickedByInquerystring[]No
ReceivedByquerystringNo
ReceivedByStartsWithquerystringNo
ReceivedByEndsWithquerystringNo
ReceivedByContainsquerystringNo
ReceivedByLikequerystringNo
ReceivedByBetweenquerystring[]No
ReceivedByInquerystring[]No
Typequeryshort?No
TypeGreaterThanOrEqualToqueryshort?No
TypeGreaterThanqueryshort?No
TypeLessThanqueryshort?No
TypeLessThanOrEqualToqueryshort?No
TypeNotEqualToqueryshort?No
TypeBetweenqueryshort[]No
TypeInqueryshort[]No
AddCostMethodquerystringNo
AddCostMethodStartsWithquerystringNo
AddCostMethodEndsWithquerystringNo
AddCostMethodContainsquerystringNo
AddCostMethodLikequerystringNo
AddCostMethodBetweenquerystring[]No
AddCostMethodInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
WH_Transfer Parameters:
NameParameterData TypeRequiredDescription
WH_TransferIDformstringNo
LastSavedDateTimeformDateTimeNo
TransferDateformDateTimeNo
ActivateDateformDateTimeNo
Statusformshort?No
TransferByformstringNo
RefformstringNo
NotesformstringNo
SourceTypeformshort?No
SourceIDformstringNo
SrcIN_LogicalIDformstringNo
DstIN_LogicalIDformstringNo
TransferNoformstringNo
InTransitformboolNo
TransitNotesformstringNo
IN_TransitIDformstringNo
AddedCost1formdecimalNo
AddedCost2formdecimalNo
AddedCost3formdecimalNo
PickedByformstringNo
ReceivedByformstringNo
TypeformshortNo
AddCostMethodformstringNo
QueryResponse<T> Parameters:
NameParameterData TypeRequiredDescription
OffsetformintNo
TotalformintNo
ResultsformList<T>No
MetaformDictionary<string, string>No
ResponseStatusformResponseStatusNo

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"}}}