Retrieve Line Item Formula from Anaplan with Python VS Code

Community,

I have been able to connect Python/VS Code to my Anaplan model. The information I am trying to retrieve is the formulas in each line item. This will help make it more readable. Does anyone have a python code example to get this data from an Anaplan model?

Accepted answers

allitixtgaluska

This is now available in the V2 API.

All comments

kevin.cho

Not available as part of any publicly advertised endpoint that I know of, but I'd love to be told I'm wrong!

Next best thing that you could do is, save an export action in your model that will export the entire blueprint. Since the combo of Module name and Line Item name are unique (and both are present in the blueprint extract), you should be able to then link up the formula to each module/line item ID.

Just be aware that any specific "line item formula" (via line item subset, and adding version formula to a line item) won't appear in this blueprint export.

allitixtgaluska

Oh ****. I have built some great work on other planning tool with python and jupyter notebooks. Tracking user logging trend, track data change large values, audit queries, and model health check that were automated. Maybe in the future? Please!!!!

allitixtgaluska

This is now available in the V2 API.

kevin.cho

Awesome - just tested it out and it's very detailed.

One thing that I do realise is still missing though is the "Version Formula" that you can add onto items within a Line Item Subset - but these are quite rare anyway. Couldn't figure out a way to return that formula.

allitixtgaluska

Yeah I agree. Still a lot missing from the API. I might have missed it but it appears Anaplan skipped adding all the Module info. Looks like you can't pull module cell count as an example.

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…