To get the TOTAL COUNT of list of items price lists for multiple search criteria.
Use this method with only_counted = 'Y' FIRST to determine how many total records there are for the given criteria.
After you call this method with only_counted = 'Y', then call again this method with only_counted = 'N', and pass the required paging parameters.
To get a list of items price lists for multiple search criteria.
| field |
type |
description |
| api_credentials
|
| token |
string |
Credentials provided by Powersoft that allow access to the API |
| filter_define
|
| only_counted |
string |
'Y' = brings only the total of items price lists found based on user filter criteria. 'N' = brings the list of the item price lists found based on user filter criteria. |
| page_number |
integer |
The page number in the entire list. eg Page 1. |
| page_size |
integer |
The number of rows to return. eg 100 rows. |
| effective_date_from |
string |
Effective date from in format yyyy-mm-dd. |
| effective_date_to |
string |
Effective date to in format yyyy-mm-dd. |
| expired_date_from |
string |
Expired date from in format yyyy-mm-dd. |
| expired_date_to |
string |
Expired date to in format yyyy-mm-dd. |
| price_list_selection |
string |
A comma separated list of price lists numbers (e.g SP1000000005,SP1000000006). |
| categories_selection |
string |
A comma separated list of 365 items categories codes (eg 'DRINK,FOOD,CLOTHES,...'). If the value is empty then no search criteria by item category is applied. |
| departments_selection |
string |
A comma separated list of 365 items departments codes (eg 'MEN,WOMEN,CHILDREN,...'). If the value is empty then no search criteria by item department is applied. |
| items_supplier_selection |
string |
A comma separated list of 365 items suppliers codes (eg '10000001,10000004,10000009,...'). If the value is empty then no search criteria by item supplier is applied. |
| brands_selection |
string |
A comma separated list of 365 brands codes (eg 'GUCCI,LEVINTZA,...'). If the value is empty then no search criteria by brands is applied. |
| seasons_selection |
string |
A comma separated list of 365 seasons codes (eg '2015S,2016W,...'). If the value is empty then no search criteria by season is applied. |
| models_selection |
string |
A comma separated list of 365 models codes (eg 'ARTICLE01,DRESS,...'). If the value is empty then no search criteria by model is applied. |
| items_selection |
string |
A comma separated list of 365 items codes (eg 'MILKSHST,MILKSHSTTA,MILKVAN,MILKVANTA,MILKCHOCA,MILKCHOTA,...'). If the value is empty then no search criteria by item is applied. |
| colours_selection |
string |
A comma separated list of 365 colours codes (eg 'RED,BLACK,...'). If the value is empty then no search criteria by colour is applied. |
| sizes_selection |
string |
A comma separated list of 365 sizes codes (eg 'XL,XXL,L,...'). If the value is empty then no search criteria by size is applied. |
| sizes_group_selection |
string |
A comma separated list of 365 sizes groups codes (eg 'SML,10-20,...'). If the value is empty then no search criteria by size group is applied. |
| attributes_1_selection |
string |
A comma separated list of 365 attributes 1 codes (eg 'A,B,C,...'). If the value is empty then no search criteria by attribute 1 is applied. |
| attributes_2_selection |
string |
A comma separated list of 365 attributes 2 codes (eg 'A,B,C,...'). If the value is empty then no search criteria by attribute 2 is applied. |
| attributes_3_selection |
string |
A comma separated list of 365 attributes 3 codes (eg 'A,B,C,...'). If the value is empty then no search criteria by attribute 3 is applied. |
| attributes_4_selection |
string |
A comma separated list of 365 attributes 4 codes (eg 'A,B,C,...'). If the value is empty then no search criteria by attribute 4 is applied. |
| attributes_5_selection |
string |
A comma separated list of 365 attributes 5 codes (eg 'A,B,C,...'). If the value is empty then no search criteria by attribute 5 is applied. |
| attributes_6_selection |
string |
A comma separated list of 365 attributes 6 codes (eg 'A,B,C,...'). If the value is empty then no search criteria by attribute 6 is applied. |
TOTAL COUNT of list of items price lists for multiple search criteria (only_counted='Y').
List of items price lists for multiple search criteria (only_counted='N').