none
Random records returned in a continuation token RESTful request

    Question

  • We have tables on the Azure service that we use the RESTful API to interface with.

    I've noticed that as our tables have grown, the larger tables (4500+ records and 7000+ records) are returning more query responses that require continuation tokens.  According to what I've read, supposedly when your query exceeds 1000 records or the query crosses a partition boundary, continuation tokens are returned.

    When the continuation tokens are presented for a query that crosses a partition boundary, the second response, i.e. the response retrieved by using the continuation tokens 'forgets' the original query and seemingly returns random records.

    For example, when present this query:

    Last query = 'ObjectID eq '73a781fb-4657-467d-b893-f8110635b3bc' and UserID eq 'f70eb1a0-b221-4577-9a8d-c1fb0f6ebd79'' from Table 'Permissions'.

    using this code:

    Dim resource As String = [String].Format(_tableName & "()?$filter=" & Uri.EscapeDataString(_filter))

    request = CreateRESTRequest("GET", resource, Nothing, Nothing)
    request.Accept = "application/atom+xml,application/xml"
    where CreateRESTRequest is:

           Public Function CreateRESTRequest(ByVal method As String, _
                                              ByVal resource As String, _
                                    Optional ByVal requestBody As String = Nothing, _
                                    Optional ByVal headers As SortedList(Of String, String) = Nothing, _
                                    Optional ByVal contentType As String = "", _
                                    Optional ByVal ifMatch As String = "", _
                                    Optional ByVal md5 As String = "") As HttpWebRequest

                Dim strTrace As String = "General Fault."
                Dim strRoutine As String = _rootClass & ":CreateRESTRequest"
                Try
                    Dim byteArray As Byte() = Nothing
                    Dim now As DateTime = DateTime.UtcNow
                    Dim uri As String = Endpoint & resource

                    Dim request As HttpWebRequest = TryCast(HttpWebRequest.Create(uri), HttpWebRequest)
                    request.Method = method
                    request.ContentLength = 0
                    request.Headers.Add("x-ms-date", now.ToString("R", System.Globalization.CultureInfo.InvariantCulture))
                    request.Headers.Add("x-ms-version", "2009-09-19")

                    If IsTableStorage Then
                        request.ContentType = "application/atom+xml"

                        request.Headers.Add("DataServiceVersion", "1.0;NetFx")
                        request.Headers.Add("MaxDataServiceVersion", "2.0;NetFx") ' Changed 2012-09-24
                    End If

                    If Not String.IsNullOrEmpty(contentType) Then request.ContentType = contentType ' Supports the batch call

                    If headers IsNot Nothing Then
                        For Each header As KeyValuePair(Of String, String) In headers
                            request.Headers.Add(header.Key, header.Value)
                        Next
                    End If

                    If Not [String].IsNullOrEmpty(requestBody) Then
                        request.Headers.Add("Accept-Charset", "UTF-8")

                        byteArray = Encoding.UTF8.GetBytes(requestBody)
                        request.ContentLength = byteArray.Length
                    End If

                    request.Headers.Add("Authorization", AuthorizationHeader(method, now, request, ifMatch, md5))

                    If Not [String].IsNullOrEmpty(requestBody) Then
                        request.GetRequestStream().Write(byteArray, 0, byteArray.Length)
                    End If

                    strTrace = "The default timeout is: " & request.Timeout.ToString
                    TraceLogger(strTrace, strRoutine)
                    request.Timeout = ThisAddIn.AddinConfig.FocusSyncTimeout


                    '' Add Proxy if necessary - if a proxy is used, by default .Net knows the proxy settings and will use
                    ''   the default credentials.  This code is only useful if Windows credentials do not match what is
                    ''   expected by the proxy
                    strTrace = "Establishing a proxy if required."
                    Dim myProxy As System.Net.WebProxy = GetMyProxy()
                    If Not IsNothing(myProxy) Then
                        request.Proxy = myProxy
                    End If

                    ' Trace
                    strTrace = "Method: '" & method & "' Resource: '" & resource & "' Request Body: '" & requestBody & "'"
                    TraceLogger(strTrace, strRoutine)

                    Return request

                Catch ex As Exception
                    TraceLogger(strTrace & " " & ex.StackTrace, strRoutine)
                    ErrorLogger(ex.Message & " " & strTrace, Err.Number, strRoutine)
                    Return Nothing
                End Try

            End Function

    In the first response - we get the requested record (since there is only one corresponding to that query).

    <feed xml:base="https://myName.table.core.windows.net/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
      <id>https://myName.table.core.windows.net/Permissions</id>
      <title type="text">Permissions</title>
      <updated>2015-09-03T06:22:57Z</updated>
      <link rel="self" title="Permissions" href="Permissions" />
      <entry m:etag="W/&quot;datetime'2014-05-12T15%3A49%3A04.7327577Z'&quot;">
        <id>https://myName.table.core.windows.net/Permissions(PartitionKey='hyekJUQxeLrYZHtUu6GGBg%3D%3D',RowKey='fd22ba37-543f-40b7-8a31-075e044f8cbf')</id>
        <category term="myName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='hyekJUQxeLrYZHtUu6GGBg%3D%3D',RowKey='fd22ba37-543f-40b7-8a31-075e044f8cbf')" />
        <title />
        <updated>2015-09-03T06:22:57Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>hyekJUQxeLrYZHtUu6GGBg==</d:PartitionKey>
            <d:RowKey>fd22ba37-543f-40b7-8a31-075e044f8cbf</d:RowKey>
            <d:Timestamp>2014-05-12T15:49:04.7327577Z</d:Timestamp>
            <d:ID>fd22ba37-543f-40b7-8a31-075e044f8cbf</d:ID>
            <d:UserID>f70eb1a0-b221-4577-9a8d-c1fb0f6ebd79</d:UserID>
            <d:ObjectID>73a781fb-4657-467d-b893-f8110635b3bc</d:ObjectID>
            <d:OwnerID>f70eb1a0-b221-4577-9a8d-c1fb0f6ebd79</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Devices</d:TableName>
            <d:ModifiedDate>2014-05-12T15:49:04.2488952Z</d:ModifiedDate>
            <d:CreatedDate>2014-05-12T15:49:04.2488952Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    </feed>
    We would expect that response without any additional records, however, we get continuation tokens - then when we use the continuation tokens to make subsequent request, we get a larger response 

    set (over 500 records, from four different partitions) where the data doesn't match the query.

    Here's a subset of that response:

    <feed xml:base="https://myName.table.core.windows.net/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" 

    xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
      <id>https://myName.table.core.windows.net/Permissions</id>
      <title type="text">Permissions</title>
      <updated>2015-09-03T06:22:58Z</updated>
      <link rel="self" title="Permissions" href="Permissions" />
      <entry m:etag="W/&quot;datetime'2014-10-27T00%3A01%3A02.521521Z'&quot;">
        <id>https://myName.table.core.windows.net/Permissions(PartitionKey='tAKu1Tgk4Y7TOp3zY2BrXA%3D%3D',RowKey='f6c83bfd-5bbd-4dcb-92a8-ddd94df762bc')</id>
        <category term="myName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='tAKu1Tgk4Y7TOp3zY2BrXA%3D%3D',RowKey='f6c83bfd-5bbd-4dcb-92a8-ddd94df762bc')" />
        <title />
        <updated>2015-09-03T06:22:58Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>tAKu1Tgk4Y7TOp3zY2BrXA==</d:PartitionKey>
            <d:RowKey>f6c83bfd-5bbd-4dcb-92a8-ddd94df762bc</d:RowKey>
            <d:Timestamp>2014-10-27T00:01:02.521521Z</d:Timestamp>
            <d:ID>f6c83bfd-5bbd-4dcb-92a8-ddd94df762bc</d:ID>
            <d:UserID>b3b2a2e9-9111-4709-92ed-71e2b3360622</d:UserID>
            <d:ObjectID>1fc6ba0e-304a-47b3-81d8-2201cdac9e49</d:ObjectID>
            <d:OwnerID>b3b2a2e9-9111-4709-92ed-71e2b3360622</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Focuses</d:TableName>
            <d:ModifiedDate>2014-10-27T00:01:02.1738624Z</d:ModifiedDate>
            <d:CreatedDate>2014-10-27T00:01:02.1738624Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    <!...>
      <entry m:etag="W/&quot;datetime'2015-09-03T03%3A48%3A55.4824602Z'&quot;">
        <id>https://myName.table.core.windows.net/Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='0c710b16-3f34-47e6-bba4-5a849100f393')</id>
        <category term="myName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='0c710b16-3f34-47e6-bba4-5a849100f393')" />
        <title />
        <updated>2015-09-03T06:22:58Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>yRL5TND2w4mVaqkvkQABAQ==</d:PartitionKey>
            <d:RowKey>0c710b16-3f34-47e6-bba4-5a849100f393</d:RowKey>
            <d:Timestamp>2015-09-03T03:48:55.4824602Z</d:Timestamp>
            <d:ID>0c710b16-3f34-47e6-bba4-5a849100f393</d:ID>
            <d:UserID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:UserID>
            <d:ObjectID>19d495c3-dd17-44b2-970a-c9f06b136c8c</d:ObjectID>
            <d:OwnerID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Devices</d:TableName>
            <d:ModifiedDate>2015-09-03T03:48:57.3381567Z</d:ModifiedDate>
            <d:CreatedDate>2015-09-03T03:48:57.3381567Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    <!...>
      <entry m:etag="W/&quot;datetime'2015-01-11T11%3A41%3A47.8576124Z'&quot;">
        <id>https://myName.table.core.windows.net/Permissions(PartitionKey='yjj3m2tJR1ubuHomKn3Sg%3D%3D',RowKey='ce58baa0-e6a8-4df7-9917-8f32cd135126')</id>
        <category term="myName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='yjj3m2tJR1ubuHomKn3Sg%3D%3D',RowKey='ce58baa0-e6a8-4df7-9917-8f32cd135126')" />
        <title />
        <updated>2015-09-03T06:22:58Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>yjj3m2tJR1ubuHomKn3Sg==</d:PartitionKey>
            <d:RowKey>ce58baa0-e6a8-4df7-9917-8f32cd135126</d:RowKey>
            <d:Timestamp>2015-01-11T11:41:47.8576124Z</d:Timestamp>
            <d:ID>ce58baa0-e6a8-4df7-9917-8f32cd135126</d:ID>
            <d:UserID>23903b0b-4a83-41dd-bf31-7effbb606bce</d:UserID>
            <d:ObjectID>2156cf4f-6a75-4925-b858-f92cefe9b2f4</d:ObjectID>
            <d:OwnerID>23903b0b-4a83-41dd-bf31-7effbb606bce</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Devices</d:TableName>
            <d:ModifiedDate>2015-01-11T11:41:48.2049915Z</d:ModifiedDate>
            <d:CreatedDate>2015-01-11T11:41:48.2049915Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    <!...>
      <entry m:etag="W/&quot;datetime'2014-07-30T10%3A15%3A43.1214265Z'&quot;">
        <id>https://myName.table.core.windows.net/Permissions(PartitionKey='zgl8%2BvItzHtLq73fEC%2BbAw%3D%3D',RowKey='ff309c48-cde3-412c-b1c9-be9514ed7ec0')</id>
        <category term="myName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='zgl8%2BvItzHtLq73fEC%2BbAw%3D%3D',RowKey='ff309c48-cde3-412c-b1c9-be9514ed7ec0')" />
        <title />
        <updated>2015-09-03T06:22:58Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>zgl8+vItzHtLq73fEC+bAw==</d:PartitionKey>
            <d:RowKey>ff309c48-cde3-412c-b1c9-be9514ed7ec0</d:RowKey>
            <d:Timestamp>2014-07-30T10:15:43.1214265Z</d:Timestamp>
            <d:ID>ff309c48-cde3-412c-b1c9-be9514ed7ec0</d:ID>
            <d:UserID>cd80b091-d344-4ba8-8d20-1be79ff7d22d</d:UserID>
            <d:ObjectID>1f5fade0-cf15-4110-97ee-df75ab6a0dd2</d:ObjectID>
            <d:OwnerID>cd80b091-d344-4ba8-8d20-1be79ff7d22d</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Projects</d:TableName>
            <d:ModifiedDate>2014-07-30T10:15:44.7787126Z</d:ModifiedDate>
            <d:CreatedDate>2014-07-30T10:15:44.7787126Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    </feed>
    As a reminder, this is from one of our larger tables (7000+ records) - although larger than many of our other tables, 7000 records is not a large table.

    Can anyone let me know if Azure is having any issues with continuation token requests?

    thanks
    Chris







    • Edited by clindstrom Thursday, September 3, 2015 1:35 PM
    Thursday, September 3, 2015 1:33 PM

Answers

  • To close the loop on this thread - it turns out that when doing a continuation token query, based on a previous filter request, you must add the filter criteria into the continuation token query.  This is not documented anywhere - since we are using RESTful calls to interface with Azure we saw the error.  If you use the Azure SDK, it puts the Filter into the continuation token queries by default.

    A bit of additional information - when using continuation tokens, it's not unusual to have subsequent continuation token calls that retrieve zero additional records (we've seen up to four additional calls).  Causing quite a lot of traffic with no payload.  This is probably could be a big problem for Microsoft in the future, considering Azure charges for bandwidth and the architecture of the queries is causing additional cost with no return.


    • Marked as answer by clindstrom Tuesday, November 24, 2015 3:18 AM
    • Edited by clindstrom Tuesday, November 24, 2015 3:19 AM
    Tuesday, November 24, 2015 3:18 AM

All replies

  • Hi Chris,

    We'd more time to research on this, we'll keep you updated with our findings.
    We regret the inconvenience caused and appreciate the patience.

    Regards,
    Malar.

    Friday, September 4, 2015 10:58 AM
  • Thanks Malar - I'm working on other problem sets and will post with Request IDs, hopefully that will help.
    Friday, September 4, 2015 2:59 PM
  • I've included a full query trace - from the initial query through processing all of the continuation tokens and included all of the x-ms-request-ids as well.  In all there are 8 total queries and responses.

    Hope this  helps to narrow the issue down:

    Query Trace : S2KC | Date Created: 9/5/2015 2:09 PM
    Azure Filter: 'UserID eq 'b1e065da-cc05-4c38-a203-586b1cfeb189' and OwnerID ne 'b1e065da-cc05-4c38-a203-586b1cfeb189' and TableName eq 'Workspaces'' created 8 separate queries.

    Page: 1
    Original Record Count: 0
    Resource: Permissions()?$filter=UserID%20eq%20'b1e065da-cc05-4c38-a203-586b1cfeb189'%20and%20OwnerID%20ne%20'b1e065da-cc05-4c38-a203-586b1cfeb189'%20and%20TableName%20eq%20'Workspaces'
    x-ms-request_id: 7d14a319-0002-0006-6a1f-e85dc3000000

    Response:
    <feed xml:base="https://MyName.table.core.windows.net/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
      <id>https://MyName.table.core.windows.net/Permissions</id>
      <title type="text">Permissions</title>
      <updated>2015-09-05T21:08:44Z</updated>
      <link rel="self" title="Permissions" href="Permissions" />
      <author>
        <name />
      </author>
    </feed>

    Page: 2
    Original Record Count: 1000
    - Corrected Count: 0
    - Incorrect Count: 1000 (# of records that didn't pass original filter)
    Resource: Permissions?NextPartitionKey=1!32!dEFLdTFUZ2s0WTdUT3AzelkyQnJYQT09&NextRowKey=1!48!Y2YxYTBmNWQtYmEwMi00Yzg3LTg1NDEtZDliNzQyNjQyM2Yz
    x-ms-request_id: 7d14aff6-0002-0006-391f-e85dc3000000

    Response:
    <feed xml:base="https://MyName.table.core.windows.net/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
      <id>https://MyName.table.core.windows.net/Permissions</id>
      <title type="text">Permissions</title>
      <updated>2015-09-05T21:09:10Z</updated>
      <link rel="self" title="Permissions" href="Permissions" />
      <entry m:etag="W/&quot;datetime'2015-09-02T15%3A30%3A04.4428402Z'&quot;">
        <id>https://MyName.table.core.windows.net/Permissions(PartitionKey='tAKu1Tgk4Y7TOp3zY2BrXA%3D%3D',RowKey='cf1a0f5d-ba02-4c87-8541-d9b7426423f3')</id>
        <category term="MyName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='tAKu1Tgk4Y7TOp3zY2BrXA%3D%3D',RowKey='cf1a0f5d-ba02-4c87-8541-d9b7426423f3')" />
        <title />
        <updated>2015-09-05T21:09:10Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>tAKu1Tgk4Y7TOp3zY2BrXA==</d:PartitionKey>
            <d:RowKey>cf1a0f5d-ba02-4c87-8541-d9b7426423f3</d:RowKey>
            <d:Timestamp m:type="Edm.DateTime">2015-09-02T15:30:04.4428402Z</d:Timestamp>
            <d:ID>cf1a0f5d-ba02-4c87-8541-d9b7426423f3</d:ID>
            <d:UserID>97c5262f-4757-4c94-8598-51ac0b49fe98</d:UserID>
            <d:ObjectID>f3c4bbee-68fe-459b-8a53-3188acb496ab</d:ObjectID>
            <d:OwnerID>97c5262f-4757-4c94-8598-51ac0b49fe98</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Projects</d:TableName>
            <d:ModifiedDate m:type="Edm.DateTime">2015-09-02T15:30:05.371359Z</d:ModifiedDate>
            <d:CreatedDate m:type="Edm.DateTime">2015-09-02T15:30:05.371359Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
      <entry m:etag="W/&quot;datetime'2014-10-26T23%3A59%3A03.6326333Z'&quot;">
        <id>https://MyName.table.core.windows.net/Permissions(PartitionKey='tAKu1Tgk4Y7TOp3zY2BrXA%3D%3D',RowKey='cf496add-8fc7-4f65-bf49-aadd5f41fe7b')</id>
        <category term="MyName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='tAKu1Tgk4Y7TOp3zY2BrXA%3D%3D',RowKey='cf496add-8fc7-4f65-bf49-aadd5f41fe7b')" />
        <title />
        <updated>2015-09-05T21:09:10Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>tAKu1Tgk4Y7TOp3zY2BrXA==</d:PartitionKey>
            <d:RowKey>cf496add-8fc7-4f65-bf49-aadd5f41fe7b</d:RowKey>
            <d:Timestamp m:type="Edm.DateTime">2014-10-26T23:59:03.6326333Z</d:Timestamp>
            <d:ID>cf496add-8fc7-4f65-bf49-aadd5f41fe7b</d:ID>
            <d:UserID>b3b2a2e9-9111-4709-92ed-71e2b3360622</d:UserID>
            <d:ObjectID>0623ac6d-b856-44de-b2d7-5188e292aad6</d:ObjectID>
            <d:OwnerID>b3b2a2e9-9111-4709-92ed-71e2b3360622</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Projects</d:TableName>
            <d:ModifiedDate m:type="Edm.DateTime">2014-10-26T23:59:03.2880581Z</d:ModifiedDate>
            <d:CreatedDate m:type="Edm.DateTime">2014-10-26T23:59:03.2880581Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    <! ......Records omitted>
      <entry>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>yRL5TND2w4mVaqkvkQABAQ==</d:PartitionKey>
            <d:RowKey>272102e5-d9aa-4368-8bf6-dd035b7ef366</d:RowKey>
            <d:Timestamp m:type="Edm.DateTime">2015-09-03T22:05:31.262813Z</d:Timestamp>
            <d:ID>272102e5-d9aa-4368-8bf6-dd035b7ef366</d:ID>
            <d:UserID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:UserID>
            <d:ObjectID>d2868b64-2e3a-4dff-b469-20994e1bc456</d:ObjectID>
            <d:OwnerID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Devices</d:TableName>
            <d:ModifiedDate m:type="Edm.DateTime">2015-09-03T22:05:33.604757Z</d:ModifiedDate>
            <d:CreatedDate m:type="Edm.DateTime">2015-09-03T22:05:33.604757Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    </feed>

    Page: 3
    Original Record Count: 1000
    - Corrected Count: 0
    - Incorrect Count: 1000 (# of records that didn't pass orignal filter)
    Resource: Permissions?NextPartitionKey=1!32!eVJMNVRORDJ3NG1WYXFrdmtRQUJBUT09&NextRowKey=1!48!MjcyZWYzMzMtYmQ4OS00MWVjLTliMWEtYTkwYmE0NWZiZWEx
    x-ms-request_id: 7d14b0e6-0002-0006-171f-e85dc3000000

    Response:
    <feed xml:base="https://MyName.table.core.windows.net/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
      <id>https://MyName.table.core.windows.net/Permissions</id>
      <title type="text">Permissions</title>
      <updated>2015-09-05T21:09:12Z</updated>
      <link rel="self" title="Permissions" href="Permissions" />
      <entry m:etag="W/&quot;datetime'2015-09-03T16%3A36%3A18.8767255Z'&quot;">
        <id>https://MyName.table.core.windows.net/Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='272ef333-bd89-41ec-9b1a-a90ba45fbea1')</id>
        <category term="MyName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='272ef333-bd89-41ec-9b1a-a90ba45fbea1')" />
        <title />
        <updated>2015-09-05T21:09:12Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>yRL5TND2w4mVaqkvkQABAQ==</d:PartitionKey>
            <d:RowKey>272ef333-bd89-41ec-9b1a-a90ba45fbea1</d:RowKey>
            <d:Timestamp m:type="Edm.DateTime">2015-09-03T16:36:18.8767255Z</d:Timestamp>
            <d:ID>272ef333-bd89-41ec-9b1a-a90ba45fbea1</d:ID>
            <d:UserID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:UserID>
            <d:ObjectID>9892e361-1a4b-4311-bd36-845b55215f97</d:ObjectID>
            <d:OwnerID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Devices</d:TableName>
            <d:ModifiedDate m:type="Edm.DateTime">2015-09-03T16:36:20.7576618Z</d:ModifiedDate>
            <d:CreatedDate m:type="Edm.DateTime">2015-09-03T16:36:20.7576618Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    <!... Records omitted>
      <entry m:etag="W/&quot;datetime'2015-09-03T21%3A59%3A04.5368383Z'&quot;">
        <id>https://MyName.table.core.windows.net/Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='5311d39c-d8c4-4228-9563-f95334f3fb31')</id>
        <category term="MyName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='5311d39c-d8c4-4228-9563-f95334f3fb31')" />
        <title />
        <updated>2015-09-05T21:09:12Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>yRL5TND2w4mVaqkvkQABAQ==</d:PartitionKey>
            <d:RowKey>5311d39c-d8c4-4228-9563-f95334f3fb31</d:RowKey>
            <d:Timestamp m:type="Edm.DateTime">2015-09-03T21:59:04.5368383Z</d:Timestamp>
            <d:ID>5311d39c-d8c4-4228-9563-f95334f3fb31</d:ID>
            <d:UserID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:UserID>
            <d:ObjectID>d385d091-b025-4a54-8f48-d38e291f7840</d:ObjectID>
            <d:OwnerID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Devices</d:TableName>
            <d:ModifiedDate m:type="Edm.DateTime">2015-09-03T21:59:06.8813813Z</d:ModifiedDate>
            <d:CreatedDate m:type="Edm.DateTime">2015-09-03T21:59:06.8813813Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
      
    Page: 4
    Original Record Count: 1000
    - Corrected Count: 0
    - Incorrect Count: 1000 (# of records that didn't pass orignal filter)
    Resource: Permissions?NextPartitionKey=1!32!eVJMNVRORDJ3NG1WYXFrdmtRQUJBUT09&NextRowKey=1!48!NTMxMjYzNzAtY2NmOC00Y2U0LTk5NTQtMDliMDk3MTAyZTM3
    x-ms-request_id: 7d14b1cc-0002-0006-6a1f-e85dc3000000

    Response:
    <feed xml:base="https://MyName.table.core.windows.net/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
      <id>https://MyName.table.core.windows.net/Permissions</id>
      <title type="text">Permissions</title>
      <updated>2015-09-05T21:09:14Z</updated>
      <link rel="self" title="Permissions" href="Permissions" />
      <entry m:etag="W/&quot;datetime'2015-09-04T10%3A19%3A02.730526Z'&quot;">
        <id>https://MyName.table.core.windows.net/Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='53126370-ccf8-4ce4-9954-09b097102e37')</id>
        <category term="MyName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='53126370-ccf8-4ce4-9954-09b097102e37')" />
        <title />
        <updated>2015-09-05T21:09:14Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>yRL5TND2w4mVaqkvkQABAQ==</d:PartitionKey>
            <d:RowKey>53126370-ccf8-4ce4-9954-09b097102e37</d:RowKey>
            <d:Timestamp m:type="Edm.DateTime">2015-09-04T10:19:02.730526Z</d:Timestamp>
            <d:ID>53126370-ccf8-4ce4-9954-09b097102e37</d:ID>
            <d:UserID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:UserID>
            <d:ObjectID>443eb6d9-8c4b-460a-afc4-e9f0b228f775</d:ObjectID>
            <d:OwnerID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Devices</d:TableName>
            <d:ModifiedDate m:type="Edm.DateTime">2015-09-04T10:19:05.1172324Z</d:ModifiedDate>
            <d:CreatedDate m:type="Edm.DateTime">2015-09-04T10:19:05.1172324Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    <! .....Records omitted>
      <entry m:etag="W/&quot;datetime'2015-09-04T09%3A20%3A50.2665293Z'&quot;">
        <id>https://MyName.table.core.windows.net/Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='80be9209-6cb6-41bb-b788-bd04d9dbdb44')</id>
        <category term="MyName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='80be9209-6cb6-41bb-b788-bd04d9dbdb44')" />
        <title />
        <updated>2015-09-05T21:09:14Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>yRL5TND2w4mVaqkvkQABAQ==</d:PartitionKey>
            <d:RowKey>80be9209-6cb6-41bb-b788-bd04d9dbdb44</d:RowKey>
            <d:Timestamp m:type="Edm.DateTime">2015-09-04T09:20:50.2665293Z</d:Timestamp>
            <d:ID>80be9209-6cb6-41bb-b788-bd04d9dbdb44</d:ID>
            <d:UserID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:UserID>
            <d:ObjectID>51e85e16-ee32-424c-a31f-207817b4a819</d:ObjectID>
            <d:OwnerID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Devices</d:TableName>
            <d:ModifiedDate m:type="Edm.DateTime">2015-09-04T09:20:52.7130259Z</d:ModifiedDate>
            <d:CreatedDate m:type="Edm.DateTime">2015-09-04T09:20:52.7130259Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    </feed>

    Page: 5
    Original Record Count: 1000
    - Corrected Count: 0
    - Incorrect Count: 1000 (# of records that didn't pass orignal filter)
    Resource: Permissions?NextPartitionKey=1!32!eVJMNVRORDJ3NG1WYXFrdmtRQUJBUT09&NextRowKey=1!48!ODBjYTI5ZGMtOGEzYy00MmU0LWIwNmYtNWNkYWY1ZmIwMGYz
    x-ms-request_id: 7d14b2ab-0002-0006-391f-e85dc3000000

    Response:
    <feed xml:base="https://MyName.table.core.windows.net/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
      <id>https://MyName.table.core.windows.net/Permissions</id>
      <title type="text">Permissions</title>
      <updated>2015-09-05T21:09:17Z</updated>
      <link rel="self" title="Permissions" href="Permissions" />
      <entry m:etag="W/&quot;datetime'2015-09-03T21%3A49%3A30.0678673Z'&quot;">
        <id>https://MyName.table.core.windows.net/Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='80ca29dc-8a3c-42e4-b06f-5cdaf5fb00f3')</id>
        <category term="MyName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='80ca29dc-8a3c-42e4-b06f-5cdaf5fb00f3')" />
        <title />
        <updated>2015-09-05T21:09:17Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>yRL5TND2w4mVaqkvkQABAQ==</d:PartitionKey>
            <d:RowKey>80ca29dc-8a3c-42e4-b06f-5cdaf5fb00f3</d:RowKey>
            <d:Timestamp m:type="Edm.DateTime">2015-09-03T21:49:30.0678673Z</d:Timestamp>
            <d:ID>80ca29dc-8a3c-42e4-b06f-5cdaf5fb00f3</d:ID>
            <d:UserID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:UserID>
            <d:ObjectID>d41c1047-b497-4bbd-baef-a31bcc8d634c</d:ObjectID>
            <d:OwnerID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Devices</d:TableName>
            <d:ModifiedDate m:type="Edm.DateTime">2015-09-03T21:49:32.4226951Z</d:ModifiedDate>
            <d:CreatedDate m:type="Edm.DateTime">2015-09-03T21:49:32.4226951Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    <!... Records Omitted>
      <entry m:etag="W/&quot;datetime'2015-09-03T16%3A36%3A36.0560413Z'&quot;">
        <id>https://MyName.table.core.windows.net/Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='aea99e57-4668-40d4-a348-1f26cd2bf68a')</id>
        <category term="MyName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='aea99e57-4668-40d4-a348-1f26cd2bf68a')" />
        <title />
        <updated>2015-09-05T21:09:17Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>yRL5TND2w4mVaqkvkQABAQ==</d:PartitionKey>
            <d:RowKey>aea99e57-4668-40d4-a348-1f26cd2bf68a</d:RowKey>
            <d:Timestamp m:type="Edm.DateTime">2015-09-03T16:36:36.0560413Z</d:Timestamp>
            <d:ID>aea99e57-4668-40d4-a348-1f26cd2bf68a</d:ID>
            <d:UserID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:UserID>
            <d:ObjectID>c8c080b6-9004-42e0-a891-f9da37b7c9b3</d:ObjectID>
            <d:OwnerID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Devices</d:TableName>
            <d:ModifiedDate m:type="Edm.DateTime">2015-09-03T16:36:37.9352155Z</d:ModifiedDate>
            <d:CreatedDate m:type="Edm.DateTime">2015-09-03T16:36:37.9352155Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    </feed>

    Page: 6
    Original Record Count: 1000
    - Corrected Count: 0
    - Incorrect Count: 1000 (# of records that didn't pass orignal filter)
    Resource: Permissions?NextPartitionKey=1!32!eVJMNVRORDJ3NG1WYXFrdmtRQUJBUT09&NextRowKey=1!48!YWVhYzkzNjQtNjU0ZC00N2U5LTg2ODUtN2I2YmFhMDRhNjgy
    x-ms-request_id: 7d14b396-0002-0006-0b1f-e85dc3000000

    Response:
    <feed xml:base="https://MyName.table.core.windows.net/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
      <id>https://MyName.table.core.windows.net/Permissions</id>
      <title type="text">Permissions</title>
      <updated>2015-09-05T21:09:19Z</updated>
      <link rel="self" title="Permissions" href="Permissions" />
      <entry m:etag="W/&quot;datetime'2015-09-04T22%3A12%3A15.6971834Z'&quot;">
        <id>https://MyName.table.core.windows.net/Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='aeac9364-654d-47e9-8685-7b6baa04a682')</id>
        <category term="MyName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='aeac9364-654d-47e9-8685-7b6baa04a682')" />
        <title />
        <updated>2015-09-05T21:09:19Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>yRL5TND2w4mVaqkvkQABAQ==</d:PartitionKey>
            <d:RowKey>aeac9364-654d-47e9-8685-7b6baa04a682</d:RowKey>
            <d:Timestamp m:type="Edm.DateTime">2015-09-04T22:12:15.6971834Z</d:Timestamp>
            <d:ID>aeac9364-654d-47e9-8685-7b6baa04a682</d:ID>
            <d:UserID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:UserID>
            <d:ObjectID>acda2fec-ed19-4098-9feb-e46b3f4cf1f3</d:ObjectID>
            <d:OwnerID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Devices</d:TableName>
            <d:ModifiedDate m:type="Edm.DateTime">2015-09-04T22:12:18.1702644Z</d:ModifiedDate>
            <d:CreatedDate m:type="Edm.DateTime">2015-09-04T22:12:18.1702644Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    <! ....Records Omitted>
      <entry m:etag="W/&quot;datetime'2015-09-04T10%3A01%3A52.9217534Z'&quot;">
        <id>https://MyName.table.core.windows.net/Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='da1d2108-b6a7-4405-996b-78ea1330e31b')</id>
        <category term="MyName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='da1d2108-b6a7-4405-996b-78ea1330e31b')" />
        <title />
        <updated>2015-09-05T21:09:19Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>yRL5TND2w4mVaqkvkQABAQ==</d:PartitionKey>
            <d:RowKey>da1d2108-b6a7-4405-996b-78ea1330e31b</d:RowKey>
            <d:Timestamp m:type="Edm.DateTime">2015-09-04T10:01:52.9217534Z</d:Timestamp>
            <d:ID>da1d2108-b6a7-4405-996b-78ea1330e31b</d:ID>
            <d:UserID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:UserID>
            <d:ObjectID>4d597288-fba6-413d-9398-e7b45a1c996d</d:ObjectID>
            <d:OwnerID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Devices</d:TableName>
            <d:ModifiedDate m:type="Edm.DateTime">2015-09-04T10:01:55.5948247Z</d:ModifiedDate>
            <d:CreatedDate m:type="Edm.DateTime">2015-09-04T10:01:55.5948247Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    </feed>

    Page: 7
    Original Record Count: 1000
    - Corrected Count: 0
    - Incorrect Count: 1000 (# of records that didn't pass orignal filter)
    Resource: Permissions?NextPartitionKey=1!32!eVJMNVRORDJ3NG1WYXFrdmtRQUJBUT09&NextRowKey=1!48!ZGEyM2FjZTctZjZlNy00NGFiLThkM2ItNDRlZWM1Y2Q1NWEy
    x-ms-request_id: 7d14b474-0002-0006-551f-e85dc3000000

    Response:
    <feed xml:base="https://MyName.table.core.windows.net/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
      <id>https://MyName.table.core.windows.net/Permissions</id>
      <title type="text">Permissions</title>
      <updated>2015-09-05T21:09:22Z</updated>
      <link rel="self" title="Permissions" href="Permissions" />
      <entry m:etag="W/&quot;datetime'2015-09-04T09%3A10%3A47.4543616Z'&quot;">
        <id>https://MyName.table.core.windows.net/Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='da23ace7-f6e7-44ab-8d3b-44eec5cd55a2')</id>
        <category term="MyName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='yRL5TND2w4mVaqkvkQABAQ%3D%3D',RowKey='da23ace7-f6e7-44ab-8d3b-44eec5cd55a2')" />
        <title />
        <updated>2015-09-05T21:09:22Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>yRL5TND2w4mVaqkvkQABAQ==</d:PartitionKey>
            <d:RowKey>da23ace7-f6e7-44ab-8d3b-44eec5cd55a2</d:RowKey>
            <d:Timestamp m:type="Edm.DateTime">2015-09-04T09:10:47.4543616Z</d:Timestamp>
            <d:ID>da23ace7-f6e7-44ab-8d3b-44eec5cd55a2</d:ID>
            <d:UserID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:UserID>
            <d:ObjectID>bbfd2bd6-eca5-49b4-be90-5783d797f08e</d:ObjectID>
            <d:OwnerID>c56dfd79-850e-4eb8-9144-c0c9cb1334ee</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Devices</d:TableName>
            <d:ModifiedDate m:type="Edm.DateTime">2015-09-04T09:10:49.7051877Z</d:ModifiedDate>
            <d:CreatedDate m:type="Edm.DateTime">2015-09-04T09:10:49.7051877Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    <! ... Records Omitted>
      <entry m:etag="W/&quot;datetime'2014-09-29T09%3A33%3A28.73723Z'&quot;">
        <id>https://MyName.table.core.windows.net/Permissions(PartitionKey='zgl8%2BvItzHtLq73fEC%2BbAw%3D%3D',RowKey='92e571a4-97b1-452c-8e19-d0633980cca9')</id>
        <category term="MyName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='zgl8%2BvItzHtLq73fEC%2BbAw%3D%3D',RowKey='92e571a4-97b1-452c-8e19-d0633980cca9')" />
        <title />
        <updated>2015-09-05T21:09:22Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>zgl8+vItzHtLq73fEC+bAw==</d:PartitionKey>
            <d:RowKey>92e571a4-97b1-452c-8e19-d0633980cca9</d:RowKey>
            <d:Timestamp m:type="Edm.DateTime">2014-09-29T09:33:28.73723Z</d:Timestamp>
            <d:ID>92e571a4-97b1-452c-8e19-d0633980cca9</d:ID>
            <d:UserID>a036e4b8-1f31-4b9b-8a25-597b905f87d0</d:UserID>
            <d:ObjectID>b14c2450-c352-44c6-a015-737e8185eb74</d:ObjectID>
            <d:OwnerID>a036e4b8-1f31-4b9b-8a25-597b905f87d0</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Projects</d:TableName>
            <d:ModifiedDate m:type="Edm.DateTime">2014-09-29T09:33:28.6858698Z</d:ModifiedDate>
            <d:CreatedDate m:type="Edm.DateTime">2014-09-29T09:33:28.6858698Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    </feed>

    Page: 8
    Original Record Count: 129
    - Corrected Count: 0
    - Incorrect Count: 129 (# of records that didn't pass orignal filter)
    Resource: Permissions?NextPartitionKey=1!32!emdsOCt2SXR6SHRMcTczZkVDK2JBdz09&NextRowKey=1!48!OTVlYmQ5YTktNDNkZS00Nzg4LWI5NDUtZjhkNDcwYzFmZTRl
    x-ms-request_id: 7d14b57c-0002-0006-481f-e85dc3000000

    Response:
    <feed xml:base="https://MyName.table.core.windows.net/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
      <id>https://MyName.table.core.windows.net/Permissions</id>
      <title type="text">Permissions</title>
      <updated>2015-09-05T21:09:23Z</updated>
      <link rel="self" title="Permissions" href="Permissions" />
      <entry m:etag="W/&quot;datetime'2014-09-29T09%3A37%3A33.66723Z'&quot;">
        <id>https://MyName.table.core.windows.net/Permissions(PartitionKey='zgl8%2BvItzHtLq73fEC%2BbAw%3D%3D',RowKey='95ebd9a9-43de-4788-b945-f8d470c1fe4e')</id>
        <category term="MyName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='zgl8%2BvItzHtLq73fEC%2BbAw%3D%3D',RowKey='95ebd9a9-43de-4788-b945-f8d470c1fe4e')" />
        <title />
        <updated>2015-09-05T21:09:23Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>zgl8+vItzHtLq73fEC+bAw==</d:PartitionKey>
            <d:RowKey>95ebd9a9-43de-4788-b945-f8d470c1fe4e</d:RowKey>
            <d:Timestamp m:type="Edm.DateTime">2014-09-29T09:37:33.66723Z</d:Timestamp>
            <d:ID>95ebd9a9-43de-4788-b945-f8d470c1fe4e</d:ID>
            <d:UserID>a036e4b8-1f31-4b9b-8a25-597b905f87d0</d:UserID>
            <d:ObjectID>9eafb58f-5cf2-4b9c-9503-61bb910392f9</d:ObjectID>
            <d:OwnerID>a036e4b8-1f31-4b9b-8a25-597b905f87d0</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Projects</d:TableName>
            <d:ModifiedDate m:type="Edm.DateTime">2014-09-29T09:37:33.6408874Z</d:ModifiedDate>
            <d:CreatedDate m:type="Edm.DateTime">2014-09-29T09:37:33.6408874Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
     <! ... Records omitted>
      <entry m:etag="W/&quot;datetime'2014-07-30T10%3A15%3A43.1214265Z'&quot;">
        <id>https://MyName.table.core.windows.net/Permissions(PartitionKey='zgl8%2BvItzHtLq73fEC%2BbAw%3D%3D',RowKey='ff309c48-cde3-412c-b1c9-be9514ed7ec0')</id>
        <category term="MyName.Permissions" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link rel="edit" title="Permissions" href="Permissions(PartitionKey='zgl8%2BvItzHtLq73fEC%2BbAw%3D%3D',RowKey='ff309c48-cde3-412c-b1c9-be9514ed7ec0')" />
        <title />
        <updated>2015-09-05T21:09:23Z</updated>
        <author>
          <name />
        </author>
        <content type="application/xml">
          <m:properties>
            <d:PartitionKey>zgl8+vItzHtLq73fEC+bAw==</d:PartitionKey>
            <d:RowKey>ff309c48-cde3-412c-b1c9-be9514ed7ec0</d:RowKey>
            <d:Timestamp m:type="Edm.DateTime">2014-07-30T10:15:43.1214265Z</d:Timestamp>
            <d:ID>ff309c48-cde3-412c-b1c9-be9514ed7ec0</d:ID>
            <d:UserID>cd80b091-d344-4ba8-8d20-1be79ff7d22d</d:UserID>
            <d:ObjectID>1f5fade0-cf15-4110-97ee-df75ab6a0dd2</d:ObjectID>
            <d:OwnerID>cd80b091-d344-4ba8-8d20-1be79ff7d22d</d:OwnerID>
            <d:Permission>7</d:Permission>
            <d:TableName>Projects</d:TableName>
            <d:ModifiedDate m:type="Edm.DateTime">2014-07-30T10:15:44.7787126Z</d:ModifiedDate>
            <d:CreatedDate m:type="Edm.DateTime">2014-07-30T10:15:44.7787126Z</d:CreatedDate>
          </m:properties>
        </content>
      </entry>
    </feed>

    Saturday, September 5, 2015 9:31 PM
  • To close the loop on this thread - it turns out that when doing a continuation token query, based on a previous filter request, you must add the filter criteria into the continuation token query.  This is not documented anywhere - since we are using RESTful calls to interface with Azure we saw the error.  If you use the Azure SDK, it puts the Filter into the continuation token queries by default.

    A bit of additional information - when using continuation tokens, it's not unusual to have subsequent continuation token calls that retrieve zero additional records (we've seen up to four additional calls).  Causing quite a lot of traffic with no payload.  This is probably could be a big problem for Microsoft in the future, considering Azure charges for bandwidth and the architecture of the queries is causing additional cost with no return.


    • Marked as answer by clindstrom Tuesday, November 24, 2015 3:18 AM
    • Edited by clindstrom Tuesday, November 24, 2015 3:19 AM
    Tuesday, November 24, 2015 3:18 AM