With over 3.5 billion active users, SMS (Short Message Service) is one of the most widely used data applications in the world. In the United States over 91% of adults own cell phone. Text messaging can be an incredibly useful way for delivering services and information to people.
So today, I’m going to show you how you can create a super simple light weight SMS application with just a few lines of code using Twilio, Lua, webscript.io, and Socrata’s Open Data API (SODA). Twilio is a wonderful service that provides a HTTP API that allows people to build quick and easy SMS & voice applications. Lua is lightweight scripting language and webscript.io is a service that allows simple webscripts written in Lua to run without the hassle of setting up and running servers i.e. no deployment.
In this example, we’ll build a web application that allows a person to text the name of a NYC restaurant to a phone number and will get in return restaurant inspection information for that restaurant (e.g. letter grade and score). For data we will be using live New York City restaurant inspection data from New York City’s Department of Health and Mental Hygiene powered by Socrata ‘s Open Data portal.
Next let’s add information from our Twilio API account
You can find account and authentication information by looking under your account in Twilio. Use the phone number you just created.
While we are here, let’s also add the URL we just created in webscript.io
Now for the fun part! Let’s go to NYC’s Open Data Portal and find our restaurant inspection data. The variables will focus on our DBA (Name of restaurant aka “Doing Business As”), Street, Grade (letter grade ranking e.g. A, B, C), and Score (points, higher points mean more violations). For reference: A (0-13 points); B (14-37 points); C (28 points or more)
To access this data will use Socrata’s Open Data API (SODA). Here is the API endpoint for this dataset.
We can use this endpoint to ask questions from data via the API. For example, let’s look up the restaurant “Momofuku Ko”. Type
in to your browser and you should get some data about the restaurant in json form.
So now let’s use this to get some data. When someone sends a text message to this phone number we want to check the name and look it up in the API.
To get the body of a text message received we use:
Now we can use this information to append to our API query and make an HTTP request.
Since we will be getting JSON back will need to parse the response to get the specific information we are look for e.g. name, street, grade, and score.
The json.parse function converts json into a Lua table which makes manipulating the data a little easier in Lua. For this example, I’ll make this simple and assume that the first match is the correct match and only use the first result returned (
rest = restaurants).
Note: If you were building something more sophisticated you might want to handle this interaction a little better. For example what about situations when you have two restaurants with the same name but different addresses (e.g. MCDONALD'S or WENDY'S).
Now let’s construct the message we will return to our user.
This string simply returns some text with the results concatenated together. Lua uses .. to concatenate strings (weird right?).
Now that we have our message let’s return it to our user by adding
We could stop there but I want to add some helpful information and do a little error handling so I’m going to make a few changes. I’ll add some if/else statements to add a few more features.
First, I’ll allow people to text “HELP ME” to get useful help information i.e.
then the message returned should be:
Second, I’ll return an error message if my request didn’t find anything i.e.
then message returned should be:
Now we can save our script in webscript.io and go back to Twilio to finish configuring everything. You’ll want to go back to your phone number in Twilio (under Number) and add the URL for webscript under SMS & MMS for Request URL. And finally, save your results.
Now try texting the number you created and watch the magic happen. If you don’t know a restaurant try using “MOMOFUKU KO”.
Congrats! You just created an SMS application with a few lines of code and a couple of dollars. If my script is still running you can try my example by texting a name to
If you want to see all of the code used for this example see my repository on GitHub. There are many improvements that can be made, so feel free to send me pull requests!