nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

File Schema details using api

kandasamy

Using the Anaplan api how to get the schema details of the file by passing the file name. I am using api version 1.3

Thanks

Kandasamy

Accepted answers

All comments

anirudh

Hi,

Can you please elaborate what you mean by schema details of the file?

kandasamy

Under the model I am having list of report file in .csv and .xls files

my requirement is by using the filename I need to get the schema details

For Example head_count.csv report file it contains Unique_ID ,Budget_ID, Employee_ID, Employee_Name as column name. I need to extract the column name and datatype of the file using the Anaplan api

Thanks

Kandasamy

ben_speight

Under https://anaplan.docs.apiary.io/#reference/export, look for "Get the metadata for an export definition".

anirudh

Please refer the link posted by @ben_speight

If you need specific help and are unable to execute the API call, please feel free to ask for additional help!

kandasamy

Thanks, I refereed the api document and exported the metadata for the export id, but as a response output I can see

ENTITY not the exact data type.

Please let me know how to get the exact data type.

Thanks

Kandasamy

kandasamy

Hi,

I gone through the ben_speight posts but I can't find any help on getting the exact date type for the export id from metadata.

In the postman I can see ENTITY as the datatype as response output . I need to how to get the actual data type .

Thanks

Kandasamy

ben_speight

The dataTypes field carries only basic information about the data in the columns to differentiate between Boolean, numeric, text, date, entity(list-formatted) and time entity. For a module view where line items are not in columns but have a mix of data types, dataTypes are likely to be MIXED for the data as they could vary by row. For columns assigned to list dimensions, the column name should identify the dimension.

Quick Links

Can you help?

Unanswered questions

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.…
Top-Down Allocations
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
PowerPoint Add-in: Installation requires elevated privileges
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue For versions 1.6, 1.7 and 1.8 of the PowerPoint Add-in elevated privileges are required to install the add-in through command line and for the "all users" option. Workaround * Installing through…