JiwaAPI

<back to all web services

JB_CostLineDetailsQuery

Requires Authentication
JB_CostLineDetailsQuery Parameters:
NameParameterData TypeRequiredDescription
DetailsLineIDquerystringNo
DetailsLineIDStartsWithquerystringNo
DetailsLineIDEndsWithquerystringNo
DetailsLineIDContainsquerystringNo
DetailsLineIDLikequerystringNo
DetailsLineIDBetweenquerystring[]No
DetailsLineIDInquerystring[]No
CostEntryLineIDquerystringNo
CostEntryLineIDStartsWithquerystringNo
CostEntryLineIDEndsWithquerystringNo
CostEntryLineIDContainsquerystringNo
CostEntryLineIDLikequerystringNo
CostEntryLineIDBetweenquerystring[]No
CostEntryLineIDInquerystring[]No
SOHIDquerystringNo
SOHIDStartsWithquerystringNo
SOHIDEndsWithquerystringNo
SOHIDContainsquerystringNo
SOHIDLikequerystringNo
SOHIDBetweenquerystring[]No
SOHIDInquerystring[]No
Costquerydecimal?No
CostGreaterThanOrEqualToquerydecimal?No
CostGreaterThanquerydecimal?No
CostLessThanquerydecimal?No
CostLessThanOrEqualToquerydecimal?No
CostNotEqualToquerydecimal?No
CostBetweenqueryNullable<Decimal>[]No
CostInqueryNullable<Decimal>[]No
Quantityquerydecimal?No
QuantityGreaterThanOrEqualToquerydecimal?No
QuantityGreaterThanquerydecimal?No
QuantityLessThanquerydecimal?No
QuantityLessThanOrEqualToquerydecimal?No
QuantityNotEqualToquerydecimal?No
QuantityBetweenqueryNullable<Decimal>[]No
QuantityInqueryNullable<Decimal>[]No
SerialNoquerystringNo
SerialNoStartsWithquerystringNo
SerialNoEndsWithquerystringNo
SerialNoContainsquerystringNo
SerialNoLikequerystringNo
SerialNoBetweenquerystring[]No
SerialNoInquerystring[]No
ExpiryDatequeryDateTime?No
ExpiryDateGreaterThanOrEqualToqueryDateTime?No
ExpiryDateGreaterThanqueryDateTime?No
ExpiryDateLessThanqueryDateTime?No
ExpiryDateLessThanOrEqualToqueryDateTime?No
ExpiryDateNotEqualToqueryDateTime?No
ExpiryDateBetweenqueryNullable<DateTime>[]No
ExpiryDateInqueryNullable<DateTime>[]No
BinLocationquerystringNo
BinLocationStartsWithquerystringNo
BinLocationEndsWithquerystringNo
BinLocationContainsquerystringNo
BinLocationLikequerystringNo
BinLocationBetweenquerystring[]No
BinLocationInquerystring[]No
DateInqueryDateTime?No
DateInGreaterThanOrEqualToqueryDateTime?No
DateInGreaterThanqueryDateTime?No
DateInLessThanqueryDateTime?No
DateInLessThanOrEqualToqueryDateTime?No
DateInNotEqualToqueryDateTime?No
DateInBetweenqueryNullable<DateTime>[]No
DateInInqueryNullable<DateTime>[]No
DeliveredDatequeryDateTime?No
DeliveredDateGreaterThanOrEqualToqueryDateTime?No
DeliveredDateGreaterThanqueryDateTime?No
DeliveredDateLessThanqueryDateTime?No
DeliveredDateLessThanOrEqualToqueryDateTime?No
DeliveredDateNotEqualToqueryDateTime?No
DeliveredDateBetweenqueryNullable<DateTime>[]No
DeliveredDateInqueryNullable<DateTime>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
JB_CostLineDetails Parameters:
NameParameterData TypeRequiredDescription
DetailsLineIDformstringNo
CostEntryLineIDformstringNo
SOHIDformstringNo
Costformdecimal?No
Quantityformdecimal?No
SerialNoformstringNo
ExpiryDateformDateTime?No
BinLocationformstringNo
DateInformDateTime?No
DeliveredDateformDateTime?No
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.

POST /csv/reply/JB_CostLineDetailsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"DetailsLineID":"String","DetailsLineIDStartsWith":"String","DetailsLineIDEndsWith":"String","DetailsLineIDContains":"String","DetailsLineIDLike":"String","DetailsLineIDBetween":["String"],"DetailsLineIDIn":["String"],"CostEntryLineID":"String","CostEntryLineIDStartsWith":"String","CostEntryLineIDEndsWith":"String","CostEntryLineIDContains":"String","CostEntryLineIDLike":"String","CostEntryLineIDBetween":["String"],"CostEntryLineIDIn":["String"],"SOHID":"String","SOHIDStartsWith":"String","SOHIDEndsWith":"String","SOHIDContains":"String","SOHIDLike":"String","SOHIDBetween":["String"],"SOHIDIn":["String"],"Cost":0,"CostGreaterThanOrEqualTo":0,"CostGreaterThan":0,"CostLessThan":0,"CostLessThanOrEqualTo":0,"CostNotEqualTo":0,"CostBetween":[0],"CostIn":[0],"Quantity":0,"QuantityGreaterThanOrEqualTo":0,"QuantityGreaterThan":0,"QuantityLessThan":0,"QuantityLessThanOrEqualTo":0,"QuantityNotEqualTo":0,"QuantityBetween":[0],"QuantityIn":[0],"SerialNo":"String","SerialNoStartsWith":"String","SerialNoEndsWith":"String","SerialNoContains":"String","SerialNoLike":"String","SerialNoBetween":["String"],"SerialNoIn":["String"],"ExpiryDate":"0001-01-01T00:00:00.0000000","ExpiryDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ExpiryDateGreaterThan":"0001-01-01T00:00:00.0000000","ExpiryDateLessThan":"0001-01-01T00:00:00.0000000","ExpiryDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ExpiryDateNotEqualTo":"0001-01-01T00:00:00.0000000","ExpiryDateBetween":["0001-01-01T00:00:00.0000000"],"ExpiryDateIn":["0001-01-01T00:00:00.0000000"],"BinLocation":"String","BinLocationStartsWith":"String","BinLocationEndsWith":"String","BinLocationContains":"String","BinLocationLike":"String","BinLocationBetween":["String"],"BinLocationIn":["String"],"DateIn":"0001-01-01T00:00:00.0000000","DateInGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","DateInGreaterThan":"0001-01-01T00:00:00.0000000","DateInLessThan":"0001-01-01T00:00:00.0000000","DateInLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","DateInNotEqualTo":"0001-01-01T00:00:00.0000000","DateInBetween":["0001-01-01T00:00:00.0000000"],"DateInIn":["0001-01-01T00:00:00.0000000"],"DeliveredDate":"0001-01-01T00:00:00.0000000","DeliveredDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","DeliveredDateGreaterThan":"0001-01-01T00:00:00.0000000","DeliveredDateLessThan":"0001-01-01T00:00:00.0000000","DeliveredDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","DeliveredDateNotEqualTo":"0001-01-01T00:00:00.0000000","DeliveredDateBetween":["0001-01-01T00:00:00.0000000"],"DeliveredDateIn":["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: text/csv
Content-Length: length

{"Results":[{"DetailsLineID":"String","CostEntryLineID":"String","SOHID":"String","Cost":0,"Quantity":0,"SerialNo":"String","ExpiryDate":"0001-01-01T00:00:00.0000000","BinLocation":"String","DateIn":"0001-01-01T00:00:00.0000000","DeliveredDate":"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"}}}