JiwaAPI

IN_PricingGroupMatrixQuery

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

**IN_PricingGroupMatrixQuery** 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
IN_PricingGroups_RecID	query	string	No
IN_PricingGroups_RecIDStartsWith	query	string	No
IN_PricingGroups_RecIDEndsWith	query	string	No
IN_PricingGroups_RecIDContains	query	string	No
IN_PricingGroups_RecIDLike	query	string	No
IN_PricingGroups_RecIDBetween	query	string[]	No
IN_PricingGroups_RecIDIn	query	string[]	No
DB_PricingGroups_RecID	query	string	No
DB_PricingGroups_RecIDStartsWith	query	string	No
DB_PricingGroups_RecIDEndsWith	query	string	No
DB_PricingGroups_RecIDContains	query	string	No
DB_PricingGroups_RecIDLike	query	string	No
DB_PricingGroups_RecIDBetween	query	string[]	No
DB_PricingGroups_RecIDIn	query	string[]	No
SourcePrice	query	short?	No
SourcePriceGreaterThanOrEqualTo	query	short?	No
SourcePriceGreaterThan	query	short?	No
SourcePriceLessThan	query	short?	No
SourcePriceLessThanOrEqualTo	query	short?	No
SourcePriceNotEqualTo	query	short?	No
SourcePriceBetween	query	short[]	No
SourcePriceIn	query	short[]	No
Mode	query	short?	No
ModeGreaterThanOrEqualTo	query	short?	No
ModeGreaterThan	query	short?	No
ModeLessThan	query	short?	No
ModeLessThanOrEqualTo	query	short?	No
ModeNotEqualTo	query	short?	No
ModeBetween	query	short[]	No
ModeIn	query	short[]	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
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	Nullable<Decimal>[]	No
QuantityBreakIn	query	Nullable<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
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	Nullable<DateTime>[]	No
StartDateIn	query	Nullable<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	Nullable<DateTime>[]	No
EndDateIn	query	Nullable<DateTime>[]	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

**IN_PricingGroupMatrix** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
IN_PricingGroups_RecID	form	string	No
DB_PricingGroups_RecID	form	string	No
SourcePrice	form	short	No
Mode	form	short	No
Amount	form	decimal	No
UseQuantityBreak	form	bool?	No
QuantityBreak	form	decimal?	No
RowHash	form	byte[]	No
ItemNo	form	int	No
StartDate	form	DateTime?	No
EndDate	form	DateTime?	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/IN_PricingGroupMatrix 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","IN_PricingGroups_RecID":"String","DB_PricingGroups_RecID":"String","UseQuantityBreak":false,"QuantityBreak":0,"RowHash":"AA==","StartDate":"0001-01-01T00:00:00.0000000","EndDate":"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"}}}