Hi
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
Hi,
Can you please elaborate what you mean by schema details of the file?
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
Under https://anaplan.docs.apiary.io/#reference/export, look for "Get the metadata for an export definition".
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!
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.
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 .
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.
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
