JiwaAPI

PR_ClassificationPricingQuery

The following routes are available for this service:
GET	/Queries/PR_ClassificationPricing	Retrieves the debtor and inventory classification pricing matrix.

**PR_ClassificationPricingQuery** Parameters:
Name	Parameter	Data Type	Required
RecID	query	string	No
RecIDStartsWith	query	string	No
RecIDEndsWith	query	string	No
RecIDContains	query	string	No
RecIDLike	query	string	No
RecIDBetween	query	string[]	No
RecIDIn	query	string[]	No
DB_Classification_RecID	query	string	No
DB_Classification_RecIDStartsWith	query	string	No
DB_Classification_RecIDEndsWith	query	string	No
DB_Classification_RecIDContains	query	string	No
DB_Classification_RecIDLike	query	string	No
DB_Classification_RecIDBetween	query	string[]	No
DB_Classification_RecIDIn	query	string[]	No
IN_Classification_RecID	query	string	No
IN_Classification_RecIDStartsWith	query	string	No
IN_Classification_RecIDEndsWith	query	string	No
IN_Classification_RecIDContains	query	string	No
IN_Classification_RecIDLike	query	string	No
IN_Classification_RecIDBetween	query	string[]	No
IN_Classification_RecIDIn	query	string[]	No
Source	query	byte?	No
SourceGreaterThanOrEqualTo	query	byte?	No
SourceGreaterThan	query	byte?	No
SourceLessThan	query	byte?	No
SourceLessThanOrEqualTo	query	byte?	No
SourceNotEqualTo	query	byte?	No
SourceBetween	query	byte[]	No
SourceIn	query	byte[]	No
Mode	query	byte?	No
ModeGreaterThanOrEqualTo	query	byte?	No
ModeGreaterThan	query	byte?	No
ModeLessThan	query	byte?	No
ModeLessThanOrEqualTo	query	byte?	No
ModeNotEqualTo	query	byte?	No
ModeBetween	query	byte[]	No
ModeIn	query	byte[]	No
Amount	query	decimal?	No
AmountGreaterThanOrEqualTo	query	decimal?	No
AmountGreaterThan	query	decimal?	No
AmountLessThan	query	decimal?	No
AmountLessThanOrEqualTo	query	decimal?	No
AmountNotEqualTo	query	decimal?	No
AmountBetween	query	decimal[]	No
AmountIn	query	decimal[]	No
StartDate	query	DateTime?	No
StartDateGreaterThanOrEqualTo	query	DateTime?	No
StartDateGreaterThan	query	DateTime?	No
StartDateLessThan	query	DateTime?	No
StartDateLessThanOrEqualTo	query	DateTime?	No
StartDateNotEqualTo	query	DateTime?	No
StartDateBetween	query	DateTime[]	No
StartDateIn	query	DateTime[]	No
EndDate	query	DateTime?	No
EndDateGreaterThanOrEqualTo	query	DateTime?	No
EndDateGreaterThan	query	DateTime?	No
EndDateLessThan	query	DateTime?	No
EndDateLessThanOrEqualTo	query	DateTime?	No
EndDateNotEqualTo	query	DateTime?	No
EndDateBetween	query	DateTime[]	No
EndDateIn	query	DateTime[]	No
UseQuantityBreak	query	bool?	No
QuantityBreak	query	decimal?	No
QuantityBreakGreaterThanOrEqualTo	query	decimal?	No
QuantityBreakGreaterThan	query	decimal?	No
QuantityBreakLessThan	query	decimal?	No
QuantityBreakLessThanOrEqualTo	query	decimal?	No
QuantityBreakNotEqualTo	query	decimal?	No
QuantityBreakBetween	query	decimal[]	No
QuantityBreakIn	query	decimal[]	No
RowHash	query	byte[]	No
ItemNo	query	int?	No
ItemNoGreaterThanOrEqualTo	query	int?	No
ItemNoGreaterThan	query	int?	No
ItemNoLessThan	query	int?	No
ItemNoLessThanOrEqualTo	query	int?	No
ItemNoNotEqualTo	query	int?	No
ItemNoBetween	query	int[]	No
ItemNoIn	query	int[]	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

**PR_ClassificationPricing** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
DB_Classification_RecID	form	string	No
IN_Classification_RecID	form	string	No
Source	form	byte	No
Mode	form	byte	No
Amount	form	decimal	No
StartDate	form	DateTime	No
EndDate	form	DateTime	No
UseQuantityBreak	form	bool	No
QuantityBreak	form	decimal	No
RowHash	form	byte[]	No
ItemNo	form	int	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/PR_ClassificationPricing HTTP/1.1 
Host: testapi.wagga.redpoint.com.au 
Accept: text/csv

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

{"Results":[{"RecID":"String","DB_Classification_RecID":"String","IN_Classification_RecID":"String","RowHash":"AA=="}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}