Anaplan Connect - Export Script

Hi,

I am getting the following error, followed by a list of options in my CMD window when i run my batch file.

My batch file is as follows (minus credentials and export names);

@echo off
Set AnaplanUser="Username:Password"
Set WorkspaceId="XXX"
Set ModelId="XXX"
Set Operation=-export "XXX" -get "XXX"
rem *** End of setting - 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

This is my error message:

Running Anaplan Connect...
Using Class-Path: C:\Users\XXX\Downloads\anaplan-connect-1.4.1\anaplan-connect-1.4.1-jar-with-dependencies.jar
2019-07-19 15:42:29 [1;31mERROR[0;39m [35m16992[0;39m |-- Options are:

And the list goes on with a huge list of options.

Any help would be much appreciated.

Accepted answers

ben_speight

Are you missing a space between -model and %ModelId%?

Also, don't forget to use -execute if you want to run the export before downloading the result.

jnoone

Can you also trying adding an -execute before your -get command?

All comments

ben_speight

Are you missing a space between -model and %ModelId%?

Also, don't forget to use -execute if you want to run the export before downloading the result.

jnoone

Can you also trying adding an -execute before your -get command?

CallumW

Thanks both, I am now being asked for an Auth URL, is there a way to default this?

jnoone

Assuming you are using the 1.4 API, add in:

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

CallumW

That is great - thank you!

All working perfectly now.

aravind_1895

Hi,
@echo off
set AnaplanUser="XXX:XXX"
set WorkspaceId="XXX"
set ModelID="XXX"
set Operation= -service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -export "AMPS Export - Copy - Data.txt" -execute -get "C:\Output.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
This is my script to run export action. but the error I am facing is ''Using Class-Path: C:\anaplan-connect-1.4.1 (2)\anaplan-connect-1.4.1-jar-with-dependencies.jar
\lib\%l was unexpected at this time.''

Please give me some suggestions to fix this.

aravind_1895

Current Java version is valid for Anaplan Connect.
Running Anaplan Connect...
'Using Class-Path: C:\anaplan-connect-1.4.1 (2)\anaplan-connect-1.4.1-jar-with-dependencies.jar
\lib\%l was unexpected at this time.' - Exact error which I am facing

Niko1703

Hi,

Did you manage to solve this?

I have exactly the same issue.

Thanks!

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…