title: How to retrieve more than 1000 results from table storage?
body: <p><strong>How can we retrieve more 1000 results from table storage?</strong></p>
  
  <p>Currently, this method is not retrieving more than 1000 results:</p>
  
  <pre><code>public static List&lt;Translation&gt; Get&lt;T&gt;(string sourceParty, string destinationParty, string wildcardSourceParty, string tableName) where T : ITableEntity, new()
  {
      var acc = CloudStorageAccount.Parse(Environment.GetEnvironmentVariable("RosettaCacheStorageConnection"));
      var tableClient = acc.CreateCloudTableClient();
      var table = tableClient.GetTableReference(Environment.GetEnvironmentVariable("RosettaTableCache"));
  
      TableQuery&lt;T&gt; treanslationsQuery = new TableQuery&lt;T&gt;().Where(
          TableQuery.CombineFilters(
              TableQuery.CombineFilters(
                  TableQuery.GenerateFilterCondition("sourceParty", QueryComparisons.Equal, sourceParty.ToLowerTrim()),
                  TableOperators.And,
                  TableQuery.GenerateFilterCondition("destinationParty", QueryComparisons.Equal, destinationParty.ToLowerTrim())
                  ), TableOperators.Or,
              TableQuery.CombineFilters(
                  TableQuery.GenerateFilterCondition("sourceParty", QueryComparisons.Equal, wildcardSourceParty),
                  TableOperators.And,
                  TableQuery.GenerateFilterCondition("destinationParty", QueryComparisons.Equal, destinationParty.ToLowerTrim()))
          ));
  
      TableContinuationToken continuationToken = null;
      Task&lt;TableQuerySegment&lt;T&gt;&gt; translations = table.ExecuteQuerySegmentedAsync(treanslationsQuery, continuationToken);
      TableQuerySegment&lt;T&gt; translationss = translations.Result;
  
      List&lt;Translation&gt; trans = translationss.Cast&lt;Translation&gt;().ToList();
  
      return trans.Where(x =&gt; x.expireAt &gt; DateTime.Now)
                         .Where(x =&gt; x.effectiveAt &lt; DateTime.Now)
                         .ToList();
  }
  </code></pre>
  
  <p><strong>Is there a way to retrieve more 1000 results?</strong></p>
  
  <p>Please keep in mind that this is Azure Table Storage, and not cosmosdb. </p>