API: GET the data in a chunk in JSON format

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/chunkI...
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.

The content in this article has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation.
Please consult your internal administrators prior to applying any of the ideas or steps in this article.
3 Comments
Previous Contributor
 
Status changed to: On Roadmap
Contributor

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.  

Contributor

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.