Data Integration

NUX Forms: Exception handling when duplicate code entered
When using forms to add to a list (where the code can be entered), users can accidently re-enter an existing code which triggers a model roll back, as it's considered a duplicate. There's also no notification the model is rolling back so it looks like the app is spinning its wheels. This leads to confusion and potentially…
Powerpoint Text Help
Greetings, Is there a way other than Copy and paste each word (text), to create 10 separate slides of a 10-word sentence on PPT using a command or Plugin? (Task - 700 to an 800-word essay has to be separated into slides. One word per slide.)
1.5.6.2 Import Data into Historic Volumes Module | Invalid line item identifier
Hello All, Can someone help me to point where this is going wrong. I am getting Import complete but with failures : Invalid line item identifier please see the screen shots for details. Thank you
Size limit import data Using Talend ETL & API
Hi all, i need to load a lot of data in transaction level AP & AR. For now, i still don't have any idea how big. just wondering about : 1. is there any size limitation when import data using API? 2. Is there any timeout when import data using API? Thanks a lot
Outlook Email to Create Item in Anaplan
It would be cool if we could take an email and create an item in Anaplan. If we use anaplan for tracking defects/bugs and enhancements but users submit an item via email, having an item created could be a nice feature. I have done this in the past with integrating microsoft forms with Azure DevOps but that took workflow…
Increase number of integrations for Cloudworks
Increase the limit for Cloudworks integrations & integration flows from 500 to 1000.
Be able to have multiple imports of saved view to module
As part of the model cycle have an import which takes from model A and imports to model B but for the first run it's only half the line items and then for the second run it's the whole set. Essentially the second half of metrics are in flux and the end users don't want them updated. What we have to do is go in and adjust…
Automatically generate Keys for Importing fact data into Data Hub module
Importing fact data into "flat modules" in a Data Hub is challenging when your data source is unable to provide a single unique Key to act as a List Item. That work ends up taking place between the extracted data and the import into Anaplan and oftentimes involves concatenating Key columns into a single column, sometimes…
Export User Access with Display Names of Selective Access Lists (if Numbered)
If in the system Selective Access is set to Numbered List, when you export User Access list, all items are shown as #NAME instead of display name. Currently, on quarter basis we are preparing current user access lists to provide to responsible people. An it takes a lot of time to manually replace #NAMES with Display one,…
Anaplan Api call via postman
Hi, I am trying to call Anaplan API via postman. I tried Authenicate with https://auth.anaplan.com/token/authenticate and generated token Then i tried calling imports pasting the token through the url https://api.anaplan.com/1/0/workspaces/[workspace id]/models/[model id]/imports and its retrieving the data. But i am not…
Import Shipping Expenses into OTH01 Module
Import Shipping Expenses into OTH01 Module In the Financial Planning & Analysis model: Import the data from the Supply Chain model into the OTH01 Non Employee Expenses module, Shipping Cost line item. * For department, import into the Sales department. * Run the import. * Results should have none ignored and 0 errors .…
Publish Postman API Collections for various Anaplan API Categories
It would be handy if the various API documentations outlined in is accompanied with its corresponding Postman collection like the one below . Currently I'm unable to find the Postman collections for ALM API and CloudWorks APLI
CloudWorks - Page Readability
Hi everyone, Is it only me or does the CloudWorks Page - Integration & Processes Page in particular - lack in terms of readability in your opinion? What I mean by that is, there are presumably cases where users have lots and lots of Integrations & Processes listed one after another and it's pretty cumbersome to manage them…
Export Model Map to PDF/Excel
Capability to Export Model Map from Contents page to PDF/Excel.
Run Action Concurrency
Hi, I want to check the action concurrency. If several users run the action, Action which first user run will run? The second user's will not run?
Using Python 3 with the Anaplan API
* Getting Started * Authentication * Getting the Information Needed for Each Script * Uploads * Multiple Chunk Uploads * Single Chunk Upload * Imports * Exports * Actions * Processes * Downloading a File * Deleting a File * Standalone Requests Code and Their Required Headers * Get Workspaces List * Get Models List * Get…
Anaplan API | Add list items to a numbered list by combination of properties as a unique identifier
Dears, I am currently writing an API call to add a list item to a numbered list. Here, i would like to use a combination of properties as a unique identifier, not the regular code. Which has to be specified in the request body. Unfortunately, I haven't found any guidance in the documentation on how to do that (). Does…
Saved Export Actions
For saved exports from Anaplan, how does the export remember what to export? I'm used to creating a saved view to represent the export, however, if a saved view is not created and potentially certain list members and/or line items were hidden/visible when the export was created, is that what Anaplan remembers for that…
Maintain Formatting in Data Export
When exporting data from Anaplan to Excel, it would be great to have the option to maintain certain formatting options such as wrapped text and conditional formatting.
Host Images Directly In Anaplan and Display on Dashboards Like Data and Files
Hi Anaplan! It would be great if Anaplan could store images directly and host them on the platform to dashboards. This would allow for easier hosting and one secure location. Also if there was a process assigned to uploading images this could help use cases for uploading multiple images at once in a bulk upload. Thanks,…
How to move or copy an excel spreadsheet without loosing connection
I'd like to merge 2 excel files. Both have anaplan connections. How can I move or copy excel spreadsheets to another file withour loosing my anaplan connection?
How to I access a failure dump of an action within a process using the API
I understand I can get an import's failure dump if I run the import, then get the task id, then construct a url: https://api.anaplan.com/2/0/workspaces/{WorkspaceId}/models/{ModelId}/imports/{ImportId}/tasks/{TaskId}/dump . My issue is that i'm running a process, which runs a number of imports. One of which has a failure…
Use ChatGPT's API to produce commentary and send it back into Anaplan
I've love to see some more native API's to connect Anaplan into ChatGPT API to be able to generate commentary. This would be an application similar to CloudWorks or PlanIQ that allows you to configure certain fields to be selected and then a certain style or questions can be asked to ChatGPT to produce the commentary based…
CloudWorks Integrations & Processes General Columns
I don't want to waste the space to create an extensively long name to identify what Model my Integration corresponds to, especially when we add many new integrations. Can you please add the Workspace and Model to the columns available when looking at Integrations so I don't need to click into every single one to check…
1.5.6.2 Import Data into Historic Volumes Module
Hi All, Please find attached the screenshots of the mapping I have done for the import process. But I am facing the error - Manual mapping is unavailable when number of items exceeds 5000. Because this I am unable to perform the mapping of line item "Volume". I have used the file provided in the activity…
VBA/macros for Excel Add-In
As a model builder I would like VBA and macros to be supported in the Excel Add-In so that I could further automate workbooks. For example : 1) I would like to be able to create VBA code and macros for the various Anaplan actions so that I could automate a number of tasks (eg Login and refresh data) through macros 2) I…
Metadata
Can someone explain what exactly is metadata, and what is the role of metadata in the datahub and how it is better to calculate the metadata in the datahub itself rather than importing it to other spoke models?
Excel Add-in 4.0 - Make Clone function be able to clone a tab into another workbook
Hi, I would like to suggest adding additional functionality to the Clone button. It would be helpful to be able to clone a tab and all of its formatting (or at least the tab's connection and connection settings) to a new tab in another Excel workbook and/or to a new tab in a brand new workbook to be opened. Thanks,
Automate Notification Feature
Hi Team, I have currently published the "Notification" button on New UX page which shares the URL for the respective page with defined "Recipient". Anaplan has introduced the "ANAPLAN Cloudworks" which automates the defined Actions(Import/Export) but how can I automate the notification feature through ANAPLAN Cloudworks…
CloudWorks Integrations & Processes General Columns
I don't want to waste the space to create an extensively long name to identify what Model my Integration corresponds to, especially when we add many new integrations. Can you please add the Workspace and Model to the columns available when looking at Integrations so I don't need to click into every single one to check…

Data Integration

Discussion List