What's new in Sigma

API

New option for List workbooks endpoint

The List workbooks (GET /v2/workbooks) endpoint now includes the excludeExplorations query parameter to be used with the skipPermissionCheck query parameter to exclude explorations from the response.

For example, if an admin wants to return all workbooks in an organization, but exclude ad hoc explorations, they could send a GET request to https://api.sigmacomputing.com/v2/workbooks?skipPermissionCheck=true&excludeExplorations=true.

New filtering options for List connections and List user attributes endpoints

The following endpoints now support optional query parameters to allow you to filter the results:

• The List connections (GET /v2/connections) endpoint now includes the search query parameter.
• The List user attributes (GET /v2/user-attributes) endpoint now includes the name query parameter.

Workbook elements

Copy and paste container format

Copy the format of a container, then paste it to a destination container in any workbook. Select Copy/Paste > Copy format from the element menu, or use keyboard shortcuts ( ⌘+⌥+C to copy and ⌘+⌥+P to paste for Mac OS, or Ctrl+Alt+C to copy and Ctrl+Alt+P to paste for MS Windows).

Workbook features

Selection criteria for action conditions

When configuring a column condition on an action sequence, use the Selection matches criteria option to run the sequence only when a user selects a table, pivot table, or input table row containing a specific column value, or when the user selects a data point representing that value in a chart.

Dynamically move columns with actions

Use the Modify element > Move columns action to dynamically move columns into and out of groupings and properties when column names match selected control values in the trigger element. This action can be configured on List value and Segmented controls only.

For more information, see Move columns.