getTeamraisersByInfo

Returns a list of TeamRaiser events that match the search criteria provided. Search criteria includes the TeamRaiser's Public Event Name; the Event Information fields of: City, County, and State; Event Security Category; and Primary Event Type.

Client Servlet Server Servlet HTTP Methods Supported Requires Authentication
CRTeamraiserAPI None. GET, POST No.

Client API Syntax

https://secure2.convio.net/organization/site/CRTeamraiserAPI?method=getTeamraisersByInfo &api_key=value &v=value [ &center_id=value ] [ &error_redirect=value ] [ &redirect=value ] [ &response_format=xml | json ] [ &sign_redirects=value ] [ &source=value ] [ &sub_source=value ] [ &success_redirect=value ] [ &suppress_response_codes=value ] &name=value [ &city=value ] [ &country=value ] [ &county=value ] [ &event_type=value ] [ &full_search=value ] [ &list_ascending=value ] [ &list_category_id=value ] [ &list_filter_column=value ] [ &list_filter_text=value ] [ &list_page_offset=value ] [ &list_page_size=value ] [ &list_record_offset=value ] [ &list_sort_column=value ] [ &public_event_type=value ] [ &state=value ]

Usage Notes

This client-only method returns a list of active TeamRaiser Events located based off criteria that matches the Event's Public Name and/or the Event's Location Information.

Note: An Active event is an event that is Accepting Gifts, Accepting Registrations, or Accepting Gifts and Registrations.

Use this method when you want to provide your users the ability to locate events that they may already be familiar with by name, or to find events in the geographical area of their choice.

Note: When searching on the event information, the search is a like search, and is case insensitive (except for state which is an exact, case insensitive match of the state's or province's two letter abbreviation or "None"). A search for name=walk will return all events that have the word "walk" in their name, such as the events "Walk Against Hunger" or "Survivors walking out".

When using this method, you must provide a value for at least 1 of the following parameters: name, city, county, or state. Each paramter is individually optional, but at least one of them must provide some data for the system to search on. If you do not provide a value to search on for one of those parameters, you will receive an error.

This method shares several features with getTeamraisersByDistance, including the ability to limit the search to TeamRaiser Events within a given Security Category or Primary Event Type. To limit the search to a given Security Category, use the list_category_id to provide the Category ID to limit the search to. To limit the search to a given Primary Event Type, use the event_type parameter to specify the name of the Primary Event Type. If you provide the name of a Primary Event Type that does not exist, an error message will be thrown.

You can use these parameters to limit the search in ways that your users may not be familiar with. One example would be that if your organization has several chapters, divisions or affiliates and each wants their own search page to locate only their events. You can include the security category ID for that affiliate as a hidden form field to ensure that the search returns only events within that affiliate's category. If you have separate programs within each affiliate and want each program to have it's own search page, include the primary event type that identifies that program and the security category id for that affiliate.

Additionally, the list that is returned supports several parameters allowing finer control of the results, including filtering on any of the returned elements, pagination, and sorting.

Paginating the List takes two parameters: list_page_size, which specifies the number of results to be retrieved for that page. You must also provide one of the following two parameters:
  • list_page_offset: specifies which page of the results to retrieve. The first page of results has a list_page_offset of 0, page 2 has a list_page_offset of 1, and so on.
  • list_record_offset: specifies which record the page should start with. This also uses numbering from 0, so the first record has a list_record_offset of 0, the 2nd record has a list_record_offset of 1, and so on.
Filtering the List takes two parameters:
  • list_filter_column: name of the element to be filtered on.
  • list_filter_text: text that the element specified by list_filter_column must contain.
Note: list_filter_text performs an exact match, and is case sensitive.
Sorting the List takes two parameters:
  • list_sort_column: name of the element to be sorted by.
  • list_ascending: Boolean value indicating whether the sort should be in ascending order
Note: You can paginate, filter, and sort the list all in one call.

Client API Parameters

Common Client Parameters

See topic Common Parameters.

name

Required. The name of the TeamRaiser event.

Type xsd:string.

city

Optional. The city the event takes place in, as configured in the Event's Location Details.

Type xsd:string.

country

Optional. The country the event takes place in, as configured in the Event's Location Details.

Type xsd:string.

county

Optional. The county the event takes place in, as configured in the Event's Location Details.

Type xsd:string.

event_type

Optional. The name of the Primary Event Type to limit search results to. Omit this parameter to search on all Primary Event Types. Defaults to null.

Type xsd:string.

full_search

Optional. If TRUE, returns all events regardless of event status, otherwise returns only published events. Possible status values include: Unpublished = 0, Accepting Registrations Only = 1, AcceptingRegistrations and Gifts = 2, Accepting Gifts Only= 3, Closed = 4, Archived = 8, Deleted = 9.

Type xsd:boolean.

list_ascending

Optional. Whether the list should be sorted in ascending order.

Type xsd:boolean.

Default is true.

list_category_id

Optional. Security Category filter.

Type xsd:integer.

list_filter_column

Optional. The database column that will be used to match the filter text (used with "list_filter_text").

Type xsd:string.

list_filter_text

Optional. The text that will be used to filter results.

Type xsd:string.

list_page_offset

Optional. The requested page number (used with "list_page_size"). The first page (default) is zero. Only one of "list_record_offset" or "list_page_offset" should be used in a request.

Type xsd:integer.

list_page_size

Optional. The number of results in each page (used with "list_record_offset" or "list_page_offset").

Type xsd:integer.

Default is 25.

list_record_offset

Optional. The requested initial record number (used with "list_page_size"). The first record (default) is zero. Only one of "list_record_offset" or "list_page_offset" should be used in a request.

Type xsd:integer.

list_sort_column

Optional. The column to sort with (used with "list_ascending").

Type xsd:string.

public_event_type

Optional. The case-sensitive name of the Public Event Type to limit search results to. Omit this parameter to search on events with any Public Event Type. Defaults to null.

Type xsd:string.

state

Optional. The state the event takes place in, as configured in the Event's Location Details.

Type xsd:string.

Response

See topic HTTP Status Codes.

XML response
<?xml version="1.0" encoding="UTF-8"?>
<getTeamraisersResponse xsi:schemaLocation="http://convio.com/crm/v1.0 http://service.convio.net/xmlschema/crm.public.v1.xsd" xmlns="http://convio.com/crm/v1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <totalNumberResults>3</totalNumberResults>
  <teamraiser>
    <id>12000</id>
    <name>Sample Event Title 0</name>
    <description>Sample Event Description 0</description>
    <event_date>2016-02-01T09:43:42.078-06:00</event_date>
    <accepting_registrations>true</accepting_registrations>
    <accepting_donations>true</accepting_donations>
    <location_name>Sample Location 0</location_name>
    <street_address>1234 Fake St.</street_address>
    <city>Austin</city>
    <state>TX</state>
    <zip>78758</zip>
    <county>Travis</county>
    <country>United States</country>
    <region>Hill Country</region>
    <area>North Austin</area>
    <mailingAddrAttn>J. Doe</mailingAddrAttn>
    <mail_street1>1234 Fake Ave.</mail_street1>
    <mail_street2>Suite 1000</mail_street2>
    <mail_city>Austin</mail_city>
    <mail_state>TX</mail_state>
    <mail_zip>78758</mail_zip>
    <status>1</status>
    <greeting_url>http://example.com/greetingUrl</greeting_url>
    <find_url>http://example.com/findTeamOrParticipantUrl</find_url>
    <donate_event_url>http://example.com/donateUrl</donate_event_url>
    <reg_indiv_url>http://example.com/registerIndividualUrl</reg_indiv_url>
    <reg_new_team_url>http://example.com/formANewTeamUrl</reg_new_team_url>
    <reg_join_team_url>http://example.com/joinTeamUrl</reg_join_team_url>
    <public_event_type_name>Central Texas</public_event_type_name>
    <ecommerce_event_url>http://example.com/eCommerceEventUrl</ecommerce_event_url>
    <customized_url>http://example.com/customizedUrl</customized_url>
  </teamraiser>
  <teamraiser>
    <id>12001</id>
    <name>Sample Event Title 1</name>
    <description>Sample Event Description 1</description>
    <event_date>2016-02-01T09:43:42.080-06:00</event_date>
    <accepting_registrations>true</accepting_registrations>
    <accepting_donations>true</accepting_donations>
    <location_name>Sample Location 1</location_name>
    <street_address>1234 Fake St.</street_address>
    <city>Austin</city>
    <state>TX</state>
    <zip>78758</zip>
    <county>Travis</county>
    <country>United States</country>
    <region>Hill Country</region>
    <area>North Austin</area>
    <mailingAddrAttn>J. Doe</mailingAddrAttn>
    <mail_street1>1234 Fake Ave.</mail_street1>
    <mail_street2>Suite 1000</mail_street2>
    <mail_city>Austin</mail_city>
    <mail_state>TX</mail_state>
    <mail_zip>78758</mail_zip>
    <status>1</status>
    <greeting_url>http://example.com/greetingUrl</greeting_url>
    <find_url>http://example.com/findTeamOrParticipantUrl</find_url>
    <donate_event_url>http://example.com/donateUrl</donate_event_url>
    <reg_indiv_url>http://example.com/registerIndividualUrl</reg_indiv_url>
    <reg_new_team_url>http://example.com/formANewTeamUrl</reg_new_team_url>
    <reg_join_team_url>http://example.com/joinTeamUrl</reg_join_team_url>
    <public_event_type_name>Central Texas</public_event_type_name>
    <ecommerce_event_url>http://example.com/eCommerceEventUrl</ecommerce_event_url>
    <customized_url>http://example.com/customizedUrl</customized_url>
  </teamraiser>
  <teamraiser>
    <id>12002</id>
    <name>Sample Event Title 2</name>
    <description>Sample Event Description 2</description>
    <event_date>2016-02-01T09:43:42.081-06:00</event_date>
    <accepting_registrations>true</accepting_registrations>
    <accepting_donations>true</accepting_donations>
    <location_name>Sample Location 2</location_name>
    <street_address>1234 Fake St.</street_address>
    <city>Austin</city>
    <state>TX</state>
    <zip>78758</zip>
    <county>Travis</county>
    <country>United States</country>
    <region>Hill Country</region>
    <area>North Austin</area>
    <mailingAddrAttn>J. Doe</mailingAddrAttn>
    <mail_street1>1234 Fake Ave.</mail_street1>
    <mail_street2>Suite 1000</mail_street2>
    <mail_city>Austin</mail_city>
    <mail_state>TX</mail_state>
    <mail_zip>78758</mail_zip>
    <status>1</status>
    <greeting_url>http://example.com/greetingUrl</greeting_url>
    <find_url>http://example.com/findTeamOrParticipantUrl</find_url>
    <donate_event_url>http://example.com/donateUrl</donate_event_url>
    <reg_indiv_url>http://example.com/registerIndividualUrl</reg_indiv_url>
    <reg_new_team_url>http://example.com/formANewTeamUrl</reg_new_team_url>
    <reg_join_team_url>http://example.com/joinTeamUrl</reg_join_team_url>
    <public_event_type_name>Central Texas</public_event_type_name>
    <ecommerce_event_url>http://example.com/eCommerceEventUrl</ecommerce_event_url>
    <customized_url>http://example.com/customizedUrl</customized_url>
  </teamraiser>
</getTeamraisersResponse>

        
JSON response
{"getTeamraisersResponse":{"teamraiser":[{"region":"Hill Country","state":"TX","city":"Austin","id":"12000","reg_new_team_url":"http://example.com/formANewTeamUrl","mail_state":"TX","area":"North Austin","description":"Sample Event Description 0","name":"Sample Event Title 0","mail_city":"Austin","reg_indiv_url":"http://example.com/registerIndividualUrl","ecommerce_event_url":"http://example.com/eCommerceEventUrl","public_event_type_name":"Central Texas","zip":"78758","reg_join_team_url":"http://example.com/joinTeamUrl","location_name":"Sample Location 0","status":"1","customized_url":"http://example.com/customizedUrl","find_url":"http://example.com/findTeamOrParticipantUrl","country":"United States","accepting_donations":"true","donate_event_url":"http://example.com/donateUrl","greeting_url":"http://example.com/greetingUrl","county":"Travis","event_date":"2016-02-01T09:43:42.089-06:00","mail_zip":"78758","mailingAddrAttn":"J. Doe","street_address":"1234 Fake St.","accepting_registrations":"true","mail_street1":"1234 Fake Ave.","mail_street2":"Suite 1000"},{"region":"Hill Country","state":"TX","city":"Austin","id":"12001","reg_new_team_url":"http://example.com/formANewTeamUrl","mail_state":"TX","area":"North Austin","description":"Sample Event Description 1","name":"Sample Event Title 1","mail_city":"Austin","reg_indiv_url":"http://example.com/registerIndividualUrl","ecommerce_event_url":"http://example.com/eCommerceEventUrl","public_event_type_name":"Central Texas","zip":"78758","reg_join_team_url":"http://example.com/joinTeamUrl","location_name":"Sample Location 1","status":"1","customized_url":"http://example.com/customizedUrl","find_url":"http://example.com/findTeamOrParticipantUrl","country":"United States","accepting_donations":"true","donate_event_url":"http://example.com/donateUrl","greeting_url":"http://example.com/greetingUrl","county":"Travis","event_date":"2016-02-01T09:43:42.090-06:00","mail_zip":"78758","mailingAddrAttn":"J. Doe","street_address":"1234 Fake St.","accepting_registrations":"true","mail_street1":"1234 Fake Ave.","mail_street2":"Suite 1000"},{"region":"Hill Country","state":"TX","city":"Austin","id":"12002","reg_new_team_url":"http://example.com/formANewTeamUrl","mail_state":"TX","area":"North Austin","description":"Sample Event Description 2","name":"Sample Event Title 2","mail_city":"Austin","reg_indiv_url":"http://example.com/registerIndividualUrl","ecommerce_event_url":"http://example.com/eCommerceEventUrl","public_event_type_name":"Central Texas","zip":"78758","reg_join_team_url":"http://example.com/joinTeamUrl","location_name":"Sample Location 2","status":"1","customized_url":"http://example.com/customizedUrl","find_url":"http://example.com/findTeamOrParticipantUrl","country":"United States","accepting_donations":"true","donate_event_url":"http://example.com/donateUrl","greeting_url":"http://example.com/greetingUrl","county":"Travis","event_date":"2016-02-01T09:43:42.091-06:00","mail_zip":"78758","mailingAddrAttn":"J. Doe","street_address":"1234 Fake St.","accepting_registrations":"true","mail_street1":"1234 Fake Ave.","mail_street2":"Suite 1000"}],"totalNumberResults":"3"}}

        

Examples

To perform an Information search looking for events with "fest" in their Name:

https://demo-secure.convio.net/demo829/site/CRTeamraiserAPI?api_key=MyAPIKey&v=1.0&method=getTeamraisersByInfo&name=fest

Same as above, but limiting the search to events with a Primary Event Type of "Walks", and only retrieving the first page of results, displaying 10 results per page:

https://demo-secure.convio.net/demo829/site/CRTeamraiserAPI?api_key=MyAPIKey&v=1.0&method=getTeamraisersByInfo&name=fest&event_type=Walks&list_page_size=10&list_page_offset=0

Same as above, but sorting the results by event date:

https://demo-secure.convio.net/demo829/site/CRTeamraiserAPI?api_key=MyAPIKey&v=1.0&method=getTeamraisersByInfo&name=fest&event_type=Walks&list_page_size=10&list_page_offset=0&list_ascending=true&list_sort_column=event_date

Retrieving Page 2 of the above query:

https://demo-secure.convio.net/demo829/site/CRTeamraiserAPI?api_key=MyAPIKey&v=1.0&method=getTeamraisersByInfo&name=fest&event_type=Walks&list_page_size=10&list_page_offset=1&list_ascending=true&list_sort_column=event_date

An Event Information search for events in the state of New York, with the name of "Funwalk", in Oneida county, limited only to events within the Security Category with the id=1020:

https://demo-secure.convio.net/demo829/site/CRTeamraiserAPI?api_key=MyAPIKey&v=1.0&method=getTeamraisersByInfo&name=Funwalk&state=NY&county=oneida&list_category_id=1020

Same as above, but selecting 20 results per page starting with result #5, sorting by name in descending order, filtered to events with an area of Capitol Hill:

https://demo-secure.convio.net/demo829/site/CRTeamraiserAPI?api_key=MyAPIKey&v=1.0&method=getTeamraisersByInfo&name=Funwalk&state=NY&county=oneida&list_category_id=1020&list_page_size=20&list_record_offset=5&list_filter_column=area&list_filter_text=Capitol%20Hill&list_sort_column=name&list_ascending=false

Leave a Comment

Nickname
Comment
Enter this word: