Gets contacts leads.

Table Specific Information

Select

The connector 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 connector processes other filters client-side within the connector. For example, the following queries are processed server side:

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

SELECT * FROM CampaignLeadsinfo

Columns