Paginate through large result sets in CharityStack

import requests

API_KEY = "cs_live_your_key_here"
BASE_URL = "https://0k90mc4jjj.execute-api.us-east-2.amazonaws.com"

def fetch_all_payments():
    headers = {"Authorization": f"Bearer {API_KEY}"}
    all_payments = []
    params = {"limit": 100}

    while True:
        response = requests.get(
            f"{BASE_URL}/v1/payments",
            headers=headers,
            params=params,
        )
        response.raise_for_status()
        body = response.json()

        all_payments.extend(body["payments"])
        print(f"Fetched {body['count']} payments (total so far: {len(all_payments)})")

        if not body.get("hasMore"):
            break

        params["lastEvaluatedKey"] = body["lastEvaluatedKey"]

    return all_payments

payments = fetch_all_payments()
print(f"Done. Total payments retrieved: {len(payments)}")

const API_KEY = "cs_live_your_key_here";
const BASE_URL = "https://0k90mc4jjj.execute-api.us-east-2.amazonaws.com";

async function fetchAllPayments() {
  const headers = { Authorization: `Bearer ${API_KEY}` };
  const allPayments = [];
  let lastEvaluatedKey = null;

  do {
    const params = new URLSearchParams({ limit: "100" });
    if (lastEvaluatedKey) {
      params.set("lastEvaluatedKey", lastEvaluatedKey);
    }

    const response = await fetch(
      `${BASE_URL}/v1/payments?${params}`,
      { headers }
    );

    if (!response.ok) {
      throw new Error(`Request failed: ${response.status}`);
    }

    const body = await response.json();
    allPayments.push(...body.payments);
    console.log(`Fetched ${body.count} payments (total: ${allPayments.length})`);

    lastEvaluatedKey = body.hasMore ? body.lastEvaluatedKey : null;
  } while (lastEvaluatedKey);

  return allPayments;
}

fetchAllPayments().then((payments) => {
  console.log(`Done. Total payments retrieved: ${payments.length}`);
});