ANAPLAN CONNECT EXPORT SCRIPT

adityaplanafin
adityaplanafin
in Integrations and extensibility

@Echo off
set AnaplanUser="***"
set WorkspaceId="***"
set ModelId="***"
set Operation=-service "https://api.anaplan.com" -auth "https://auth.anaplan.com"
-export "***" -execute -get "***"
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
 after running this i am getting an error as below :

 

Action Information:
-------------------
(-o|-output) <local path>: Retrieve dump file(s) for completed import/process
-emd: Describe layout of an export (metadata)

JDBC:
-----
-loadclass <class name>: This parameter is not required since AC 1.4.4.
It will be removed in next version of AC.
-jdbcproperties: Path to JDBC properties file.

 

Any help

Tagged:

Best Answer

  • ben_speight
    ben_speight
    Answer ✓

    Has a text editor wrapped the -export "***" -execute -get "***" bit onto a separate line?

    Anaplan Connect gives a usage summary either if an unrecognised option or it looks like it has been given nothing to do

Answers

  • adityaplanafin
    adityaplanafin

    Cant get it still now

  • M.Kierepka
    M.Kierepka

    Hi,

    It looks like you have extra "%" there - I believe it should be "set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation%" instead of "set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model% %ModelId% %Operation%"

    Also, if you are posting code to community, I recommend putting it in "Code sample" type of input:

     

    <a href="/profile/Echo">@Echo</a> off
set AnaplanUser="Anaplan.User@anaplan.com:Password"
set WorkspaceId="8a1234567897c12b014bf01234567890"
set ModelID="CD1234D60CA84E9A123C1C5D061C1234"
set Operation=-service "https://api.anaplan.com" -auth "https://auth.anaplan.com"
-export "Employee by Department.xls" -execute -get "C:\Employee.xls"
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

     

  • adityaplanafin
    adityaplanafin
    yes after doing this it is still not working

Categories