ClubManager.Api

FindJournal

**Requires Authentication**
Required role:	API

The following routes are available for this service:
All Verbs	/api/Query/Journal

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**JournalInstance** Parameters:
Name	Parameter	Data Type	Required
JournalId	form	int	No
JournalDate	form	DateTime	No
Title	form	string	No
Comment	form	string	No
MessageType	form	int	No
UserName	form	string	No
Member	form	MemberInstance	No
MemberId	form	int	No
Message	form	MessageInstance	No
MessageId	form	int?	No
ViewedDate	form	DateTime?	No
Deleted	form	bool	No
Demo	form	bool	No
Permanent	form	bool	No
alertDate	form	DateTime?	No
AssignedToUserId	form	int?	No
Completed	form	bool?	No
CompletedDate	form	DateTime?	No
CreatedByUserId	form	int?	No
PostponedCount	form	int	No
SendSMSReminder	form	bool	No
NoShow	form	bool?	No

**MemberInstance** Parameters:
Name	Parameter	Data Type	Required
MemberId	form	int	No
MemberType	form	int	No
MembershipNumber	form	string	No
CardNumber	form	string	No
CompanyName	form	string	No
Surname	form	string	No
Forenames	form	string	No
Title	form	string	No
Gender	form	int	No
DateOfBirth	form	DateTime?	No
Address1	form	string	No
Address2	form	string	No
City	form	string	No
County	form	string	No
Postcode	form	string	No
HomePhone	form	string	No
MobilePhone	form	string	No
EmailAddress	form	string	No
EmailOptOut	form	bool	No
SmsOptOut	form	bool	No
PhoneOptOut	form	bool	No
LetterOptOut	form	bool	No
DirectDebitAccountHolder	form	string	No
DirectDebitAccountNumber	form	string	No
DirectDebitSortCode	form	string	No
JoinedDate	form	DateTime?	No
DirectDebitBankAddress	form	string	No
FullName	form	string	No
ExternalReference	form	string	No
Photo	form	byte[]	No
PhotoModifiedDate	form	DateTime?	No
Notes	form	string	No
Deleted	form	bool	No
Demo	form	bool	No
UseExternalStatus	form	bool	No
ExternalStatus	form	int	No
FreeText	form	string	No
MemberKey	form	Guid?	No
Balance	form	decimal	No
CreditLimit	form	decimal	No
CreatedDate	form	DateTime	No
ModifiedDate	form	DateTime?	No
DeletedDate	form	DateTime?	No
ExternalSource	form	int	No
RetentionMetric	form	decimal?	No
MonthlyAttendanceFrequency	form	decimal?	No
AssignedToUserId	form	int?	No
CreatedByUserId	form	int?	No
DeletedByUserId	form	int?	No
LossReason	form	LossReasonInstance	No
LossReasonId	form	int?	No
WonOrLost	form	int?	No
WonOrLostDate	form	DateTime?	No
GiftAidPermission	form	bool	No
PhotoPermission	form	bool?	No
FirstAidPermission	form	bool?	No
EmergencyContact	form	string	No
WonOrLostByUser	form	UserInstance	No
WonOrLostByUserId	form	int?	No
AgreedToTerms	form	DateTime?	No
OnlineBookingBanned	form	bool	No
Country	form	string	No
FingerprintEnrolled	form	DateTime?	No
LastPaymentAmount	form	decimal?	No
Pin	form	string	No
ProspectingPoints	form	int	No
AchievementPoints	form	int	No
ParentForenames	form	string	No
ParentSurname	form	string	No

**LossReasonInstance** Parameters:
Name	Parameter	Data Type	Required
LossReasonId	form	int	No
Reason	form	string	No
Deleted	form	bool	No
Demo	form	bool	No
Selectable	form	bool	No

**UserInstance** Parameters:
Name	Parameter	Data Type	Required
UserId	form	int	No
UserName	form	string	No
Name	form	string	No
Email	form	string	No
MobilePhone	form	string	No
Enabled	form	bool	No
LastLogin	form	DateTime?	No
Created	form	DateTime	No
Training	form	bool	No
Deleted	form	bool	No
CoursesCompleted	form	int	No
DisplayHomeNotification	form	bool?	No
TwoFactorEnabled	form	bool	No
EmailConfirmed	form	bool	No
MobilePhoneConfirmed	form	bool	No
Notifications	form	bool	No
ChangePassword	form	DateTime?	No
Activated	form	DateTime?	No

**MessageInstance** Parameters:
Name	Parameter	Data Type	Required
MessageId	form	int	No
DueDate	form	DateTime	No
SentDate	form	DateTime?	No
Processed	form	bool	No
Failures	form	int	No
InstanceId	form	int?	No
MessageSid	form	string	No
MessageTemplate	form	MessageTemplateInstance	No
MessageTemplateId	form	int?	No
OpenedDate	form	DateTime?	No
BouncedDate	form	DateTime?	No
DeliveredDate	form	DateTime?	No
UnsubscribedDate	form	DateTime?	No
SpamReportDate	form	DateTime?	No
User	form	UserInstance	No
UserId	form	int?	No
InstanceType	form	int?	No

**MessageTemplateInstance** Parameters:
Name	Parameter	Data Type	Required
MessageTemplateId	form	int	No
Name	form	string	No
Subject	form	string	No
Body	form	string	No
ReportId	form	int?	No
TemplateType	form	int	No
Created	form	DateTime?	No
CreatedBy	form	int?	No
Modified	form	DateTime?	No
ModifiedBy	form	int?	No
Deleted	form	DateTime?	No
DeletedBy	form	int?	No
EventType	form	int	No
ContentType	form	int	No
Hidden	form	bool?	No
ParentMessageTemplateId	form	int?	No
InclusionTags	form	string	No
ExclusionTags	form	string	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

To override the Content-type in your clients, use the HTTP Accept Header, append the .jsv suffix or ?format=jsv

HTTP + 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
		}
	}
}