JiwaAPI

<back to all web services

SO_LineShippingLabelsQuery

Requires Authentication
SO_LineShippingLabelsQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
SO_Lines_InvoiceLineIDquerystringNo
SO_Lines_InvoiceLineIDStartsWithquerystringNo
SO_Lines_InvoiceLineIDEndsWithquerystringNo
SO_Lines_InvoiceLineIDContainsquerystringNo
SO_Lines_InvoiceLineIDLikequerystringNo
SO_Lines_InvoiceLineIDBetweenquerystring[]No
SO_Lines_InvoiceLineIDInquerystring[]No
Quantityquerydecimal?No
QuantityGreaterThanOrEqualToquerydecimal?No
QuantityGreaterThanquerydecimal?No
QuantityLessThanquerydecimal?No
QuantityLessThanOrEqualToquerydecimal?No
QuantityNotEqualToquerydecimal?No
QuantityBetweenquerydecimal[]No
QuantityInquerydecimal[]No
SSCC_NumberquerystringNo
SSCC_NumberStartsWithquerystringNo
SSCC_NumberEndsWithquerystringNo
SSCC_NumberContainsquerystringNo
SSCC_NumberLikequerystringNo
SSCC_NumberBetweenquerystring[]No
SSCC_NumberInquerystring[]No
BatchNoquerystringNo
BatchNoStartsWithquerystringNo
BatchNoEndsWithquerystringNo
BatchNoContainsquerystringNo
BatchNoLikequerystringNo
BatchNoBetweenquerystring[]No
BatchNoInquerystring[]No
UseByDatequeryDateTime?No
UseByDateGreaterThanOrEqualToqueryDateTime?No
UseByDateGreaterThanqueryDateTime?No
UseByDateLessThanqueryDateTime?No
UseByDateLessThanOrEqualToqueryDateTime?No
UseByDateNotEqualToqueryDateTime?No
UseByDateBetweenqueryNullable<DateTime>[]No
UseByDateInqueryNullable<DateTime>[]No
ReferencequerystringNo
ReferenceStartsWithquerystringNo
ReferenceEndsWithquerystringNo
ReferenceContainsquerystringNo
ReferenceLikequerystringNo
ReferenceBetweenquerystring[]No
ReferenceInquerystring[]No
LabelNumberqueryint?No
LabelNumberGreaterThanOrEqualToqueryint?No
LabelNumberGreaterThanqueryint?No
LabelNumberLessThanqueryint?No
LabelNumberLessThanOrEqualToqueryint?No
LabelNumberNotEqualToqueryint?No
LabelNumberBetweenqueryint[]No
LabelNumberInqueryint[]No
SpareString1querystringNo
SpareString1StartsWithquerystringNo
SpareString1EndsWithquerystringNo
SpareString1ContainsquerystringNo
SpareString1LikequerystringNo
SpareString1Betweenquerystring[]No
SpareString1Inquerystring[]No
SpareString2querystringNo
SpareString2StartsWithquerystringNo
SpareString2EndsWithquerystringNo
SpareString2ContainsquerystringNo
SpareString2LikequerystringNo
SpareString2Betweenquerystring[]No
SpareString2Inquerystring[]No
SpareString3querystringNo
SpareString3StartsWithquerystringNo
SpareString3EndsWithquerystringNo
SpareString3ContainsquerystringNo
SpareString3LikequerystringNo
SpareString3Betweenquerystring[]No
SpareString3Inquerystring[]No
SpareNumeric1querydecimal?No
SpareNumeric1GreaterThanOrEqualToquerydecimal?No
SpareNumeric1GreaterThanquerydecimal?No
SpareNumeric1LessThanquerydecimal?No
SpareNumeric1LessThanOrEqualToquerydecimal?No
SpareNumeric1NotEqualToquerydecimal?No
SpareNumeric1BetweenqueryNullable<Decimal>[]No
SpareNumeric1InqueryNullable<Decimal>[]No
SpareNumeric2querydecimal?No
SpareNumeric2GreaterThanOrEqualToquerydecimal?No
SpareNumeric2GreaterThanquerydecimal?No
SpareNumeric2LessThanquerydecimal?No
SpareNumeric2LessThanOrEqualToquerydecimal?No
SpareNumeric2NotEqualToquerydecimal?No
SpareNumeric2BetweenqueryNullable<Decimal>[]No
SpareNumeric2InqueryNullable<Decimal>[]No
SpareNumeric3querydecimal?No
SpareNumeric3GreaterThanOrEqualToquerydecimal?No
SpareNumeric3GreaterThanquerydecimal?No
SpareNumeric3LessThanquerydecimal?No
SpareNumeric3LessThanOrEqualToquerydecimal?No
SpareNumeric3NotEqualToquerydecimal?No
SpareNumeric3BetweenqueryNullable<Decimal>[]No
SpareNumeric3InqueryNullable<Decimal>[]No
SpareDate1queryDateTime?No
SpareDate1GreaterThanOrEqualToqueryDateTime?No
SpareDate1GreaterThanqueryDateTime?No
SpareDate1LessThanqueryDateTime?No
SpareDate1LessThanOrEqualToqueryDateTime?No
SpareDate1NotEqualToqueryDateTime?No
SpareDate1BetweenqueryNullable<DateTime>[]No
SpareDate1InqueryNullable<DateTime>[]No
SpareDate2queryDateTime?No
SpareDate2GreaterThanOrEqualToqueryDateTime?No
SpareDate2GreaterThanqueryDateTime?No
SpareDate2LessThanqueryDateTime?No
SpareDate2LessThanOrEqualToqueryDateTime?No
SpareDate2NotEqualToqueryDateTime?No
SpareDate2BetweenqueryNullable<DateTime>[]No
SpareDate2InqueryNullable<DateTime>[]No
SpareDate3queryDateTime?No
SpareDate3GreaterThanOrEqualToqueryDateTime?No
SpareDate3GreaterThanqueryDateTime?No
SpareDate3LessThanqueryDateTime?No
SpareDate3LessThanOrEqualToqueryDateTime?No
SpareDate3NotEqualToqueryDateTime?No
SpareDate3BetweenqueryNullable<DateTime>[]No
SpareDate3InqueryNullable<DateTime>[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryDateTime[]No
LastSavedDateTimeInqueryDateTime[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
SO_LineShippingLabels Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
SO_Lines_InvoiceLineIDformstringNo
QuantityformdecimalNo
SSCC_NumberformstringNo
BatchNoformstringNo
UseByDateformDateTime?No
ReferenceformstringNo
LabelNumberformintNo
SpareString1formstringNo
SpareString2formstringNo
SpareString3formstringNo
SpareNumeric1formdecimal?No
SpareNumeric2formdecimal?No
SpareNumeric3formdecimal?No
SpareDate1formDateTime?No
SpareDate2formDateTime?No
SpareDate3formDateTime?No
LastSavedDateTimeformDateTimeNo
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 .json suffix or ?format=json

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /json/reply/SO_LineShippingLabelsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"RecID":"String","RecIDStartsWith":"String","RecIDEndsWith":"String","RecIDContains":"String","RecIDLike":"String","RecIDBetween":["String"],"RecIDIn":["String"],"SO_Lines_InvoiceLineID":"String","SO_Lines_InvoiceLineIDStartsWith":"String","SO_Lines_InvoiceLineIDEndsWith":"String","SO_Lines_InvoiceLineIDContains":"String","SO_Lines_InvoiceLineIDLike":"String","SO_Lines_InvoiceLineIDBetween":["String"],"SO_Lines_InvoiceLineIDIn":["String"],"Quantity":0,"QuantityGreaterThanOrEqualTo":0,"QuantityGreaterThan":0,"QuantityLessThan":0,"QuantityLessThanOrEqualTo":0,"QuantityNotEqualTo":0,"QuantityBetween":[0],"QuantityIn":[0],"SSCC_Number":"String","SSCC_NumberStartsWith":"String","SSCC_NumberEndsWith":"String","SSCC_NumberContains":"String","SSCC_NumberLike":"String","SSCC_NumberBetween":["String"],"SSCC_NumberIn":["String"],"BatchNo":"String","BatchNoStartsWith":"String","BatchNoEndsWith":"String","BatchNoContains":"String","BatchNoLike":"String","BatchNoBetween":["String"],"BatchNoIn":["String"],"UseByDate":"0001-01-01T00:00:00.0000000","UseByDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","UseByDateGreaterThan":"0001-01-01T00:00:00.0000000","UseByDateLessThan":"0001-01-01T00:00:00.0000000","UseByDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","UseByDateNotEqualTo":"0001-01-01T00:00:00.0000000","UseByDateBetween":["0001-01-01T00:00:00.0000000"],"UseByDateIn":["0001-01-01T00:00:00.0000000"],"Reference":"String","ReferenceStartsWith":"String","ReferenceEndsWith":"String","ReferenceContains":"String","ReferenceLike":"String","ReferenceBetween":["String"],"ReferenceIn":["String"],"LabelNumber":0,"LabelNumberGreaterThanOrEqualTo":0,"LabelNumberGreaterThan":0,"LabelNumberLessThan":0,"LabelNumberLessThanOrEqualTo":0,"LabelNumberNotEqualTo":0,"LabelNumberBetween":[0],"LabelNumberIn":[0],"SpareString1":"String","SpareString1StartsWith":"String","SpareString1EndsWith":"String","SpareString1Contains":"String","SpareString1Like":"String","SpareString1Between":["String"],"SpareString1In":["String"],"SpareString2":"String","SpareString2StartsWith":"String","SpareString2EndsWith":"String","SpareString2Contains":"String","SpareString2Like":"String","SpareString2Between":["String"],"SpareString2In":["String"],"SpareString3":"String","SpareString3StartsWith":"String","SpareString3EndsWith":"String","SpareString3Contains":"String","SpareString3Like":"String","SpareString3Between":["String"],"SpareString3In":["String"],"SpareNumeric1":0,"SpareNumeric1GreaterThanOrEqualTo":0,"SpareNumeric1GreaterThan":0,"SpareNumeric1LessThan":0,"SpareNumeric1LessThanOrEqualTo":0,"SpareNumeric1NotEqualTo":0,"SpareNumeric1Between":[0],"SpareNumeric1In":[0],"SpareNumeric2":0,"SpareNumeric2GreaterThanOrEqualTo":0,"SpareNumeric2GreaterThan":0,"SpareNumeric2LessThan":0,"SpareNumeric2LessThanOrEqualTo":0,"SpareNumeric2NotEqualTo":0,"SpareNumeric2Between":[0],"SpareNumeric2In":[0],"SpareNumeric3":0,"SpareNumeric3GreaterThanOrEqualTo":0,"SpareNumeric3GreaterThan":0,"SpareNumeric3LessThan":0,"SpareNumeric3LessThanOrEqualTo":0,"SpareNumeric3NotEqualTo":0,"SpareNumeric3Between":[0],"SpareNumeric3In":[0],"SpareDate1":"0001-01-01T00:00:00.0000000","SpareDate1GreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","SpareDate1GreaterThan":"0001-01-01T00:00:00.0000000","SpareDate1LessThan":"0001-01-01T00:00:00.0000000","SpareDate1LessThanOrEqualTo":"0001-01-01T00:00:00.0000000","SpareDate1NotEqualTo":"0001-01-01T00:00:00.0000000","SpareDate1Between":["0001-01-01T00:00:00.0000000"],"SpareDate1In":["0001-01-01T00:00:00.0000000"],"SpareDate2":"0001-01-01T00:00:00.0000000","SpareDate2GreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","SpareDate2GreaterThan":"0001-01-01T00:00:00.0000000","SpareDate2LessThan":"0001-01-01T00:00:00.0000000","SpareDate2LessThanOrEqualTo":"0001-01-01T00:00:00.0000000","SpareDate2NotEqualTo":"0001-01-01T00:00:00.0000000","SpareDate2Between":["0001-01-01T00:00:00.0000000"],"SpareDate2In":["0001-01-01T00:00:00.0000000"],"SpareDate3":"0001-01-01T00:00:00.0000000","SpareDate3GreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","SpareDate3GreaterThan":"0001-01-01T00:00:00.0000000","SpareDate3LessThan":"0001-01-01T00:00:00.0000000","SpareDate3LessThanOrEqualTo":"0001-01-01T00:00:00.0000000","SpareDate3NotEqualTo":"0001-01-01T00:00:00.0000000","SpareDate3Between":["0001-01-01T00:00:00.0000000"],"SpareDate3In":["0001-01-01T00:00:00.0000000"],"LastSavedDateTime":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeBetween":["0001-01-01T00:00:00.0000000"],"LastSavedDateTimeIn":["0001-01-01T00:00:00.0000000"],"Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}
HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length

{"Results":[{"RecID":"String","SO_Lines_InvoiceLineID":"String","SSCC_Number":"String","BatchNo":"String","UseByDate":"0001-01-01T00:00:00.0000000","Reference":"String","SpareString1":"String","SpareString2":"String","SpareString3":"String","SpareNumeric1":0,"SpareNumeric2":0,"SpareNumeric3":0,"SpareDate1":"0001-01-01T00:00:00.0000000","SpareDate2":"0001-01-01T00:00:00.0000000","SpareDate3":"0001-01-01T00:00:00.0000000"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}