Required role: | API |
All Verbs | /api/Query/Journal |
---|
// @DataContract
export class QueryBase
{
// @DataMember(Order=1)
public Skip?: number;
// @DataMember(Order=2)
public Take?: number;
// @DataMember(Order=3)
public OrderBy?: string;
// @DataMember(Order=4)
public OrderByDesc?: string;
// @DataMember(Order=5)
public Include?: string;
// @DataMember(Order=6)
public Fields?: string;
// @DataMember(Order=7)
public Meta?: { [index: string]: string; };
public constructor(init?: Partial<QueryBase>) { (Object as any).assign(this, init); }
}
export class QueryDb<T> extends QueryBase
{
public constructor(init?: Partial<QueryDb<T>>) { super(init); (Object as any).assign(this, init); }
}
export class LossReasonInstance
{
public LossReasonId?: number;
public Reason?: string;
public Deleted?: boolean;
public Demo?: boolean;
public Selectable?: boolean;
public constructor(init?: Partial<LossReasonInstance>) { (Object as any).assign(this, init); }
}
export class UserInstance
{
public UserId?: number;
public UserName?: string;
public Name?: string;
public Email?: string;
public MobilePhone?: string;
public Enabled?: boolean;
public LastLogin?: string;
public Created?: string;
public Training?: boolean;
public Deleted?: boolean;
public CoursesCompleted?: number;
public DisplayHomeNotification?: boolean;
public TwoFactorEnabled?: boolean;
public EmailConfirmed?: boolean;
public MobilePhoneConfirmed?: boolean;
public Notifications?: boolean;
public ChangePassword?: string;
public Activated?: string;
public constructor(init?: Partial<UserInstance>) { (Object as any).assign(this, init); }
}
export class MemberInstance
{
public MemberId?: number;
public MemberType?: number;
public MembershipNumber?: string;
public CardNumber?: string;
public CompanyName?: string;
public Surname?: string;
public Forenames?: string;
public Title?: string;
public Gender?: number;
public DateOfBirth?: string;
public Address1?: string;
public Address2?: string;
public City?: string;
public County?: string;
public Postcode?: string;
public HomePhone?: string;
public MobilePhone?: string;
public EmailAddress?: string;
public EmailOptOut?: boolean;
public SmsOptOut?: boolean;
public PhoneOptOut?: boolean;
public LetterOptOut?: boolean;
public DirectDebitAccountHolder?: string;
public DirectDebitAccountNumber?: string;
public DirectDebitSortCode?: string;
public JoinedDate?: string;
public DirectDebitBankAddress?: string;
public FullName?: string;
public ExternalReference?: string;
public Photo?: string;
public PhotoModifiedDate?: string;
public Notes?: string;
public Deleted?: boolean;
public Demo?: boolean;
public UseExternalStatus?: boolean;
public ExternalStatus?: number;
public FreeText?: string;
public MemberKey?: string;
public Balance?: number;
public CreditLimit?: number;
public CreatedDate?: string;
public ModifiedDate?: string;
public DeletedDate?: string;
public ExternalSource?: number;
public RetentionMetric?: number;
public MonthlyAttendanceFrequency?: number;
public AssignedToUserId?: number;
public CreatedByUserId?: number;
public DeletedByUserId?: number;
public LossReason?: LossReasonInstance;
// @References("typeof(ClubManager.Api.Services.Query.LossReasonInstance)")
public LossReasonId?: number;
public WonOrLost?: number;
public WonOrLostDate?: string;
public GiftAidPermission?: boolean;
public PhotoPermission?: boolean;
public FirstAidPermission?: boolean;
public EmergencyContact?: string;
public WonOrLostByUser?: UserInstance;
// @References("typeof(ClubManager.Api.Services.Query.UserInstance)")
public WonOrLostByUserId?: number;
public AgreedToTerms?: string;
public OnlineBookingBanned?: boolean;
public Country?: string;
public FingerprintEnrolled?: string;
public LastPaymentAmount?: number;
public Pin?: string;
public ProspectingPoints?: number;
public AchievementPoints?: number;
public ParentForenames?: string;
public ParentSurname?: string;
public constructor(init?: Partial<MemberInstance>) { (Object as any).assign(this, init); }
}
export class MessageTemplateInstance
{
public MessageTemplateId?: number;
public Name?: string;
public Subject?: string;
public Body?: string;
public ReportId?: number;
public TemplateType?: number;
public Created?: string;
public CreatedBy?: number;
public Modified?: string;
public ModifiedBy?: number;
public Deleted?: string;
public DeletedBy?: number;
public EventType?: number;
public ContentType?: number;
public Hidden?: boolean;
public ParentMessageTemplateId?: number;
public InclusionTags?: string;
public ExclusionTags?: string;
public constructor(init?: Partial<MessageTemplateInstance>) { (Object as any).assign(this, init); }
}
export class MessageInstance
{
public MessageId?: number;
public DueDate?: string;
public SentDate?: string;
public Processed?: boolean;
public Failures?: number;
public InstanceId?: number;
public MessageSid?: string;
public MessageTemplate?: MessageTemplateInstance;
// @References("typeof(ClubManager.Api.Services.Query.MessageTemplateInstance)")
public MessageTemplateId?: number;
public OpenedDate?: string;
public BouncedDate?: string;
public DeliveredDate?: string;
public UnsubscribedDate?: string;
public SpamReportDate?: string;
public User?: UserInstance;
// @References("typeof(ClubManager.Api.Services.Query.UserInstance)")
public UserId?: number;
public InstanceType?: number;
public constructor(init?: Partial<MessageInstance>) { (Object as any).assign(this, init); }
}
export class JournalInstance
{
public JournalId?: number;
public JournalDate?: string;
public Title?: string;
public Comment?: string;
public MessageType?: number;
public UserName?: string;
public Member?: MemberInstance;
// @References("typeof(ClubManager.Api.Services.Query.MemberInstance)")
public MemberId?: number;
public Message?: MessageInstance;
// @References("typeof(ClubManager.Api.Services.Query.MessageInstance)")
public MessageId?: number;
public ViewedDate?: string;
public Deleted?: boolean;
public Demo?: boolean;
public Permanent?: boolean;
public alertDate?: string;
public AssignedToUserId?: number;
public Completed?: boolean;
public CompletedDate?: string;
public CreatedByUserId?: number;
public PostponedCount?: number;
public SendSMSReminder?: boolean;
public NoShow?: boolean;
public constructor(init?: Partial<JournalInstance>) { (Object as any).assign(this, init); }
}
// @AutoQueryViewer(Description="", IconUrl="octicon:database", Title="Journal")
export class FindJournal extends QueryDb<JournalInstance>
{
public constructor(init?: Partial<FindJournal>) { super(init); (Object as any).assign(this, init); }
}
// @DataContract
export class QueryResponse<T>
{
// @DataMember(Order=1)
public Offset?: number;
// @DataMember(Order=2)
public Total?: number;
// @DataMember(Order=3)
public Results?: T[];
// @DataMember(Order=4)
public Meta?: { [index: string]: string; };
// @DataMember(Order=5)
public ResponseStatus?: ResponseStatus;
public constructor(init?: Partial<QueryResponse<T>>) { (Object as any).assign(this, init); }
}
To override the Content-type in your clients, use the HTTP Accept Header, append the .jsv suffix or ?format=jsv
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /api/Query/Journal HTTP/1.1
Host: api.clubmanagercentral.com
Accept: text/jsv
Content-Type: text/jsv
Content-Length: length
{
Skip: 0,
Take: 0,
OrderBy: String,
OrderByDesc: String,
Include: String,
Fields: String,
Meta:
{
String: String
}
}
HTTP/1.1 200 OK Content-Type: text/jsv Content-Length: length { Offset: 0, Total: 0, Results: [ { JournalId: 0, JournalDate: 0001-01-01, Title: String, Comment: String, MessageType: 0, UserName: String, Member: { MemberId: 0, MemberType: 0, MembershipNumber: String, CardNumber: String, CompanyName: String, Surname: String, Forenames: String, Title: String, Gender: 0, DateOfBirth: 0001-01-01, Address1: String, Address2: String, City: String, County: String, Postcode: String, HomePhone: String, MobilePhone: String, EmailAddress: String, EmailOptOut: False, SmsOptOut: False, PhoneOptOut: False, LetterOptOut: False, DirectDebitAccountHolder: String, DirectDebitAccountNumber: String, DirectDebitSortCode: String, JoinedDate: 0001-01-01, DirectDebitBankAddress: String, FullName: String, ExternalReference: String, Photo: AA==, PhotoModifiedDate: 0001-01-01, Notes: String, Deleted: False, Demo: False, UseExternalStatus: False, ExternalStatus: 0, FreeText: String, MemberKey: 00000000000000000000000000000000, Balance: 0, CreditLimit: 0, CreatedDate: 0001-01-01, ModifiedDate: 0001-01-01, DeletedDate: 0001-01-01, ExternalSource: 0, RetentionMetric: 0, MonthlyAttendanceFrequency: 0, AssignedToUserId: 0, CreatedByUserId: 0, DeletedByUserId: 0, LossReason: { LossReasonId: 0, Reason: String, Deleted: False, Demo: False, Selectable: False }, LossReasonId: 0, WonOrLost: 0, WonOrLostDate: 0001-01-01, GiftAidPermission: False, PhotoPermission: False, FirstAidPermission: False, EmergencyContact: String, WonOrLostByUser: { UserId: 0, UserName: String, Name: String, Email: String, MobilePhone: String, Enabled: False, LastLogin: 0001-01-01, Created: 0001-01-01, Training: False, Deleted: False, CoursesCompleted: 0, DisplayHomeNotification: False, TwoFactorEnabled: False, EmailConfirmed: False, MobilePhoneConfirmed: False, Notifications: False, ChangePassword: 0001-01-01, Activated: 0001-01-01 }, WonOrLostByUserId: 0, AgreedToTerms: 0001-01-01, OnlineBookingBanned: False, Country: String, FingerprintEnrolled: 0001-01-01, LastPaymentAmount: 0, Pin: String, ProspectingPoints: 0, AchievementPoints: 0, ParentForenames: String, ParentSurname: String }, MemberId: 0, Message: { MessageId: 0, DueDate: 0001-01-01, SentDate: 0001-01-01, Processed: False, Failures: 0, InstanceId: 0, MessageSid: String, MessageTemplate: { MessageTemplateId: 0, Name: String, Subject: String, Body: String, ReportId: 0, TemplateType: 0, Created: 0001-01-01, CreatedBy: 0, Modified: 0001-01-01, ModifiedBy: 0, Deleted: 0001-01-01, DeletedBy: 0, EventType: 0, ContentType: 0, Hidden: False, ParentMessageTemplateId: 0, InclusionTags: String, ExclusionTags: String }, MessageTemplateId: 0, OpenedDate: 0001-01-01, BouncedDate: 0001-01-01, DeliveredDate: 0001-01-01, UnsubscribedDate: 0001-01-01, SpamReportDate: 0001-01-01, User: { UserId: 0, UserName: String, Name: String, Email: String, MobilePhone: String, Enabled: False, LastLogin: 0001-01-01, Created: 0001-01-01, Training: False, Deleted: False, CoursesCompleted: 0, DisplayHomeNotification: False, TwoFactorEnabled: False, EmailConfirmed: False, MobilePhoneConfirmed: False, Notifications: False, ChangePassword: 0001-01-01, Activated: 0001-01-01 }, UserId: 0, InstanceType: 0 }, MessageId: 0, ViewedDate: 0001-01-01, Deleted: False, Demo: False, Permanent: False, alertDate: 0001-01-01, AssignedToUserId: 0, Completed: False, CompletedDate: 0001-01-01, CreatedByUserId: 0, PostponedCount: 0, SendSMSReminder: False, NoShow: False } ], Meta: { String: String }, ResponseStatus: { ErrorCode: String, Message: String, StackTrace: String, Errors: [ { ErrorCode: String, FieldName: String, Message: String, Meta: { String: String } } ], Meta: { String: String } } }