Query the available footer of the mail on your ActOn account.

Table Specific Information

Each email Footer present on you Act-On Account

Select

Get a list of Footers in the account:

SELECT * FROM Footer

INSERT

Add a new Footer to your account.

Note: The Title of the Footer must be unique. Fields Title, Text and HTML are required to create a record.

INSERT INTO Footer(Title, Text, HTML) VALUES('Test Value', 'hello', 'html text');

Update

Update the specified Footer.

Note: To update the Footer, the Id must be specified.

UPDATE Footer SET HTML = 'made some changes' where id=9;

Delete

Delete the specified Footer from your account.

Note: To Delete the Footer, the Id must be specified.

DELETE FROM Footer where id = 8

Columns