### Response 200 for starting process
Source: https://help.anaplan.com/start-the-process-c76c3d8d-9d98-4a76-bd6d-efed03ebecb4
Example JSON response returned when the process starts successfully. Contains the taskId.
```json
{
"taskId" : "E1F648F527AF4297B09E06C278B99F4C"
}
```
--------------------------------
### Installation to a specific directory
Source: https://help.anaplan.com/898abd84-d6c7-44d5-94e5-848a9bfeaa13
Install the add-in to a specific directory using /i and APPDIR. The PowerPointAddin Setup wizard displays when executed.
```command line
msiexec /i "C:\Users\AnaplanUser\Downloads\AnaplanPowerPointAddin.Release.msi" APPDIR="C:/Users/AnaplanUser/Add-in Folder"
```
--------------------------------
### Curl example to start a process action
Source: https://help.anaplan.com/3db20a69-108a-4ecd-8e34-4905513164cd
Use this curl command to start a process action. It posts a task to the specified process ID and returns a task ID for monitoring. The example uses a placeholder token and sets the locale to US English.
```bash
curl -X POST \
https://api.anaplan.com/2/0/workspaces/0a800b00e0000000f000001eab0d0000/models/F1111111C11111111B11111F1111E11F/processes/118000000002/tasks \
-H 'authorization: AnaplanAuthToken {token}' \
-H "Content-Type:application/json" \
-d '{"localeName": "en_US"}'
```
--------------------------------
### msiexec /i with APPDIR for custom directory installation
Source: https://help.anaplan.com/0b1f0748-2805-4988-a394-bdb6186a94df
Use this command to install the add-in to a specific directory. Replace the path between the quotation marks with your desired directory. When executed, the PowerPointAddin Setup wizard displays.
```command
msiexec /i "C:\Users\AnaplanUser\Downloads\AnaplanExcelAddin.Release.msi" APPDIR="C:/Users/AnaplanUser/Add-in Folder"
```
--------------------------------
### Curl example: GET /users
Source: https://help.anaplan.com/d7b672ee-2777-4adb-a933-3418a9929323
Retrieves a list of users for the CustomerTenant tenant. Requires the TENANT and X-API-TOKEN headers. The API enforces a 60-second timeout on GET commands.
```bash
curl --location 'https://fluenceapi-prod.fluence.app/api/v2305.1/users' \
--header 'TENANT: CustomerTenant' \
--header 'X-API-TOKEN: 73ca5973-ce3e-4cc6-b2d4-b09a99770ccf'
```
--------------------------------
### GET /api/v2305.1/process/start/ImportandExports/Data/ModelExport
Source: https://help.anaplan.com/structure-of-an-api-request-bcddc03e-9c46-4174-9bae-347cf77a45d4
Example of a request to start a process workflow for model export.
```APIDOC
## GET /api/v2305.1/process/start/ImportandExports/Data/ModelExport
### Description
Starts a process workflow for model export.
### Method
GET
### Endpoint
https://fluenceapi-prod.fluence.app/api/v2305.1/process/start/ImportandExports/Data/ModelExport
### Parameters
#### Path Parameters
- **ImportandExports** (string) - Required - The import/export category.
- **Data** (string) - Required - The data type.
- **ModelExport** (string) - Required - The model export name.
### Response
#### Success Response (200)
- **status** (string) - The state of the workflow.
#### Response Example
{
"status": "started"
}
```
--------------------------------
### Response for GET /ResourceTypes
Source: https://help.anaplan.com/get-resource-types-39e7544b-4731-42fb-ae08-e47fb41bf4d0
Example JSON response showing a list of resource types, including the User resource type with its metadata and schema.
```json
{
"schemas": ["urn:ietf:params:scim:api:messages:2.0:ListResponse"],
"totalResults": 1,
"startIndex": 1,
"itemsPerPage": 50,
"Resources": [{
"schemas": ["urn:ietf:params:scim:schemas:core:2.0:ResourceType"],
"meta": {
"resourceType": "ResourceType",
"location": "https://api.anaplan.com/scim/1/0/v2/ResourceTypes/User"
},
"id": "User",
"name": "User",
"endpoint": "/Users",
"description": "User Account",
"schema": "urn:ietf:params:scim:schemas:core:2.0:User"
}]
}
```
--------------------------------
### Sample JSON response for GET /Users
Source: https://help.anaplan.com/get-multiple-users-08193d51-b8d8-48cc-855d-b20983ee6ef6
Example response from the GET /Users endpoint showing a single user with metadata, name, and entitlements. Note the response includes both a string 'active' field and a boolean 'active' field.
```json
{
"totalResults": 1,
"startIndex": 1,
"itemsPerPage": 1,
"Resources": [
{
"schemas": [
"urn:ietf:params:scim:schemas:core:2.0:User"
],
"meta": {
"resourceType": "User",
"created": "2018-04-24T23:43:48.000+00:00",
"lastModified": "2019-01-15T22:04:19.000+00:00",
"location": "https://localhost:8090/1/0/v2/Users/8a80db9362f64cad0162fa0ab3fe0001"
},
"id": "8a80db9362f64cad0162fa0ab3fe0001",
"externalId": "",
"active": "True",
"userName": "sfqasuper@anaplan.com",
"name": {
"familyName": "Super",
"givenName": "SFQA",
"formatted": "SFQA Super"
},
"displayName": "SFQA Super",
"active": true,
"entitlements": [
{
"display": "Finance Workspace",
"value": "6edb50156273d29050001",
"type": "WORKSPACE"
},
{
"display": "Sales Workspace",
"value": "6edb50156273d29050002",
"type": "WORKSPACE"
},
{
"value": "6edb50156273d29050001,6edb50156273d29050002",
"type": "WORKSPACE_IDS"
}
]
}
]
}
```
--------------------------------
### Curl example for GET /ServiceProviderConfig
Source: https://help.anaplan.com/get-supported-scim-capabilities-24bb9b1f-a47e-49f7-9647-5d90717e4aa2
Use this curl command to retrieve the supported SCIM capabilities. The endpoint is https://api.anaplan.com/scim/1/0/v2/ServiceProviderConfig.
```bash
curl -X GET https://api.anaplan.com/scim/1/0/v2/ServiceProviderConfig
```
--------------------------------
### Curl example for GET /ResourceTypes
Source: https://help.anaplan.com/get-resource-types-39e7544b-4731-42fb-ae08-e47fb41bf4d0
Use this curl command to retrieve all supported resource types from the Anaplan SCIM API.
```bash
curl -X GET https://api.anaplan.com/scim/1/0/v2/ResourceTypes
```
--------------------------------
### XL3RefreshConnections example with XL3Link
Source: https://help.anaplan.com/70b2e734-8944-488e-8b56-cb8e54801c8b
Example setup: first create the XL3RefreshConnections formula referencing cell $A$1 and connection 1, then set up an XL3Link to fire the refresh. Selecting the link will refresh all grids/small multiples/etc. connected to connection 1.
```formula
=XL3RefreshConnections($A$1, 1)
```
```formula
=XL3Link(XL3Address($A$1),"Refresh All",,XL3Address($A$1),TRUE)
```
--------------------------------
### Response: GET /users
Source: https://help.anaplan.com/d7b672ee-2777-4adb-a933-3418a9929323
Example JSON response containing user details such as userId, userName, fullName, isDisabled, email, and roles. The response shows multiple user objects.
```json
[
{
"userId": 3,
"userName": "jdoe@fluence.app",
"fullName": "Jane Doe",
"isDisabled": false,
"email": "jdoe@acme.com",
"roles": [
"Admin",
"Controller",
"Preparer"
]
},
{
"userId": 164,
"userName": "jbay@fluence.app",
"fullName": "James Bay",
"isDisabled": false,
"email": "jbay@acme.com",
"roles": [
"Admin",
"Controller",
"Preparer",
"Reviewer",
"Cash Team",
"Reporting Manager",
"Accounting Manager",
"Consolidation Workflow"
]
},
{
"userId": 208,
"userName": "ttesfaye@fluence.app",
"fullName": "Teddy Tesfaye",
"isDisabled": false,
"email": "tesfaye@acme.com",
"roles": [
"Admin"
]
},
{
"userId": 235,
"userName": "hkovacs@fluence.app",
"fullName": "Hanna Kovacs",
"isDisabled": false,
"email": "kovacs@acme.com",
"roles": [
"Admin",
"Controller"
]
}
]
```
--------------------------------
### Curl example for GET /users/me
Source: https://help.anaplan.com/d5e7ae19-0a8a-44a7-a482-bdee7479e039
Use this curl command to retrieve the user associated with the Anaplan authentication token. Replace {anaplan_auth_token} with your actual token.
```bash
curl -X GET \
https://api.anaplan.com/2/0/users/me \
-H 'authorization: AnaplanAuthToken {anaplan_auth_token}' \
-H 'Content-Type:application/json'
```
--------------------------------
### Response 200 for starting an import task
Source: https://help.anaplan.com/start-the-import-7e0dcedb-3628-44a1-8688-4a68eef85cdb
Example JSON response returned when the import task is successfully created. The taskId can be used to track the import status.
```json
{
"taskId" : "5E6331685CC648A29B725923B8FAEA1C"
}
```
--------------------------------
### Curl example for GET /Schemas
Source: https://help.anaplan.com/get-resource-schema-7523d5ad-0743-43fd-b868-89cd8856759b
Use this curl command to retrieve the supported attributes and attribute metadata for resources. The endpoint is https://api.anaplan.com/scim/1/0/v2/Schemas.
```bash
curl -X GET https://api.anaplan.com/scim/1/0/v2/Schemas
```
--------------------------------
### Response 200 for starting export task
Source: https://help.anaplan.com/start-the-export-03d2acc9-0305-42c3-816e-15629133e9c5
Example JSON response returned when the export task is successfully created. It includes the taskId in the task object.
```json
{
"meta":{
"schema":"https://api.anaplan.com//2/0/models/736367E9DB484E3AB3A50C3704FD33ED/objects/task"
},
"status":{
"code":200,
"message":"Success"
},
"task":{
"taskId":"F362B99442C54425970E200037D48A91"
}
}
```
--------------------------------
### Curl example for GET /user/{username}/roles
Source: https://help.anaplan.com/list-roles-for-a-user-582f9dfa-1f2b-4e67-a98b-120e58a9f5a9
Use this curl command to retrieve the roles for a specific user. Replace the username in the URL with the Financial Consolidation app username (not email). The TENANT and X-API-TOKEN headers are required for authentication. The API enforces a 60-second timeout on GET commands.
```bash
curl --location 'https://fluenceapi-prod.fluence.app/api/v2305.1/user/john.doe@fluence.app/roles' \
--header 'TENANT: CustomerTenant' \
--header 'X-API-TOKEN: 73ca5973-ce3e-4cc6-b2d4-b09a99770ccf'
```
--------------------------------
### Response for GET /workspaces?tenantDetails=true
Source: https://help.anaplan.com/list-user-workspaces-c324d0af-01ce-4e6b-8039-06289a4f5b19
Example JSON response from the workspace listing endpoint. It includes metadata with paging information, a status of 200 with message 'Success', and a workspaces array containing workspace details such as id, name, active flag, sizeAllowance, and currentSize.
```json
{
"meta": {
"schema": "https://api.anaplan.com/2/0/objects/workspace",
"paging": {
"currentPageSize": 1,
"totalSize": 1,
"offset": 0
}
},
"status": {
"code": 200,
"message": "Success"
},
"workspaces": [
{
"id": "8a8b8c8d8e8f8g8i",
"name": "Financial Planning",
"active": true,
"sizeAllowance": 1073741824,
"currentSize": 873741824
}
]
}
```
--------------------------------
### Response from starting a process action
Source: https://help.anaplan.com/3db20a69-108a-4ecd-8e34-4905513164cd
The response from the POST request includes a task object with a taskId, taskState, and creationTime. The example shows a successful response with status code 200 and taskState NOT_STARTED.
```json
{
"meta":{
"schema":"https://api.anaplan.com/2/0/models/F1111111C11111111B11111F1111E11F/objects/task"
},
"status":{
"code":200,
"message":"Success"
},
"task":{
"taskId":"E36791D709C44246878B708B4C76A1F9",
"taskState":"NOT_STARTED",
"creationTime":1570823579809
}
}
```
--------------------------------
### Curl example for retrieving list items
Source: https://help.anaplan.com/retrieve-list-data-2309ce30-9f81-40d4-a7c3-473a8ff60667
Use this curl command to call the GET endpoint. Replace {workspaceId}, {modelId}, {listId}, and {anaplan_auth_token} with actual values. The includeAll query parameter is set to true.
```bash
curl -X GET 'https://api.anaplan.com/2/0/workspaces/{workspaceId}/models/{modelId}/lists/{listId}/items?includeAll=true' \
-H 'Accept: application/json' \
-H 'Authorization: AnaplanAuthToken {anaplan_auth_token}'
```
--------------------------------
### Quiet installation with /q
Source: https://help.anaplan.com/898abd84-d6c7-44d5-94e5-848a9bfeaa13
Use /q to perform a quiet installation with no installation wizard.
```command line
msiexec /i "C:\Users\AnaplanUser\Downloads\AnaplanPowerPointAddin.Release.msi" /q
```
--------------------------------
### Curl GET request to OData endpoint
Source: https://help.anaplan.com/480986d3-a907-4675-9cdf-1392e95e1a20
Use this curl command to send a GET request to the OData endpoint. It includes the TENANT and X_API_TOKEN headers. The example filters data for dates starting with '2024'.
```bash
curl -L -X GET 'https://fluenceapi-prod.fluence.app/api/v2305.1/odata/Consolidation?$filter=startswith(Date,’2024’)' \
-H 'TENANT: CustomerTenant' \
-H 'X_API_TOKEN: 73ca5973-ce3e-4cc6-b2d4-b09a99770ccf'
```
--------------------------------
### Response 200 body for get current fiscal year
Source: https://help.anaplan.com/get-current-fiscal-year-0454318c-0d4f-4d35-8d0e-2969a03ec7b3
Example JSON response returned by the endpoint when the request is successful. Shows the fiscal year, start date, and end date.
```json
{
"meta": {
"schema": "https://api.anaplan.com/2/0/objects/modelCalendar"
},
"status": {
"code": 200,
"message": "Success"
},
"modelCalendar": {
"fiscalYear": {
"year": "FY21",
"startDate": "2021-01-01",
"endDate": "2021-12-31"
}
}
}
```
--------------------------------
### mapping.xml - Simple mapping example
Source: https://help.anaplan.com/connection-parameter-web-extension-49f28d5c-fd8d-4ce3-b760-4b9cfcab0569
This configuration maps a web parameter 'connection' with value 'mapped' to use the AlternativeServer. Blank database and cube details are left unchanged. The example URL shows how to load the report with the parameter.
```xml
```
```url
https://MyServer/AnaplanXLWeb/WebForm/ShowReport.aspx?rep=673dad1d-e406-4493-8ee3-6afdc9ec4f7f.wbsql&connection=mapped
```
--------------------------------
### GET /processes/{taskId}
Source: https://help.anaplan.com/monitor-the-process-tasks-95904c2c-9253-4293-a13c-cf8e44881b17
Gets the status of a specific export task. Optionally include process details to get start time and duration of each step.
```APIDOC
## GET /processes/{taskId}
### Description
Gets the status of a specific export task. Optionally include process details to get start time and duration of each step.
### Method
GET
### Endpoint
/processes/{taskId}
### Parameters
#### Path Parameters
- **taskId** (string) - Required - The ID of the process task to monitor.
#### Query Parameters
- **includeProcessDetails** (boolean) - Optional - When true, includes the start time and duration of each step.
### Response
#### Success Response (200)
- **currentStep** (object) - The task associated with the specified taskId.
- **taskState** (string) - The status of the process task. Possible values: NOT_STARTED, IN_PROGRESS, COMPLETE, CANCELLING, CANCELLED.
- **progress** (double) - Typically 1.0.
- **result** (object) - Indicates whether a failure dump file was created, the objectId, and whether the task succeeded.
- **failureDumpAvailable** (boolean) - Indicates whether this process container or an action within it has a failure dump file. For a deletion action, this is always false.
- **nestedResults** (array) - Indicates whether the actions carried out in the process were successful. Contains details in the form of a JSON array, including debug information when failures occur.
- **objectID** (string) - The identifier of the process task or a task that it includes.
- **taskID** (string) - The ID that you specified in the request.
- **duration** (number) - The overall processing time.
- **startTime** (string) - The time when the step started.
#### Response Example
{
"currentStep": {},
"taskState": "COMPLETE",
"progress": 1.0,
"result": {},
"failureDumpAvailable": false,
"nestedResults": [],
"objectID": "string",
"taskID": "string",
"duration": 0,
"startTime": "string"
}
```
--------------------------------
### Curl example for GET /users/{userId}
Source: https://help.anaplan.com/45d7e37a-652c-44f1-8b81-06b9034f707c
Use this curl command to retrieve user information. Requires a Workspace Administrator role or any tenant-level access role. Replace {userId} and {anaplan_auth_token} with actual values.
```bash
curl -X GET \
https://api.anaplan.com/2/0/users/{userId} \
-H 'authorization: AnaplanAuthToken {anaplan_auth_token}' \
-H 'Content-Type:application/json'
```
--------------------------------
### Quiet installation with progress bar using /qr option
Source: https://help.anaplan.com/0b1f0748-2805-4988-a394-bdb6186a94df
Use this command to perform a quiet installation with only a progress bar and no final window. The /qr option also enables installation without administrator permissions.
```command
msiexec /i "C:\Users\AnaplanUser\Downloads\AnaplanExcelAddin.Release.msi" /qr
```
--------------------------------
### Curl example: GET line items with includeAll=true
Source: https://help.anaplan.com/retrieve-all-line-item-metadata-in-a-module-c8c41f1d-dd4e-4ca6-ac92-1a3d6c46bfeb
Use this curl command to retrieve all line items and metadata for a module. Replace {modelId}, {moduleId}, and {anaplan_auth_token} with actual values. Requires workspace administrator role and Read access to the module.
```bash
curl -X GET 'https://api.anaplan.com/2/0/models/{modelId}/modules/{moduleId}/lineItems?includeAll=true' \
-H 'Authorization: AnaplanAuthToken {anaplan_auth_token}' \
-H 'Accept: application/json'
```
--------------------------------
### Download prerequisites to a folder
Source: https://help.anaplan.com/anaplan-xl-reporting-silent-installation-92c87d07-ae25-49d3-bd4b-2f0709a1ecd1
Use this command to create a folder with all installation files in the correct layout, which can be copied to a DVD or target computer.
```plaintext
AnaplanXLReporting.exe /layout
```
--------------------------------
### Example chunk object
Source: https://help.anaplan.com/upload-a-file-in-chunks-64df7566-f12f-45f0-a2f9-a992688ebc47
Example JSON object returned in the chunks array when getting the chunks in a file. Contains id and name fields.
```json
{
"id": "0",
"name": "Chunk 0"
}
```
--------------------------------
### Example command to run the conversion script
Source: https://help.anaplan.com/troubleshoot-wrapped-keys-2facc339-7673-43a7-857b-ff88fdd9b439
Example command that runs the script named convertPublicKey.sh with the key file myPublicKey.pem. This generates two PEM files with .pkcs8.pem and .pkcs1.pem suffixes.
```bash
sh convertPublicKey.sh myPublicKey.pem
```
--------------------------------
### GET /api/v2305.1/users
Source: https://help.anaplan.com/structure-of-an-api-request-bcddc03e-9c46-4174-9bae-347cf77a45d4
Example of a request to retrieve a list of users in the tenant.
```APIDOC
## GET /api/v2305.1/users
### Description
Retrieves a list of users in the tenant.
### Method
GET
### Endpoint
https://fluenceapi-prod.fluence.app/api/v2305.1/users
### Response
#### Success Response (200)
- **users** (array) - List of users.
#### Response Example
{
"users": []
}
```
--------------------------------
### View installation options with msiexec
Source: https://help.anaplan.com/898abd84-d6c7-44d5-94e5-848a9bfeaa13
Run the MSI file with msiexec to display the Windows Installer dialog with a full list of installation options. Requires administrator permissions.
```command line
msiexec "C:\Users\AnaplanUser\Downloads\AnaplanPowerPointAddin.Release.msi"
```
--------------------------------
### GET /api/v2305.1/metadata/Dimensions
Source: https://help.anaplan.com/structure-of-an-api-request-bcddc03e-9c46-4174-9bae-347cf77a45d4
Example of a request to retrieve metadata for all dimensions across a tenant.
```APIDOC
## GET /api/v2305.1/metadata/Dimensions
### Description
Retrieves a list of all dimensions, including parent-child relationships and attributes, across a tenant.
### Method
GET
### Endpoint
https://fluenceapi-prod.fluence.app/api/v2305.1/metadata/Dimensions
### Parameters
#### Path Parameters
- **Dimensions** (string) - Required - The resource path for dimensions.
### Response
#### Success Response (200)
- **dimensions** (array) - List of dimensions with metadata.
#### Response Example
{
"dimensions": []
}
```
--------------------------------
### Quiet installation with /q option
Source: https://help.anaplan.com/0b1f0748-2805-4988-a394-bdb6186a94df
Use this command to perform a quiet installation of the add-in, with no installation wizard. The /q option suppresses the user interface.
```command
msiexec /i "C:\Users\AnaplanUser\Downloads\AnaplanExcelAddin.Release.msi" /q
```
--------------------------------
### InstalledExtensions.xml - Register ConnectionParameterExtension.dll
Source: https://help.anaplan.com/connection-parameter-web-extension-49f28d5c-fd8d-4ce3-b760-4b9cfcab0569
Create this file in the Extensions folder to load the extension. Place it in the same folder as the DLL, typically C:\inetpub\wwwroot\AnaplanXLWeb\Extensions.
```xml
.
```
--------------------------------
### GET /api/v2305.1/odata
Source: https://help.anaplan.com/structure-of-an-api-request-bcddc03e-9c46-4174-9bae-347cf77a45d4
Example of a request to the OData endpoint to retrieve data records.
```APIDOC
## GET /api/v2305.1/odata
### Description
Retrieves data records using the OData endpoint.
### Method
GET
### Endpoint
https://fluenceapi-prod.fluence.app/api/v2305.1/odata
### Response
#### Success Response (200)
- **data** (array) - List of data records.
#### Response Example
{
"data": []
}
```
--------------------------------
### Get list of export tasks with curl GET
Source: https://help.anaplan.com/start-the-export-03d2acc9-0305-42c3-816e-15629133e9c5
Use this curl command to retrieve a list of export tasks. It requires the same URL parameters and authentication as the POST example.
```bash
curl -X GET \
https://api.anaplan.com/2/0/workspaces/{workspaceId}/models/{modelId}/exports/{exportId}/tasks \
-H 'authorization: AnaplanAuthToken {anaplan_auth_token}' \
-H 'Content-Type:application/json'
```
--------------------------------
### Install the add-in with /i option
Source: https://help.anaplan.com/0b1f0748-2805-4988-a394-bdb6186a94df
Use this command to install the add-in. The /i option is a universal Windows Installer option that specifies installation.
```command
msiexec /i "C:\Users\AnaplanUser\Downloads\AnaplanExcelAddin.Release.msi"
```
--------------------------------
### Install to a specified directory with APPDIR option
Source: https://help.anaplan.com/0b1f0748-2805-4988-a394-bdb6186a94df
Use this command to install the add-in to a specified directory. The APPDIR option sets the installation directory.
```command
msiexec /i "C:\Users\AnaplanUser\Downloads\AnaplanExcelAddin.Release.msi" APPDIR="C:/Users/Anaplan/Add-in Folder"
```
--------------------------------
### GET /api/v2305.1/models/Consolidations/Dimensions
Source: https://help.anaplan.com/structure-of-an-api-request-bcddc03e-9c46-4174-9bae-347cf77a45d4
Example of a request to retrieve a list of dimensions within a specific model.
```APIDOC
## GET /api/v2305.1/models/Consolidations/Dimensions
### Description
Retrieves a list of dimensions within the Consolidations model.
### Method
GET
### Endpoint
https://fluenceapi-prod.fluence.app/api/v2305.1/models/Consolidations/Dimensions
### Parameters
#### Path Parameters
- **Consolidations** (string) - Required - The model name.
- **Dimensions** (string) - Required - The resource path for dimensions.
### Response
#### Success Response (200)
- **dimensions** (array) - List of dimensions.
#### Response Example
{
"dimensions": []
}
```
--------------------------------
### Response example with application/json and includeAll=true
Source: https://help.anaplan.com/retrieve-list-data-2309ce30-9f81-40d4-a7c3-473a8ff60667
Example response body when the Accept header is application/json and includeAll is true. The response includes additional fields subsets and properties for each list item.
```json
{
"meta": {
"schema": "https://api.anaplan.com/2/0/objects/list"
},
"status": {
"code": 200,
"message": "Success"
},
"listItems": [
{
"id": "206000000001",
"name": "cake",
"code": "c1",
"subsets": {
"favourite": true
},
"properties": {
"count": "1.0"
}
},
{
"id": "206000000002",
"name": "bread",
"code": "b2",
"subsets": {
"favourite": false
},
"properties": {
"count": "4.0"
}
},
{
"id": "206000000003",
"name": "pastry",
"code": "p3",
"subsets": {
"favourite": true
},
"properties": {
"count": "5.0"
}
}
]
}
```
--------------------------------
### GET /api/v2305.1/odata/ClientSchemaTable
Source: https://help.anaplan.com/structure-of-an-api-request-bcddc03e-9c46-4174-9bae-347cf77a45d4
Example of a valid API request to retrieve a client schema table using the OData endpoint.
```APIDOC
## GET /api/v2305.1/odata/ClientSchemaTable
### Description
Retrieves a client schema table using the OData endpoint.
### Method
GET
### Endpoint
https://fluenceapi-prod.fluence.app/api/v2305.1/odata/ClientSchemaTable
### Parameters
#### Path Parameters
- **ClientSchemaTable** (string) - Required - The name of the client schema table to retrieve.
### Response
#### Success Response (200)
- **data** (object) - The client schema table data.
#### Response Example
{
"data": {}
}
```
--------------------------------
### POST /process/start/
Source: https://help.anaplan.com/start-workflow-process-0e412efb-e168-4c94-818f-bb6bc550f493
Starts a workflow process within the specified folder(s) in the Explorer module. The request body should contain parameters for the start task or an empty array.
```APIDOC
## POST /process/start/
### Description
Use this method to command the Anaplan Financial Consolidation server to start a workflow process within the specified folder(s) in the Explorer module.
### Method
POST
### Endpoint
`/process/start/{path}/{name_of_workflow}`
### Parameters
#### Path Parameters
- **{path}** (string) - Required - The path to the workflow file in Explorer. Example: `ImportsandExports`
- **{name_of_workflow}** (string) - Required - The name of the workflow file in Explorer. Example: `ModelExport`
#### Request Body
- The request body should contain the parameters for the start task within the workflow process, or type `[]`.
### Request Example
```
curl --location POST 'https://fluenceapi-prod.fluence.app/api/v2305.1/process/start/ImportsandExports/ModelExport' \
--header 'TENANT: CustomerTenant' \
--header 'X-API-TOKEN: 73ca5973-ce3e-4cc6-b2d4-b09a99770ccf'
```
### Response
#### Success Response (200)
A `200 OK` response is generated if successful.
### Notes
Special characters such as `?`, `&`, and `/` are not recommended in the names of Explorer module folders or Workflow processes.
```
--------------------------------
### Enable EXE installation logging for Anaplan XL Reporting Web Edition
Source: https://help.anaplan.com/06264b8a-e6be-4129-9c03-885993ed4d52
Use this command to log installation errors when running the bootstrapper executable (EXE). The /ComponentArgs switch passes the logging arguments to the MSI component, writing a verbose log to the specified file path.
```text
Anaplan XL ReportingWebEdition.exe /ComponentArgs "Anaplan XL Reporting Web Edition":"/l*v C:\log.txt"
```
--------------------------------
### Initialize repository and get top-level folder
Source: https://help.anaplan.com/web-development-in-anaplan-xl-web-ff5db17c-52ac-44bc-8ebe-842ae566af2f
Initializes Anaplan XL, creates a repository object, and queries the server asynchronously. The callback receives the top-level folder; replace MyServerName with the actual Anaplan XL web site.
```javascript
```
--------------------------------
### Response 200 for getting tasks
Source: https://help.anaplan.com/start-the-process-c76c3d8d-9d98-4a76-bd6d-efed03ebecb4
Example JSON response returned when listing tasks. Shows taskId, taskState, and creationTime.
```json
{
"taskId":"BAB7819744034F25BF73EA1B41804478",
"taskState":"IN_PROGRESS",
"creationTime":1535145539157
}
```
--------------------------------
### Set SPNs for Web Server - Example
Source: https://help.anaplan.com/9dbca7be-7c69-4380-8239-3009a4f0a584
Example of setting SPNs for a web server using a domain account. Replace webserver and domain\appooluser with actual values.
```text
setspn -S http/webserver domain\appooluser setspn -S http/webserver.domain.com domain\appooluser
```
--------------------------------
### Curl example for GET /workspaces?tenantDetails=true
Source: https://help.anaplan.com/list-user-workspaces-c324d0af-01ce-4e6b-8039-06289a4f5b19
Use this curl command to list all workspaces the user can access in their default tenant. The tenantDetails=true query parameter returns an estimate of the current size (currentSize) and the allotted quota (sizeAllowance). Replace {anaplan_auth_token} with a valid Anaplan authentication token.
```bash
curl -X GET \
https://api.anaplan.com/2/0/workspaces?tenantDetails=true \
-H 'authorization: AnaplanAuthToken {anaplan_auth_token}'
```
--------------------------------
### Extract MSI with wix burn extract
Source: https://help.anaplan.com/anaplan-xl-msi-installation-45a17574-e7f9-4507-b39b-ad4e840f99c7
Run this command at the command line to extract the Windows Installer MSI from the AnaplanXLReporting.exe setup executable. Replace AnaplanXLReporting.exe with the full path to the setup executable. The MSI is extracted into a subdirectory called SupportFiles\WixAttachedContainer.
```shell
wix burn extract AnaplanXLReporting.exe -out SupportFiles -outba SupportFiles
```
--------------------------------
### Create symbolic link to share repository
Source: https://help.anaplan.com/configure-dual-authentication-for-anaplan-xl-web-50173fb4-2619-4c69-968f-73d6dfd30a2c
Run this command in an administrative Command Prompt to replace the new website's Repository folder with a symbolic link pointing to the original repository. This step is not needed if using the SQL repository.
```plaintext
MKLink /D Repository c:\inetpub\wwwroot\AnaplanXLWeb\repository
```
--------------------------------
### Response 200 (application/json) for GET /models/{modelId}
Source: https://help.anaplan.com/8baa6c1e-265f-440b-af26-1963fb88474c
Example response when modelDetails is not set or false. Contains model metadata and status.
```json
{
"meta": {
"schema": "https://api.anaplan.com/2/0/objects/model"
},
"model": {
"id": "FC12345678912343455667",
"activeState": "UNLOCKED",
"name": "PF&A",
"currentWorkspaceId": "8a8b8c8d8e8f8g8i",
"currentWorkspaceName": "Financial Planning",
"modelUrl": "https://rt.anaplan.com/anaplan/rt?selectedWorkspaceId\8a8b8c8d8e8f8g8i\u0026selectedModelId\FC12345678912343455667",
"categoryValues": []
},
"status": {
"code": 200,
"message": "Success"
}
}
```
--------------------------------
### Response example with application/json and includeAll=false
Source: https://help.anaplan.com/retrieve-list-data-2309ce30-9f81-40d4-a7c3-473a8ff60667
Example response body when the Accept header is application/json and includeAll is false. The response contains list items with id, name, and code fields.
```json
{
"meta": {
"schema": "https://api.anaplan.com/2/0/objects/list"
},
"status": {
"code": 200,
"message": "Success"
},
"listItems": [
{
"id": "206000000001",
"name": "cake",
"code": "c1"
},
{
"id": "206000000002",
"name": "bread",
"code": "b2"
},
{
"id": "206000000003",
"name": "pastry",
"code": "p3"
}
]
}
```
--------------------------------
### GET /process/start/ImportandExports/Data/ModelExport
Source: https://help.anaplan.com/bcddc03e-9c46-4174-9bae-347cf77a45d4
Start a process workflow for importing and exporting data, specifically for model export. This endpoint manages process workflows.
```APIDOC
## GET /process/start/ImportandExports/Data/ModelExport
### Description
Start a process workflow for importing and exporting data, specifically for model export. This endpoint manages process workflows.
### Method
GET
### Endpoint
https://fluenceapi-prod.fluence.app/api/v2305.1/process/start/ImportandExports/Data/ModelExport
### Response
#### Success Response (200)
- **status** (string) - The state of the workflow after starting.
#### Response Example
{
"status": "started"
}
```
--------------------------------
### GET /scim/1/0/v2/Users
Source: https://help.anaplan.com/how-to-implement-scim-6f127888-9b62-4ff1-8c5b-7a91be0f2d66
Example call to the SCIM Users endpoint using an Anaplan auth token. The Authorization header contains the token value.
```APIDOC
## GET /scim/1/0/v2/Users
### Description
Example call to the SCIM Users endpoint using an Anaplan auth token.
### Method
GET
### Endpoint
https://api.anaplan.com/scim/1/0/v2/Users
### Parameters
#### Headers
- **Authorization** (string) - Required - Header format: `Authorization: AnaplanAuthToken `
### Request Example
```
curl -X GET \
-H 'Authorization: AnaplanAuthToken _exampletokenvalue_' \
https://api.anaplan.com/scim/1/0/v2/Users
```
### Response
No response details provided in the source.
```
--------------------------------
### Response example for process dump download
Source: https://help.anaplan.com/download-the-process-dump-file-ffa228d0-2cc7-4e7f-9e95-279a4da30ecd
Example response body returned by the download request. It contains CSV-like data with headers and error messages for invalid rows.
```text
"_Status_","Column 1","Parent","Code","Start Date","Leave Date","Column 6","Column 7","Start Datesss","Column 9","Column 10","Column 11","_Line_","_Error_1_"
"W","Max Warren",",,","","4/16/12","","","","4/16/12","","","","151","Invalid parent"
"W","Carolyn Tabor","Supply Chain","",",,,","6/30/09","","","6/30/06","","","","153","Invalid date: ,,,"
"E","","Parent","Code","Start Date","Leave Date","","","Start Datesss","","","","11522","Invalid name: Code"
"E","","Parent","Code","Start Date","Leave Date","","","Start Datesss","","","","23043","Invalid name: Code"
```
--------------------------------
### GET /scim/1/0/v2/Users
Source: https://help.anaplan.com/how-to-implement-scim-6f127888-9b62-4ff1-8c5b-7a91be0f2d66
Example call to the SCIM Users endpoint using Basic Authentication. The Authorization header contains a Base64-encoded username and password.
```APIDOC
## GET /scim/1/0/v2/Users
### Description
Example call to the SCIM Users endpoint using Basic Authentication.
### Method
GET
### Endpoint
https://api.anaplan.com/scim/1/0/v2/Users
### Parameters
#### Headers
- **Authorization** (string) - Required - Header format: `Authorization: BASIC `
### Request Example
```
curl -X GET \
-H 'Authorization: BASIC dXNlcm5hbWU6cGFzc3dvcmQ=' \
https://api.anaplan.com/scim/1/0/v2/Users
```
### Response
No response details provided in the source.
```
--------------------------------
### Response example for assigning user roles
Source: https://help.anaplan.com/assign-user-roles-c0dabed5-b2c3-448f-813d-36e724bd5775
Example response showing the list of all roles after a successful assignment. If the user already had the Admin role, the response lists all roles, existing and new.
```json
[
"Admin",
"Controller",
"Reviewer"
]
```
--------------------------------
### Start process with curl POST
Source: https://help.anaplan.com/start-the-process-c76c3d8d-9d98-4a76-bd6d-efed03ebecb4
Use this curl command to start a process. Replace {workspaceId}, {modelId}, {processId}, and {anaplan_auth_token} with actual values. The request body includes localeName set to en_US.
```bash
curl -X POST \
https://api.anaplan.com/2/0/workspaces/{workspaceId}/models/{modelId}/processes/{processId}/tasks \
-H 'authorization: AnaplanAuthToken {anaplan_auth_token}' \
-H 'Content-Type:application/json' \
-d '{"localeName": "en_US"}'
```
--------------------------------
### Response 200 for create action
Source: https://help.anaplan.com/cb492bdf-5e59-4d3e-aa43-16d4431eddf2
Example response for a create action (SIMPLE_CREATE). Shows actionType and name.
```json
{
"meta": {
"schema": "https://api.anaplan.com/2/0/models/F7F3D1004C214A00A44C1655DE413B50/objects/action"
},
"status": {
"code": 200,
"message": "Success"
},
"action": {
"id": "117000000008",
"actionType": "SIMPLE_CREATE",
"name": "Create Action"
}
}
```
--------------------------------
### XLCubed.Settings.Init
Source: https://help.anaplan.com/web-development-in-anaplan-xl-web-ff5db17c-52ac-44bc-8ebe-842ae566af2f
Initializes the Anaplan XL web settings with the base URL of the Anaplan XL website.
```APIDOC
## XLCubed.Settings.Init
### Description
Initializes the Anaplan XL web settings with the base URL of the Anaplan XL website.
### Method
JavaScript function call
### Parameters
- **xlcubedOptions** (object) - Required - An object containing the `BaseUrl` property.
- `BaseUrl` (string) - Required - The base URL of the Anaplan XL website.
### Example
```javascript
var xlcubedOptions = { BaseUrl: "http://MyServerName" };
XLCubed.Settings.Init(xlcubedOptions);
```
```
--------------------------------
### Response 200 for GET /users/me
Source: https://help.anaplan.com/d5e7ae19-0a8a-44a7-a482-bdee7479e039
Example JSON response returned when the request is successful. Contains user details such as id, email, and status.
```json
{
"meta":{
"schema":"https://api.anaplan.com/2/0/objects/user"
},
"user":{
"id":"8a8b844a477d5da70147d150ee080b17",
"active":true,
"email":"a.user@anaplan.com",
"emailOptIn":true,
"firstName":"A",
"lastName":"User",
"customerId":"8b81da6f5fb6b75701604d6c950c05b1",
"lastLoginDate":"2017-09-07T08:05:37.000+0000"
},
"status":{
"code":200,
"message":"Success"
}
}
```
--------------------------------
### GET /scim/1/0/v2/Users
Source: https://help.anaplan.com/how-to-implement-scim-6f127888-9b62-4ff1-8c5b-7a91be0f2d66
Example call to the SCIM Users endpoint using an API key as a bearer token. The Authorization header contains the API key.
```APIDOC
## GET /scim/1/0/v2/Users
### Description
Example call to the SCIM Users endpoint using an API key as a bearer token.
### Method
GET
### Endpoint
https://api.anaplan.com/scim/1/0/v2/Users
### Parameters
#### Headers
- **Authorization** (string) - Required - Header format: `Authorization: Bearer `
### Request Example
```
curl -X GET \
-H 'Authorization: Bearer my-secure-api-key' \
https://api.anaplan.com/scim/1/0/v2/Users
```
### Response
No response details provided in the source.
```
--------------------------------
### Run MSI file with msiexec command
Source: https://help.anaplan.com/0b1f0748-2805-4988-a394-bdb6186a94df
Use this command to run the MSI file and display the Windows Installer dialog with a full list of installation options. Replace the file path with the actual location of the MSI file.
```command
msiexec "C:\Users\AnaplanUser\Downloads\AnaplanExcelAddin.Release.msi"
```
--------------------------------
### Response 200 (application/json) for get task information
Source: https://help.anaplan.com/ae734b14-4f61-4cfa-9e16-4d84b9500dda
Example JSON response for a successful task information request. The taskState is COMPLETE and successful is true.
```json
{
"task":{
"type":"taskInformation",
"taskId":"0690AA1C761F48549C3442A02F91D962",
"currentStep":"Complete.",
"progress":1,
"result":{
"failureDumpAvailable":false,
"objectId":"117000000019",
"successful":true
},
"taskState":"COMPLETE"
}
}
```
--------------------------------
### Response example with text/csv and includeAll=true
Source: https://help.anaplan.com/retrieve-list-data-2309ce30-9f81-40d4-a7c3-473a8ff60667
Example response body when the Accept header is text/csv and includeAll is true. The response is a CSV with columns id, name, code, parent, parentId, listId, listName, favourite, count.
```csv
id,name,code,parent,parentId,listId,listName,favourite,count
206000000001,cake,c1,,,,true,1.0
206000000002,bread,b2,,,,false,4.0
206000000003,pastry,p3,,,,true,5.0
```
--------------------------------
### Curl example for retrieving Optimizer action log
Source: https://help.anaplan.com/7e4dc987-4b11-491d-91de-046fc2c8947a
Use this curl command to download the Anaplan Optimizer solution log. Requires a valid authentication token, the Optimizer action ID, and the correlation ID from the Anaplan UI. The response is plain text.
```bash
curl -X GET \
https://api.anaplan.com/2/0/workspaces/{workspaceId}/models/{modelId}/optimizeActions/{actionId}/tasks/{correlationId}/solutionLogs \
-H 'Authorization: AnaplanAuthToken {anaplan_auth_token}'
-H 'Accept:text/plain'
```
--------------------------------
### Curl example for GET /models
Source: https://help.anaplan.com/9287c44b-7383-4ff2-b6fb-da34d77c6017
Use this curl command to retrieve model information. The endpoint is https://api.anaplan.com/2/0/models and requires an authorization header with an AnaplanAuthToken.
```bash
curl -X GET \
https://api.anaplan.com/2/0/models \
-H 'authorization: AnaplanAuthToken {anaplan_auth_token}'
```
--------------------------------
### Response 200 for start deletion task
Source: https://help.anaplan.com/e085ce2c-861c-4b1a-9842-4da010773ae6
Example JSON response returned when the deletion task is successfully initiated. Contains the taskId of the created task.
```json
{
"task":{
"taskId":"0690AA1C761F48549C3442A02F91D962"
}
}
```
--------------------------------
### Curl example for GET /models/{modelId}
Source: https://help.anaplan.com/8baa6c1e-265f-440b-af26-1963fb88474c
Use this curl command to retrieve model information. Replace {modelId} with the model ID and {anaplan_auth_token} with your authentication token.
```bash
curl -X GET \
https://api.anaplan.com/2/0/models/{modelId} \
-H 'authorization: AnaplanAuthToken {anaplan_auth_token}'
```
--------------------------------
### Set installation location with bootstrapper
Source: https://help.anaplan.com/anaplan-xl-reporting-silent-installation-92c87d07-ae25-49d3-bd4b-2f0709a1ecd1
Use this command to specify a custom installation folder when using the .exe bootstrapper.
```plaintext
AnaplanXLReporting.exe INSTALLLOCATION="C:\My Install Folder"
```