JDBC Driver for Act! CRM

Build 24.0.9060

CampaignLeads

Gets contacts leads.

Table Specific Information

Select

The driver will use the Act! CRM API to process WHERE clause conditions built with the following column and operator.

  • Date supports the '=,>,<,>=,<=' operators.
  • Status supports the '=' operator.
  • UserId supports the '=' operator.
  • CampaignId supports the '=' operator.

The driver processes other filters client-side within the driver. For example, the following queries are processed server side:

SELECT * FROM CampaignLeadsinfo where UserId = 'b7c23fa5-6cd3-4bcd-a036-f8bbb85ba760'

SELECT * FROM CampaignLeadsinfo

Columns

Name Type Description
AmaScore Integer Ama Score
BusinessEmail String Business Email
BusinessPhone String Business Phone
CompanyName String Company Name
ContactId String Contact Id
ContactName String Contact Name
Sends Integer Sends
TotalClicks Integer Total Clicks
TotalOpens Integer Total Opens
UniqueClicks Integer Unique Clicks
UniqueOpens Integer Unique Opens

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060