MappingID
int
The Mapping identifier
LFField
string
The name of the mapping field
LFFieldID
int
The identifier of the mapping field
CRMField
string
The name of the crm field
CRMFieldID
int
The identifier of the crm field
ClientCRMVersionID
int
The ClientCRMVersion identifier
FieldName
string
The name of the field
SortOrder
int
The order that the field is displayed in
PasswordField
int
If the field should be treated as a password
CrmLFColumnID
int
The column identifier
FieldName
string
The name of the column
ClientID
int
The Client identifier
ClientUserID
int
The ClientUser identifier
ClientCRMVersionID
int
The ClientCRMVersion identifier
ClientCRMVersionID
int
The ClientCRMVersion identifier
CRMID
int
The CRM identifier
CustomID1
string
The first custom CRM parameter field
CustomID2
string
The second custom CRM parameter field
CustomID3
string
The third custom CRM parameter field
CustomID4
string
The fourth custom CRM parameter field
CustomID5
string
The fifth custom CRM parameter field
CustomID6
string
The sixth custom CRM parameter field
CustomID7
string
The seventh custom CRM parameter field
CustomID8
string
The eighth custom CRM parameter field
WeeklyImportsEmail
string
The weekly import email address for Salesforce lite delivery
AutoPost
int
If the visits are automatically sent
InterfaceVersion
int
The interface version used at the integration service
UsesIntegrationService
int
If the integration uses the integration service
AutomaticIntegration
int
If the integration uses the integration service
CRMName
string
The name of the crm integrated with
oAuthKey
string
Our oAuthKey used to connect to Salesforce
oAuthSecret
string
Our oAuthSecret used to connect to Salesforce
oAuthEnabled
int
If the integration is open authentication enabled
NotificationEmail
string
The main notification email adderess
ImageURL
string
The image used for the crm instance
AllowAddDefaultMappings
int
If the default mapping button should be displayed
ShowAdvanced
int
If the advanced options should be displayed or not
ServiceURL
string
The main service url of the CRM integration
Assembly
string
The name of the plugin assembly
Class
string
The name of the plugin class
User
string
The user name to connect with
Password
string
The password to connect with
VisitXML
string
The raw visit information in XML
Domain
string
The login url to use
Instance
string
The instance of the CRM to use
InterfaceVersion
int
The interface version of the integration service to use
CreateLead
int
If a lead should be created in the CRM (1 if yes, 0 if no)
TriggerID
int
The trigger identifier
TriggerName
string
The name of the trigger
VisitXML
string
The generated XML containing the visits information
VisitID
Int64
The visit identifier
Assembly
string
The assembly name used in the integration service
Class
string
The class inside the assembly which is being used
ServiceURL
string
The main service url of the CRM integration
User
string
The user name to connect with
Password
string
The password to connect with
Domain
string
The login url to use
Instance
string
The instance of the CRM to use
InterfaceVersion
int
The interface version of the integration service to use
CreateLead
int
If a lead should be created in the CRM (1 if yes, 0 if no)
ClientUserID
int
ClientUserID
int
The ClientUser identifier
ClientCRMVersionID
int
The ClientCRMVersion identifier
DateSent
DateTime
The date that the visit was sent
BusinessID
int
The Business identifier
VisitID
Int64
The Visit identifier
Name
string
The name of the business
Referrer
string
The referrer
Keywords
string
The keywords
PageViews
int
The number of pages viewed
Duration
int
The duration of the visit
Link
string
The url of the CRM image
CRMID
int
The CRM identifier
CRM
int
The name of the CRM instance
Sent
int
Determines if the visit has been successfully sent
ClientCRMVersionID
int
The Client CRM Version identifier
Name
string
The name of the CRM
Image
string
The url of the CRM image
InternalCRMID
int
The internal crm identifier
CRMID
int
The CRM identifier
CRMName
string
The name of the CRM instance
CRMLink
string
The link to the CRM record
CRMSent
int
If the CRM record has been sent
ClientCRMVersionID
int
The ClientCRMVersion identifier
ClientCRMUserTriggerReportID
int
The ClientCRMUserTriggerReport identifier
ClientUserID
int
The client user identifier
ClientUserName
string
The name of client user
TriggerReportID
int
The identifier for the trigger report
TriggerReportName
string
The name of the client user
ClientUserID
int
The Client User identifier
ClientUserName
string
The name of the Client User
ClientCRMParameterID
int
The Client CRM Parameter identifier
Name
string
The name of the parameter
Value
string
The value of the parameter
Display
int
If the field should be shown (0 = no, 1 = yes)
ReadOnly
int
If the field is read only (0 = no, 1 = yes)
PasswordField
int
If the field is a password field (0 = no, 1 = yes)
HelpText
string
The text to display as help
DefaultValue
string
The default value to apply to the parameter
ClientID
string
[Use oAuth only] The Client Identifier
ClientUserID
string
[Use oAuth only] The Client User Identifier
ButtonText
string
[Use oAuth only] The text for the button link to the oAuth Service
ClientCRMUpdateLogID
int
The unique identifier for the ClientCRMUpdateLog table.
ClientCRMUpdateLogDate
datetime
The date at which the log entry was added.
ClientCRMVersionID
int
The unique identifier for the ClientCRMVersion table.
ClientUserID
int
The unique identifier for the ClientUser table.
FieldName
string
The name of the field updated.
FieldValue
string
The value that the field was updated to.
ChangeType
string
The type of change made (I = inserted, D = deleted, U = updated).