You can't use this until you register with us!

Description

Use HTML from MySQL to generate a PDF and send it to an e-mail address.

Purchasing Options

MySQL to PDF Creator - Email - $149.99 / month

Available Actions

Create PDF

Run the specified SQL Query against a MySQL database to obtain the HTML needed to create a PDF file, then send the file to the specified recipients via e-mail.

Variables

Source Parameters
target_db required

Credentials to use to access the MySQL Database.

html_sql required

SQL Query to retrieve the HTML code that will be used to create the content of the PDF file.

pointer required

Date and time where the processing of your sequentially sorted data should begin. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.

range_end_point_query

SQL query to use to determine the end point of the data to process.

user_params

Parameters to use in your SQL queries, if any. Refer to slide out help for more information.


PDF Parameters
pdf_config

Parameters to control the general structure of the PDF file created.

pdf_filename

Specify the name of the PDF file to create and attach to the e-mail. Can use dynamic values.


Email Parameters
smtp_connection required

Credentials to use to access the SMTP Server.

alt_from

If this field is blank, the e-mail address associated with the Username specified in the SMTP connection will be used.

to required

Addresses to place in the To field of the e-mail. Multiple values must be separated by commas.

cc

Addresses to place in the Cc field of the e-mail. Multiple values must be separated by commas.

bcc

Addresses to place in the Bcc field of the e-mail. Multiple values must be separated by commas.

subject required

Subject content of the email.

body

Body content of the email.