Flow Tutorial 3 - Stock Ticker Information REST Lookup
This tutorial includes a video and documented time stamps to walk you through building an automation Flow that identifies stock ticker abbreviations from emails, finds the current price for the requested stocks, and replies to the original sender with the requested stock price information.
The Problem to Solve
You want to automatically respond to customers emailing requests for current stock prices.
Prerequisites
To follow along with this tutorial you will need to have:
- Email account
- IEX Cloud account
- Training materials
Video - Stock Ticker Information REST Lookup
Outline with Timestamps
The steps to complete for this tutorial are noted with timestamps to the video above:
| Time Stamp | Action |
|---|---|
| 00:00 | Introduction |
| 00:15 | Objectives |
| 01:04 | Send two stock price requests emails |
| 01:54 | Confirm emails arrived in inbox |
| 02:10 | Prerequisites |
| 02:28 | Log into IEX Cloud and review console |
| 02:59 | Review IEX API documentation |
| 03:33 | Log into Hero_Flow |
| 03:39 | Create Gmail IMAP Connection |
| 04:48 | Create Gmail SMTP Connection |
| 05:19 | Create a REST Connection to IEX Cloud |
| 05:55 | Create a Gmail (IMAP) Input |
| 07:13 | Start building the automated Flow |
| 07:27 | Add the Input (Gmail IMAP) in the Flow |
| 07:34 | Add the Flatten List function to change the email List value to a String value |
| 08:05 | Add the Constant String function to hold the IEX API token |
| 08:41 | Add the Contains function to scan the email subjects |
| 09:07 | Add the RegExtract function to extract the stock ticker abbreviations from the email bodies |
| 09:57 | Add the Concat function to be able to send the regex output to the REST Lookup as a String value |
| 10:37 | Add the ReplaceAll function to remove the parentheses from the stock ticker value to be used in the REST Lookup function |
| 11:45 | Add the REST Lookup function to request the stock ticker data |
| 14:33 | Add the Concat function to format the trade share size data from a Long value to a String value |
| 15:15 | Add the Concat function to format the price data from a Double value to a String value |
| 15:33 | Add the Multiple Constants function to bring the stock ticker data, price data, and size data together |
| 16:11 | Add the Concat function to combine the results from the IEX Cloud API with the String values (above) |
| 17:17 | Add the Aggregate function to create a String value of the data to send to the stock requester |
| 19:16 | Create a Gmail (SMTP) Output |
| 20:06 | Add the Output (Gmail SMTP) to the Flow |
| 21:38 | Run the Flow |
| 21:57 | Confirm automated response emails arrived to stock price requester's email inbox |