Reading Messages Sent Using Twilio Programmable SMS Service

In this example we use the Twilio Read Snap to retrieve messages sent with Programmable SMS services based on certain filter parameters and pagination options. This example assumes that you have configured and authorized a valid Twilio Account (see Configure Twilio Accounts).


Twilio Read messages pipeline overview

Download this pipeline.
  1. Configure the Twilio Read Snap with the following settings to filter messages by phone number and date sent.

    We want to view these messages in two pages:

    • API object: Programmable SMS
    • Entity: Messages
    • Filter criteria: Messages sent from $Phone_number and messages sent on date 2020-03-10T10:00-20:00
    • Page size: 2
    • Next URL: $original.Host+$next_page_url

    Twilio Read Snap configuration
  2. Validate the Snap to view the results.

    A successful validation of this Snap generates a JSON array containing each page as an independent JSON object. Expand one of the JSON objects and observe 2 messages present in the $messages array as specified in the Page Size field.

    Also, note that there are 5 pages in total, with their page indexes marked under the $page node.

  3. Configure the Router Snap to bifurcate the pages into two different output views.

    Route the first two pages to the first output view and the remaining pages to the second output view.


    Router Snap configuration for page routing
  4. Add the JSON Formatter and XML Formatter Snaps.

    Connect these Snaps to the Router Snap where the diverted output ends.

  5. Add File Writer Snaps to write the outputs to files.

    Write the two outputs into files in different formats (XML and JSON).

  6. Run the pipeline.

    On successful execution, you will see two files with the corresponding names in the Project space.


    Output files in Project space

To reuse this pipeline in your environment:

  1. Download and import the Pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Update the Filter criteria with your phone number and date range.
  4. Adjust the Page size and routing logic as needed.