Exporting Submissions with a Webhook URL

This is a Pro-only feature powered by a plugin that's disabled by default. Enable it first:

Log into your Joomla backend.
Go to System → Manage → Plugins.
Search for Convert Forms - Submissions Exporter.
Click the toggle in the Status column to enable the plugin.

export subnmissio 2

Using the Webhook URL

To export form submissions, you need to visit the following URL:

http://site.com/index.php?option=com_convertforms&task=cron&command=exportsubmissions

URL Parameters

Below you can find a list with the supported parameters you can use in the webhook URL to customize the export of your submissions further.

Name	Description
secret (required)	The Secret Key set in the Security tab on the Convert Forms configuration page.
form_id (required)	The ID of the form to export form submissions
filter_period	Select submissions created on a certain period or date range. Accepts: today, yesterday, this_week, this_month, this_year, last_week, last_month, last_year, daterange. Note: All submissions will be exported if no filter period is given.
filter_created_from	Select submissions created on or after a specific date. The expected date format is Y-m-d. Note: To use this option, you must pass filter_period=daterange.
filter_created_to	Select submissions created on or before a specific date. The expected date format is Y-m-d. Note: To use this option, you must pass filter_period=daterange.
filter_search	Select submissions that contain the given search term.
filter_timezone	By default, all submissions are exported with respect to your site's configured timezone. To export them in UTC time you can use filter_timezone=UTC.
columns	The columns to include in the file, passed as an array. They appear in the exported file in the order you list them: columns[]=id&columns[]=created&columns[]=email. Omit this to export the form's default columns (every core column plus all of the form's fields). Accepts: core columns (id, created, modified, form_id, form_name, status, status_label), your form's field names in lowercase (e.g. email, name, message), and submission detail columns (ip, country_code, country_name, device, browser, os, page_title, source_url, referrer_url, user_agent, visitor_id, user_id, notes, utm_source, utm_medium, utm_campaign).
export_type	Set whether to export submissions to a CSV or JSON file. Accepts: json, csv. Defaults to csv
export_append	If set to true and the export file already contains data, the submissions will be appended. Defaults to false.
export_path	The path relative to your site's root directory where to store the export file. It defaults to Joomla's temp directory, usually set to the /tmp/ folder in your site's root directory.
download	Set to true to force the download of the export file. The file is automatically deleted after download.

Examples

Select form #2 submissions received this year and export them to a CSV file.

http://site.com/index.php?option=com_convertforms&task=cron&command=exportsubmissions&secret=123&form_id=2&filter_period=this_year

Select form #3 submissions received today and export them to a JSON file.

http://site.com/index.php?option=com_convertforms&task=cron&command=exportsubmissions&secret=123&form_id=3&filter_period=today&export_type=json

Select form #1 submissions based on a custom date range and export them to a CSV file.

http://site.com/index.php?option=com_convertforms&task=cron&command=exportsubmissions&secret=123&form_id=1&filter_period=daterange&filter_created_from=2022-10-01&filter_created_to=2022-10-30

Select form submissions containing the keyword "apple" were received this week.

http://site.com/index.php?option=com_convertforms&task=cron&command=exportsubmissions&secret=123&form_id=1&filter_search=apple&filter_period=this_week

Download this month's form submissions.

http://site.com/index.php?option=com_convertforms&task=cron&command=exportsubmissions&secret=123&form_id=2&filter_period=this_month&download=1

Select today's submissions and convert their timestamps to the UTC timezone.

http://site.com/index.php?option=com_convertforms&task=cron&command=exportsubmissions&secret=123&form_id=2&filter_period=today&filter_timezone=UTC

Export form #2 submissions for this year, including only the ID, submission date, and the email and name fields.

http://site.com/index.php?option=com_convertforms&task=cron&command=exportsubmissions&secret=123&form_id=2&filter_period=this_year&columns[]=id&columns[]=created&columns[]=email&columns[]=name