Too much data in view, access token expires during data extraction.
When extracting a large amount of data from a view in api, there are too many pages and the access token expires during pipeline execution.
After initiating the request, the access token expires because the time spent preparing the data and downloading the page exceeds 35 minutes.
The VIEW of data to be extracted has 1 billion cell data and more than 600 downloadable pages.
Is there any way to reduce this?
Right now, I am using the following request in the api.
{"exportType": "TABULAR_MULTI_COLUMN"}
Answers
-
Like I already commented earlier, you can use
GRID_ALL_PAGES This layout respects the existing sorting and filtering you have imposed on a data grid before you launch the export. Export grid This way you can filter the data before you export it. Not sure if that helps, but it's worth a try.
Kind regards,
Steven
0 -
You can refresh your token at any point between API requests - see the Refresh Token section in https://anaplanauthentication.docs.apiary.io/#/reference/auth-token
1
