How to get all metadata from a Model using RESTful API?

Highlighted
New Contributor

How to get all metadata from a Model using RESTful API?

Hello I'm new using Anaplan web app. and the RESTful API. I need a way to export all the metadata or the raw data for a Model (1.8 Billion cells).  Per the API guide, https://anaplan.docs.apiary.io/#reference/export, it reads I'll need to run a task for each export and get the data by chunks?  Is this the only way to get the metadata for a Model?    

7 REPLIES 7
Highlighted
Master Anaplanner/Community Boss

Re: How to get all metadata from a Model using RESTful API?

Hi edithm,

What exactly do you mean by metadata of a model?

Regards,
Anirudh
Highlighted
New Contributor

Re: How to get all metadata from a Model using RESTful API?

All the data stored in the modules for a specific Model.  

Highlighted
Master Anaplanner/Community Boss

Re: How to get all metadata from a Model using RESTful API?

@edithm 

 

May I ask the question of why do want to do this?

Highlighted
New Contributor

Re: How to get all metadata from a Model using RESTful API?

For Business Intelligence.
Highlighted
Master Anaplanner/Community Boss

Re: How to get all metadata from a Model using RESTful API?

@edithm ,

 

If that is the case, then I would get a plan together to understand exactly what you need as you will not need the entire Anaplan model or 1.8 Billion cells (you most likely don't need historical data nor calculated/parent level data as well as all of the dimensions).  Based off that, then export modules can be put together (built) and you will be able to pull that data into your BI solution

Highlighted
Master Anaplanner/Community Boss

Re: How to get all metadata from a Model using RESTful API?

You will have to create export actions in all the modules that you want to pull data from

Use "Tabular Multiple Column" option to get the data in a consumable format as well as in the fastest way

anirudh_0-1600448815482.png

You can then programmatically extract all the data from a model by pointing the rest api at each of the export actions

 

Regards,

Anirudh

Highlighted
New Contributor

Re: How to get all metadata from a Model using RESTful API?

Thanks for the recommendation, but from what I understand I will need to do the following to get the data:

1. Post a task to run each export 

2. Monitor that task until it's completed

3. Get the lists for that task

4. Get chunk IDs for each list

5. Get detail data for each chunk ID