Act-On Connector

Act-On Connector

Connecting to Act-On

Please read the instructions to obtain your API Key and API call limitations here:  https://developer.act-on.com/provision/
Please supply the username, password and API Key for Act-On in the Connector window:



Contacts

To read from Contacts, it seems that you have to pass in the list id and/or(?) contact id. Please check out the documentation to get this to work. If you think it should work differently, please let us know.

Filters

“Criteria” is passed directly to the REST API. ‘createdafter’ is in Epoch/Unix millisecond timestamp format.
Act-On Origin Filter Criteria.png


SELECT Statements

A SELECT statement can consist of the following basic clauses.

  • SELECT
  • INTO
  • FROM
  • JOIN
  • WHERE
  • GROUP BY
  • HAVING
  • UNION
  • ORDER BY
  • LIMIT

SELECT Syntax

The following syntax diagram outlines the syntax supported by the SQL engine of the provider:

SELECT {
  [ TOP <numeric_literal> | DISTINCT ]
  {
    *
    | {
        <expression> [ [ AS ] <column_reference> ]
        | { <table_name> | <correlation_name> } .*
      } [ , ... ]
  }
  [ INTO csv:// [ filename= ] <file_path> [ ;delimiter=tab ] ]
  {
    FROM <table_reference> [ [ AS ] <identifier> ]
  } [ , ... ]
  [ [ 
      INNER | { { LEFT | RIGHT | FULL } [ OUTER ] }
    ] JOIN <table_reference> [ ON <search_condition> ] [ [ AS ] <identifier> ]
  ] [ ... ]
  [ WHERE <search_condition> ]
  [ GROUP BY <column_reference> [ , ... ]
  [ HAVING <search_condition> ]
  [ UNION [ ALL ] <select_statement> ]
  [
    ORDER BY
    <column_reference> [ ASC | DESC ] [ NULLS FIRST | NULLS LAST ]
  ]
  [
    LIMIT <expression>

    • Related Articles

    • Act! Connector

      ACT! Premium Cloud: Connect Creatio supports two-way integration. ACT! On-Prem: Connect Creatio does not have a native Act! connector for versions less than Act v18 so we read directly from the database. Configuration Options Connect Act Premium ...

    • Pardot Connector

      Additional Documentation This Connector is based on the Salesforce Pardot ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/GPG/ado/ Overview The Creatio Connect Pardot ...

    • Salesforce Connector

      Additional Documentation This Connector is based on the Salesforce ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RFG/ado/ Salesforce Origin Case as Origin Table You ...

    • SugarCRM REST Connector

        SugarCRM REST Origin Use JSONLint to validate JSON: https://jsonlint.com/. Sample Origin Filters See the GET /<module> filterList in the SugarCRM REST Help: https://SERVER/rest/v10/help/ Note the [{...}] surrounding the filter. This is required. ...

    • Stripe Connector

      Additional Documentation This Connector is based on the Stripe ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/BOG/ado/