2.13 Summary

New Features:

• Introduced a caching strategy for variance reports to save data between refreshes and optimize report generation efficiency
• Users can now set the join condition of variance and Power Pick data (e.g. show joined data only; defaults to showing all data)
• Added Token-Based Authentication method for token authentication methods without an OAuth2.0 refresh endpoint 
• Added a 404 page for invalid URLs

Bugfixes:

• Trailing whitespaces in string columns in SQL query results are automatically removed
• Fixed issue when filtering API logs by user "None"

New Features:

• Adds support for exporting and importing a variance integration.
• Adds /api/users/logout API endpoint to specifically revoke user access.

Bugfixes:

• Fixes bug in Data Pull where log would indicate order successfully created when the action performed was lines appended to existing order.

New Features:

• Adds /api/storage_rules endpoint.

Bugfixes:

• Properly schedules Data Pull jobs for large orders.
• Fixes Report template importing/exporting for reports with grouping/subgrouping and comparison columns.

Bug Fixes:

• Overall performance upgrades for order creation, making Data Pull much more efficient.
• Optimized dynamic datetime checks and improved accuracy in identifying valid date formats in Data Pull.
   

Patch 2.13.4.1

Bugfixes:

• Improving Data Pull performance when appending lines to an existing order.
   

Patch 2.13.4.2

Bug Fixes

• Fixes bug where flat orders were not being grouped properly.
• Fixes bug where datetime format was not being correctly applied to the dynamic datetime filter.
   

Patch 2.13.4.3

Bug Fixes

• Manually adds colon when converting datetime to a format with timezone offset (%z).
   

Patch 2.13.4.4

Bug Fixes

• Fixes advanced mappings in flat data structure in Data Pull.

New Features:

• Adds support to Data Pull for manually running and testing the integration using JSON input.
• Increases scheduled Data Pull job timeout from 3 to 5 minutes.
   

Patch 2.13.3.1

Bugfixes:

• Fixes bug on update material calls that would trigger a validation error when passing the material's own name.
• Fixes bug where material property of a material was incorrectly being changed.
   

Patch 2.13.3.2

New Features:

• Enhanced order validation methods to improve efficiency and provide detailed error messages.

Bug Fixes:

• Refined error handling for invalid material properties.

Bugfixes:

• Fixes bug causing generated files for Power Pick themes to have the incorrect time zone.
   

Patch 2.13.2.1

Bugfixes:

• Fixes UI bug causing the signup form to be inaccessible.

Bugfixes:

• When running manual Data Pull, the user can now select the data type of the mapping. This will prevent Number values from being wrapped by single quotes, for an OData endpoint queries. If the conversion of data type fails, it will default back to a string value.
   

Patch 2.13.1.1

Bugfixes:

• Fixes bug where order name validation for Data Pull would fail when the received order name is a number.

New Features:

• Grouping and subgrouping within a report is now available. You can select the columns to group by in the "Columns" tab of a report.
  • This adds a new type of report column called "Count". This report column will display how many rows were grouped together.
  • Aggregate functions can be set for report columns. This tells ItemPath what to do with the data of rows that are grouped together. The currently supported aggregate functions are 'sum', 'mean', 'max', 'min', 'median', 'first', and 'last'.
• Token-Based Authentication is a newly available authentication method.
  • A "login" or "get token" URL is required when setting up the connection.
  • This authentication method adds the token as a Bearer token in the header.
  • The duration of the token should be set in the connection settings (defaults to 15 minutes).
  • When retrieving token, the connection expects it to have a key of "token", "accessToken", or "access_token" (case does not matter).