Pagination, Filtering, and Sorting

{
  edges {        # Array of results
    node { ... } # The entity (Payin, Payout, or Claim)
    cursor       # Opaque cursor for this record
  }
  pageInfo {
    hasNextPage  # true if more results exist
    endCursor    # Cursor of the last item; pass as "after" for the next page
  }
  summary {
    rowCount     # Number of items in this page
    pageSizeLimit # Effective page size limit applied
    totalCount   # Always null for list queries
  }
}

# First page
CURSOR=""
HAS_NEXT=true

while [ "$HAS_NEXT" = "true" ]; do
  if [ -z "$CURSOR" ]; then
    AFTER_CLAUSE=""
  else
    AFTER_CLAUSE=", after: \"$CURSOR\""
  fi

  RESPONSE=$(curl -s -X POST https://api.payretailers.com/data-api/graphql \
    -H "Content-Type: application/json" \
    -H "Authorization: Basic $(echo -n 'YOUR_SHOP_ID:YOUR_API_TOKEN' | base64)" \
    -d "{\"query\": \"{ payins(first: 100${AFTER_CLAUSE}, filter: { createdDateFrom: \\\"2026-01-01\\\", createdDateTo: \\\"2026-01-31\\\" }) { edges { node { transactionId amount currency transactionStatusName } cursor } pageInfo { hasNextPage endCursor } summary { rowCount } } }\"}")

  echo "$RESPONSE" | python3 -m json.tool

  HAS_NEXT=$(echo "$RESPONSE" | python3 -c "import sys,json; print(json.load(sys.stdin)['data']['payins']['pageInfo']['hasNextPage'])" | tr '[:upper:]' '[:lower:]')
  CURSOR=$(echo "$RESPONSE" | python3 -c "import sys,json; d=json.load(sys.stdin)['data']['payins']['pageInfo']; print(d.get('endCursor',''))")
done

import requests
from requests.auth import HTTPBasicAuth

url = "https://api.payretailers.com/data-api/graphql"
auth = HTTPBasicAuth("YOUR_SHOP_ID", "YOUR_API_TOKEN")

all_payins = []
cursor = None
has_next_page = True

while has_next_page:
    after_clause = f', after: "{cursor}"' if cursor else ""
    query = f"""
    query {{
      payins(
        first: 100
        {after_clause}
        filter: {{
          createdDateFrom: "2026-01-01"
          createdDateTo: "2026-01-31"
        }}
      ) {{
        edges {{
          node {{
            transactionId
            amount
            currency
            transactionStatusName
          }}
        }}
        pageInfo {{
          hasNextPage
          endCursor
        }}
        summary {{
          rowCount
        }}
      }}
    }}
    """

    response = requests.post(
        url,
        json={"query": query},
        auth=auth,
        headers={"Content-Type": "application/json"},
    )
    result = response.json()

    payins_data = result["data"]["payins"]
    for edge in payins_data["edges"]:
        all_payins.append(edge["node"])

    page_info = payins_data["pageInfo"]
    has_next_page = page_info["hasNextPage"]
    cursor = page_info.get("endCursor")

    print(f"Fetched {payins_data['summary']['rowCount']} records. "
          f"Total so far: {len(all_payins)}")

print(f"Done. Total payins: {len(all_payins)}")

import axios from "axios";

const url = "https://api.payretailers.com/data-api/graphql";
const credentials = Buffer.from("YOUR_SHOP_ID:YOUR_API_TOKEN").toString("base64");

interface PayinNode {
  transactionId: string;
  amount: string;
  currency: string;
  transactionStatusName: string;
}

const allPayins: PayinNode[] = [];
let cursor: string | null = null;
let hasNextPage = true;

while (hasNextPage) {
  const afterClause = cursor ? `, after: "${cursor}"` : "";
  const query = `
    query {
      payins(
        first: 100
        ${afterClause}
        filter: {
          createdDateFrom: "2026-01-01"
          createdDateTo: "2026-01-31"
        }
      ) {
        edges {
          node {
            transactionId
            amount
            currency
            transactionStatusName
          }
        }
        pageInfo {
          hasNextPage
          endCursor
        }
        summary {
          rowCount
        }
      }
    }
  `;

  const response = await axios.post(
    url,
    { query },
    {
      headers: {
        "Content-Type": "application/json",
        Authorization: `Basic ${credentials}`,
      },
    }
  );

  const payinsData = response.data.data.payins;
  for (const edge of payinsData.edges) {
    allPayins.push(edge.node);
  }

  hasNextPage = payinsData.pageInfo.hasNextPage;
  cursor = payinsData.pageInfo.endCursor;

  console.log(
    `Fetched ${payinsData.summary.rowCount} records. Total so far: ${allPayins.length}`
  );
}

console.log(`Done. Total payins: ${allPayins.length}`);

query {
  payins(
    first: 1
    filter: {
      transactionId: "9c017f16-a41c-7040-8eb6-31030c7fea76"
    }
  ) {
    edges {
      node {
        transactionId
        amount
        transactionStatusName
        createdTs
      }
    }
    summary {
      rowCount
    }
  }
}

{
  "data": {
    "payins": {
      "edges": [
        {
          "node": {
            "transactionId": "9c017f16-a41c-7040-8eb6-31030c7fea76",
            "amount": "55.03",
            "transactionStatusName": "CANCELLED",
            "createdTs": "2026-01-31T23:59:15.167Z"
          }
        }
      ],
      "summary": {
        "rowCount": 1
      }
    }
  }
}

{
  "data": {
    "payins": {
      "edges": [],
      "pageInfo": {
        "hasNextPage": false,
        "endCursor": null
      },
      "summary": {
        "rowCount": 0,
        "pageSizeLimit": 1000,
        "totalCount": null
      }
    }
  }
}