Actions25
- Export
- Get List Items
- Get Single Cell
- Get Line Items
- Get Line Item Dimension IDs
- Get Line Item Dimensions
- Get Line Item Metadata (Model)
- Get Module Line Item Metadata
- Get List Metadata
- Get List Data
- Add List Items
- Update Module Cells
- Import
- Get Files
- Upload File
- Update List Items
- Delete List Items
- Reset List Index
- Preview List Data
- Initiate List Read Request
- Get List Read Request Status
- Download List Read Request Page
- Delete List Read Request
- Import Module
- Import List
Get Single Cell
AI-generatedOverview
This node interacts with the Anaplan API to perform various operations including exporting data, importing data, managing lists, files, module updates, and retrieving single cell values from Anaplan models. Specifically, the 'Get Single Cell' operation allows users to retrieve the value of a single cell from a specified module or line item within an Anaplan model. This is useful for scenarios where precise data points are needed from complex models, such as financial figures, inventory counts, or other key metrics stored in Anaplan.
Use Case Examples
- Retrieve a specific financial metric from a budgeting model by specifying the workspace, model, module, and line item.
- Fetch a single cell value from a sales forecast model to use in further automation or reporting workflows.
Properties
| Name | Meaning |
|---|---|
| Authentication | Method of authenticating 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 some operations. |
| Line Item | Select a line item from the chosen module; overrides the module ID in the request if set. |
| Dimension ID | Select a dimension from the chosen line item; used for operations involving dimensions. |
| Dimension Items | Optional dimension item to help locate a row in the returned data; used for post-processing only. |
| Pages | Select existing page selectors (dimensionId:itemId) to apply to the request; if empty, no pages are applied. |
Output
JSON
cellValue- The value of the single cell retrieved from the Anaplan model.
Dependencies
- Anaplan API with Basic Authentication
Troubleshooting
- Ensure that the workspace ID, model ID, and module or line item IDs are correctly selected and exist in your Anaplan environment.
- Authentication errors may occur if the Basic Auth credentials are incorrect or expired; verify and update credentials as needed.
- If the specified cell or dimension does not exist, the node may return an empty or error response; double-check the IDs and parameters used.
Links
- Anaplan API Documentation - Official documentation for the Anaplan API, useful for understanding available endpoints and data structures.