JiwaAPI

<back to all web services

IN_SellingPricesQuery

Requires Authentication
IN_SellingPricesQuery Parameters:
NameParameterData TypeRequiredDescription
InventoryIDquerystringNo
InventoryIDStartsWithquerystringNo
InventoryIDEndsWithquerystringNo
InventoryIDContainsquerystringNo
InventoryIDLikequerystringNo
InventoryIDBetweenquerystring[]No
InventoryIDInquerystring[]No
ForwardPriceDatequeryDateTime?No
ForwardPriceDateGreaterThanOrEqualToqueryDateTime?No
ForwardPriceDateGreaterThanqueryDateTime?No
ForwardPriceDateLessThanqueryDateTime?No
ForwardPriceDateLessThanOrEqualToqueryDateTime?No
ForwardPriceDateNotEqualToqueryDateTime?No
ForwardPriceDateBetweenqueryDateTime[]No
ForwardPriceDateInqueryDateTime[]No
CurrentPriceDatequeryDateTime?No
CurrentPriceDateGreaterThanOrEqualToqueryDateTime?No
CurrentPriceDateGreaterThanqueryDateTime?No
CurrentPriceDateLessThanqueryDateTime?No
CurrentPriceDateLessThanOrEqualToqueryDateTime?No
CurrentPriceDateNotEqualToqueryDateTime?No
CurrentPriceDateBetweenqueryDateTime[]No
CurrentPriceDateInqueryDateTime[]No
Price1querydecimal?No
Price1GreaterThanOrEqualToquerydecimal?No
Price1GreaterThanquerydecimal?No
Price1LessThanquerydecimal?No
Price1LessThanOrEqualToquerydecimal?No
Price1NotEqualToquerydecimal?No
Price1BetweenqueryNullable<Decimal>[]No
Price1InqueryNullable<Decimal>[]No
ForwardPrice1querydecimal?No
ForwardPrice1GreaterThanOrEqualToquerydecimal?No
ForwardPrice1GreaterThanquerydecimal?No
ForwardPrice1LessThanquerydecimal?No
ForwardPrice1LessThanOrEqualToquerydecimal?No
ForwardPrice1NotEqualToquerydecimal?No
ForwardPrice1BetweenqueryNullable<Decimal>[]No
ForwardPrice1InqueryNullable<Decimal>[]No
Price1IsIncTaxquerybool?No
Price2querydecimal?No
Price2GreaterThanOrEqualToquerydecimal?No
Price2GreaterThanquerydecimal?No
Price2LessThanquerydecimal?No
Price2LessThanOrEqualToquerydecimal?No
Price2NotEqualToquerydecimal?No
Price2BetweenqueryNullable<Decimal>[]No
Price2InqueryNullable<Decimal>[]No
ForwardPrice2querydecimal?No
ForwardPrice2GreaterThanOrEqualToquerydecimal?No
ForwardPrice2GreaterThanquerydecimal?No
ForwardPrice2LessThanquerydecimal?No
ForwardPrice2LessThanOrEqualToquerydecimal?No
ForwardPrice2NotEqualToquerydecimal?No
ForwardPrice2BetweenqueryNullable<Decimal>[]No
ForwardPrice2InqueryNullable<Decimal>[]No
Price2IsIncTaxquerybool?No
Price3querydecimal?No
Price3GreaterThanOrEqualToquerydecimal?No
Price3GreaterThanquerydecimal?No
Price3LessThanquerydecimal?No
Price3LessThanOrEqualToquerydecimal?No
Price3NotEqualToquerydecimal?No
Price3BetweenqueryNullable<Decimal>[]No
Price3InqueryNullable<Decimal>[]No
ForwardPrice3querydecimal?No
ForwardPrice3GreaterThanOrEqualToquerydecimal?No
ForwardPrice3GreaterThanquerydecimal?No
ForwardPrice3LessThanquerydecimal?No
ForwardPrice3LessThanOrEqualToquerydecimal?No
ForwardPrice3NotEqualToquerydecimal?No
ForwardPrice3BetweenqueryNullable<Decimal>[]No
ForwardPrice3InqueryNullable<Decimal>[]No
Price3IsIncTaxquerybool?No
Price4querydecimal?No
Price4GreaterThanOrEqualToquerydecimal?No
Price4GreaterThanquerydecimal?No
Price4LessThanquerydecimal?No
Price4LessThanOrEqualToquerydecimal?No
Price4NotEqualToquerydecimal?No
Price4BetweenqueryNullable<Decimal>[]No
Price4InqueryNullable<Decimal>[]No
ForwardPrice4querydecimal?No
ForwardPrice4GreaterThanOrEqualToquerydecimal?No
ForwardPrice4GreaterThanquerydecimal?No
ForwardPrice4LessThanquerydecimal?No
ForwardPrice4LessThanOrEqualToquerydecimal?No
ForwardPrice4NotEqualToquerydecimal?No
ForwardPrice4BetweenqueryNullable<Decimal>[]No
ForwardPrice4InqueryNullable<Decimal>[]No
Price4IsIncTaxquerybool?No
Price5querydecimal?No
Price5GreaterThanOrEqualToquerydecimal?No
Price5GreaterThanquerydecimal?No
Price5LessThanquerydecimal?No
Price5LessThanOrEqualToquerydecimal?No
Price5NotEqualToquerydecimal?No
Price5BetweenqueryNullable<Decimal>[]No
Price5InqueryNullable<Decimal>[]No
ForwardPrice5querydecimal?No
ForwardPrice5GreaterThanOrEqualToquerydecimal?No
ForwardPrice5GreaterThanquerydecimal?No
ForwardPrice5LessThanquerydecimal?No
ForwardPrice5LessThanOrEqualToquerydecimal?No
ForwardPrice5NotEqualToquerydecimal?No
ForwardPrice5BetweenqueryNullable<Decimal>[]No
ForwardPrice5InqueryNullable<Decimal>[]No
Price5IsIncTaxquerybool?No
Price6querydecimal?No
Price6GreaterThanOrEqualToquerydecimal?No
Price6GreaterThanquerydecimal?No
Price6LessThanquerydecimal?No
Price6LessThanOrEqualToquerydecimal?No
Price6NotEqualToquerydecimal?No
Price6BetweenqueryNullable<Decimal>[]No
Price6InqueryNullable<Decimal>[]No
ForwardPrice6querydecimal?No
ForwardPrice6GreaterThanOrEqualToquerydecimal?No
ForwardPrice6GreaterThanquerydecimal?No
ForwardPrice6LessThanquerydecimal?No
ForwardPrice6LessThanOrEqualToquerydecimal?No
ForwardPrice6NotEqualToquerydecimal?No
ForwardPrice6BetweenqueryNullable<Decimal>[]No
ForwardPrice6InqueryNullable<Decimal>[]No
Price6IsIncTaxquerybool?No
Price7querydecimal?No
Price7GreaterThanOrEqualToquerydecimal?No
Price7GreaterThanquerydecimal?No
Price7LessThanquerydecimal?No
Price7LessThanOrEqualToquerydecimal?No
Price7NotEqualToquerydecimal?No
Price7BetweenqueryNullable<Decimal>[]No
Price7InqueryNullable<Decimal>[]No
ForwardPrice7querydecimal?No
ForwardPrice7GreaterThanOrEqualToquerydecimal?No
ForwardPrice7GreaterThanquerydecimal?No
ForwardPrice7LessThanquerydecimal?No
ForwardPrice7LessThanOrEqualToquerydecimal?No
ForwardPrice7NotEqualToquerydecimal?No
ForwardPrice7BetweenqueryNullable<Decimal>[]No
ForwardPrice7InqueryNullable<Decimal>[]No
Price7IsIncTaxquerybool?No
Price8querydecimal?No
Price8GreaterThanOrEqualToquerydecimal?No
Price8GreaterThanquerydecimal?No
Price8LessThanquerydecimal?No
Price8LessThanOrEqualToquerydecimal?No
Price8NotEqualToquerydecimal?No
Price8BetweenqueryNullable<Decimal>[]No
Price8InqueryNullable<Decimal>[]No
ForwardPrice8querydecimal?No
ForwardPrice8GreaterThanOrEqualToquerydecimal?No
ForwardPrice8GreaterThanquerydecimal?No
ForwardPrice8LessThanquerydecimal?No
ForwardPrice8LessThanOrEqualToquerydecimal?No
ForwardPrice8NotEqualToquerydecimal?No
ForwardPrice8BetweenqueryNullable<Decimal>[]No
ForwardPrice8InqueryNullable<Decimal>[]No
Price8IsIncTaxquerybool?No
Price9querydecimal?No
Price9GreaterThanOrEqualToquerydecimal?No
Price9GreaterThanquerydecimal?No
Price9LessThanquerydecimal?No
Price9LessThanOrEqualToquerydecimal?No
Price9NotEqualToquerydecimal?No
Price9BetweenqueryNullable<Decimal>[]No
Price9InqueryNullable<Decimal>[]No
ForwardPrice9querydecimal?No
ForwardPrice9GreaterThanOrEqualToquerydecimal?No
ForwardPrice9GreaterThanquerydecimal?No
ForwardPrice9LessThanquerydecimal?No
ForwardPrice9LessThanOrEqualToquerydecimal?No
ForwardPrice9NotEqualToquerydecimal?No
ForwardPrice9BetweenqueryNullable<Decimal>[]No
ForwardPrice9InqueryNullable<Decimal>[]No
Price9IsIncTaxquerybool?No
Price10querydecimal?No
Price10GreaterThanOrEqualToquerydecimal?No
Price10GreaterThanquerydecimal?No
Price10LessThanquerydecimal?No
Price10LessThanOrEqualToquerydecimal?No
Price10NotEqualToquerydecimal?No
Price10BetweenqueryNullable<Decimal>[]No
Price10InqueryNullable<Decimal>[]No
ForwardPrice10querydecimal?No
ForwardPrice10GreaterThanOrEqualToquerydecimal?No
ForwardPrice10GreaterThanquerydecimal?No
ForwardPrice10LessThanquerydecimal?No
ForwardPrice10LessThanOrEqualToquerydecimal?No
ForwardPrice10NotEqualToquerydecimal?No
ForwardPrice10BetweenqueryNullable<Decimal>[]No
ForwardPrice10InqueryNullable<Decimal>[]No
Price10IsIncTaxquerybool?No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
IN_SellingPrices Parameters:
NameParameterData TypeRequiredDescription
InventoryIDformstringNo
ForwardPriceDateformDateTimeNo
CurrentPriceDateformDateTimeNo
Price1formdecimal?No
ForwardPrice1formdecimal?No
Price1IsIncTaxformbool?No
Price2formdecimal?No
ForwardPrice2formdecimal?No
Price2IsIncTaxformbool?No
Price3formdecimal?No
ForwardPrice3formdecimal?No
Price3IsIncTaxformbool?No
Price4formdecimal?No
ForwardPrice4formdecimal?No
Price4IsIncTaxformbool?No
Price5formdecimal?No
ForwardPrice5formdecimal?No
Price5IsIncTaxformbool?No
Price6formdecimal?No
ForwardPrice6formdecimal?No
Price6IsIncTaxformbool?No
Price7formdecimal?No
ForwardPrice7formdecimal?No
Price7IsIncTaxformbool?No
Price8formdecimal?No
ForwardPrice8formdecimal?No
Price8IsIncTaxformbool?No
Price9formdecimal?No
ForwardPrice9formdecimal?No
Price9IsIncTaxformbool?No
Price10formdecimal?No
ForwardPrice10formdecimal?No
Price10IsIncTaxformbool?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/IN_SellingPricesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"ForwardPriceDate":"0001-01-01T00:00:00.0000000","ForwardPriceDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ForwardPriceDateGreaterThan":"0001-01-01T00:00:00.0000000","ForwardPriceDateLessThan":"0001-01-01T00:00:00.0000000","ForwardPriceDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ForwardPriceDateNotEqualTo":"0001-01-01T00:00:00.0000000","ForwardPriceDateBetween":["0001-01-01T00:00:00.0000000"],"ForwardPriceDateIn":["0001-01-01T00:00:00.0000000"],"CurrentPriceDate":"0001-01-01T00:00:00.0000000","CurrentPriceDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","CurrentPriceDateGreaterThan":"0001-01-01T00:00:00.0000000","CurrentPriceDateLessThan":"0001-01-01T00:00:00.0000000","CurrentPriceDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","CurrentPriceDateNotEqualTo":"0001-01-01T00:00:00.0000000","CurrentPriceDateBetween":["0001-01-01T00:00:00.0000000"],"CurrentPriceDateIn":["0001-01-01T00:00:00.0000000"],"Price1":0,"Price1GreaterThanOrEqualTo":0,"Price1GreaterThan":0,"Price1LessThan":0,"Price1LessThanOrEqualTo":0,"Price1NotEqualTo":0,"Price1Between":[0],"Price1In":[0],"ForwardPrice1":0,"ForwardPrice1GreaterThanOrEqualTo":0,"ForwardPrice1GreaterThan":0,"ForwardPrice1LessThan":0,"ForwardPrice1LessThanOrEqualTo":0,"ForwardPrice1NotEqualTo":0,"ForwardPrice1Between":[0],"ForwardPrice1In":[0],"Price1IsIncTax":false,"Price2":0,"Price2GreaterThanOrEqualTo":0,"Price2GreaterThan":0,"Price2LessThan":0,"Price2LessThanOrEqualTo":0,"Price2NotEqualTo":0,"Price2Between":[0],"Price2In":[0],"ForwardPrice2":0,"ForwardPrice2GreaterThanOrEqualTo":0,"ForwardPrice2GreaterThan":0,"ForwardPrice2LessThan":0,"ForwardPrice2LessThanOrEqualTo":0,"ForwardPrice2NotEqualTo":0,"ForwardPrice2Between":[0],"ForwardPrice2In":[0],"Price2IsIncTax":false,"Price3":0,"Price3GreaterThanOrEqualTo":0,"Price3GreaterThan":0,"Price3LessThan":0,"Price3LessThanOrEqualTo":0,"Price3NotEqualTo":0,"Price3Between":[0],"Price3In":[0],"ForwardPrice3":0,"ForwardPrice3GreaterThanOrEqualTo":0,"ForwardPrice3GreaterThan":0,"ForwardPrice3LessThan":0,"ForwardPrice3LessThanOrEqualTo":0,"ForwardPrice3NotEqualTo":0,"ForwardPrice3Between":[0],"ForwardPrice3In":[0],"Price3IsIncTax":false,"Price4":0,"Price4GreaterThanOrEqualTo":0,"Price4GreaterThan":0,"Price4LessThan":0,"Price4LessThanOrEqualTo":0,"Price4NotEqualTo":0,"Price4Between":[0],"Price4In":[0],"ForwardPrice4":0,"ForwardPrice4GreaterThanOrEqualTo":0,"ForwardPrice4GreaterThan":0,"ForwardPrice4LessThan":0,"ForwardPrice4LessThanOrEqualTo":0,"ForwardPrice4NotEqualTo":0,"ForwardPrice4Between":[0],"ForwardPrice4In":[0],"Price4IsIncTax":false,"Price5":0,"Price5GreaterThanOrEqualTo":0,"Price5GreaterThan":0,"Price5LessThan":0,"Price5LessThanOrEqualTo":0,"Price5NotEqualTo":0,"Price5Between":[0],"Price5In":[0],"ForwardPrice5":0,"ForwardPrice5GreaterThanOrEqualTo":0,"ForwardPrice5GreaterThan":0,"ForwardPrice5LessThan":0,"ForwardPrice5LessThanOrEqualTo":0,"ForwardPrice5NotEqualTo":0,"ForwardPrice5Between":[0],"ForwardPrice5In":[0],"Price5IsIncTax":false,"Price6":0,"Price6GreaterThanOrEqualTo":0,"Price6GreaterThan":0,"Price6LessThan":0,"Price6LessThanOrEqualTo":0,"Price6NotEqualTo":0,"Price6Between":[0],"Price6In":[0],"ForwardPrice6":0,"ForwardPrice6GreaterThanOrEqualTo":0,"ForwardPrice6GreaterThan":0,"ForwardPrice6LessThan":0,"ForwardPrice6LessThanOrEqualTo":0,"ForwardPrice6NotEqualTo":0,"ForwardPrice6Between":[0],"ForwardPrice6In":[0],"Price6IsIncTax":false,"Price7":0,"Price7GreaterThanOrEqualTo":0,"Price7GreaterThan":0,"Price7LessThan":0,"Price7LessThanOrEqualTo":0,"Price7NotEqualTo":0,"Price7Between":[0],"Price7In":[0],"ForwardPrice7":0,"ForwardPrice7GreaterThanOrEqualTo":0,"ForwardPrice7GreaterThan":0,"ForwardPrice7LessThan":0,"ForwardPrice7LessThanOrEqualTo":0,"ForwardPrice7NotEqualTo":0,"ForwardPrice7Between":[0],"ForwardPrice7In":[0],"Price7IsIncTax":false,"Price8":0,"Price8GreaterThanOrEqualTo":0,"Price8GreaterThan":0,"Price8LessThan":0,"Price8LessThanOrEqualTo":0,"Price8NotEqualTo":0,"Price8Between":[0],"Price8In":[0],"ForwardPrice8":0,"ForwardPrice8GreaterThanOrEqualTo":0,"ForwardPrice8GreaterThan":0,"ForwardPrice8LessThan":0,"ForwardPrice8LessThanOrEqualTo":0,"ForwardPrice8NotEqualTo":0,"ForwardPrice8Between":[0],"ForwardPrice8In":[0],"Price8IsIncTax":false,"Price9":0,"Price9GreaterThanOrEqualTo":0,"Price9GreaterThan":0,"Price9LessThan":0,"Price9LessThanOrEqualTo":0,"Price9NotEqualTo":0,"Price9Between":[0],"Price9In":[0],"ForwardPrice9":0,"ForwardPrice9GreaterThanOrEqualTo":0,"ForwardPrice9GreaterThan":0,"ForwardPrice9LessThan":0,"ForwardPrice9LessThanOrEqualTo":0,"ForwardPrice9NotEqualTo":0,"ForwardPrice9Between":[0],"ForwardPrice9In":[0],"Price9IsIncTax":false,"Price10":0,"Price10GreaterThanOrEqualTo":0,"Price10GreaterThan":0,"Price10LessThan":0,"Price10LessThanOrEqualTo":0,"Price10NotEqualTo":0,"Price10Between":[0],"Price10In":[0],"ForwardPrice10":0,"ForwardPrice10GreaterThanOrEqualTo":0,"ForwardPrice10GreaterThan":0,"ForwardPrice10LessThan":0,"ForwardPrice10LessThanOrEqualTo":0,"ForwardPrice10NotEqualTo":0,"ForwardPrice10Between":[0],"ForwardPrice10In":[0],"Price10IsIncTax":false,"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":[{"InventoryID":"String","Price1":0,"ForwardPrice1":0,"Price1IsIncTax":false,"Price2":0,"ForwardPrice2":0,"Price2IsIncTax":false,"Price3":0,"ForwardPrice3":0,"Price3IsIncTax":false,"Price4":0,"ForwardPrice4":0,"Price4IsIncTax":false,"Price5":0,"ForwardPrice5":0,"Price5IsIncTax":false,"Price6":0,"ForwardPrice6":0,"Price6IsIncTax":false,"Price7":0,"ForwardPrice7":0,"Price7IsIncTax":false,"Price8":0,"ForwardPrice8":0,"Price8IsIncTax":false,"Price9":0,"ForwardPrice9":0,"Price9IsIncTax":false,"Price10":0,"ForwardPrice10":0,"Price10IsIncTax":false}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}