Please supply the username, password and API Key for Act-On in the Connector window:
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.
“Criteria” is passed directly to the REST API. ‘createdafter’ is in Epoch/Unix millisecond timestamp format.
A SELECT statement can consist of the following basic clauses.
The following syntax diagram outlines the syntax supported by the SQL engine of the provider:
Some input-only fields are available in SELECT statements. These fields, called pseudo columns, do not appear as regular columns in the results, yet may be specified as part of the WHERE clause. You can use pseudo columns to access additional features from Act-On.
SELECT * FROM Images WHERE Pseudo = '@Pseudo'
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
ACT! Premium Cloud: StarfishETL supports two-way integration. ACT! On-Prem: Starfish 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 (v18+) using ...
Overview The Starfish Pardot Connector uses the pardot v3 API. See http://developer.pardot.com/ for more information. Origin Where do I find my "API User Key"? In Pardot, hover over the gear icon in the upper right corner of the screen, click ...
Hubspot Connector Note: As of September 8, 2020 the Hubspot API does not allow external applications to write into their Quoting module. See below. Overview The StarfishETL Hubspot Connector enables you to easily connect to Hubspot for integrations ...
Salesforce Destination Be aware that if you are importing into a Salesforce Sandbox, the size is limited. If you import somewhere around 150,000 records, you will run out of space. You should only import what is necessary for testing. Standard Input ...
Creatio Connector Versions StarfishETL has two connector types for Creatio. OData: Allows for more complex querying. 4-6k records per hour Data Services: Faster than OData. Approx 30k records per hour Creatio (OData) Advanced Filtering Sometimes it ...