How to export result as .csv file through Anaplan Connect script?

Hi Experts,

I'm trying to explore on Transactional APIs scripting. When I execute below script is working fine and extracting all the List items. But I want to export this data as .csv file, how to achieve this?

set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -L

I tried with below code, but it's not creating any file.

set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -L -execute –get:csv %OutputPath%

Seems I'm doing some thing wrong. Kindly help me here.

Thanks & regards,

Anil

Accepted answers

All comments

StevenBeerthuizen

Hi Anil,

As far as I can see in the documentation, the -get is used for getting an export file from an export action. Not just exporting anything from the operation you define. But i do not know Anaplan Connect that well. It might also help if you change the subject title to "How to export result as .csv file through Anaplan Connect script?", because it does make a difference if you use Anaplan Connect or the Transactional API directly.

Kind regards,

Steven

anildudam

Hi Steven,

Thanks for your reply.

as per your suggestion I have changed the subject title.

Still waiting for the solution from expects.

Thanks & regards,

Anil

ManjunathKN

Hi Anil,

I am no expert in pulling transactional API from anaplan connect. it seems that you are missing the List ID to execute the operation

Add

set ListId="listid"

and use operation

set Operation=-debug -service %ServiceUrl% -auth
%AuthUrl% -workspace %WorkspaceId% -model %ModelId% -l %ListId% -execute -get:csv %FilePath%

Let me know if this helps.

Thanks,
Manjunath

ManjunathKN

@anildudam

didnt help? are you thinking of exporting the List ids and names? I am not sure you can do that, Transactional APIs will only work to do operations at granular level. As far i understand we can do pick and execute in Transactional API.

@ryan_kohn can we export the Display of Lists and IDs?

Thanks,
Manjunath

StevenBeerthuizen

@ManjunathKN Indeed if you use the Transactional API directly, and not Anaplan Connect you can just use this call and use the json response to do whatever you want:

curl -X GET 'https://api.anaplan.com/2/0/workspaces/{workspaceId}/models/{modelId}/lists' \ -H 'Accept: application/json' \ -H 'Authorization: AnaplanAuthToken {anaplan_auth_token}'

For this call there is no 'Accept: text/csv' option, so i guess that Anaplan Connect also is not able to get it in csv format.

ManjunathKN

Hi @StevenBeerthuizen

Thanks for further clarification! So in both(REST API and Anaplan Connect) case I believe it can call but it cannot download into CSV.

Regards,
Manjunath

ryan_kohn

@anildudam @ManjunathKN Anaplan Connect (version 3 and up) supports exporting a model's list details (ID's and Names). Example command below.

.\AnaplanClient.bat -debug -service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -user "<username>" -workspace "7g1cb09d652b041801654aa9b" -model "E4BDDAA4F28464179EFDAA345" -L -get:csv output.csv

EDIT

To further expand on my previous answer, it is also possible to export the contents of a particular list into a csv file. See below for the command structure.

.\AnaplanClient.bat -debug -service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -user "<username>" -workspace "7g1cb09d652b041801654aa9b" -model "E4BDDAA4F28464179EFDAA345" -execute -l "1000015" -get:csv output.csv

@anildudam To respond directly to your initial post, your issue is with the -execute flag. For metadata commands (like -L), you cannot include the -execute flag, but for data commands (like -l), it is required. The above examples should fully answer your question.

anildudam

Hi @ManjunathKN , @StevenBeerthuizen and @ryan_kohn

Thank you so much for your quick responses and possible solutions.

Really very appreciate your help and support.

Thank you and regards,

Anil

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385