Retrieving more than 1000 records from azure storage table - js

Question

I have an issue of retrieving more than a thousand records. Somehow only the first 1000 are retrieved. From my research, I have figured out that I have to use getContinuation Token to get the subsequent records. Please advise how should I add it into my code.

tableService.queryEntities(table, tableQuery, null, function(error, results) {
    if (error) {
        alert('List table entities error, please open browser console to view detailed error');
        console.log(error);
    } else {
        //display records

});

Answer 1

I created an npm package just for this if you want to use it. https://www.npmjs.com/package/azure-table-query-recursive

Usage

const {queryAzureTableStorage, TableQuery, createTableService} = require('azure-table-query-recursive');

const validConnectionString = 'DefaultEndpointsProtocol=https;AccountName=xxxxxxx;AccountKey=xxxxxxxxxxxxxxxxxxxxxxx==;EndpointSuffix=core.windows.net';
const query = `PartitionKey eq 'apartitionkey'`;
const table = 'aTable';

//Constract a tableStorage object
const tableStorage = createTableService(validConnectionString);
//Constract an azure table query
const azureQuery = new TableQuery().where(query);

const tableResults = await queryAzureTableStorage(azureQuery, table, tableStorage);

Answer 2

The following works in C#:

var resultList = new List<T>();
TableQuery<T> query = new TableQuery<T>();

TableContinuationToken continuationToken = null;


var table = _tableClient.GetTableReference(tableName);

do
{
    var token = continuationToken;
    var queryResult = TryOperation(() => table.ExecuteQuerySegmented(new TableQuery<T>(), token), tableName);
    if (queryResult != null)
    {
        resultList.AddRange(queryResult.Results);
        continuationToken = queryResult.ContinuationToken;
    }
} while (continuationToken != null);

return resultList;