Message

Table:
message
Model Version:
d217054b3e86f0b3
JSON Schema:
Message
appointmentEvent
Nullable
Rescheduled, Scheduled, Reminder, Confirm, Canceled, Acknowledgement
appointmentId
Nullable
string
authorType
Customer, User, System
automatedCampaignId
Nullable
string
avoidSMSQuietHours
boolean
companyId
string
conversationId
Nullable
string
createdDate
date-time
customerId
Nullable
string
deleted
boolean
deletedDate
Nullable
date-time
deletedReason
Nullable
string
deletedUserId
Nullable
string
detached
Nullable
boolean
emailError
Nullable
string
emailId
Nullable
string
emailStatus
Nullable
Pending, Sent, Read, Error, Delivered, Unknown
emailSubject
Nullable
string
id
Primary Key
string
imported
boolean
internal
Nullable
boolean
isOrderShare
boolean
locationId
string
locationReviewRequestId
Nullable
string
metadata
Nullable
object
oneTimeCampaignBatchId
Nullable
string
oneTimeCampaignId
Nullable
string
orderId
Nullable
string
orderShareType
Nullable
Inspection, Order
origin
ChatBot, Scheduler, Campaign, Web, Mobile, CustomerOrderPage, SMS, Email
phoneNumberId
Nullable
string
requestAppointmentConfirmation
Nullable
boolean
sendEmail
Nullable
boolean
sendSms
Nullable
boolean
shopRead
Nullable
boolean
smsError
Nullable
string
smsStatus
Nullable
Pending, Sent, Read, Error, Delivered, Unknown
suggestedReply
Nullable
string
suggestedReplyState
None, Partial, Full
text
string
type
Transactional, Marketing
updatedDate
Nullable
date-time
userId
Nullable
string
vehicleId
Nullable
string
vendorId
Nullable
string