Zapier + MySQL tutorial

You may want to save hotspot customer's data to your database. In this example we show you how to add a new Mysql row whenever a new hotspot customer registers on your splash page.

What you need:

• Mysql database

• Zapier account

• HotspotSystem.com API key

You can start from this page and click on "Start Using This!" on the top right.

! Before you start.

Before you start, prepare a database that can receive data. We have prepared an SQL statement as a sample, you can run this and it will create the database.

CREATE TABLE IF NOT EXISTS `hotspot_customer` ( `customer_id` int(10) unsigned NOT NULL, `customer_name` varchar(64) COLLATE utf8_bin NOT NULL, `user_name` varchar(100) COLLATE utf8_bin NOT NULL, `email` varchar(254) COLLATE utf8_bin NOT NULL, `company_name` varchar(128) COLLATE utf8_bin NOT NULL, `address` varchar(256) COLLATE utf8_bin NOT NULL, `city` varchar(64) COLLATE utf8_bin NOT NULL, `state` varchar(64) COLLATE utf8_bin NOT NULL, `zip` varchar(16) COLLATE utf8_bin NOT NULL, `country_code` varchar(2) COLLATE utf8_bin NOT NULL, `phone` varchar(64) COLLATE utf8_bin NOT NULL, `registered_at` datetime NOT NULL, UNIQUE KEY `customer_id` (`customer_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

1. Choose a trigger and action

From the left side, choose HotspotSystem as the trigger. Choose "New Customer" to send a new data for every new customer. From the right side, choose Mysql and choose "New Row".

2. Add your HotspotSystem.com API Key

You can get your API key from the Control Center > Tools & Settings > API Keys.

3. Add connection details to your Mysql database

4. Set a Location filter (optional)

You may want to include customers from a specific location only. You can also use Locations Groups if you defined them in the Control Center. If you used an API Key which is created for a secondary operator, then only those customers will be added who register in those locations that are assigned to the secondary operator.

5. Select the table and match customer's data fields with Mysql row fields

6. You are done!