Fetch specific columns from Azure storage table query with the Javascript API

Question

Is it possible to fetch specific columns from an Azure storage table with the Javascript library.

Right now I can fetch the entire row, but I want just a few of the columns.

Here is what I'm doing to fetch the entire row from the table

var tableUri = "https://mytablerg.table.core.windows.net";
var tableService = AzureStorage.Table.createTableServiceWithSas(tableUri, sasToken);
var tableQuery = new AzureStorage.Table.TableQuery().top(100).where('PartitionKey eq ?', partitionName);

tableService.queryEntities('ChatMessages', tableQuery, null, function(error, result, response) {
   // do some work with a returned data
});

Jerry Liu · Accepted Answer · 2018-11-09 08:59:41Z

4

Appending your original query with method select() should work.

var tableQuery = new AzureStorage.Table.TableQuery().top(100).where('PartitionKey eq ?', partitionName).select('field1','field2');

Have a look at the official doc.

edited Nov 9, 2018 at 8:59

answered Nov 9, 2018 at 8:33

Jerry Liu

17.9k4 gold badges47 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

chuckd Over a year ago

Thanks, do you know where I can find documentation for writing these queries in javascript? I can't find much....

Jerry Liu Over a year ago

@user1186050 Added in my answer.

Collectives™ on Stack Overflow

Fetch specific columns from Azure storage table query with the Javascript API

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related