Planning a January Trip: Flight Prices and API Integration

•

Yesterday, we started planning our January trip. We will add another field to the table, the airport code, convert it to an AI field, and remove the quotes. Now let's see about flight prices. Using @serp_api, you get a 100 free API searches, and they include Google Flights!

We can create a command to use the @serp_api in @tana_inc to look up flight prices. First, add a node "Get flight prices", convert it to a command node, and add a "Make API call" command. Add a flight price field to the table and set it as the target.

Note that I added the the names of the fields in the URL as parameters using the same format as we use in title expressions. I also used a trick, when you add ${secret:NAME}, it will store the secret in your settings, so you can reuse it later on.

I put the date and departure date hardcoded in the URL for now. And when we run the command on all of the nodes in our proposed cities. Most worked, one didn't, but we can ignore that for now. Now, create another quick AI command to extract the number and we are done.

This is much faster than going into Google Flights myself and checking all the prices, plus when I change something, I can update it all. Naturally, you can build upon this and make it much more fancy if you want :)