API XML Errors When Retrieving Large Datasets

Overview

You may encounter errors when using the REST API to retrieve large datasets (such as invoices with many line items). These can include XML errors or timeouts when expanding details

• Errors such as:

  • “Name cannot begin with the '<' character”

  • “'<‘ is an unexpected token”

Cause

These errors are typically caused by large API responses exceeding the default system limit for concatenated data (group_concat_max_len, set to 1 MB).

When this limit is exceeded, the response may be truncated, resulting in malformed XML

Resolution

Please contact Support who can test a change in the web.config file for the groupConcatMaxLength setting (under PXSqlDatabaseProvider)