Export in Anaplan API - What to do next?

Hi everyone!

I'm new working with Anaplan and also with APIs. i've been managing it quite well but I'm stucked in one step hope you can help me overcoming this.

I've already get al chunks of the export however I don't know how to download the data... the file exported 26 chunks and I get chunk id 0, 1, 2 and so on. So the lastest request that I've made so far is:

https://api.anaplan.com/2/0/workspaces/workspaceid/models/modelid/files/taskid/chunks/1

And it does shows me data but... what to do next? I need to concatenate with other 25 chunks and donwload them.

I'm using Postman btw.

Thanks in advance for your help.

Accepted answers

All comments

kevin.cho

You will need to loop through the number of chunks you are requiring to download, and then concatenate the result together. Chunk counts start at 0 remember, so if you have 26 chunks it will be from 0 to 25.

Within Postman, I think you could use the Collection Runner Using the Collection Runner | Postman Learning Center to loop through and then store the response from each successive request using the Tests Scripts section to eventually concatenate through, but this may be a bit convoluted.

I personally use Postman more for testing individual requests - anything repeatable or productionised, I would move to something else. If you're just automating exports/downloads, then Anaplan Connect is a good option, otherwise building out a Python app or other is also an option.

dfpaezo

Thanks kevin.cho for your prompt response.

I feel overwhelmed trying to understand this. 😞 I need to do exactly as you told. Automate exports from my Anaplan model. Is there any documentation how to use python with Anaplan? I dont know where and how to start.

Thank you in advance.

kevin.cho

Hi @dfpaezo - If you're just trying to automate exports, I wouldn't try to re-invent the wheel - try taking a look at Anaplan Connect, which is a supported Java based CLI tool that you can then combine with schedulers such as Windows Task Scheduler or cron jobs, depending on the operating system you are working with. Anaplan Connect - Anaplan Technical Documentation

dfpaezo

Hi there @kevin.cho ,

I read Anaplan Connect documentation and ain't difficult so far. Running my first script haven''t been successfull at all. May I share with you some details?

This is the first script on documentation that may run but unfortunately it doesn't

echo off

rem This example loads a source text file and runs an Anaplan import into a module.

rem For details of how to configure this script see doc\Anaplan Connect User Guide.doc

set AnaplanUser="periscope@abbott.com:password"

set WorkspaceId="8a8194824045c4240140a4a15253610d"

set ModelId="CF6A1AC04E0D4F5686B95E137BA57938"

set Operation=-service "https://api.anaplan.com" -auth "https://auth.anaplan.com"

-file "testing.txt" -put "C:\Users\Diego\Documents\Anaplan\testing.txt" -import "C:\Users\Diego\Documents\Anaplan\importsample.txt" -execute

-output "C:\Users\Diego\Documents\Anaplan\My Errors.txt"

rem *** End of settings - Do not edit below this line ***

setlocal enableextensions enabledelayedexpansion || exit /b 1

cd %~dp0

if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser%

set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation%

echo %Command%

cmd /c %Command%

pause

The output that i got, is Error 7832 (Whenever I run the script throws another number)

I don't know why I'm doing wrong 😞

kevin.cho

Can you share a screenshot of your entire Command Prompt window? Just to see how you are calling the script itself

ben_speight

The -import command line switch is used to specify an import in the model, not a file on your computer. Not sure why the program is unhappy with the command line arguments, perhaps try something simple like listing available files in the model first, then build it up step by step.

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?