Actions25
- Export
- Get List Items
- Get Line Items
- Get Line Item Dimension IDs
- Get Module Line Item Metadata
- Get Line Item Metadata (Model)
- Get List Data
- Update Module Cells
- Get Files
- Upload File
- Reset List Index
- Delete List Items
- Initiate List Read Request
- Download List Read Request Page
- Delete List Read Request
- Import List
- Get Single Cell
- Get Line Item Dimensions
- Get List Metadata
- Add List Items
- Import
- Update List Items
- Preview List Data
- Get List Read Request Status
- Import Module
Overview
This node integrates with the Anaplan API to perform various operations including updating module cells within an Anaplan model. Specifically, the 'Update Module Cells' operation allows users to write data to specific cells in a module by specifying the workspace, model, module, and cell data in JSON format. This is useful for automating data updates in Anaplan models, such as updating sales figures, inventory levels, or other key metrics programmatically.
Use Case Examples
- Updating sales data for specific products and time periods in an Anaplan module.
- Automating the input of forecast values into an Anaplan model based on external calculations.
Properties
| Name | Meaning |
|---|---|
| Authentication | Method of authenticating with the Anaplan API, currently supports Basic Auth. |
| Workspace ID | Select the Anaplan workspace where the model resides. |
| Model ID | Select the specific Anaplan model within the workspace. |
| Module ID | Select the module within the model to update cells in. |
| Pages | Optional page selectors to filter the data update by specific dimension items. |
| Cell Data (JSON) | JSON array describing the cells to update, including line item names, dimension details, and values to write. |
| Confirm Write Operation | Boolean flag to confirm the write operation; must be true to perform the update to prevent accidental data changes. |
Output
JSON
success- Indicates if the update operation was successful.message- Additional information or error messages related to the update operation.
Dependencies
- Anaplan API with Basic Authentication
Troubleshooting
- Ensure the 'Confirm Write Operation' flag is set to true to allow data updates; otherwise, the operation will not execute.
- Verify that the workspace, model, and module IDs are correct and accessible with the provided credentials.
- Validate the JSON format of the 'Cell Data' input to avoid parsing errors.
- Check API rate limits and permissions if updates fail or return authorization errors.
Links
- Anaplan API Documentation - Official documentation for Anaplan API endpoints and usage.