You are here: HTTP Services > Get Member List

Get Member List

Summary

This service will return details for selected members for a particular club in ABC's club management system. This member information includes items such as name, address, membership type, agreement details, and last check in time.

Service Name getMemberList
Service Type HTTP
Invoked by HTTPS GET Request
Returns HTTPS Response
URL Format

[server]/ws/getMemberList/[club-number]

Required Parameters All parameters are optional

 

Parameters

The web service has no required parameters. You may use one of these optional parameters to specify members as individuals or by status:

When you do not specify a parameter, the web service returns a list of all members, regardless of status.

 

Selecting the time range

 

All date range parameters for this service are optional. These can be used to limit the response set to include members with a contract date or converted date that falls in the selected time range.

 

Note: The member's contract date can be altered. Therefore, the same member might be retrieved by two separate, non-overlapping date ranges.
In some cases, the contract date may be a future value for clubs in presale mode.

 

Time Zones and Time Stamps

The updateStartTime and updateEndTime request parameters are assumed to be in the club's time zone. The member update timestamp is saved as a value in Central Time Zone. Responses for clubs in other time zones include a memberUpdateTimestamp relating to Central Time.
In the example below, the mismatch between timestamps is due to the fact that the lastCheckInTimestamp is saved as Eastern Time (where the club is located), while memberUpdateTimestamp is saved in Central Time.

<lastCheckInTimestamp>2014-10-1 14:11:27.000000</lastCheckInTimestamp> <totalCheckInCount>7</totalCheckInCount>
<memberUpdateTimestamp>2014-10-19 13:11:27.235180</memberUpdateTimestamp>

 

Contract Date and Converted Date

This service returns a response that includes the tag <contractDate>. For a member, this indicates when they joined the club. For a prospect, this indicates when they were created in the system. The <convertedDate> tag indicates when a prospect converted to member status.

Note: Use contractDate to determine when a member joined a club.
Use convertedDate to determine when a prospect became a member.

contractStartTime

Optional. This parameter is used to define the beginning of the contract date range. This will return both inactive and active members, unless memberStatus is otherwise specified. When specifying the contractStartTime, use the criteria outlined in simple datetime.

 

Use the following criteria when specifying contractStartTime:

 

contractEndTime

Optional. This parameter is used to define the end of the contract date range. This will return both inactive and active members, unless memberStatus is otherwise specified. When specifying contractEndTime, use the criteria outlined in simple datetime.

 

Use the following criteria when specifying contractEndTime:

 

convertedStartTime

Optional. This parameter is used to define the beginning of the converted date range. When specifying the convertedStartTime, use the criteria outlined in simple datetime.

 

Use the following criteria when specifying convertedStartTime:

 

 

convertedEndTime

Optional. This parameter is used to define the end of the converted date range. When specifying the convertedEndTime, use the criteria outlined in simple datetime.

 

Use the following criteria when specifying convertedEndTime:

 

 

createStartTime

Optional. This parameter is used to define the beginning of the time range in which the agreement was created.

 

Use the following criteria when specifying createStartTime:

 

createEndTime

Optional. This parameter is used to define the end of the time range in which the agreement was created.

 

Use the following criteria when specifying createStartTime:

 

 

signStartTime

Optional. This parameter is used to define the beginning of the time range in which the agreement was signed.

 

Use the following criteria when specifying signStartTime:

 

signEndTime

Optional. This parameter is used to define the end of the time range in which the agreement was signed.

 

Use the following criteria when specifying signStartTime:

 

updateStartTime

Optional. This parameter is used to define the beginning of the date range in which member information was updated (designated with the memberUpdateTimestamp tag). This will return both inactive and active members, unless memberStatus is otherwise specified. When specifying the updateStartTime, use the criteria outlined in simple datetime.

 

Note: See the values that will cause memberUpdateTimeStamp to change. Not all changes will be returned in the web service.

 

Use the following criteria when specifying updateStartTime:

 

updateEndTime

Optional. This parameter is used to define the end of the date range in which member information was updated (designated with the memberUpdateTimestamp tag). This will return both inactive and active members, unless memberStatus is otherwise specified. When specifying the updateEndTime, use the criteria outlined in simple datetime.

 

Note: See the values that will cause memberUpdateTimeStamp to change. Not all changes will be returned in the web service.

 

Use the following criteria when specifying updateEndTime:

 

 

 

 

memberStatus

Optional. The memberStatus parameter allows you to specify whether you want active members, inactive members, or all members. Using the prospect setting (memberStatus=prospect) will return only members with the agreement number "PROSP". Prospects can also be found by using the "inactive" or "all" setting, but they will not be separated from other inactive members.

URL Format

[server\]/ws/getMemberList/[club-number]?memberStatus=[status]

Valid Settings
  • active
  • inactive
  • all
  • prospect

agreementNumber

Optional. This is the five-digit agreement number. It does not include the first four digits that define the club number.

 

memberId

Optional. The memberId uniquely identifies a member within a particular club. ABC assigns memberIds in the form of a GUID.

URL Format

[server\]/ws/getMemberList/[club-number]?memberId=[id]

 

barcode

Optional. Clubs assign barcode values to members.

URL Format

[server\]/ws/getMemberList/[club-number]?barcode=[barcode]

 

Response Data

The Response is a standard HTTPS GET Request object containing a message in XML. The XML message contains three sections:

The root tag is getMemberList.

Status Section

This section describes the overall status of the request. The Status Section's tag name is <status>. The <status> tag contains the following tags:

Tag Name Format Description
response string, up to 50 characters

Contains a value indicating the overall status of the request. The overall status will be one of three values:

  • completed: The service completed successfully. Check ins may or may not have been returned.
  • usageError: Required Request parameters did not pass validation, and no check ins were returned.
  • internalError: System exceptions occurred while executing the web service, and no check ins were returned.
message string, up to 125 characters

Provides a more specific description of the result value. Each message tag includes an attribute. The id attribute is assigned to a unique id.

Example tags and values include:

<message id="0">Service completed successfully</message>

membersReturned integer

Contains a value corresponding to the number of members returned in the response. If the service returns no members, then the value is zero.

Example tag with value:

<membersReturned>5574</membersReturned>

Request Section

This section lists what the original request contained. The Request section's tag name is request.

Tags included in the request tag include:

Tag Name Format Description
clubNumber #### The club number specified in the request URL.
memberStatus string Omitted if parameter was not used in the URL.
Contains the value for the parameter, if used.
memberId GUID Omitted if parameter was not used in the URL.
Contains the value for the parameter, if used.
barcode barcode Omitted if parameter was not used in the URL.
Contains the value for the parameter, if used.

Result Section

This section contains specific information about each member returned. The Result section's tag name is result.

The result tag contains the following tags:

The root tag is members.

Tag Name Format Parent Tag Description
member GUID members (root tag)

Contains the id attribute equal to a GUID. Contains member-specific information in the following tags and their child tags:

  • homeClub
  • status
  • barcode
  • group
  • lastCheckInTimestamp
  • totalCheckInCount
  • personal
  • contact
  • membership
  • agreement

The GUID can be used in this and other ABC web services to restrict the results to a particular member.

homeClub #### member The homeClub tag contains the home club number for this member. A member's agreement with a home club may allow the member to check in to additional clubs.
status string member

The status tag contains the various statuses of the member, using the following child tags:

  • active
  • joinType
  • alert
  • alertReason
active boolean status

The active tag contains a value of true or false. When the value is false, the member is inactive, in one of the following states:

  • Expired
  • Canceled
  • Return for Collection
  • Prospect
joinType string status

Contains one of two values:

  • Member
  • Prospect
alert string, up to 50 characters status

Optional. If an alert was created at the time of the check in, then this tag contains a description of the alert. Example values include, but are not limited to:

  • Canceled
  • Return for Collection
alertReason string, up to 150 characters status Optional. If there was an alert at the time of check in, the alertReason tag contains an explanation of the alert status.
alertDate YYYY-MM-DD status

Optional. Contains the data for when the member's status changed.

For example, if the alert tag has a value of Canceled, then the alertDate tag contains the date for when the member was set to Canceled.

barcode barcode members Contains the barcode value for the member.
group string, up to 50 characters members Optional. Contains the name of the member group with which the member is associated, if any.
The tag will not appear if group is null or blank.
lastCheckInTimestamp timestamp members Contains the member's most recent check in time.
totalCheckInCount members Contains the number of times the member has checked in to the club.
memberUpdateTimestamp YYYY-MM-DD hh:mm:ss members

Contains the date of the most recent update to the member's demographic information.

Note: In some cases, the memberUpdatetimestamp may show a date on which none of the member's information was changed. See more information.

personal members

Contains personal member information and contact information. Contains child tags

Child tags:

  • firstName
  • middleInitial
  • lastName
  • birthDate
  • gender
address string, up to 40 characters contact Optional. Contains the member's street address in uppercase.
city string, up to 17 characters contact Optional. Contains the member's city in uppercase.
state State Code contact Optional. Contains the value for the member's state of residence, in uppercase.
zip string, up to 10 characters contact Optional. Contains the value for the member's ZIP code or postal code.
Format:
  • ##### (Example: 72205)
  • #####-#### (Example: 12144-7050)
  • A#A#A (Example: L6M 1V7 )
email string, up to 60 characters contact Optional. Contains the value for the member's email address.
homePhone Phone Number contact

Optional. Contains the value for the member's home phone number.

Format:

  • (###)###-#### [Example: (501)555-5555]
cellPhone Phone Number contact Optional. Contains the value for the member's cell phone number.
workPhone Phone Number contact Optional. Contains the value for the member's work phone number.
membership members

Optional. Contains specific membership details in the following tags and their child tags.

Child tags:

  • createTimestamp
  • type
  • managedBy
  • campaign
createTimestamp Timestamp membership Contains a timestamp representing when the membership was created.
This time relates to the club's local time zone.
type string, up to 50 characters membership Contains a value indicating the type of memberships. Clubs define and maintain membership types.
managedBy string membership

Contains a value describing who manages the member.

Allowable values:

  • Club
  • ABC
campaign string membership Optional. Contains a value describing how the member was referred to the club. Clubs define and maintain valid values for campaigns.
agreement members

Contains specific details for the member's agreement with the club in the following child tags:

Child tags:

  • number
  • station name
  • primaryMember
  • ordinal
  • renewalType
  • referringMember
  • salesperson
  • payment
  • dates
number string, limited to 9 or 12 characters agreement

Contains the member's agreement number, using the following criteria:

  • Prospects: Use the format of ####Prospect, where #### is equal to the club's number
  • Secondary Members: Have the agreement number of the corresponding primary member
  • ABC-Managed Members: Whether primary or secondary, limited to 9 characters
  • Club-Managed Members: Whether primary or secondary, limited to 12 characters

Note: The number tag contains the full agreement number, which begins with the four-digit club number.
The request parameter agreementNumber, however, has the five-digit format (with club number excluded).

stationName string, up to 50 characters agreement Optional. The name of the work station location associated with the agreement. This is usually the station at which the agreement information was entered.
This tag will not appear if the station name is null or blank.
ordinal ordinal agreement

Required. Describes whether the member is the primary member, using an ordinal:

  • 0 indicates the primary member
  • 1 indicates a secondary member
renewalType agreement

Required. Contains the member's renewal type.

Possible values:

  • Auto-Renew Open
  • Auto-Renew Term
  • Manual
  • None
referringMember GUID agreement

Optional. Contains the member id of the member who referred this member to the club. This GUID can be used in this and other ABC web services to restrict data to a specific member.

Child tag:

  • homeClub
homeClub #### referringMember Optional. Contains the value for the referring member's home club.
salesperson agreement

Optional. Contains the attribute of the salesperson's unique identifier.

Use the salesperson's identifier with other requests to obtain specific information for an employee.

Child tag:

  • homeClub
homeClub #### salesperson Optional. Contains the value for the salesperson's home club. There may be multiple uses of this tag if the salesperson works at multiple clubs.
payment agreement

Contains information about the member's payment obligations.

Child tags:

  • plan
  • terms
  • downPayment
  • method
  • card
  • dues
  • pastDueBalance
plan string, up to 50 characters payment Contains the plan name. The club is responsible for defining plans and their features.
terms payment

Required. Contains the value for the terms of the payment.

Allowed values:

  • Cash
  • Cash Open
  • Installment
  • Open
downPayment #####.## payment Optional. Contains the value for the amount the club received as a down payment for this agreement. The maximum allowed value is 99999.99.
method payment

Required. Contains a description of how dues will be collected.

Allowed values:

  • EFT
  • Credit Card
  • Coupon Book
card payment

Only applicable if the value for method is Credit Card.

Child tags:

  • type
  • lastFour
  • Expiration
type card

The type of credit card.

Allowed values:

  • Visa
  • AmericanExpress
  • MasterCard
  • Discover
lastFour #### card Contains the last four digits of the credit card number.
expiration MM-YY card Contains the month and year of the card's expiration.
dues ####.## payment Contains the amount that will be collected for dues. The maximum allowed value is 9999.99.
pastDueBalance ####.## payment Contains the delinquent amount on the agreement, excluding fees and club accounts. The maximum allowed value is 9999.99.
lateFeeAmount ####.## payment Contains the late fee amount. This fee may be assessed if the payment is overdue and has not been made during the grace period. The maximum allowed value is 9999.99.
serviceFeeAmount ####.## payment Contains the service fee amount. This fee may be assessed for a payment that has been declined or rejected. The maximum allowed value is 9999.99.
totalPastDueBalance ####.## payment Contains the total delinquent amount. It may include the past due amount, late fees, service fees, or any other past due invoices. The maximum allowed value is 9999.99.
nextDueAmount ####.## payment Contains the amount for all invoices due on the next due date, excluding late and service fees. The maximum allowed value is 9999.99.
nextDueDate YYYY-MM-DD dates Contains the date that the nextDueAmount is due.
queue   agreement Contains queue information.

Agreements in the Hold queue are hidden.
Agreements that have been placed in the Hold queue will not be displayed in the results section when this service is run.



Child tags:
  • name
    • ABC System Reject
    • Approval
    • Hold
    • POS
    • Posted
    • Pre-Approval
    • Removed
  • entryDate
name   queue The name of the agreement queue the agreement is currently in.
entryDate   queue The date the agreement was placed into its current queue.
entrySource   agreement

Contain s the following child tags:

  • name
  • report
  • autoPost
name string, up to 50 characters entrySource The name of the source from which the agreement information was entered (ex. "DataTrak EAE").
report string, up to 50 characters entrySource The report name that coincides with the source name (ex. "EAE").
autoPost
  • true
  • false
entrySource Required. Indicates whether or not the agreement will auto post (be posted without being entered in a hold queue).
dates agreement

Contains agreement and payment dates.

Child tags:

  • contract
  • effective
  • expiration
  • converted
  • lastRenewal
  • lastRewrite
  • renewal
sign YYYY-MM-DD dates Required. Contains the date the member signed an agreement.
contract YYYY-MM-DD dates Required. Contains the date the member joined the club, or the date a prospect was entered in the system.
effective YYYY-MM-DD dates Required. Contains the date the member can first access the club.
expiration YYYY-MM-DD dates Contains the date the agreement expires.
converted YYYY-MM-DD dates Optional. Contains the date that the agreement was converted from prospect to member.
lastRenewal YYYY-MM-DD dates Optional. Contains the date that the agreement was renewed
lastRewrite YYYY-MM-DD dates Optional. Contains the date that the agreement was rewritten.
renewal YYYY-MM-DD dates Required. Contains the date the agreement must be renewed.