Start date for fetching the messages. Requests can specify a start date formatted as RRRR-MM-DD GG:MM:SS, RRRR-MM-DD GG:MM or RRRR-MM-DD

End date for fetching the messages. Requests can specify a start date formatted as RRRR-MM-DD GG:MM:SS, RRRR-MM-DD GG:MM or RRRR-MM-DD.
By default, it's 0:00 on the following day.

International phone format (without a "+" sign)

Sending time in ISO 8601 format. The message will be send at given time.

Additional identifier (on the client side).

Set only if your message contains non ASCII characters.

mProfi is a service that lets you send and receive SMS and more.

mProfi

We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.

**Highly recommended!** Usually you want the results to be most recent first so we can skim off only new results, so choose something like `date_created` or your autoincrement `id`. Column names that contain a space must be enclosed within brackets `[ ]`.

We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.

Query results must have a unique `id` field so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.

**Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows**

Usually something auto-incremented like `id`. Must be unique. Column names that contain a space must be enclosed within brackets `[ ]`.

Usually something like `date_updated` or `last_modified`. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.

Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.

You should include desired ordering and limiting (usually to 1 record) in the query.

**This query must run in less than ~30 seconds.**

MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.

MySQL

SQL server (or MS SQL) is a top of the line database geared for the cloud

SQL Server

Quickbase makes it easy to create custom applications and workflows to streamline processes, with IT visibility and control.

Quickbase

Firebase Realtime Database and Google Cloud Firestore are flexible databases that give you the ability to easily store and sync app data at global scale.

Firebase / Firestore

Amazon Relational Database Services (RDS) allow you to set up, operate, and scale relational databases in the cloud.

Amazon Relational Database Services (RDS)

Keeping your messages on your database automatically means you can query for them when needed. Set up this template, and whenever you receive a new SMS message on mProfi, a corresponding MySQL row will be added automatically.

mProfi + MySQL

Add new mProfi SMS messages as MySQL rows

Supported triggers and actions

Incoming SMS Message

New Column

New Row (Custom Query)

New or Updated Row

Update Row

Find Multiple Rows via Custom Query

Send SMS Message

New Row

New Table

New Row

Find Row

Find Row via Custom Query

About mProfi

Related categories

About MySQL

Related categories

Similar apps

SQL Server

Quickbase

Firebase / Firestore