-
can we send a file name into the process api?
Hi: I have a Process which contains delete list, import list and update module action, as import action need users to pick a file from their computer, do we have any API for Process that can receive the file name? I want to use ETL tool to call this API and send the file to it. I know the Import API can receive the file…
-
Help with Level 1 model builder 7.2.3 : import issues
Hello ! In the import, commission % is 0.15% but when it appears on my dashboard Anaplan it writes 15% which is not the same ahah I tried to change format in blue view but I don't know what to do ?
-
Anaplan Connect - Script Import Files
Hello I used the following script provided by the Anaplan Connect guide to import files: set AnaplanUser="useremail:password"set ServiceUrl="https://api.anaplan.com" set AuthUrl="https://auth.anaplan.com" set WorkspaceId="8a81b09e5f88df6e015f9773e37c675f" set ModelId="FCDBA62F401B40E9B73A42983C4FDDCC" set Operation=-debug…
-
Cloudwork export don't include the time stamp
Is there a way i could exclude the time stamp? i basically don't want anything that's from _January until 034607. Thanks.
-
Data Validation when using Anaplan API
One thing i've found quite challenging when doing API implementations (and at this point i've done well into my 20s of these) is, what is the best way to validate that my API calls are properly working? Specifically - how can I validate that file uploads are pushing in the right data? There are so many different variables…
-
Cloudworks export to azure blob container
Is it possible to define the export to a folder directory within the blob container? Currently i can dump it into the container (i.e., not to a specific folder in the container) Thank you
-
Avoid creating duplicate items in list when importing from a versioned module
I have a process that creates keys and values in a list based on if a key has a non-zero value in a source module. The source module is versioned and some key value pairs could be zero for some versions and non-zero for others. The list finally has to have all key value pairs that have non-zero values in at least one…
-
Data Export Tabular Single Column
Hi all, I want to export a table format without the page dimention (which is essentailly the red and green as below) But when i choose Tabular Single Column, It gives me a lot of columns that didn't exist in my original saved view and made my csv from 70mb to 2gb. These appeared in the labels tab which are the info i don't…
-
JAVA REST API example with Anaplan generated Certificate
Hi All - SSO is enabled for my tenant with exemption users not allowed due to internal policy so certificate authentication is my next option to bring data into anaplan is a systematic flow. I will obtain a CA Certificate as described…
-
Unable to import data from Azure blob via Anaplan Cloudworks
Hi, I'm unable to import data into my list/module from Azure Blob via Anaplan Cloudworks. The connection is correctly created. I can successfully export data from cloudworks to azure and i don't know why i'm encountering issues when importing data. I've tried to import manually the data and actions are correct (import work…
-
Is there a way to connect Anaplan with KNIME?
Hi all, I'm trying to connect Anaplan with KNIME to automate some custom upload files. And thinking to use Anaplan API, but haven't figured out yet how to connect it. Hoping that sb already managed to connect to KNIME. Thank you!
-
CloudWorks performance question
We were considering using Cloudworks for integration instead of Anaplan Connect scripts and someone is dissuading us from using Cloudworks because it had "performance" issues because there is only one server dedicated executing all actions setup on Cloudworks? Is this true as I'm unable to find any such information on this…
-
error parsing key for this row no values" error while importing a list from saved view. In what way
-
Help with level 1 model builder 7.2.3 Activity: Import Data into Employee Details Module
I have blank I don't know how to map them manually as I don't know who is number 2 ? Thank you :)
-
Cloudworks API: Change Schedule
I'm working on a script that would update integration schedule. In future my target is to have a script that would move all my integrations + integration flows +/- 1 hour on DST changes. For updating integration shedule I have sent PUT request to endpoint…
-
OAuth Authentication and Anaplan Connect
Hi, I have been testing OAuth connection with Anaplan Connect. And it has been quite a struggle. I started with "Authentication - Generate OAuth Token With Force Register" and it was not really working but giving strange error messages that didn't really help. After trial and error I got the example script to work by…
-
Excel add-in save & refresh: possible to fill line item data with formula's in excel?
Hi, Using the Excel add-in, I am curious whether it is possible to auto-populate line item data using formula's in Excel. Can anyone tell me if it is possible to set this up and if so how? As an example: consider a module linked in Excel where cell A7 contains a line item with B7 a number that is editable. Is it possible…
-
Anaplan Excel add-in 4.3 Cloning
I am trying to copy an excel sheet with an existing Anaplan connection into another workbook. However, once the copy is done, the Anaplan connection seems to be broken and cannot be refreshed. I understand that the cloning function currently works within a workbook only, does anyone have any workarounds with respect to…
-
Different numbers being imported
I have 2 modules, both with exactly the same structure (2 dimensions, multiple versions, no time scale, and with only one line item). I created a simple import from one module to the other, however, once the import has run successfully with no errors, I'm getting different numbers landing in the corresponding cells in the…
-
Anaplan Connect: Difficulties setting up export from Anaplan to SQL Server
Hi, We're trying to set up a connection to export data from Anaplan to Microsoft SQL Server. We already have a working connection to import data into Anaplan, but we can't manage to set this up the other way around (export). We set up the export connection using the Anaplan Connect guide and our working import actions. We…
-
Export failed for non Admin users
Hi all, I am currently facing an Export issue: non-Admin users do not get the file xlsx exported, while i can, being Admin user. I have checked all possible reasons: I have checked that export action is assigned to the roles I have set in export definition the default export file for "Everyone" I have saved the view to…
-
Can the current AND previous Start Date and Time (UTC) values be saved?
For daily (or any automated) processes, it would be convenient to see 'version -1' start times. We have dozens of processes that run daily, and this would assist in determining if/what is running as designed when an issue arises. It's cumbersome to examine the History logs.
-
Data from Anaplan to snowflake
Hi all what's the best solution for moving data from anaplan to snowflake? Thank you.
-
Adding new level to existing hierarchy
Hi Everyone, The model has 7 levels of hierarchy for three years now. Would it be advisable to add another level between l6 and l7, taking into account the consequences?
-
"dumps.json file not available" when trying to download error logs from CloudWorks
I am getting the error "dumps.json file not available" when trying to download an error log from a past integration run. At first I thought this was because the logs I was downloading were from a few weeks ago, but now I am getting this error for a run that happened yesterday (I was able to successfully download the .csv…
-
How to set up integration from MS SQL Server table to Anaplan model via Talend
Hi, We are trying to load contents from a table in MS SQL Server table to Anaplan model (processes, actions, etc.) using Talend. So far we are able to make connection to Anaplan model and do the authentication successfully. We are able to view all import ids of the model / process ids / action id. I am following this user…
-
Get authentication token details
Hello I'm currently trying to execute the instructions of the Authentication Service API document: I'm stuck at the step "Get auth token details". I use the software Postman to test the request. I tried the type of authorization "Bearer Token" and fill the field "Token" with the token value that i got with the request HTTP…
-
How can I connect Anaplan to Talend using Anaplan Jar Modules
How can I test if this jar library module is running fine. Anaplan Home Along with this jar file, I also have keystore(jks), pem files too.
-
Integrating to Anaplan with Talend
Hi all, Has anyone successfully integrated a Database result to Anaplan using Talend Studio? I've looked all over and cannot find successful examples of querying a db, using that dataset and pushing it to Anaplan without saving it to a file first. My issue is I cannot get the db result into a format that feeds correctly…
-
Transactional API for Direct Module Data Access
Hi All, Has anybody built a solution using the Transactional APIs to Retrieve cell data for a view yet. There is reference of Denodo Virtualization tool on forums but it does not work for modules above 1,000,000 cells since there is restriction on the API endpoint.