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 actions such as exporting data, importing CSV data into Anaplan files, managing lists, updating modules, and more. Specifically, the 'Import' operation allows users to upload raw CSV data to a specified Anaplan file and optionally run an import process on that file. This is useful for automating data uploads and imports into Anaplan models within specified workspaces, streamlining data integration workflows.
Use Case Examples
- Automate uploading sales data CSV files into an Anaplan model for daily updates.
- Run an import process in Anaplan after uploading new data to trigger model recalculations.
- Use JSON mapping to customize how CSV data fields map to Anaplan import fields.
Properties
| Name | Meaning |
|---|---|
| Authentication | Method of authenticating with the Anaplan API, currently supports Basic Auth. |
| Workspace ID | Select the Anaplan workspace where the model and files reside. |
| Model ID | Select the specific Anaplan model within the chosen workspace. |
| File ID (For Import) | The Anaplan File ID where the CSV data will be uploaded. |
| Import ID | The Anaplan Import ID to run after the CSV upload completes. |
| CSV Data (For Import) | Raw CSV data string to upload into the specified Anaplan file. |
| Import Mapping (JSON) | Optional JSON string to define custom field mappings for the import process. |
| Confirm Write Operation | Boolean flag to confirm and allow write operations to Anaplan (dangerous operation). |
Output
JSON
importResult- Result of the import operation including status and any messages returned by Anaplan.
Dependencies
- Anaplan API
- Basic Auth credentials for Anaplan
Troubleshooting
- Ensure the workspaceId, modelId, fileId, and importId are correct and exist in your Anaplan account.
- Confirm that the CSV data format matches the expected format for the target Anaplan file.
- Set 'Confirm Write Operation' to true to allow data upload and import; otherwise, the operation will not proceed.
- Check network connectivity and API authentication credentials if requests fail.
Links
- Anaplan Import Documentation - Official documentation on importing data into Anaplan.
- Anaplan Authentication - Details on authenticating API requests to Anaplan.