Transactionnal API - Direct Query with JSON Line / Parsing ?!?

Hello,

I am looking currently at the Transactionnal API.

I see great usage associated to Transactionnal API reading function for direct reporting through third party tool (ex : POWERBI), which offer more thank BULK API.

This call help you to direct query a view :

Currently, the documentation show a limitation of cells able to be read :

This call only supports the retrieval of cells from a view that contains a maximum of 1,000,000 cells. If the specified view contains more than 1,000,000 cells, then the call returns a 400 Bad Request HTTP status, instead of a subset of the cells. Use the quick sum bar in Anaplan to identify the number of cells in a view.

Nevertheless, I saw in the return, the page aspect. That is associated to parsing/ Json Line perspective

Is there any perspective that we see anytime soon, the parsing on those kind of request ? (@christophe_keom 👀)

Comments

david.savarin

Large read query method on the transactional api endpoint was released a few months ago.

It allows to launch a query on views containing more than 1m cells with multiple pages results.

The api call includes a page number parameter to return the results of the corresponding page.

You will find documentation on the apiary anaplan api

Nico

I have used the long request query method.
Nevertheless It is still asynchrone as you need to launch a request and then get a task affected and the response is “Plain Text”

Could we see the page functionnality on the view request in order to have a synchronized & JSON (JSON Line) response ?

david.savarin

I see.

It would be great to be able to see the page number, but i d say that the page number gets generated by a large query launch. So as long as the query isnt run, the page number is blank.

Quick Links

New ideas

Virtual Data Warehouse using Anaplan metadata
We are writing from Centrify Solutions, an Enterprise Data Integration +AI company. We have developed a solution that integrates metadata from Anaplan and external sources like NetSuite into a virtual data warehouse. This creates a dynamic large language model that can be deployed internally to any data source or securely…
How CloudWorks Changed My Day-to-Day Work
Hello Everyone, I’ve been using Anaplan CloudWorks, and honestly, it has completely transformed the way I handle daily integrations. What I love most is how simple it is — you don’t need deep technical knowledge to get started. It’s simple, user-friendly, and has become an essential part of my daily workflow. If you are…
Select All Members in a Time Level Instead of One at a Time
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: In a working grid I click 'show/hide' and select 'Time'. My time hierarchy is FY > Half > Quarter > Month > Week. I want to display…