Query Donors

Query Donors

curl --request POST \
  --url https://prod-api.raisedonors.com/api/Donor/query \
  --header 'Authorization: <api-key>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "filter": "<string>",
  "skip": 123,
  "take": 123,
  "sortBy": "createdate",
  "descending": true,
  "includeDetails": true,
  "groups": [
    {
      "conditions": [
        {
          "parameter": "<string>",
          "value": "<string>",
          "secondaryValue": "<string>",
          "values": [
            "<string>"
          ]
        }
      ]
    }
  ],
  "selectedColumns": [
    "<string>"
  ]
}
'

const options = {
  method: 'POST',
  headers: {Authorization: '<api-key>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    filter: '<string>',
    skip: 123,
    take: 123,
    sortBy: 'createdate',
    descending: true,
    includeDetails: true,
    groups: [
      {
        conditions: [
          {
            parameter: '<string>',
            value: '<string>',
            secondaryValue: '<string>',
            values: ['<string>']
          }
        ]
      }
    ],
    selectedColumns: ['<string>']
  })
};

fetch('https://prod-api.raisedonors.com/api/Donor/query', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

import requests

url = "https://prod-api.raisedonors.com/api/Donor/query"

payload = {
    "filter": "<string>",
    "skip": 123,
    "take": 123,
    "sortBy": "createdate",
    "descending": True,
    "includeDetails": True,
    "groups": [{ "conditions": [
                {
                    "parameter": "<string>",
                    "value": "<string>",
                    "secondaryValue": "<string>",
                    "values": ["<string>"]
                }
            ] }],
    "selectedColumns": ["<string>"]
}
headers = {
    "Authorization": "<api-key>",
    "Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

using RestSharp;


var options = new RestClientOptions("https://prod-api.raisedonors.com/api/Donor/query");
var client = new RestClient(options);
var request = new RestRequest("");
request.AddHeader("Authorization", "<api-key>");
request.AddJsonBody("{\n  \"filter\": \"<string>\",\n  \"skip\": 123,\n  \"take\": 123,\n  \"sortBy\": \"createdate\",\n  \"descending\": true,\n  \"includeDetails\": true,\n  \"groups\": [\n    {\n      \"conditions\": [\n        {\n          \"parameter\": \"<string>\",\n          \"value\": \"<string>\",\n          \"secondaryValue\": \"<string>\",\n          \"values\": [\n            \"<string>\"\n          ]\n        }\n      ]\n    }\n  ],\n  \"selectedColumns\": [\n    \"<string>\"\n  ]\n}", false);
var response = await client.PostAsync(request);

Console.WriteLine("{0}", response.Content);

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://prod-api.raisedonors.com/api/Donor/query",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    'filter' => '<string>',
    'skip' => 123,
    'take' => 123,
    'sortBy' => 'createdate',
    'descending' => true,
    'includeDetails' => true,
    'groups' => [
        [
                'conditions' => [
                                [
                                                                'parameter' => '<string>',
                                                                'value' => '<string>',
                                                                'secondaryValue' => '<string>',
                                                                'values' => [
                                                                                                                                '<string>'
                                                                ]
                                ]
                ]
        ]
    ],
    'selectedColumns' => [
        '<string>'
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: <api-key>",
    "Content-Type: application/json"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

HttpResponse<String> response = Unirest.post("https://prod-api.raisedonors.com/api/Donor/query")
  .header("Authorization", "<api-key>")
  .header("Content-Type", "application/json")
  .body("{\n  \"filter\": \"<string>\",\n  \"skip\": 123,\n  \"take\": 123,\n  \"sortBy\": \"createdate\",\n  \"descending\": true,\n  \"includeDetails\": true,\n  \"groups\": [\n    {\n      \"conditions\": [\n        {\n          \"parameter\": \"<string>\",\n          \"value\": \"<string>\",\n          \"secondaryValue\": \"<string>\",\n          \"values\": [\n            \"<string>\"\n          ]\n        }\n      ]\n    }\n  ],\n  \"selectedColumns\": [\n    \"<string>\"\n  ]\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://prod-api.raisedonors.com/api/Donor/query")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["Authorization"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"filter\": \"<string>\",\n  \"skip\": 123,\n  \"take\": 123,\n  \"sortBy\": \"createdate\",\n  \"descending\": true,\n  \"includeDetails\": true,\n  \"groups\": [\n    {\n      \"conditions\": [\n        {\n          \"parameter\": \"<string>\",\n          \"value\": \"<string>\",\n          \"secondaryValue\": \"<string>\",\n          \"values\": [\n            \"<string>\"\n          ]\n        }\n      ]\n    }\n  ],\n  \"selectedColumns\": [\n    \"<string>\"\n  ]\n}"

response = http.request(request)
puts response.read_body

const url = 'https://prod-api.raisedonors.com/api/Donor/query';
const options = {
  method: 'POST',
  headers: {Authorization: '<api-key>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    filter: '<string>',
    skip: 123,
    take: 123,
    sortBy: 'createdate',
    descending: true,
    includeDetails: true,
    groups: [
      {
        conditions: [
          {
            parameter: '<string>',
            value: '<string>',
            secondaryValue: '<string>',
            values: ['<string>']
          }
        ]
      }
    ],
    selectedColumns: ['<string>']
  })
};

fetch(url, options)
  .then(res => res.json())
  .then(json => console.log(json))
  .catch(err => console.error(err));

{
  "items": [
    {
      "id": 200234,
      "name": "Marcus Castellano",
      "title": "Mr.",
      "firstName": "Marcus",
      "middleName": "David",
      "lastName": "Castellano",
      "suffix": null,
      "email": "marcus.castellano@example.org",
      "phone": "(555) 012-3401",
      "createdDate": "2018-09-15T14:22:31Z",
      "modifiedDate": "2025-10-12T09:15:42Z",
      "notes": "Board member. Prefers email for receipts and annual reports.",
      "isOrganization": false,
      "organizationName": null,
      "crmKeyUrls": {
        "VirtuousCRM": {
          "crmKey": "100234",
          "url": "https://app.virtuoussoftware.com/Generosity/Contact/Detail/100234"
        }
      },
      "crmKey": "100234",
      "crmSecondKey": null,
      "isTestMode": false,
      "isArchived": false,
      "isGDPRDeleted": false,
      "primaryAddress": {
        "id": 400101,
        "donorId": 200234,
        "isPrimary": true,
        "address1": "219 Oak Hill Drive",
        "address2": null,
        "city": "Springfield",
        "state": "OR",
        "postal": "97478",
        "countryString": "United States",
        "addressTypeDisplay": "Home"
      },
      "donorAddresses": [
        {
          "id": 400101,
          "donorId": 200234,
          "isPrimary": true,
          "address1": "219 Oak Hill Drive",
          "address2": null,
          "city": "Springfield",
          "state": "OR",
          "postal": "97478",
          "countryString": "United States",
          "addressTypeDisplay": "Home"
        }
      ],
      "donorEmailAddresses": [
        {
          "id": 300101,
          "donorId": 200234,
          "typeDisplay": "Home Email",
          "value": "marcus.castellano@example.org",
          "secondaryValue": null,
          "isPrimary": true,
          "isOptedIn": true,
          "isValid": true,
          "isEmail": true,
          "isPhone": false,
          "isBounced": false,
          "countryCode": null
        }
      ],
      "donorPhoneNumbers": [
        {
          "id": 300102,
          "donorId": 200234,
          "typeDisplay": "Mobile Phone",
          "value": "(555) 012-3401",
          "secondaryValue": null,
          "isPrimary": true,
          "isOptedIn": true,
          "isValid": true,
          "isEmail": false,
          "isPhone": true,
          "isBounced": false,
          "countryCode": "1"
        },
        {
          "id": 300103,
          "donorId": 200234,
          "typeDisplay": "Home Phone",
          "value": "(555) 012-3400",
          "secondaryValue": null,
          "isPrimary": false,
          "isOptedIn": true,
          "isValid": true,
          "isEmail": false,
          "isPhone": true,
          "isBounced": false,
          "countryCode": "1"
        }
      ]
    },
    {
      "id": 200456,
      "name": "Priya Sharma",
      "title": "Ms.",
      "firstName": "Priya",
      "middleName": null,
      "lastName": "Sharma",
      "suffix": null,
      "email": "priya.sharma@example.org",
      "phone": "(555) 012-3450",
      "createdDate": "2023-02-15T10:30:00Z",
      "modifiedDate": "2025-11-15T03:00:00Z",
      "notes": "Monthly donor since February 2023. Volunteer organizer.",
      "isOrganization": false,
      "organizationName": null,
      "crmKeyUrls": {
        "VirtuousCRM": {
          "crmKey": "100456",
          "url": "https://app.virtuoussoftware.com/Generosity/Contact/Detail/100456"
        }
      },
      "crmKey": "100456",
      "crmSecondKey": null,
      "isTestMode": false,
      "isArchived": false,
      "isGDPRDeleted": false,
      "primaryAddress": {
        "id": 400156,
        "donorId": 200456,
        "isPrimary": true,
        "address1": "1542 Elmwood Lane",
        "address2": null,
        "city": "Springfield",
        "state": "OR",
        "postal": "97477",
        "countryString": "United States",
        "addressTypeDisplay": "Home"
      },
      "donorAddresses": [
        {
          "id": 400156,
          "donorId": 200456,
          "isPrimary": true,
          "address1": "1542 Elmwood Lane",
          "address2": null,
          "city": "Springfield",
          "state": "OR",
          "postal": "97477",
          "countryString": "United States",
          "addressTypeDisplay": "Home"
        }
      ],
      "donorEmailAddresses": [
        {
          "id": 300156,
          "donorId": 200456,
          "typeDisplay": "Home Email",
          "value": "priya.sharma@example.org",
          "secondaryValue": null,
          "isPrimary": true,
          "isOptedIn": true,
          "isValid": true,
          "isEmail": true,
          "isPhone": false,
          "isBounced": false,
          "countryCode": null
        }
      ],
      "donorPhoneNumbers": [
        {
          "id": 300157,
          "donorId": 200456,
          "typeDisplay": "Mobile Phone",
          "value": "(555) 012-3450",
          "secondaryValue": null,
          "isPrimary": true,
          "isOptedIn": true,
          "isValid": true,
          "isEmail": false,
          "isPhone": true,
          "isBounced": false,
          "countryCode": "1"
        }
      ]
    },
    {
      "id": 202301,
      "name": "The Aspen Family Foundation",
      "title": null,
      "firstName": null,
      "middleName": null,
      "lastName": null,
      "suffix": null,
      "email": "grants@aspenfoundation.example.org",
      "phone": "(555) 012-3800",
      "createdDate": "2023-06-15T11:05:00Z",
      "modifiedDate": "2025-06-20T16:41:09Z",
      "notes": "Annual grantor. Capital campaign supporter.",
      "isOrganization": true,
      "organizationName": "The Aspen Family Foundation",
      "crmKeyUrls": {},
      "crmKey": "102301",
      "crmSecondKey": null,
      "isTestMode": false,
      "isArchived": false,
      "isGDPRDeleted": false,
      "primaryAddress": {
        "id": 400231,
        "donorId": 202301,
        "isPrimary": true,
        "address1": "100 Foundation Boulevard",
        "address2": "Suite 200",
        "city": "Portland",
        "state": "OR",
        "postal": "97201",
        "countryString": "United States",
        "addressTypeDisplay": "Work"
      },
      "donorAddresses": [],
      "donorEmailAddresses": [],
      "donorPhoneNumbers": []
    }
  ],
  "total": 1284
}

{
  "type": "https://tools.ietf.org/html/rfc7231#section-6.5.1",
  "title": "One or more validation errors occurred.",
  "status": 400,
  "errors": {
    "groups[0].conditions[0].parameter": [
      "'donorEmail' is not a valid parameter for this query type. Call Get Query Options for the parameters this query type supports."
    ]
  },
  "instance": "/api/Donor/query"
}

{
  "type": "https://tools.ietf.org/html/rfc7235#section-3.1",
  "title": "Unauthorized",
  "status": 401,
  "detail": "The Authorization header is missing, malformed, or carries a token that is expired or revoked.",
  "instance": "/api/Donor/query"
}

POST

https://prod-api.raisedonors.com

api

Donor

query

Query Donors

curl --request POST \
  --url https://prod-api.raisedonors.com/api/Donor/query \
  --header 'Authorization: <api-key>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "filter": "<string>",
  "skip": 123,
  "take": 123,
  "sortBy": "createdate",
  "descending": true,
  "includeDetails": true,
  "groups": [
    {
      "conditions": [
        {
          "parameter": "<string>",
          "value": "<string>",
          "secondaryValue": "<string>",
          "values": [
            "<string>"
          ]
        }
      ]
    }
  ],
  "selectedColumns": [
    "<string>"
  ]
}
'

const options = {
  method: 'POST',
  headers: {Authorization: '<api-key>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    filter: '<string>',
    skip: 123,
    take: 123,
    sortBy: 'createdate',
    descending: true,
    includeDetails: true,
    groups: [
      {
        conditions: [
          {
            parameter: '<string>',
            value: '<string>',
            secondaryValue: '<string>',
            values: ['<string>']
          }
        ]
      }
    ],
    selectedColumns: ['<string>']
  })
};

fetch('https://prod-api.raisedonors.com/api/Donor/query', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

import requests

url = "https://prod-api.raisedonors.com/api/Donor/query"

payload = {
    "filter": "<string>",
    "skip": 123,
    "take": 123,
    "sortBy": "createdate",
    "descending": True,
    "includeDetails": True,
    "groups": [{ "conditions": [
                {
                    "parameter": "<string>",
                    "value": "<string>",
                    "secondaryValue": "<string>",
                    "values": ["<string>"]
                }
            ] }],
    "selectedColumns": ["<string>"]
}
headers = {
    "Authorization": "<api-key>",
    "Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

using RestSharp;


var options = new RestClientOptions("https://prod-api.raisedonors.com/api/Donor/query");
var client = new RestClient(options);
var request = new RestRequest("");
request.AddHeader("Authorization", "<api-key>");
request.AddJsonBody("{\n  \"filter\": \"<string>\",\n  \"skip\": 123,\n  \"take\": 123,\n  \"sortBy\": \"createdate\",\n  \"descending\": true,\n  \"includeDetails\": true,\n  \"groups\": [\n    {\n      \"conditions\": [\n        {\n          \"parameter\": \"<string>\",\n          \"value\": \"<string>\",\n          \"secondaryValue\": \"<string>\",\n          \"values\": [\n            \"<string>\"\n          ]\n        }\n      ]\n    }\n  ],\n  \"selectedColumns\": [\n    \"<string>\"\n  ]\n}", false);
var response = await client.PostAsync(request);

Console.WriteLine("{0}", response.Content);

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://prod-api.raisedonors.com/api/Donor/query",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    'filter' => '<string>',
    'skip' => 123,
    'take' => 123,
    'sortBy' => 'createdate',
    'descending' => true,
    'includeDetails' => true,
    'groups' => [
        [
                'conditions' => [
                                [
                                                                'parameter' => '<string>',
                                                                'value' => '<string>',
                                                                'secondaryValue' => '<string>',
                                                                'values' => [
                                                                                                                                '<string>'
                                                                ]
                                ]
                ]
        ]
    ],
    'selectedColumns' => [
        '<string>'
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: <api-key>",
    "Content-Type: application/json"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

HttpResponse<String> response = Unirest.post("https://prod-api.raisedonors.com/api/Donor/query")
  .header("Authorization", "<api-key>")
  .header("Content-Type", "application/json")
  .body("{\n  \"filter\": \"<string>\",\n  \"skip\": 123,\n  \"take\": 123,\n  \"sortBy\": \"createdate\",\n  \"descending\": true,\n  \"includeDetails\": true,\n  \"groups\": [\n    {\n      \"conditions\": [\n        {\n          \"parameter\": \"<string>\",\n          \"value\": \"<string>\",\n          \"secondaryValue\": \"<string>\",\n          \"values\": [\n            \"<string>\"\n          ]\n        }\n      ]\n    }\n  ],\n  \"selectedColumns\": [\n    \"<string>\"\n  ]\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://prod-api.raisedonors.com/api/Donor/query")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["Authorization"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"filter\": \"<string>\",\n  \"skip\": 123,\n  \"take\": 123,\n  \"sortBy\": \"createdate\",\n  \"descending\": true,\n  \"includeDetails\": true,\n  \"groups\": [\n    {\n      \"conditions\": [\n        {\n          \"parameter\": \"<string>\",\n          \"value\": \"<string>\",\n          \"secondaryValue\": \"<string>\",\n          \"values\": [\n            \"<string>\"\n          ]\n        }\n      ]\n    }\n  ],\n  \"selectedColumns\": [\n    \"<string>\"\n  ]\n}"

response = http.request(request)
puts response.read_body

const url = 'https://prod-api.raisedonors.com/api/Donor/query';
const options = {
  method: 'POST',
  headers: {Authorization: '<api-key>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    filter: '<string>',
    skip: 123,
    take: 123,
    sortBy: 'createdate',
    descending: true,
    includeDetails: true,
    groups: [
      {
        conditions: [
          {
            parameter: '<string>',
            value: '<string>',
            secondaryValue: '<string>',
            values: ['<string>']
          }
        ]
      }
    ],
    selectedColumns: ['<string>']
  })
};

fetch(url, options)
  .then(res => res.json())
  .then(json => console.log(json))
  .catch(err => console.error(err));

{
  "items": [
    {
      "id": 200234,
      "name": "Marcus Castellano",
      "title": "Mr.",
      "firstName": "Marcus",
      "middleName": "David",
      "lastName": "Castellano",
      "suffix": null,
      "email": "marcus.castellano@example.org",
      "phone": "(555) 012-3401",
      "createdDate": "2018-09-15T14:22:31Z",
      "modifiedDate": "2025-10-12T09:15:42Z",
      "notes": "Board member. Prefers email for receipts and annual reports.",
      "isOrganization": false,
      "organizationName": null,
      "crmKeyUrls": {
        "VirtuousCRM": {
          "crmKey": "100234",
          "url": "https://app.virtuoussoftware.com/Generosity/Contact/Detail/100234"
        }
      },
      "crmKey": "100234",
      "crmSecondKey": null,
      "isTestMode": false,
      "isArchived": false,
      "isGDPRDeleted": false,
      "primaryAddress": {
        "id": 400101,
        "donorId": 200234,
        "isPrimary": true,
        "address1": "219 Oak Hill Drive",
        "address2": null,
        "city": "Springfield",
        "state": "OR",
        "postal": "97478",
        "countryString": "United States",
        "addressTypeDisplay": "Home"
      },
      "donorAddresses": [
        {
          "id": 400101,
          "donorId": 200234,
          "isPrimary": true,
          "address1": "219 Oak Hill Drive",
          "address2": null,
          "city": "Springfield",
          "state": "OR",
          "postal": "97478",
          "countryString": "United States",
          "addressTypeDisplay": "Home"
        }
      ],
      "donorEmailAddresses": [
        {
          "id": 300101,
          "donorId": 200234,
          "typeDisplay": "Home Email",
          "value": "marcus.castellano@example.org",
          "secondaryValue": null,
          "isPrimary": true,
          "isOptedIn": true,
          "isValid": true,
          "isEmail": true,
          "isPhone": false,
          "isBounced": false,
          "countryCode": null
        }
      ],
      "donorPhoneNumbers": [
        {
          "id": 300102,
          "donorId": 200234,
          "typeDisplay": "Mobile Phone",
          "value": "(555) 012-3401",
          "secondaryValue": null,
          "isPrimary": true,
          "isOptedIn": true,
          "isValid": true,
          "isEmail": false,
          "isPhone": true,
          "isBounced": false,
          "countryCode": "1"
        },
        {
          "id": 300103,
          "donorId": 200234,
          "typeDisplay": "Home Phone",
          "value": "(555) 012-3400",
          "secondaryValue": null,
          "isPrimary": false,
          "isOptedIn": true,
          "isValid": true,
          "isEmail": false,
          "isPhone": true,
          "isBounced": false,
          "countryCode": "1"
        }
      ]
    },
    {
      "id": 200456,
      "name": "Priya Sharma",
      "title": "Ms.",
      "firstName": "Priya",
      "middleName": null,
      "lastName": "Sharma",
      "suffix": null,
      "email": "priya.sharma@example.org",
      "phone": "(555) 012-3450",
      "createdDate": "2023-02-15T10:30:00Z",
      "modifiedDate": "2025-11-15T03:00:00Z",
      "notes": "Monthly donor since February 2023. Volunteer organizer.",
      "isOrganization": false,
      "organizationName": null,
      "crmKeyUrls": {
        "VirtuousCRM": {
          "crmKey": "100456",
          "url": "https://app.virtuoussoftware.com/Generosity/Contact/Detail/100456"
        }
      },
      "crmKey": "100456",
      "crmSecondKey": null,
      "isTestMode": false,
      "isArchived": false,
      "isGDPRDeleted": false,
      "primaryAddress": {
        "id": 400156,
        "donorId": 200456,
        "isPrimary": true,
        "address1": "1542 Elmwood Lane",
        "address2": null,
        "city": "Springfield",
        "state": "OR",
        "postal": "97477",
        "countryString": "United States",
        "addressTypeDisplay": "Home"
      },
      "donorAddresses": [
        {
          "id": 400156,
          "donorId": 200456,
          "isPrimary": true,
          "address1": "1542 Elmwood Lane",
          "address2": null,
          "city": "Springfield",
          "state": "OR",
          "postal": "97477",
          "countryString": "United States",
          "addressTypeDisplay": "Home"
        }
      ],
      "donorEmailAddresses": [
        {
          "id": 300156,
          "donorId": 200456,
          "typeDisplay": "Home Email",
          "value": "priya.sharma@example.org",
          "secondaryValue": null,
          "isPrimary": true,
          "isOptedIn": true,
          "isValid": true,
          "isEmail": true,
          "isPhone": false,
          "isBounced": false,
          "countryCode": null
        }
      ],
      "donorPhoneNumbers": [
        {
          "id": 300157,
          "donorId": 200456,
          "typeDisplay": "Mobile Phone",
          "value": "(555) 012-3450",
          "secondaryValue": null,
          "isPrimary": true,
          "isOptedIn": true,
          "isValid": true,
          "isEmail": false,
          "isPhone": true,
          "isBounced": false,
          "countryCode": "1"
        }
      ]
    },
    {
      "id": 202301,
      "name": "The Aspen Family Foundation",
      "title": null,
      "firstName": null,
      "middleName": null,
      "lastName": null,
      "suffix": null,
      "email": "grants@aspenfoundation.example.org",
      "phone": "(555) 012-3800",
      "createdDate": "2023-06-15T11:05:00Z",
      "modifiedDate": "2025-06-20T16:41:09Z",
      "notes": "Annual grantor. Capital campaign supporter.",
      "isOrganization": true,
      "organizationName": "The Aspen Family Foundation",
      "crmKeyUrls": {},
      "crmKey": "102301",
      "crmSecondKey": null,
      "isTestMode": false,
      "isArchived": false,
      "isGDPRDeleted": false,
      "primaryAddress": {
        "id": 400231,
        "donorId": 202301,
        "isPrimary": true,
        "address1": "100 Foundation Boulevard",
        "address2": "Suite 200",
        "city": "Portland",
        "state": "OR",
        "postal": "97201",
        "countryString": "United States",
        "addressTypeDisplay": "Work"
      },
      "donorAddresses": [],
      "donorEmailAddresses": [],
      "donorPhoneNumbers": []
    }
  ],
  "total": 1284
}

{
  "type": "https://tools.ietf.org/html/rfc7231#section-6.5.1",
  "title": "One or more validation errors occurred.",
  "status": 400,
  "errors": {
    "groups[0].conditions[0].parameter": [
      "'donorEmail' is not a valid parameter for this query type. Call Get Query Options for the parameters this query type supports."
    ]
  },
  "instance": "/api/Donor/query"
}

{
  "type": "https://tools.ietf.org/html/rfc7235#section-3.1",
  "title": "Unauthorized",
  "status": 401,
  "detail": "The Authorization header is missing, malformed, or carries a token that is expired or revoked.",
  "instance": "/api/Donor/query"
}

Call Get Query Options for the Donor query type to discover the parameters, operators, and result fields available, then send one or more groups of conditions here along with selectedColumns and your paging options.

Setting includeDetails=true adds each donor’s related records (addresses and contact methods), the same as Get a Donor returns, and may slow down large result sets.

Authorizations

Authorization

string

header

required

JWT Authorization header using the Bearer scheme. Example: "Authorization: Bearer {token}"

Body

The donor query request, including structured groups/conditions, selectedColumns, includeDetails, and paging options.

Option 1
Option 2

Request body for advanced query endpoints such as donor and campaign queries.

filter

string | null

A free-text search term applied to the results.

skip

integer<int32>

The number of records to skip before the first record returned. Use it with take to page through the results.

take

integer<int32>

The maximum number of records to return in this page of results.

sortBy

enum<string> | null

Field to sort by (case-insensitive). Valid options: createdate, createddatetime, email, firstname, gifts, giftsum, id, lastname, modifieddatetimeutc, name, phone

Available options:

createdate,

createddatetime,

email,

firstname,

gifts,

giftsum,

id,

lastname,

modifieddatetimeutc,

name,

phone

Example:

"createdate"

descending

boolean

The direction to sort the results. Set to true to sort in descending order.

includeDetails

boolean

When true, includes the related records for each item in the response. Not every list has extra records to return, and it can slow down large result sets.

queryType

enum<integer>

The logical type of query being executed.

Available options:

0,

1,

2,

3,

4,

5,

6,

7,

8,

9

groups

object[] | null

The groups of conditions that make up the query.

Show child attributes

selectedColumns

string[] | null

The list of result columns to return for each item.

Response

A page of donors with the total number that match the request.

items

object[]

The donors in this page of results.

Show child attributes

total

integer<int32>

The total number of donors that match the request. Use it with skip and take to page through the full set.

Last modified on July 28, 2026

⌘I

Activity

Campaign

CustomField

Donor

EmailList

Gift

MotivationCode

OrgKnowledge

Premium

Project

Query

Raise

RecurringGift

Segment

Webhook

Zapier

Authorizations

Body

Response