Doing pagination correctly

Hello,

I have been using the guide on pagination in the API docs to paginate through data, but I’ve noticed that the endCursor is not unique across different days. It is causing me to not pull certain data which might share the cursor value at a later date. This is my query below (I had to pull data from a certain date, and now I’m only trying to pull data updated since the time my program last ran). What should I change?

The end_cursor comes from the last order that I pulled

query ($current_timestamp: ISODateTime!, $end_cursor: String!) {
    orders(fulfillment_status: "fulfilled" updated_to: $current_timestamp order_date_from:"2022-01-01 00:00:00") {
      request_id
      complexity
      data (first:10 after:$end_cursor) {
        pageInfo {
          hasNextPage
          startCursor
          endCursor
        }
        edges {
          cursor
          node {
            id
            order_number
            partner_order_id
            required_ship_date
            shop_name
            fulfillment_status
            order_date
            total_price
            total_discounts
            total_tax
            subtotal
            box_name
            email
            shipping_lines {
              title
              carrier
              method
              price
            }
            shipping_address {
              address1
              address2
              city
              state
              zip
              country
            }
            saturday_delivery
            alcohol
            expected_weight_in_oz
            currency
            has_dry_ice
            shipments {
              shipped_off_shiphero
              shipping_labels {
                tracking_number
                status
                carrier
                shipping_name
                shipping_method
                cost
                delivered
                refunded
                needs_refund
                insurance_amount
                created_date
                dimensions {
                  length
                  width
                  height
                  weight
                }
                address {
                  address1
                  address2
                  city
                  state
                  country
                  zip
                }

              }
            }

          }
        }
      }
      }
      }

Hello @saladass4254!

What is happening there is that the query changed. Using the current date-time, the new subset of values changes constantly.

You could change the order_date_from to the date of the last order you consumed and start painting again from there.

Have a great day!
TomasFD