CData Python Connector for Act-On

Build 24.0.9062

List_MyList

Create, update, delete, and query records of a List.

Table Specific Information

Every list that is created in your Act-On account is represented by a new table that is dynamically retrieved from your Act-On account. The name of the table has the following format:

List_nameOfTheList

For example, if the list in the Act-On UI is called 'MyList', the name of the table in the driver would be 'List_MyList'.

This is an example on how a list is exposed as table.

Select

Query records of the specified table.:

SELECT * FROM [List_MyList]

INSERT

Create a new record in the table.

Note: The ListId is required to insert a new record into a table.

All the fields that are not read-only can be specified.

INSERT INTO [List_MyList] ([First Name], [Last Name], [E-mail Address], [ListId]) VALUES ('John', 'Doe', '[email protected]', 'l-000d')

Update

Update details of a specific record.

Note: To update a record from a table, the ListId and E-mail Address must be specified.

All the fields that are not read-only can be specified.

UPDATE [List_MyList] SET [First Name] = 'Mohit', [Last Name] = 'Chaturvedi', [E-mail Address] = '[email protected]' WHERE [ListId] = 'l-000d' AND [E-mail Address] = '[email protected]'

Upsert

Update details of a specific record if it exists, else will insert a new record.

Note: To upsert a record from a table, the ListId and E-mail Address must be specified.

All the fields that are not read-only can be specified.

UPSERT INTO [List_MyList] ([First Name], [Last Name], [E-mail Address], [ListId]) VALUES ('Shubham', 'Prakash', '[email protected]', 'l-000a')

Delete

Delete a record of a table.

Note: To Delete a record the ListId and _contact_id_ must be specified.

All the fields that are not read-only can be specified.

DELETE FROM List_MyList WHERE [ListId] = 'l-000d' AND [_contact_id_] = 'l-000d:10'

Columns

Name Type ReadOnly Description
_contact_id_ [KEY] String False

The _contact_id_ of the List_MyList.

First Name String False

The First Name of the List_MyList.

Last Name String False

The Last Name of the List_MyList.

E-mail Address String False

The E-mail Address of the List_MyList.

_FORM String False

The _FORM of the List_MyList.

_CAMPAIGN String False

The _CAMPAIGN of the List_MyList.

_IPADDR String False

The _IPADDR of the List_MyList.

_BROWSER String False

The _BROWSER of the List_MyList.

_JSTZO String False

The _JSTZO of the List_MyList.

_TIME String False

The _TIME of the List_MyList.

_REFERRER String False

The _REFERRER of the List_MyList.

_EMAIL_REFERRER String False

The _EMAIL_REFERRER of the List_MyList.

_FORM_URL String False

The _FORM_URL of the List_MyList.

_SEARCH String False

The _SEARCH of the List_MyList.

_GEO_NAME String False

The _GEO_NAME of the List_MyList.

_GEO_COUNTRY_CODE String False

The _GEO_COUNTRY_CODE of the List_MyList.

_GEO_COUNTRY String False

The _GEO_COUNTRY of the List_MyList.

_GEO_STATE String False

The _GEO_STATE of the List_MyList.

_GEO_CITY String False

The _GEO_CITY of the List_MyList.

_GEO_POSTAL_CODE String False

The _GEO_POSTAL_CODE of the List_MyList.

__created_date Datetime False

The __created_date of the List_MyList.

__modified_date Datetime False

The __modified_date of the List_MyList.

ListId String False

The ListId of the List_MyList.

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