API: GET the data in a chunk in JSON format

Description:

Enhancement request for Export API: Download file (sample URL below) to output data in JSON format
Example of enhancement:

GET https://api.anaplan.com/major/minor/workspaces/workspaceID/models/modelID/files/fileID/chunks/chunkID
Benefit/impact:

Anaplan Connect does not have the Export (direct) into Oracle functionality, so we have to use other integration tools instead (like Workato). We are planning on developing Workato's recipes by calling Anaplan's Export REST API and parsing the Export data in JSON format and loaded into Oracle data warehouse.

Comments

AnaplanIdeas

Status changed to: Not Planned

hendersonmj

Great suggestion. I recently built a Node.js javascript application for API-to-API integration with Google Maps. I had to translate csv to JSON in code, would be much easier (less code to break / maintain) if I could simply get the data as JSON.

sean_culligan

Agreed or re-architect completely, to avoid the file and query the model directly.

get https://api.anaplan.com/major/minor/workspaces/workspaceID/models/modelID/results [param:a,b,c etc...]

This way you can then add parameters to query the data from source, rather than extracting all results, and doing a transformation and selection after the fact.

alan

Hi all,

Is this still on the roadmap? We were internally discussing a use-case and having an API to get data in JSON format would be terrific.

Thanks!

Alan

Rebecca

Thank you for your idea submission. After careful review with our internal product teams on your idea, we unfortunately have decided this does not fit our current platform road map. Thanks so much for taking the time to submit this idea and please continue to submit your ideas for how to make the Anaplan platform better. If you have any questions, don't hesitate to reach out to the Anaplan team at Community@Anaplan.com.

Quick Links

New ideas

Allow non-WSAs to view source module name in UX.
When a user clicks the ellipsis in a grid card they should be able to see the name of the source module. This empowers end users with the ability to connect to the source data they see in the UX to the module in the backend. It also enables end users to pull the data into Google Sheets or Excel.
A function that identifies all saved views which filters are broken
I would like the function to identify all saved views which filters are broken(error).
Add feature to “Use Account Style Drilling” in AnaplanXL Grids
This feature to display children above the parent when drilling in is available in AnaplanXL freeform but not grids. This would be a useful feature in Grids as well. As a user, I would expect to have same/similar functionality between Grids and Freeform.