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

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.