| Required role: | API |
| All Verbs | /api/Query/MemberGetExpiredMembers |
|---|
using System;
using System.Collections;
using System.Collections.Generic;
using System.Runtime.Serialization;
using ServiceStack;
using ServiceStack.DataAnnotations;
using ClubManager.Api.Services.Query;
namespace ClubManager.Api.Services.Query
{
public partial class LossReasonInstance
{
public virtual int LossReasonId { get; set; }
public virtual string Reason { get; set; }
public virtual bool Deleted { get; set; }
public virtual bool Demo { get; set; }
public virtual bool Selectable { get; set; }
}
public partial class MemberGetExpiredMembersInstance
{
public virtual MemberInstance Member { get; set; }
[References(typeof(ClubManager.Api.Services.Query.MemberInstance))]
public virtual int MemberId { get; set; }
public virtual string MembershipNumber { get; set; }
public virtual DateTime? JoinedDate { get; set; }
public virtual string CardNumber { get; set; }
public virtual string CompanyName { get; set; }
public virtual string FullName { get; set; }
public virtual int Gender { get; set; }
public virtual string Title { get; set; }
public virtual string Forenames { get; set; }
public virtual string Surname { get; set; }
public virtual string HomePhone { get; set; }
public virtual string MobilePhone { get; set; }
public virtual string EmailAddress { get; set; }
public virtual DateTime? DateOfBirth { get; set; }
public virtual string Postcode { get; set; }
public virtual string Address1 { get; set; }
public virtual string Address2 { get; set; }
public virtual string City { get; set; }
public virtual string County { get; set; }
public virtual DateTime? StartDate { get; set; }
public virtual DateTime? Expires { get; set; }
public virtual int? SessionsRemaining { get; set; }
public virtual DateTime? ContractEndDate { get; set; }
public virtual int? DaysRemaining { get; set; }
public virtual string MembershipType { get; set; }
public virtual DateTime? LastAttendance { get; set; }
public virtual int Attendance { get; set; }
public virtual int MemberType { get; set; }
public virtual int? RecurringPayments { get; set; }
public virtual int? OverduePayments { get; set; }
public virtual Guid BranchKey { get; set; }
public virtual int AttendanceThisWeek { get; set; }
public virtual decimal? retentionMetric { get; set; }
public virtual decimal? MonthlyAttendanceFrequency { get; set; }
public virtual decimal? TotalProductSpend { get; set; }
public virtual string JournalEntry { get; set; }
public virtual int? BookingsAttended { get; set; }
public virtual DateTime? DateOfLastBooking { get; set; }
public virtual decimal Balance { get; set; }
public virtual decimal CreditLimit { get; set; }
public virtual Guid? MemberKey { get; set; }
public virtual bool EmailOptOut { get; set; }
public virtual bool SmsOptOut { get; set; }
public virtual bool PhoneOptOut { get; set; }
public virtual bool LetterOptOut { get; set; }
public virtual bool UseExternalStatus { get; set; }
public virtual int ExternalStatus { get; set; }
public virtual DateTime CreatedDate { get; set; }
public virtual DateTime? ModifiedDate { get; set; }
public virtual DateTime? PhotoModifiedDate { get; set; }
public virtual DateTime? DeletedDate { get; set; }
public virtual string ExternalReference { get; set; }
public virtual int? RecurringPaymentsPaidInLast30Days { get; set; }
public virtual int MembershipState { get; set; }
public virtual int HasRecurringPayments { get; set; }
public virtual DateTime? LicenseRenewalDate { get; set; }
public virtual string LicenseReference { get; set; }
public virtual DateTime? LicenseStartDate { get; set; }
public virtual int? PaymentRecurrenceCount { get; set; }
}
public partial class MemberInstance
{
public MemberInstance()
{
Photo = new byte[]{};
}
public virtual int MemberId { get; set; }
public virtual int MemberType { get; set; }
public virtual string MembershipNumber { get; set; }
public virtual string CardNumber { get; set; }
public virtual string CompanyName { get; set; }
public virtual string Surname { get; set; }
public virtual string Forenames { get; set; }
public virtual string Title { get; set; }
public virtual int Gender { get; set; }
public virtual DateTime? DateOfBirth { get; set; }
public virtual string Address1 { get; set; }
public virtual string Address2 { get; set; }
public virtual string City { get; set; }
public virtual string County { get; set; }
public virtual string Postcode { get; set; }
public virtual string HomePhone { get; set; }
public virtual string MobilePhone { get; set; }
public virtual string EmailAddress { get; set; }
public virtual bool EmailOptOut { get; set; }
public virtual bool SmsOptOut { get; set; }
public virtual bool PhoneOptOut { get; set; }
public virtual bool LetterOptOut { get; set; }
public virtual string DirectDebitAccountHolder { get; set; }
public virtual string DirectDebitAccountNumber { get; set; }
public virtual string DirectDebitSortCode { get; set; }
public virtual DateTime? JoinedDate { get; set; }
public virtual string DirectDebitBankAddress { get; set; }
public virtual string FullName { get; set; }
public virtual string ExternalReference { get; set; }
public virtual byte[] Photo { get; set; }
public virtual DateTime? PhotoModifiedDate { get; set; }
public virtual string Notes { get; set; }
public virtual bool Deleted { get; set; }
public virtual bool Demo { get; set; }
public virtual bool UseExternalStatus { get; set; }
public virtual int ExternalStatus { get; set; }
public virtual string FreeText { get; set; }
public virtual Guid? MemberKey { get; set; }
public virtual decimal Balance { get; set; }
public virtual decimal CreditLimit { get; set; }
public virtual DateTime CreatedDate { get; set; }
public virtual DateTime? ModifiedDate { get; set; }
public virtual DateTime? DeletedDate { get; set; }
public virtual int ExternalSource { get; set; }
public virtual decimal? RetentionMetric { get; set; }
public virtual decimal? MonthlyAttendanceFrequency { get; set; }
public virtual int? AssignedToUserId { get; set; }
public virtual int? CreatedByUserId { get; set; }
public virtual int? DeletedByUserId { get; set; }
public virtual LossReasonInstance LossReason { get; set; }
[References(typeof(ClubManager.Api.Services.Query.LossReasonInstance))]
public virtual int? LossReasonId { get; set; }
public virtual int? WonOrLost { get; set; }
public virtual DateTime? WonOrLostDate { get; set; }
public virtual bool GiftAidPermission { get; set; }
public virtual bool? PhotoPermission { get; set; }
public virtual bool? FirstAidPermission { get; set; }
public virtual string EmergencyContact { get; set; }
public virtual UserInstance WonOrLostByUser { get; set; }
[References(typeof(ClubManager.Api.Services.Query.UserInstance))]
public virtual int? WonOrLostByUserId { get; set; }
public virtual DateTime? AgreedToTerms { get; set; }
public virtual bool OnlineBookingBanned { get; set; }
public virtual string Country { get; set; }
public virtual DateTime? FingerprintEnrolled { get; set; }
public virtual decimal? LastPaymentAmount { get; set; }
public virtual string Pin { get; set; }
public virtual int ProspectingPoints { get; set; }
public virtual int AchievementPoints { get; set; }
public virtual string ParentForenames { get; set; }
public virtual string ParentSurname { get; set; }
}
public partial class UserInstance
{
public virtual int UserId { get; set; }
public virtual string UserName { get; set; }
public virtual string Name { get; set; }
public virtual string Email { get; set; }
public virtual string MobilePhone { get; set; }
public virtual bool Enabled { get; set; }
public virtual DateTime? LastLogin { get; set; }
public virtual DateTime Created { get; set; }
public virtual bool Training { get; set; }
public virtual bool Deleted { get; set; }
public virtual int CoursesCompleted { get; set; }
public virtual bool? DisplayHomeNotification { get; set; }
public virtual bool TwoFactorEnabled { get; set; }
public virtual bool EmailConfirmed { get; set; }
public virtual bool MobilePhoneConfirmed { get; set; }
public virtual bool Notifications { get; set; }
public virtual DateTime? ChangePassword { get; set; }
public virtual DateTime? Activated { get; set; }
}
[AutoQueryViewer(Description="", IconUrl="octicon:database", Title="MemberGetExpiredMembers")]
public partial class ViewMemberGetExpiredMembers
: QueryDb<MemberGetExpiredMembersInstance>
{
}
}
namespace ServiceStack
{
[DataContract]
public partial class QueryBase
{
public QueryBase()
{
Meta = new Dictionary<string, string>{};
}
[DataMember(Order=1)]
public virtual int? Skip { get; set; }
[DataMember(Order=2)]
public virtual int? Take { get; set; }
[DataMember(Order=3)]
public virtual string OrderBy { get; set; }
[DataMember(Order=4)]
public virtual string OrderByDesc { get; set; }
[DataMember(Order=5)]
public virtual string Include { get; set; }
[DataMember(Order=6)]
public virtual string Fields { get; set; }
[DataMember(Order=7)]
public virtual Dictionary<string, string> Meta { get; set; }
}
public partial class QueryDb<T>
: QueryBase
{
}
[DataContract]
public partial class QueryResponse<T>
{
public QueryResponse()
{
Results = new List<T>{};
Meta = new Dictionary<string, string>{};
}
[DataMember(Order=1)]
public virtual int Offset { get; set; }
[DataMember(Order=2)]
public virtual int Total { get; set; }
[DataMember(Order=3)]
public virtual List<T> Results { get; set; }
[DataMember(Order=4)]
public virtual Dictionary<string, string> Meta { get; set; }
[DataMember(Order=5)]
public virtual ResponseStatus ResponseStatus { get; set; }
}
}
C# ViewMemberGetExpiredMembers DTOs
To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /api/Query/MemberGetExpiredMembers HTTP/1.1
Host: api.clubmanagercentral.com
Accept: application/xml
Content-Type: application/xml
Content-Length: length
<ViewMemberGetExpiredMembers xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/ClubManager.Api.Services.Query">
<Skip xmlns="http://schemas.servicestack.net/types">0</Skip>
<Take xmlns="http://schemas.servicestack.net/types">0</Take>
<OrderBy xmlns="http://schemas.servicestack.net/types">String</OrderBy>
<OrderByDesc xmlns="http://schemas.servicestack.net/types">String</OrderByDesc>
<Include xmlns="http://schemas.servicestack.net/types">String</Include>
<Fields xmlns="http://schemas.servicestack.net/types">String</Fields>
<Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.servicestack.net/types">
<d2p1:KeyValueOfstringstring>
<d2p1:Key>String</d2p1:Key>
<d2p1:Value>String</d2p1:Value>
</d2p1:KeyValueOfstringstring>
</Meta>
</ViewMemberGetExpiredMembers>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length
<QueryResponseOfMemberGetExpiredMembersInstancePEZRWkv_P xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.servicestack.net/types">
<Offset>0</Offset>
<Total>0</Total>
<Results xmlns:d2p1="http://schemas.datacontract.org/2004/07/ClubManager.Api.Services.Query">
<d2p1:MemberGetExpiredMembersInstance>
<d2p1:Address1>String</d2p1:Address1>
<d2p1:Address2>String</d2p1:Address2>
<d2p1:Attendance>0</d2p1:Attendance>
<d2p1:AttendanceThisWeek>0</d2p1:AttendanceThisWeek>
<d2p1:Balance>0</d2p1:Balance>
<d2p1:BookingsAttended>0</d2p1:BookingsAttended>
<d2p1:BranchKey>00000000-0000-0000-0000-000000000000</d2p1:BranchKey>
<d2p1:CardNumber>String</d2p1:CardNumber>
<d2p1:City>String</d2p1:City>
<d2p1:CompanyName>String</d2p1:CompanyName>
<d2p1:ContractEndDate>0001-01-01T00:00:00</d2p1:ContractEndDate>
<d2p1:County>String</d2p1:County>
<d2p1:CreatedDate>0001-01-01T00:00:00</d2p1:CreatedDate>
<d2p1:CreditLimit>0</d2p1:CreditLimit>
<d2p1:DateOfBirth>0001-01-01T00:00:00</d2p1:DateOfBirth>
<d2p1:DateOfLastBooking>0001-01-01T00:00:00</d2p1:DateOfLastBooking>
<d2p1:DaysRemaining>0</d2p1:DaysRemaining>
<d2p1:DeletedDate>0001-01-01T00:00:00</d2p1:DeletedDate>
<d2p1:EmailAddress>String</d2p1:EmailAddress>
<d2p1:EmailOptOut>false</d2p1:EmailOptOut>
<d2p1:Expires>0001-01-01T00:00:00</d2p1:Expires>
<d2p1:ExternalReference>String</d2p1:ExternalReference>
<d2p1:ExternalStatus>0</d2p1:ExternalStatus>
<d2p1:Forenames>String</d2p1:Forenames>
<d2p1:FullName>String</d2p1:FullName>
<d2p1:Gender>0</d2p1:Gender>
<d2p1:HasRecurringPayments>0</d2p1:HasRecurringPayments>
<d2p1:HomePhone>String</d2p1:HomePhone>
<d2p1:JoinedDate>0001-01-01T00:00:00</d2p1:JoinedDate>
<d2p1:JournalEntry>String</d2p1:JournalEntry>
<d2p1:LastAttendance>0001-01-01T00:00:00</d2p1:LastAttendance>
<d2p1:LetterOptOut>false</d2p1:LetterOptOut>
<d2p1:LicenseReference>String</d2p1:LicenseReference>
<d2p1:LicenseRenewalDate>0001-01-01T00:00:00</d2p1:LicenseRenewalDate>
<d2p1:LicenseStartDate>0001-01-01T00:00:00</d2p1:LicenseStartDate>
<d2p1:Member>
<d2p1:AchievementPoints>0</d2p1:AchievementPoints>
<d2p1:Address1>String</d2p1:Address1>
<d2p1:Address2>String</d2p1:Address2>
<d2p1:AgreedToTerms>0001-01-01T00:00:00</d2p1:AgreedToTerms>
<d2p1:AssignedToUserId>0</d2p1:AssignedToUserId>
<d2p1:Balance>0</d2p1:Balance>
<d2p1:CardNumber>String</d2p1:CardNumber>
<d2p1:City>String</d2p1:City>
<d2p1:CompanyName>String</d2p1:CompanyName>
<d2p1:Country>String</d2p1:Country>
<d2p1:County>String</d2p1:County>
<d2p1:CreatedByUserId>0</d2p1:CreatedByUserId>
<d2p1:CreatedDate>0001-01-01T00:00:00</d2p1:CreatedDate>
<d2p1:CreditLimit>0</d2p1:CreditLimit>
<d2p1:DateOfBirth>0001-01-01T00:00:00</d2p1:DateOfBirth>
<d2p1:Deleted>false</d2p1:Deleted>
<d2p1:DeletedByUserId>0</d2p1:DeletedByUserId>
<d2p1:DeletedDate>0001-01-01T00:00:00</d2p1:DeletedDate>
<d2p1:Demo>false</d2p1:Demo>
<d2p1:DirectDebitAccountHolder>String</d2p1:DirectDebitAccountHolder>
<d2p1:DirectDebitAccountNumber>String</d2p1:DirectDebitAccountNumber>
<d2p1:DirectDebitBankAddress>String</d2p1:DirectDebitBankAddress>
<d2p1:DirectDebitSortCode>String</d2p1:DirectDebitSortCode>
<d2p1:EmailAddress>String</d2p1:EmailAddress>
<d2p1:EmailOptOut>false</d2p1:EmailOptOut>
<d2p1:EmergencyContact>String</d2p1:EmergencyContact>
<d2p1:ExternalReference>String</d2p1:ExternalReference>
<d2p1:ExternalSource>0</d2p1:ExternalSource>
<d2p1:ExternalStatus>0</d2p1:ExternalStatus>
<d2p1:FingerprintEnrolled>0001-01-01T00:00:00</d2p1:FingerprintEnrolled>
<d2p1:FirstAidPermission>false</d2p1:FirstAidPermission>
<d2p1:Forenames>String</d2p1:Forenames>
<d2p1:FreeText>String</d2p1:FreeText>
<d2p1:FullName>String</d2p1:FullName>
<d2p1:Gender>0</d2p1:Gender>
<d2p1:GiftAidPermission>false</d2p1:GiftAidPermission>
<d2p1:HomePhone>String</d2p1:HomePhone>
<d2p1:JoinedDate>0001-01-01T00:00:00</d2p1:JoinedDate>
<d2p1:LastPaymentAmount>0</d2p1:LastPaymentAmount>
<d2p1:LetterOptOut>false</d2p1:LetterOptOut>
<d2p1:LossReason>
<d2p1:Deleted>false</d2p1:Deleted>
<d2p1:Demo>false</d2p1:Demo>
<d2p1:LossReasonId>0</d2p1:LossReasonId>
<d2p1:Reason>String</d2p1:Reason>
<d2p1:Selectable>false</d2p1:Selectable>
</d2p1:LossReason>
<d2p1:LossReasonId>0</d2p1:LossReasonId>
<d2p1:MemberId>0</d2p1:MemberId>
<d2p1:MemberKey>00000000-0000-0000-0000-000000000000</d2p1:MemberKey>
<d2p1:MemberType>0</d2p1:MemberType>
<d2p1:MembershipNumber>String</d2p1:MembershipNumber>
<d2p1:MobilePhone>String</d2p1:MobilePhone>
<d2p1:ModifiedDate>0001-01-01T00:00:00</d2p1:ModifiedDate>
<d2p1:MonthlyAttendanceFrequency>0</d2p1:MonthlyAttendanceFrequency>
<d2p1:Notes>String</d2p1:Notes>
<d2p1:OnlineBookingBanned>false</d2p1:OnlineBookingBanned>
<d2p1:ParentForenames>String</d2p1:ParentForenames>
<d2p1:ParentSurname>String</d2p1:ParentSurname>
<d2p1:PhoneOptOut>false</d2p1:PhoneOptOut>
<d2p1:Photo>AA==</d2p1:Photo>
<d2p1:PhotoModifiedDate>0001-01-01T00:00:00</d2p1:PhotoModifiedDate>
<d2p1:PhotoPermission>false</d2p1:PhotoPermission>
<d2p1:Pin>String</d2p1:Pin>
<d2p1:Postcode>String</d2p1:Postcode>
<d2p1:ProspectingPoints>0</d2p1:ProspectingPoints>
<d2p1:RetentionMetric>0</d2p1:RetentionMetric>
<d2p1:SmsOptOut>false</d2p1:SmsOptOut>
<d2p1:Surname>String</d2p1:Surname>
<d2p1:Title>String</d2p1:Title>
<d2p1:UseExternalStatus>false</d2p1:UseExternalStatus>
<d2p1:WonOrLost>0</d2p1:WonOrLost>
<d2p1:WonOrLostByUser>
<d2p1:Activated>0001-01-01T00:00:00</d2p1:Activated>
<d2p1:ChangePassword>0001-01-01T00:00:00</d2p1:ChangePassword>
<d2p1:CoursesCompleted>0</d2p1:CoursesCompleted>
<d2p1:Created>0001-01-01T00:00:00</d2p1:Created>
<d2p1:Deleted>false</d2p1:Deleted>
<d2p1:DisplayHomeNotification>false</d2p1:DisplayHomeNotification>
<d2p1:Email>String</d2p1:Email>
<d2p1:EmailConfirmed>false</d2p1:EmailConfirmed>
<d2p1:Enabled>false</d2p1:Enabled>
<d2p1:LastLogin>0001-01-01T00:00:00</d2p1:LastLogin>
<d2p1:MobilePhone>String</d2p1:MobilePhone>
<d2p1:MobilePhoneConfirmed>false</d2p1:MobilePhoneConfirmed>
<d2p1:Name>String</d2p1:Name>
<d2p1:Notifications>false</d2p1:Notifications>
<d2p1:Training>false</d2p1:Training>
<d2p1:TwoFactorEnabled>false</d2p1:TwoFactorEnabled>
<d2p1:UserId>0</d2p1:UserId>
<d2p1:UserName>String</d2p1:UserName>
</d2p1:WonOrLostByUser>
<d2p1:WonOrLostByUserId>0</d2p1:WonOrLostByUserId>
<d2p1:WonOrLostDate>0001-01-01T00:00:00</d2p1:WonOrLostDate>
</d2p1:Member>
<d2p1:MemberId>0</d2p1:MemberId>
<d2p1:MemberKey>00000000-0000-0000-0000-000000000000</d2p1:MemberKey>
<d2p1:MemberType>0</d2p1:MemberType>
<d2p1:MembershipNumber>String</d2p1:MembershipNumber>
<d2p1:MembershipState>0</d2p1:MembershipState>
<d2p1:MembershipType>String</d2p1:MembershipType>
<d2p1:MobilePhone>String</d2p1:MobilePhone>
<d2p1:ModifiedDate>0001-01-01T00:00:00</d2p1:ModifiedDate>
<d2p1:MonthlyAttendanceFrequency>0</d2p1:MonthlyAttendanceFrequency>
<d2p1:OverduePayments>0</d2p1:OverduePayments>
<d2p1:PaymentRecurrenceCount>0</d2p1:PaymentRecurrenceCount>
<d2p1:PhoneOptOut>false</d2p1:PhoneOptOut>
<d2p1:PhotoModifiedDate>0001-01-01T00:00:00</d2p1:PhotoModifiedDate>
<d2p1:Postcode>String</d2p1:Postcode>
<d2p1:RecurringPayments>0</d2p1:RecurringPayments>
<d2p1:RecurringPaymentsPaidInLast30Days>0</d2p1:RecurringPaymentsPaidInLast30Days>
<d2p1:SessionsRemaining>0</d2p1:SessionsRemaining>
<d2p1:SmsOptOut>false</d2p1:SmsOptOut>
<d2p1:StartDate>0001-01-01T00:00:00</d2p1:StartDate>
<d2p1:Surname>String</d2p1:Surname>
<d2p1:Title>String</d2p1:Title>
<d2p1:TotalProductSpend>0</d2p1:TotalProductSpend>
<d2p1:UseExternalStatus>false</d2p1:UseExternalStatus>
<d2p1:retentionMetric>0</d2p1:retentionMetric>
</d2p1:MemberGetExpiredMembersInstance>
</Results>
<Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d2p1:KeyValueOfstringstring>
<d2p1:Key>String</d2p1:Key>
<d2p1:Value>String</d2p1:Value>
</d2p1:KeyValueOfstringstring>
</Meta>
<ResponseStatus>
<ErrorCode>String</ErrorCode>
<Message>String</Message>
<StackTrace>String</StackTrace>
<Errors>
<ResponseError>
<ErrorCode>String</ErrorCode>
<FieldName>String</FieldName>
<Message>String</Message>
<Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d5p1:KeyValueOfstringstring>
<d5p1:Key>String</d5p1:Key>
<d5p1:Value>String</d5p1:Value>
</d5p1:KeyValueOfstringstring>
</Meta>
</ResponseError>
</Errors>
<Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d3p1:KeyValueOfstringstring>
<d3p1:Key>String</d3p1:Key>
<d3p1:Value>String</d3p1:Value>
</d3p1:KeyValueOfstringstring>
</Meta>
</ResponseStatus>
</QueryResponseOfMemberGetExpiredMembersInstancePEZRWkv_P>