Page tree

Formal Definition and Version

Formal definition for Web service: wsca

Version: 2.0

Using the Access ACS Web Services API

Before you begin using the Access ACS Web Services API, make sure you have a read and completed all the steps on the Getting Started page.

Creating a Token

  • getLoginToken — **This is the first call into the Web services. The return value is used as the token in all other calls.  This requires your secid and ACS site id. Please note, if your siteid has a leading 0 or W, do not include it when passing in the site id value.

    Return to top

     

 

Login

  • validateAccessACSLogin — validateAccessACSLogin(string token, string username, string password). This calls validates entry for an individual user in to our system. This is how you would validate the user name and password if you are trying to use a universal login for a 3rd party application.

Changing Profile Data/ Sending Data Back to Access ACS

Please note that all data changes are approved as part of the standard change request system and not automatically applied to the database.

  • peAddIndividual — Add an individual to the change request log. Member Status = member|prospect.
  • peAddUpdateAddress — Add and edit street addresses. To add an address, pass in -1 for the addressid. To update an address, pass in a valid addressid. For a family address, set sharedflag = Y.
  • peAddUpdateEmailAddress — Add and edit email addresses. To add an e-mail address, pass in -1. To update an e-mail address, pass in a valid emailid.
  • peAddUpdatePhone — Add and edit phone numbers. To add a phone number, pass in -1. To update a phone number, pass in a valid phoneid.
  • peDeleteEmailAddress — Delete email addresses. Pass in a valid emailid to delete.
  • peUpdateNewsletterFlag — Update of the newsletter flag. Valid flags are 0=>None, 1=>IndivMail, 2=>IndivEmail, 3=>IndivBoth, 4=>FamMail, 5=>FamEmail, 6=>FamBoth.
  • peUpdateOpenCategory — Update an open description. This requires the id of the description, not the text. Pass an id of 0 for null.
  • peUpdateOpenDate — Update an open date (1 - 6) to a new date. The time piece of the date is ignored (ie, set to 00:00:00 pm). Pass in the date 12/31/1899 to set the date to null.
  • peUpdateOpenField — Update an open field. Field text is limited to 20 characters. Pass in the text "null" (lowercase) to set the field to null.

    Return to top

     

 

Activities

  • grAddPersonToActivity — Add an individual into an activity list.
  • grGetActivityRoster — Retrieves who is in the roster for a category within an activity. Input the token, categoryid, and effectivedate. The date is needed to obtain the roster on a particular day due to the changes in rosters and the available history.
  • grGetCategoryElements — Retrieves the activity elements available within a group. Valid element numbers are 1-4.
  • grGetGroupCategories — Retrieves the master activity categories.
  • grGetMasterGroups — Retrieves the master groups under activities.

    Return to top

     

 

Class Calls

  • clsAddPersonToClass — Adds an individual to the class list.
  • clsGetClassClasses — Retrieves a listing of classes under a department.
  • clsGetClassCodes — Retrieves the individual class codes.
  • clsGetClassDepartments — Retrieves a listing of departments under a division.
  • clsGetClassDivisions — Retrieves the topmost class divisions.
  • clsGetClassRoster — Retrieves the roster for a class. Input the token, groupid, and effectivedate. The date is needed to obtain the roster on a particular day due to the changes in rosters and the available history.
  • clsGetClassStatuses — Retrieves the status of all classes. For status_descr_1 pass in 1. For status_descr_2 pass in 2. For neither, pass in -1.
  • clsGetMasterClasses — Retrieves the group id and descriptions for the master classes.
  • clsGetPositions — Retrieves the positions within a class.

    Return to top

     

 

Event Registration Calls

The event registration calls can be used to pull information about events such as contacts info, sub-events info, registration periods, rules, and costs. Use these calls to pull information to show event data dynamically on your website.

  • getEventData — Dataset getEventData (string token, int eventid, DateTime, startDate). Returns event calendars.
    • Format the data as <startDate>2010-08-15T00:00:00</startDate><stopDate>2010-08-21T00:00:00</stopDate>
  • GetEventRegistrationById — Retrieves event registration by solutioneventid. You can pass in an array of solution ids. This id is what ties an Event Registration to a Facility Scheduler event. The solutioneventid can be retrieved from the getBookedResources call.

    The getBookedResources call is part of the Event API.

  • getEventRegistrationByDate — Retrieves all event registrations by passing in a date range.
  • GetEventSections — Retrieves a list of events and related sub events.
  • GetEventRegistrationPricing — Retrieves pricing for the list of events and related sub events.
  • getEventRegistrationRules — Retrieves rules for each section of the event.

    Return to top

     

 

People Data

 

Pictures

 

Searching/Filtering for Individuals

 

Serving

The Serving Api calls are divided into two parts:

  • serving opportunities
  • attributes for the serving position

    Wording Changes

    Some wording changes have been made in Access ACS since the infostructure was originally built out.

    • Need = Opportunity
    • Volunteer = Serving.
      For frequency, -1 = one time, 0 = weekly, 1 = 2 weeks, 2 = monthly, 3 = two months.

    Return to top

     

 

The following Serving API calls pull Serving Positions and Opportunities:

  • vmGetServOpportunities — Pulls a list of serving opportunities. Pass in desired fields and ability to filter on OpportunityID. Fields are Opportunity ID, Opportunity Name, Opportunity Description, Opportunity Address Line 1, Opportunity Address Line 2, Opportunity City, Opportunity State, Opportunity ZIP, Opportunity Contact, Opportunity Contact Method, Opportunity Close Date, Opportunity flag to allow members to volunteer for this opportunity, and Opportunity flag for Childcare Provided
  • vmGetPositions  — Pulls a list of all positions from Small Groups and Volunteers. Ability to filter on VolNeeds. Position ID, Opportunity Position Name, Opportunity Position Description, Active, Leadership, Small Group, VolNeeds.
  • vmGetPositionOpportunities — Displays the link between Position Name and Serving Opportunities. It also provides information about when the position serving times are needed. PostionNeedID, NeedID, PositionID, Opportunity Alternate Position Name, Opportunity Position Number Requested, Opportunity Position Urgent Flag, Opportunity Position Sampling Flag, Opportunity Position Featured Flag, Opportunity Position Start Date, Opportunity Position End Date, Opportunity Position Frequency, Opportunity Position Days of the week, Opportunity Position One Day per Month, Opportunity Position Week of the Month, Opportunity Position Weekday of Month

The following Serving API calls pull attribute information for Serving Positions:

 

Small Groups

These calls can be used in conjunction with each other to retrieve group information and rosters. To create your own custom reports or to create your own small group Web pages, use these calls.

  • sgGetCatNames — Pulls small groups category names and category IDs.
  • sgGetCategoryPhraseLists — Pulls a list of items entered in to each of the small group categories. To view each item list for each category, pass in 1 - 5.
  • sgGetGroupKeywords — Pulls a list of keywords entered for a particular group.
  • sgGetGroupList — Pulls a list of all small groups. To view a full list, pass in * for fieldlist and -1 for groupids.
  • sgGetMasterKeywordList — Pulls a list of all of the key phrases entered in to small groups.
  • sgGetMeetinginfo - With the update of Small Groups in August 2011, this makes it easier to obtain information about the Small Group details.
  • sgGetMeetingTimes — Small Group meeting times. Pass in a groupid of -1 for all groups.
  • sgGetRoster — Pulls the list of individuals in a small group roster.  Pass in a groupid value from the sgGetGroupList call.

    Return to top

     

 

Statistical Data

  • getContribDataStats - DataSet getContribDataStats(string token, DateTime fromdate, DateTime todate) Returns contribution data on a weekly basis between certain dates
  • getStatContribYTD - DataSet getStatContribYTD(string token, DateTime dt) Returns contribution data for ytd regardless of month and day entered.
  • getStatAges — DataSet getStatAges(string token). Returns age breakdown.
  • getStatAttendanceByDate — DataSet getStatAttendanceByDate(string token, int groupid, DateTime, attenddate). Returns statistical attendance information broken down by date.
  • getStatAttendanceGroupsList — DataSet getStatAttendanceGroupsList(string token). Returns statistical attendance information broken down by group.
  • getStatContribWeeklyDeprecated as of May 1, 2011. Use instead getContribDataStats & getStatContribYTD.
  • getStatContribWeeklyDateDeprecated as of May 1, 2011. Use instead getContribDataStats & getStatContribYTD.
  • getStatData — Returns user defined data values. 1=recordcount; 2=member status; 3=marital status; 4=family position; 5=joined how; 6+=user defined.
  • getStatFamilyPosition — DataSet getStatFamilyPosition(string token) Statistical breakdown of family positions.
  • getStatJoinedHow — DataSet getStatJoinedHow(string token). Statistical breakdown of how people have joined.
  • getStatMaritalStatus — DataSet getStatMaritalStatus(string token). Statistical breakdown of marital status.
  • getStatMemberStats — DataSet getStatMemberStats(string token). Statistical breakdown of members.
  • getStatMemberStatus — DataSet getStatMemberStatus(string token). Statistical breakdown of member status.
  • getStatStaticTypes — DataSet getStatStaticTypes(string token). Returns statistical attendance information broken down by predefined static types within the system.

    Return to top

     

 

Volunteer Management

 

Others

Note

An "open" field is a User Defined Field from the People Suite.