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
Import
AI-generatedOverview
This node integrates with the Anaplan API to perform various actions such as importing CSV data into Anaplan models. Specifically, the 'Import' operation allows users to upload raw CSV data to a specified Anaplan file within a workspace and model, and optionally run an import process afterward. This is useful for automating data uploads and imports into Anaplan for tasks like updating financial models, sales forecasts, or operational data.
Use Case Examples
- Automate uploading monthly sales data CSV to an Anaplan model and trigger the import process.
- Upload updated inventory data CSV to a specific Anaplan file and run the import to refresh the model data.
Properties
| Name | Meaning |
|---|---|
| Authentication | Method of authenticating with 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 provide a mapping configuration for the import. |
| Confirm Write Operation | Boolean flag to confirm the write operation, required to proceed with data changes. |
Output
JSON
importResult- Result of the import operation including status and any messages.
Dependencies
- Requires Anaplan API access with Basic Authentication credentials.
Troubleshooting
- Ensure the workspaceId, modelId, fileId, and importId are correct and accessible with the provided credentials.
- Confirm that the CSV data format matches the expected schema for the Anaplan file to avoid import errors.
- Set 'Confirm Write Operation' to true to allow the import to proceed; otherwise, the operation may be blocked as a safety measure.
- Check network connectivity and API rate limits if requests fail or time out.
Links
- Anaplan Bulk API 2.0 Documentation - Official API documentation for Anaplan bulk operations including imports.