Export API call returns only module headers

Hello all,

I am trying to export out data from a module via an API call using an existing export action. Have successfully initiated the export action and retrieved the file details (chunk numbers etc), however when I attempt to download the first (and only) chunk details the API call only returns the module headers without any of the data.

Attached is screenshot from postman showing the response.

I can confirm that the file created / downloaded when running the export action manually from Anaplan does result in a file with data.

Any help will be appreciated.

Thanks !

postman_122612.png

Accepted answers

M.Kierepka

Hi @dfernandes,

Is account used by integration the same as used for manual download? What I assume could happen is that in dimension in rows has Selective Access enabled (or DCA and "Omit Empty Rows" is set in export definition), and your account has access to this hierarchy, but integration account doesn't have access to this hierarchy. The best way to check it is either copy your access to integration account in Anaplan (using bulk copy or just Ctrl+C->Ctrl+V in Users tab) or change integration credentials to yours (might not be possible if you are using Certificate Authentication).

Hope it helps, but if not, can you provide screenshot of the export's settings?

All comments

M.Kierepka

Hi @dfernandes,

Hope it helps, but if not, can you provide screenshot of the export's settings?

dfernandes

Yes it was a security access issue. The account used by the API did not have access to the lists in the module.

Thanks so much for your help !

Quick Links

Can you help?

Unanswered questions

ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…