Versions
URL Endpoint
HTTPS://api.adaptiveplanning.com/api/rest/modeling/<version>/<tenant>/versions
HTTPS://api.adaptiveplanning.com/api/rest/modeling/<version>/<tenant>/cloneVersion
(POST only)
Version: v1
Category | Metadata submission, modification, and retrieval |
Description | Metadata Modification |
Permissions Required to Invoke | |
Parameters Required on Request | Varies for endpoint:
PATCH, POST, DELETE: version name. none for GET |
Supported HTTP VERB(s)
(Note: Version folders are not supported for any of the endpoints below)
HTTP verb | Single Resource | Collection Resource | Description |
|---|---|---|---|
GET | Not Supported | Supported | Retrieve all versions of the tenant. |
DELETE | Supported | Not Supported | Delete existing deltable version. |
PATCH | Supported | Not Supported | Create/update actuals versions, or update plan versions. |
POST | Supported | Not Supported | Create a new plan version. |
GET
- Request URI
- /api/rest/modeling/v1/{tenant}/versions:Retrieves all versions of the tenantRetrieves all versions of the tenant in a list.Properties not shown on the UI for specific versions are not included in their corresponding version objects in the response. For example, startOfVersion for sub-actuals versions.Able to use pagination via the 'limit' and 'offset' parameters.The following version properties are currently not supported/displayed in GET:Base version (for virtual versions), enable constant currency reporting (for virtual versions),Calculate formula values, Admin access, user access, editable sheets access, privileged actuals access, group, group access level.Sample Request URI:HTTPS://api.adaptiveplanning.com/api/rest/modeling/v1/DACCO/versions?limit=25&offset=1Sample Request Body:<Leave blank>Query Parameters:NameDescriptionRequiredlimitThe maximum number of objects in a single response.NoffestThe zero-based index of the first object in a response collection. The default is 0.Use offset with the limit parameter to control paging of a response collection.NPath Parameters:NameDescriptionRequiredtenantThe tenant to operate on, e.g. GREENCOY
- Sample Reponse
- 200 OKNote: the Start of Version for actuals versions and the Left Scroll Limit for plan versions are both displayed under the startOfVersion property (pointer A).Similarly, the End of Version for actuals versions and the End of Plan for plan versions are both displayed under the endOfVersion property (pointer D).The Starting Scroll Location for actuals versions and the Start of Plan for plan versions are both displayed under the startingScrollLocation property (pointer C).Successful response.Sample Response{ "data": [ { "name": "Test-Actuals-Version", "shortName": "Test-Actuals-Version-Shortname", "versionType": "ACTUALS", ... "lockLeadingCompletion": true }, { "name": "JE Sub under Actuals", "shortName": "JE01", "parent": "Actuals", ... "journalEntryVersion": true, "journalEntryVersionProperties": { "journalEntryNumbering": "N", "startingNumber": 0 }, ... }, ... ], "limit": 12, "offset": 4, "total": 12 }
DELETE
- Request
- /api/rest/modeling/v1/{tenant}/versions:Delete an existing versionDeletes the version with the specified version name.The root actuals version and the default version cannot be deleted.Sample Request URI:HTTPS://api.adaptiveplanning.com/api/rest/modeling/v1/DACCO/versions?versionName={versionName}Sample Request Body:<Leave blank>Query ParametersNameDescriptionRequiredversionNameName of the existing verstion to delete.YinstanceCodeThe instanceCode to retrieve values from. For example, GLOBO. If no instanceCode is specified, the default instance of the user is used.NPath ParametersNameDescriptionRequiredtenantThe tenant to operate on, e.g. GREENCOY
- Sample Response
- 204 NO_CONTENT
- Successful response is blank with status code 204.
PATCH
- Request:
- /api/rest/modeling/v1/{tenant}/versions:Create/update actuals versions, or update plan versions.If specified version identifier exists, updates the existing actuals/plan version. If not, creates a new actuals version using that identifier.There are currently two sets of version identifiers supported via query parameters:-version nameOne and only one of the above query parameters is required to be specified in the URL for each call.Sample Request URI:HTTPS://api.adaptiveplanning.com/api/rest/modeling/v1/DACCO/versions?versionName={versionName}Request Body-JSON containing the version properties to be updated for the existing version, or to be specified for the new version to be created.Update:-For updates, no specific property is required in the request body (except for versionType), but a request body is still necessary. The request body section ofPOSToutlines the list of properties for different types of Plan versions.-Indicator properties (e.g. journalEntryVersion) cannot be updated; however they can still stay in the request body as long as they have the correct unchanged value.-Parent updating is currently not supported.-When updating non-leaf versions (versions that have children), the user groups of these versions can only have "FULL_ACCESS" or "HIDDEN" access types. "FULL_ACCESS" shows up as, and is equivalent to, "VISIBLE" on the UI.-Group Access details (group ID and group access level) can be removed via specifying groupId=0 in the request body of an update call.Create:-For creates, the following properties are available for specification in the request body:PropertiesDescriptionRequired (For Actuals)Required (For Journal Entry)Property name in request bodyValue TypeDefault ValueShort nameVersion short name.NNshortNameStringempty stringParentParent of this version.NNparentString (version name)root actuals versionVersion TypeType of version (ACTUALS or PLANNING)Y, ACTUALSY, ACTUALSversionTypeStringDescriptionDescriptionNNdescriptionStringempty stringAdministrators accessVersion access level for administrators.NNadministratorsAccessVersionAccessControlinherited from parentUser accessversion access level for users.NNuserAccessVersionAccessControlinherited from parentPrivileged actuals accessVersion access level for anyone with the Privileged Actuals Access permission.NNprivilegedActualsAccessVersionAccessControlinherited from parentGroup IDA specified user group IDNNgroupIdIntegerinherited from parentGroup Access levelVersion access level of the specified user group.Y if Group ID is specified.Y if Group ID is specified.groupAccessLevelVersionAccessControlinherited from parentAudit trailKeeping/deleting audit trail information.NNauditTrailBooleanfalse (inherited from parent for Journal Entry versions)Journal Entry VersionWhether the version to be created is a journal entry.NY, truejournalEntryVersionBooleanreturnIdReturns a version id if it is set true. New version id if the operation created a new version. Otherwise, it returns the id of the existing version that has been updated.NNreturnIdBooleanfalse (returns 204 No Content with it as false, it returns 200 OK with version in the response if it's set as true)Archived VersionIf true, it will archive this version. When a version is archived, it keeps values from changing upon future model structure or formulas changes. This parameter is used for plan versions that are locked.NNarchivedVersionBooleanfalse-The VersionAccessControl value type can take on the following string values: "HIDDEN", "LOCKED", "LOCKED_EXCEPT_NOTES", "IMPORT_AND_NOTES", "FULL_ACCESS"-Group IDs are obtainable via exportGroups public API.-Journal Entry versions are not supported for companies with consolidation disabled.Journal Entry Version Properties:The following properties exist under the journalEntryVersionProperties nested object (see sample request body) and are only used for JE Versions:PropertiesDescriptionRequired (for Actuals)Required (for Journal Entries)Property name in the request bodyValue TypeDefault ValueJournal entry numberingSpecify how journal entries will be numbered. Can be either automatic (A), manual (M), or none (N).UnusedNjournalEntryNumberingStringnone (N)PrefixPrefix of JE NumberingUnusedY if Journal Entry numbering is automatic (A) or manual (M)prefixStringStarting numberStarting number of JE numberingUnusedY if Journal entry numbering (A)startingNumberIntegerRoot Actuals-Specific Properties:The following properties are only used when updating root actuals:PropertiesDescriptionRequiredProperty name in request bodyValue TypeStart of versionStart of versionNstartOfVersionString (time period code)End of versionEnd of versionNendOfVersionString (time period code)Starting scroll locationStarting scroll location of versionNstartingScrollLocationString (time period code)Completed values throughWhen the actuals overlay on plan version stopsNcompletedValuesThroughString (time period code)Enable workflowLets you submit actuals by level in Workflow.NendableWorkflowBooleanSample Request Body:Request Body{ "parent": "Parent Version", "versionType": "ACTUALS", ... "administratorsAccess": "FULL_ACCESS", "usersAccess": "IMPORT_AND_NOTES", ... ... "auditTrail": true }Sample Request Body for versions with nested properties (Journal Entry versions and virtual versions):Request Body{ "parent": "Actuals", "versionType": "ACTUALS", "shortName": "test JE version", "journalEntryVersion": "true", "journalEntryVersionProperties": { "journalEntryNumbering": "A", "prefix": "JE-Prefix", "startingNumber": "25" }, ... "auditTrail": true }Query Parameters:NameDescriptionRequiredversionNameName of the new version to create, or the existing version to update.YproceedWithWarningsAn optional query parameter used to dismiss warning messages. If not set to true, potential warnings will be returned before the call executes. Dismiss them by specifying this parameter to true in the URL.NinstanceCodeThe instanceCode to retrieve values from. For example, GLOBO. If no instanceCode is specified, the default instance of the user is used.NPath Parameters:NameDescriptionRequiredtenantThe tenant to operate on, e.g. GREENCOYPublishing Access Properties:The following request body properties are only used when WD is enabled:
- Sample Response
- 204 NO_CONTENTSuccessful response is blank with status code 204.
POST
- Request:
- /api/rest/modeling/v1/{tenant}/cloneVersion:Create a new plan versionCreates a new plan or prediction version via cloning a source/default version, or creates a virtual version.There are currently two sets of version identifiers supported via query parameters:-new version nameOne and only one of the above is required to be specified in the URL for each callSample Request URI:HTTPS://api.adaptiveplanning.com/api/rest/modeling/v1/DACCO/cloneVersion?newVersionName=Budget 2012& sourceVersionName=Budget 2011& copyAllData=true& copySharedFormulasAndRules=true& copyAllOverrideFormulas=falseRequest body:JSON containing the version properties to be specified for the new version to be created.NameDescriptionRequired (for Plan)Required (for Predictive)Required (for Virtual)Property name in request bodyValue TypeDefault ValueShort nameVersion short name.NNNshortNameStringempty stringParentParent folder of this version.NNNparentString (folder name)Version TypeType of version (ACTUALS or PLANNING)Y, PLANNINGY, PLANNINGY, PLANNINGversionTypeStringDescriptionDescription.NNNdescriptionStringempty stringLocked versionLocks the entire version for all users, including master formulas and other account formulas.NUnusedUnusedlockedVersionBooleaninherited from source versionCalculate formula valuesAvailable for plan versions that have Locked Version checked. Used to preserve the calculated results of formulas and references in most accounts and to increase the performance of locked versions.NUnusedUnusedcalculateFormulaValuesBooleanfalseArchived VersionIf true, it will archive this version. When a version is archived, it keeps values from changing upon future model structure or formula changes. This parameter is used for plan versions that are locked.NUnusedUnusedarchivedVersionAdministrators accessVersion access level for administrators.NNNadministratorsAccessVersionAccessControlinherited from source version (Plan); IMPORT_AND_NOTES (Predictive); LOCKED (Virtual)Users accessVersion access level for users.NNNusersAccessVersionAccessControlinherited from source version (Plan); IMPORT_AND_NOTES (Predictive); LOCKED (Virtual)Editable sheet accessVersion access level for anyone with the Editable Sheet Access permission.NNNeditableSheetAccessVersionAccessControlinherited from source version (Plan, Predictive)Group IDA specified user group's ID.NNNgroupIdIntegerinherited from source version (Plan, Predictive)Access levelVersion access level of the specified user group.NNNgroupAccessLevelVersionAccessControlinherited from source version (Plan, Predictive)Left scroll limitLeft scroll limit of version.NNUnusedstartOfVersionString (time period code)inherited from source versionEnd of planEnd of planNNUnusedendOfPlanString (time period code)inherited from source versionStart of planStart of planNNUnusedstartOfPlanString (time period code)inherited from source versionLock leading time periodMakes specified periods of data uneditable in the version. Shown as "Lock leading {leaf stratum} through" on the UI.NUnusedUnusedlockLeadingTimePeriodString (time period code)inherited from source versionLock leading completionThe "Completion {leaf stratum}" option for the property above. This property and "Lock leading time period" cannot both be specified in the request body.NUnusedUnusedlockLeadingCompletionBooleaninherited from source versionDefaultMakes the version the default version for all users.NUnusedUnuseddefaultBooleanfalseAudit trailKeeping/deleting audit trail information.NNUnusedauditTrailBooleaninherited from source versionActuals overlay includes unavailable levelsDisplays all levels, even ones that are no longer used, in actuals overlays.NNUnusedactualsOverlayIncludesUnavailableLevelsBooleanfalseActuals version for overlayOverlays the plan data with the specified actuals version's data.NNUnusedactualsVersionOverlayString (version name)root actuals versionDrill into Transactios IDEnables the ability to drill into transactions for the version.NNUnuseddrillIntoTransactionIdIntegerdefault reportPredictive VersionWhether the version to be created is a predictive version.UnusedY, trueUnusedpredictiveVersionBooleanVirtual VersionWhether the version to be created is a virtual version.UnusedUnusedY, truevirtualVersionBooleanreturnIdIt returns a version id if it is set true. New version id if the operation created a new version. Otherwise, it returns the id of the existing version that has been updated.NNNreturnIdBooleanfalse (returns 204 No Content with it as false, it returns 200 OK with version in in the response if it's set as true)-The VersionAccessControl value type can take on the following string values: "HIDDEN", "LOCKED", "LOCKED_EXCEPT_NOTES", "IMPORT_AND_NOTES", "FULL_ACCESS"-Locked plan versions cannot have "IMPORT_AND_NOTES" or "FULL_ACCESS" set for any user group.-Predictive versions cannot have "FULL_ACCESS" set for any user group.-Virtual versions can only have "HIDDEN" or "LOCKED" set for any user group.-Plan and predictive versions cannot be created for companies that have consolidation enabled without planning.Version Virtual PropertiesThe following properties exist under the virtualVersionProperties nested object and are only used for Virtual Versions:NameDescriptionRequired (for Plan)Required (for Predictive)Required (for Virtual)Property name in request bodyValue TypeDefault ValueBase VersionThe version that will provide the base data for the virtual version. Cannot be a virtual version or sub actuals version.UnusedUnusedNbaseVersionString (version name)default versionExchange rate versionThe version that will provide the exchange rate for the virtual version used for constant currency reporting. Cannot be a virtual version or sub actuals version.UnusedUnusedNexchangeRateVersionString (version name)root actuals versionEnable Constant Currency ReportingEnable/disable constant currency reporting.UnusedUnusedNenableConstantCurrencyReportingBooleanfalseOffsetAmount of offset backward (positive integer) or forward (negative integer).UnusedUnusedNoffsetInteger0Publishing Access PropertiesThe following request body properties are only used when WD is enabled:NameDescriptionRequired (for Plan)Required (for Predictive)Required (for Virtual)Property name in request bodyValue TypeDefault ValueFinancial PlansEnable/disable financial plans for this version.Only used when Adaptive Planning for Financial Plans is enabled.NUnusedUnusedfinancialPlansBooleanfalseHeadcount PlansEnable/disable headcount plans for this version.Only used when either Adaptive Planning for Financial Plans or Adaptive Planning for the Workforce is enabled.NUnusedUnusedheadcountPlansBooleanfalseWorkforce Action PlansEnable/disable workforce action plans for this version.Only used when Adaptive Planning for the Workforce is enabled.NUnusedUnusedworkforceActionPlansBooleanfalse
- Sample Request BodyRequest Body{ "parent": "Parent Folder", "versionType": "PLANNING", "description": "Test Plan Version", ... ... "usersAccess": "LOCKED_EXCEPT_NOTES", "editableSheetAccess": "LOCKED", ... "startOfVersion": "2012", "endOfVersion": "2013", "startingScrollLocation": "01/2012", "lockLeadingTimePeriod": "02/2012", "actualsOverlayIncludesUnavailableLevels": true }Query ParametersNameDescriptionRequired (for Plan)Required (for Predictive)Required (for Virtual)Parameter name in URLDefault ValueSource version nameThe name of the version to clone from. If not specified, clones from the default version.NNUnusedsourceVersionNameNew version nameName of the new version to be created.YYYnewVersionNameCopy all dataIf true, copies all data.NUnusedUnusedcopyAllDatafalseCopy shared formulas and rulesIf true, copies shared formulas and rules.NUnusedUnusedcopySharedFormulasAndRulesfalseCopy all override formulasIf true, copies all override formulas.NNUnusedcopyAllOverrideFormulasfalseCopy splits in GL and custom accountsIf true, copies splits in GL and custom accounts.NUnusedUnusedcopySplitsInGLAndCustomAccountsfalseCopy modeled rowsIf true, copies modeled rows.NUnusedUnusedcopyModeledRowsfalseCopy cell, sheet and workflow notesIf true, copies cell, sheet and workflow notes (if applicable).NUnusedUnusedcopyAllNotesfalseReset workflow status to in progressIf true, resets workflow status to in progress.NUnusedUnusedresetWorkflowStatusToInProgressfalseCopy audit trail historyIf true, adds as report parameter choice to all reports.UnusedUnusedcopyAuditTrailHistoryfalseAdd as report parameterchoice to all reportsIf true, adds as report parameter choice to all reports.NUnusedUnusedaddAsReportParameterChoiceToAllReportsfalseCopy recalculated values of sheetsIf true, copies recalculated values of sheets.NUnusedUnusedcopyRecalculatedValuesOfSheetsfalseProceed with WarningsAn optional query parameter used to dismiss warning messages. If not set to true, potential warnings will be returned before the call exectues. Dismiss them by specifying this parameter to true in the URL.NNNproceedWithWarningsfalseInstance CodeThe instanceCode to retrieve values from. For example, GLOBO. If no instanceCode is specified, the default instance of the user is used.NNNinstanceCodeDefault instance of the userRun asynchronouslyIf true, the clone version job will run asynchronously. The job id will be returned in the response, which can be used to get the status of the clone version job by sending request to endpointGEThttps://api.adaptiveinsights.com/api/rest/modeling/v1/{tenant}/jobs/{id}NNNasyncfalse-"Reset workflow status to in progress" is not supported for companies with Workflow disabled.-"Copy recalculated values of sheets" is not supported if MODEL ISOLATION feature flag is off.Path Parameters:NameDescriptionRequiredtenantThe tenant to operate on, e.g. GREENCOY
- Sample Response:
- 204 NO_CONTENTSuccessful response is blank with status code 204.
- 200Successful response. The job detail will be returned.
- Response body:NameDescriptionPossible ValuesidThe job idIntegersourceIdUnique identifier of the job within its type. E.g. for version creation, it would be the new version name.StringtypeType of the job"VersionCreation"userIdThe Id of the user initialized the jobIntegerstatusStatus of the job"INVALID", "IN_PROGRESS", "SUCCESS", "FAILURE"errorMessageError message if the job failsString in preferred languagecreatedOnThe creation time of the jobString represent datetime in ISO 8601 formatupdatedOnThe last update time of the jobString represent datetime in ISO 8601 formatreturnSuccessDataAdditional data related to the job or the object created by the job. This is optional and defaults to false.BooleanExample