Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Export Configurable Model Data API

Export Configurable Model Data API

With this release, we continue to improve the exportConfigurableModelData API. You can now specify the columns you want to export, increasing performance and efficiency. We also enable you to set the decimal precision of the data.

Columns Filters in exportConfigurableModelData

Release: 2022-09-10
With this update, you can specify which modeled sheet columns you retrieve by including those columns in the exportConfigurableModelData filters element.
If you don't specify columns, all of the modeled sheet columns return in the response.
To use this functionality, you must update the API to v33 or above. This also requires you to set isGetAllRows to true for the modeled sheet element.

API Version 35

Release: 2022-11-18
We now release API version 35.

Request Raw Data in exportConfigurableModelData

Release: 2022-11-18
You can now include useActualData=true in the modeled sheet element when you stream data, enabling you to ignore the account decimal precision. We export calculated accounts at 9-decimal precision.
To use this functionality, you must use API v35 and not include useAccountPrecision in the request, or set it to false.

Escape Double Quotes in String Values

Release: 2022-11-18
We now automatically escape double quotes in string fields for dimension values and text fields to make exports easier to process.
You must use API v35 and set isGetAllRows to true.

Status Messages for Streaming exportConfigurableModelData

Release: 2022-11-18
We now include this information in the response when you stream data from exportConfigurableModelData:
  • A status tag with a Boolean success attribute.
  • A total row count for the data tag.
  • A row count sent in the status tag.
You must use API v35 and set isGetAllRows to true.

Prefix Removed from parentId in Data Output

Release: 2022-11-18
We no longer include the s prefix for parentId data output with API v35 when useNumericIds=true.

Account Data Precision for exportConfigurableModelData

Release: 2022-09-10
We add a new useAccountPrecision attribute in the modeled sheet element on the exportConfigurableModelData API. When you set the new attribute true, we export data for accounts at the account decimal precision. When you set it to false or if you don't include the attribute, we export data at nine-decimal precision.
To use this functionality, you must update the API to v33 or above. This also requires you to set isGetAllRows to true for the modeled sheet element.