How to Dimension ID and Item ID ?

Hi Team ,

I'm trying to get Subsidiary module data in a CSV using below API.

How to get Dimension ID and Item ID

API Used :

curl -X GET 'https://api.anaplan.com/2/0/models/{modelId}/views/{viewId}/data?pages=dimensionId:itemId&format=v1&exportType={TABULAR_SINGLE_COLUMN}&moduleId={moduleId}' \ -H 'Authorization: AnaplanAuthToken {anaplan_auth_token}' \ -H 'Accept: text/csv'

Can you guys help me to get the Dimension and Item ID

Regards,

Vinoth Kumar K.

Accepted answers

All comments

StevenBeerthuizen

Have you looked in the apiary?

https://anaplanbulkapi20.docs.apiary.io/

For view metadata you could use:

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

For dimension ID you could also use:

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

Then for item ID:

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

curl -X GET 'https://api.anaplan.com/2/0/workspaces/{workspaceId}/models/{modelId}/lists/{listId}/items?includeAll=true' \ -H 'Accept: text/csv' \ -H 'Authorization: AnaplanAuthToken {anaplan_auth_token}'

You could also try using postman for doing the API development / testing.

Hope this helps!

Kind regards,

Steven

StevenBeerthuizen

By the way, the ?pages part is only used if you want a specific page to be exported, so it's not mandatory to add it. So it is only needed if you want to have a certain item selected from the pages of the view. My previous comment is based on the situation that you do not have line items in the pages. If you do you have to use another API call to get the line item ID.
Kr,
Steven

VinothKumar91

Hi @StevenBeerthuizen ,

I'm planning to export subsidiary module data in CSV.

Can you please help me to export data in CSV (Using Rest API)

thanks in advance 🙂

Regards,

Vinoth Kumar K.

VinothKumar91

Hi @StevenBeerthuizen ,

I used below API to get the View ID of the Subsidiary Module.

https://api.anaplan.com/2/0/models/{modelId}/views?includesubsidiaryviews=true

Screenshot Attached :

How can i download "Tec Dev Caso 0" Subsidiary Module Data in CSV.

Regards,

Vinoth Kumar K.

Regards,

Vinoth Kumar

StevenBeerthuizen

It depends on the size, but if it is less than 1000000 cells, the apiary says the following:

You can replace the viewId with any valid lineItemId. If the line item has a subsidiary view, the response returns the data as seen in that subsidiary view.

And to get the lineitem id for Tec dev caso 0 you should use:

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

Let me know if this works.

Kind regards,

Steven

VinothKumar91

Hi @StevenBeerthuizen ,

Thanks for the reply.

I get below response , when I use the API shared by you.

Regards,

Vinoth Kumar K.

StevenBeerthuizen

So again, if you are not using the pages, then let it out of your API call.....

curl -X GET 'https://api.anaplan.com/2/0/models/{modelId}/views/{viewId=your line item id}/data?format=v1&exportType={TABULAR_SINGLE_COLUMN}&moduleId={moduleId}' \ -H 'Authorization: AnaplanAuthToken {anaplan_auth_token}' \ -H 'Accept: text/csv'

StevenBeerthuizen

@VinothKumar91 Did you manage to get it working? Would be nice to know the outcome so other users might also benefit.

Kr,

Steven

ManjunathKN

Hi @StevenBeerthuizen

can we use the request header Accept: text/csv;escaped=true, i read in article that in some cases it throws error for the request header Accept: text/csv.

I am relatively new to this Anaplan API, I just want to know that after using these cURL to get the data, either by bulk api or transactional api through postman, how are we going to automate it by scheduler? what are the scheduler we can use to automate it?

Thanks,
Manjunath

StevenBeerthuizen

Hi Manjunath,

I guess you can indeed use the escaped=true.

For automation you can probably use various solutions, but I use Power Automate. You can do the API call and use the response for further actions and it can also be scheduled. It might require additional licenses to use Power Automate though.

Kind regards,

Steven

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…