Anaplan icon

Anaplan

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

Actions25

Overview

This node interacts with the Anaplan API to perform various actions including exporting data, importing data, managing lists and files, updating modules, and retrieving single cell values from Anaplan models. Specifically, the 'Get Single Cell' operation allows users to retrieve the value of a specific cell within a module or line item in an Anaplan model. This is useful for scenarios where precise data points are needed from complex models, such as financial figures, inventory counts, or key performance indicators.

Use Case Examples

  1. Retrieve the value of a specific cell in a financial model to use in a report.
  2. Fetch a single data point from an inventory management model to trigger alerts.
  3. Get a KPI value from a sales forecast model for dashboard display.

Properties

Name Meaning
Authentication Method used to authenticate with the Anaplan API, currently supports Basic Auth.
Workspace ID Select the Anaplan workspace to operate within.
Model ID Select the Anaplan model within the chosen workspace.
Module ID Select the module or view to export data from; optional for this operation.
Line Item Select a line item from the chosen module; overrides the module ID if set.
Dimension ID Select a dimension from the chosen line item; optional for this operation.
Dimension Items Optional dimension item used for post-processing to help locate a row in the returned data; not sent to Anaplan.
Pages Select existing page selectors (dimensionId:itemId) to apply to the request; optional.

Output

JSON

  • cellValue - The value of the requested single cell from the Anaplan model.

Dependencies

  • Anaplan API
  • Basic Authentication credentials

Troubleshooting

  • Ensure that the workspace ID, model ID, and line item/module IDs are correctly selected and exist in the Anaplan environment.
  • Authentication errors may occur if the Basic Auth credentials are incorrect or expired; verify credentials.
  • If the specified cell or dimension does not exist, the node may return an empty or error response; double-check IDs and selections.

Links

Discussion