Pagination

curl -G https://prod-api.raisedonors.com/api/Donor/list \
  -H "Authorization: Bearer YOUR_API_TOKEN" \
  --data-urlencode "Skip=0" \
  --data-urlencode "Take=100" \
  --data-urlencode "SortBy=createddatetime" \
  --data-urlencode "Descending=true"

const params = new URLSearchParams({
  Skip: '0',
  Take: '100',
  SortBy: 'createddatetime',
  Descending: 'true',
});

const response = await fetch(
  `https://prod-api.raisedonors.com/api/Donor/list?${params}`,
  { headers: { Authorization: `Bearer ${process.env.RAISE_API_TOKEN}` } }
);

const page = await response.json();
console.log(`${page.items.length} of ${page.total} donors`);

async function listAllDonors() {
  const allDonors = [];
  let skip = 0;
  const take = 1000;       // Use the maximum supported value for bulk reads
  let total = null;

  do {
    const params = new URLSearchParams({
      Skip: skip.toString(),
      Take: take.toString(),
      SortBy: 'id',          // Stable sort for resumable iteration
      Descending: 'false',
    });

    const response = await fetch(
      `https://prod-api.raisedonors.com/api/Donor/list?${params}`,
      { headers: { Authorization: `Bearer ${process.env.RAISE_API_TOKEN}` } }
    );

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

    const page = await response.json();
    if (total === null) {
      total = page.total;
      console.log(`Iterating over ${total} donors`);
    }

    allDonors.push(...page.items);
    skip += take;
  } while (skip < total);

  return allDonors;
}

curl https://prod-api.raisedonors.com/api/Query/options/0 \
  -H "Authorization: Bearer YOUR_API_TOKEN"

async function queryAllDonors(filterGroups, queryType) {
  const allItems = [];
  let skip = 0;
  const take = 1000;
  let total = null;

  do {
    const response = await fetch(
      'https://prod-api.raisedonors.com/api/Donor/query',
      {
        method: 'POST',
        headers: {
          Authorization: `Bearer ${process.env.RAISE_API_TOKEN}`,
          'Content-Type': 'application/json',
        },
        body: JSON.stringify({
          queryType,
          skip,
          take,
          sortBy: 'id',
          descending: false,
          groups: filterGroups,
        }),
      }
    );

    const page = await response.json();
    if (total === null) total = page.total;

    allItems.push(...page.items);
    skip += take;
  } while (skip < total);

  return allItems;
}

async function queryAllDonorsCursor(baseFilterGroups, queryType, idOperator) {
  // idOperator: the integer enum value for "Greater Than" — discover via /api/Query/options
  const allItems = [];
  let cursorId = 0;
  const take = 1000;

  while (true) {
    // Add an ID > cursorId condition to each request
    const groupsWithCursor = [
      ...baseFilterGroups,
      {
        conditions: [
          { parameter: 'id', operator: idOperator, value: cursorId.toString() },
        ],
      },
    ];

    const response = await fetch(
      'https://prod-api.raisedonors.com/api/Donor/query',
      {
        method: 'POST',
        headers: {
          Authorization: `Bearer ${process.env.RAISE_API_TOKEN}`,
          'Content-Type': 'application/json',
        },
        body: JSON.stringify({
          queryType,
          skip: 0,
          take,
          sortBy: 'id',
          descending: false,
          groups: groupsWithCursor,
        }),
      }
    );

    const page = await response.json();
    if (page.items.length === 0) break;

    allItems.push(...page.items);
    cursorId = page.items[page.items.length - 1].id;
  }

  return allItems;
}