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

Description

Create a PDF using data from a MySQL database and store it in an S3 bucket.

Purchasing Options

MySQL to PDF Creator - S3 - $149.99 / month

Available Actions

Create PDF

Execute a query against MySQL database to find image URL's. Retrieve the images from the URL's and use them to create pages within a PDF file. Store the PDF file in a folder in an S3 bucket.

Variables

Source Parameters
target_db required

MySQL database where the query will be executed to find image URL's.

sql_query required

SQL Query to run. Result must be a single column containing URL strings.

pointer required

Datetime stamp indicating the starting point of data to use to gather images. 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.

post_sql_query

SQL Steps to run after the PDF file has been created.


Web Server Parameters
webserver_connection

Credentials to access the server hosting the images. Leave empty if not required.

signin_flow

Sign in flow to use.

proceed_on_error

Enable to continue with the PDF generation despite failure to retrieve an image.


Destination Parameters
aws_config required

AWS Access Keys to use to access the S3 bucket where the PDF file will be created.

iam_role

Optional. ARN of an IAM role to use for S3 bucket access.

s3_bucket_config required

Shared Config that contains information about the S3 Bucket where the PDF file will be created.

s3_folder_path

Path from the starting folder in the S3 Bucket Configuration to the folder where the PDF file will be created.

file_name required

Name for the PDF file that will be created.

append_date

Enable to append the creation date to the file name.

allow_overwrite

Enable to allow an existing file with the same name in the Target Folder to be overwritten.