How can we help?

    Mapping Document (MindBody Online)

    Follow

    Mindbody Online Mapping Document

    Translation from Mindbody Member

    Club OS Field

    MindBody Field

    Notes

    externalSystemId

    recipPrimaryKey OR primaryKey

    If member's most recent agreement is a traditional agreement, recipPrimaryKey is used

    If member's most recent agreement is a "pack", primaryKey is used

    This ID will never change

    Secondary externalSystemId

    ID

    This ID is used to make API calls for the member, and may change

    firstName

    firstName

     

    middleName

    middleName

     

    lastName

    lastName

     

    gender

    gender

    if MindBody gender is "female" then Club OS gender is "F"

    otherwise Club OS gender is "M"

    dateOfBirth

    birthDate

     

    marketingSource

    referredBy

     

    email

    email

     

    mobilePhone

    mobilePhone

     

    homePhone

    homePhone

     

    workPhone

    workPhone

     

    addressLine1

    addressLine1

     

    addressLine2

    addressLine2

     

    city

    city

     

    state

    state

     

    zip

    postalCode

     

    country

    country

     

    isOptOutEmail

    getEmailOptIn

    if getEmailOptIn is "true" isOptOutEmail is "false" and vice versa

    joinDate

    agreementDate

    saleDate of first agreement or pack

    createdDatetime

    agreementDate

    saleDate of first agreement or pack

    IntNotes.note

    notes

     

    IntNotes.msgType

     

    Always General message type

    IntNotes.createdDatetime

     

    Always current time

    IntNotes.createdBySystemId

     

    Salesperson for member

    IntMembershipAgreement

     

    This will be a traditional agreement or a "pack" based on which one has the most recent start date

    that's today or in the past. The fields for each can be found below.

    Translation from Mindbody Agreement

    Club OS Field

    Mindbody Field

    Notes

    systemId

    clientcontractid

     

    agreementName

    contractName

     

    agreementType

    contractType

     

    isPrimaryAgreement

     

    Always true

    recurringPayment

    firstAutopayAmount

     

    downPayment

    downPayment

     

    startDate

    startDate

     

    endDate

    endDate

     

    saleDate

    agreementDate

     

    isActive

    clientStatus

    If clientStatus is "Active" then true

    If clientStatus is anything else then false

    alert

    clientStatus

    If clientStatus is "Expired" then alert is Expired

    If clientStatus is "Terminated" then alert is Canceled

    If clientStatus is "Suspended" then alert if Freeze

    Translation from Mindbody Pack

    Club OS Field

    Mindbody Field

    Notes

    systemId

    saleID

     

    agreementName

    serviceDescription

     

    agreementType

    serviceDescription

     

    isPrimaryAgreement

     

    Always true

    downPayment

    price

     

    startDate

    activeDate

     

    endDate

    expDate

     

    isActive

     

    If end date is before or equal to current date, pack is active

    Otherwise pack is inactive

    saleDate

    saleDate

     

    Translation from Mindbody Employee

    Club OS Field

    Mindbody Field

    Notes

    firstName

    firstName

     

    lastName

    lastName

     

    email

    email

     

    mobilePhone

    mobilePhone

     

    homePhone

    homePhone

     

    workPhone

    workPhone

     

    addressLine1

    address

     

    addressLine2

    address2

     

    city

    city

     

    state

    state

     

    zip

    postalCode

     

    country

    country

     

    Translation to Mindbody Prospect

    Club OS Field

    Mindbody Field

    Notes

     

    isPropesct

    Always true

    externalSystemId

    ID

    This ID will be the Mindbody API ID

    firstName

    firstName

     

    middleName

    middleName

     

    lastName

    lastName

     

    gender

    gender

     

    dateOfBirth

    birthDate

     

    addressLine1

    addressLine1

     

    addressLine2

    addressLine2

     

    city

    city

     

    state

    state

     

    zip

    postalCode

     

    country

    country

     

    email

    email

     

    mobilePhone

    mobilePhone

     

    workPhone

    workPhone

     

    homePhone

    homePhone

    If homePhone is empty in Club OS it's set to "(111)1111111"

    as it is a required field in Mindbody

    marketingSource

    referredBy

    This is set to "Another client" and the referring member in Club OS

    is also passed to Mindbody if they are synced also.

    If marketingSource is empty it is set to "ClubOS" as it is a required field in Mindbody

    Translation from Mindbody Appointment

    Club OS Field

    Mindbody Field

    Notes

    Club OS Field

    Mindbody Field

    Notes

    eventType

     

    Always set to Lead

    startDatetime

    startDateTime

     

    endDatetime

    endDateTime

     

    createdBySystemId

    Staff.ID

     

    assignedToSystemid

    Staff.ID

     

    visitType

     

    Always set to Appointment

    eventStatus

    getSignedIn, getLateCancelled

    If getSignedIn is true eventStatus is Completed

    If getLateCancelled is true eventStatus is Canceled Charge

    Otherwise eventStatus is Active

    attendeeStatus

     

    Same as eventStatus

    Translation to Mindbody Note (Contact Log)

    Club OS FIeld

    Mindbody Field

    Notes

    userSystemId

    Client.ID

     

    createdBySystemId

    Staff.ID

     
     

    type

    Always set to 14

    createdDatetime

    createdDateTime

     

    note

    text

     

    msgType

    contactMethod

    If msgType is Email contact Method is "E-mail"

    If msgType is SMS contactMethod is "SMS"

    Otherwise contactMethod is "Phone"

     

    Was this article helpful?
    0 out of 0 found this helpful

    Comments