Can we make the api to download nqe reports in csv/ xlsx format a public api? I find this a lot more convenient than using the offset / limit api for fetching query results especially for very large datasets (greater than 500K records).
Solved
Make CSV API public
Best answer by Andreas
Hi
If you primarily want an easy way get all rows into your script so that you can manipulate it in some way (as opposed to primarily wanting to get a CSV to save it somewhere), then you might find our newer NQE query execution API useful. It provides an option to get all rows of the query in a single call, either as an array of JSON records, or via JSONLines format.
Specifically, you can use this API as follows:
- First,
POST /api/networks/:networkId/nqe-executionsto initiate the query execution. This will return an object that contains, among other things, an executionKey. - Then, use
GET /api/networks/:networkId/nqe-executions/:executionKeywith the executionKey you obtained from the prior call to check the status. Once the status indicates that the query execution is completed, then continue. - Then
GET /api/networks/:networkId/nqe-executions/:executionKey/resultto get the rows. Note that if you omit both the offset and limit arguments, then the response will include all rows - no paging needed. This endpoint all supports an “Accept: application/jsonl” header which returns all rows in the JSONLines format, in case you want to process the rows in a streaming fashion.
For full information on this endpoints, see the following doc pages:
+4Thank you for the request. This is actually already being worked on. It should be available in 26.9. which is the September release.
Hi
If you primarily want an easy way get all rows into your script so that you can manipulate it in some way (as opposed to primarily wanting to get a CSV to save it somewhere), then you might find our newer NQE query execution API useful. It provides an option to get all rows of the query in a single call, either as an array of JSON records, or via JSONLines format.
Specifically, you can use this API as follows:
- First,
POST /api/networks/:networkId/nqe-executionsto initiate the query execution. This will return an object that contains, among other things, an executionKey. - Then, use
GET /api/networks/:networkId/nqe-executions/:executionKeywith the executionKey you obtained from the prior call to check the status. Once the status indicates that the query execution is completed, then continue. - Then
GET /api/networks/:networkId/nqe-executions/:executionKey/resultto get the rows. Note that if you omit both the offset and limit arguments, then the response will include all rows - no paging needed. This endpoint all supports an “Accept: application/jsonl” header which returns all rows in the JSONLines format, in case you want to process the rows in a streaming fashion.
For full information on this endpoints, see the following doc pages:
Badge winners
Sign up
Already have an account? Login
Welcome to the Forward Networks Community
No account yet? Create an account
Select a login option:
Register / Login Forward Employee LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.