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; } } }

Rest Api response with FileName instead of FileId

kandasamy

Hi Team,

I would like to know that instead of using the file id in the api get request can I use the filename as (xxxx.xls)

https://api.anaplan.com/1/3/workspaces/8a81b0945cdbe1ec015ce678a3f60051/models/F54A3C7D6CE54A0F82EE730DE0FD12B5/files/

Thanks

Kandasamy

Accepted answers

All comments

ben_speight

You can specify the import data source or export name in the URL path instead of the numeric ID, although you may need to be careful with certain characters that must be encoded (the tool you use to access the API may handle this).

kandasamy

Hi
To check the response I am using the Postman and in the postman I am using the Get method. In the endpoint I have given https://api.anaplan.com/1/3/workspaces/8a81b0945cdbe1ec015ce678axxxxxxx/models/F54A3C7D6CE54A0F82EE730xxxxxx/Current Page - Headcount Data Master - Report.xls
Under the Header I have given the Authorization. I would like to know what type of content type I need to select.

Thanks
Kandasamy

ben_speight

Use application/octet-stream for the Accept header.

If the file is large then use the /2/0 API or the chunks endpoints instead.

kandasamy

Hi
I tried in the Post man as you suggested , but I am getting not found error.
Please let me know if I missed anything

Thanks
Kandasamy

ben_speight

It looks like you're missing the path component "/files", which should follow the model ID. Test using a numeric identifier first, then substitute the name for the numeric identifier.

kandasamy

Hi
As you suggested in the postman I have given the end url as
https://api.anaplan.com/1/4/workspaces/8a81b0945cdbe1ec015ce678a3f60xxxx/models/420BD91A051443C6ADACCF6xxxxxxxxxxx/files/116000000005
But I am getting the response as

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>

<head>
<title>Anaplan</title>
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="viewport" content="width = 960">
<link rel="shortcut icon" href="lib/anaplan/themes/original/images/favicon.ico">
<style type="text/css">
@import "lib/dojo/resources/dojo.css";

html {
overflow: auto;
}
</style>
</head>

<body>
<div id="pageWrap" class="pageWrap">
<div class="banner">
<h1>An error has occurred whilst processing your request:</h1>
</div>

<div>
<pre class="original">Not Found</pre>
</div>
<div>Please close your browser window and try again.</div>
<div>If the problem persists then please contact Anaplan Support.</div>
</div>
</body>

</html>

kandasamy

Hi
I am getting the response for the .csv files but for the .xls file I am getting the Not found error as mentioned in my previous post

Thanks

ben_speight

Now you've got /1/4 as a version instead of /1/3 or /2/0. That's not a valid API version, hence the not found error.

kandasamy

Hi
I tried with 2/0 version to get the files https://api.anaplan.com/2/0/workspaces/8a81b0945cdbe1ec015ce678a3f60051/models/420BD91A051443C6ADACCF69D33EBEA0/files
but I am getting response as
{
"status": {
"code": 401,
"message": "Not Authorized."
}
}

When I tried version1/4 I am getting File not found.

Api version 1/3 is only giving response to me.

Thanks

ben_speight

1/4 is not a valid API version.

2/0 will require a different Authorization: header to 1/3 (see https://anaplanauthentication.docs.apiary.io/)

Quick Links

Can you help?

Unanswered questions

"Failed to retrieve field list" error when importing saved view across models
Hi everyone, Has anyone run into this issue before? I am trying to import data into a Marketing model list using a saved view (Update B3 Product Dist in Mktg) from a source model (FinancialPlanning_Dev_Polaris). However, when I try to set up the import action, I get the following error: Select SourceFailed to retrieve…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
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.…