Query the available footer of the mail on your Act-On account.

Table Specific Information

Each email footer present on your 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. The 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