Anaplan icon

Anaplan

Anaplan API actions: Export, Import, Lists, Files, Module updates, Single Cell, etc.

Update Module Cells

AI-generated

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

  1. Updating sales data for specific products and time periods in an Anaplan module.
  2. 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, required to actually 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 workspace, model, and module IDs are correctly selected and accessible with the provided credentials.
  • Verify the JSON format of the cell data is correct and matches the expected structure for Anaplan cell updates.
  • Set 'Confirm Write Operation' to true to enable the update; otherwise, the operation will not perform any changes.
  • Check for permission issues or API limits that might prevent successful updates.

Links

Discussion