Powersoft 365 API Documentation

list_sync_items


Changelog

April 22, 2026
  • All methods includes in the response the property sort_positions which is a list indicating the sort position of an item within attributes such as category, department, and additional attributes. If the value is null, it should be treated as 9999 for all attributes.
April 17, 2026
  • All methods added a new property list_vat_groups
December 08, 2025
  • POST method added for the sorting the options: ModelCode, ColourCode, SizeCode and SizeSequenceNo
December 07, 2025
  • All methods added in the response the field size_sequence_no
December 02, 2025
  • All methods added in the response the field last_purchase_qty
October 13, 2025
  • New POST method with user defined filter criteria
December 16, 2024
  • In the response of the items list added new fields last_modified_date and creation_date.

GET /list_sync_items

To get a list of items that need to be synchronized. The result is ordered descending by the date that the change occurred.

/list_sync_items?token=XXXXX&records=500

field description
token Credentials provided by Powersoft that allow access to the API
records The number of records to retrieve. The maximum is 500 per request

GET /list_sync_items

To get a list of items that need to be synchronized with the result ordered ascending by the date that the change occurred.

/list_sync_items?token=XXXXX&records=500&ascending_order=true

field description
token Credentials provided by Powersoft that allow access to the API
records The number of records to retrieve. The maximum is 500 per request
ascending_order Pass value true if you want the order to be ascending by the date that the change occurred.

GET /list_sync_items

To get a list of items that need to be synchronized with the costs values. The result is ordered by the date that the change occurred.

/list_sync_items?token=XXXXX&records=500&request_password_365=yourpassword

field description
token Credentials provided by Powersoft that allow access to the API
records The number of records to retrieve. The maximum is 500 per request
request_password_365 Request password as registered in 365 BASE64 encoded - optionally. The password is necessary if the user needs to have the item cost. Password is provided by Powersoft.

Returns


POST /list_sync_items

To get the TOTAL COUNT of list of items that need to be synchronized 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 that need to be synchronized 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 found based on user filter criteria. 'N' = brings the list of the items 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 10 rows
change_type_code_selection string Change mode selection. Allowed values: 'Add', 'Edit' and 'Remove'
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.
display_fields string Comma separated list of the fields to be displayed in the response. If the value is empty or not passed all the fields will be included in the response.
request_password_365 string Request password as registered in 365 BASE64 encoded - optionally. The password is necessary if the user needs to have the item cost. Password is provided by Powersoft.
sorting
field_name string The field name the sorting is applied. Optional. If the value is not provided the default sorting is by change date/time descending. Allowed values are:
  • ChangeID - 365 change id.
  • ChangeDateTime - change date/time.
  • ItemCode - item code.
  • ItemName - item name.
  • ItemOtherName - item other name.
  • ChangeTypeCode - change mode.
  • ModelCode - model code.
  • ColourCode - colour code.
  • SizeCode - size code.
  • SizeSequenceNo - size sequence number inside of the group size.
sorting_direction string The direction the sorting is applied. Required. Allowed values are ascending and descending.

Returns

TOTAL COUNT of list of items for multiple search criteria (only_counted='Y').

List of items for multiple search criteria (only_counted='N').

Note

The POST method always returns two totals: the number of items to be synchronized total_count_list_items, which dynamically decreases as changes are applied, and the total number of items displayed per page total_items_on_page.