Integrate the The Owen Wilson Wow API with the MySQL API

The Owen Wilson Wow API is an open-source library providing access to hundreds
of Owen Wilson's classic Wow quotes. This library is perfect for any project
that needs a pinch of Owen Wilson’s humor or a quick pick-me-up. You can
generate a unique quote with just one simple API call.

What You Can Build Using the Owen Wilson Wow API?

Here are some of the ideas you can build using the Owen Wilson Wow API:

Create a browser extension or plugin that adds Owen Wilson's famous Wows to
webpages.
Create a mobile app that provides random Wow quotes for a quick pick-me-up.
Create a chatbot that serves up Owen Wilson Wows in response to user input.
Create a game where users can compete to guess the original movie from a
particular Owen Wilson Wow quote.
Add a daily Wow message to your company's Slack channel.

Connect The Owen Wilson Wow#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    owen_wilson: {
      type: "app",
      app: "owen_wilson",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://owen-wilson-wow-api.herokuapp.com/wows/random`,
    })
  },
})

Overview of MySQL#

The MySQL application on Pipedream enables direct interaction with your MySQL databases, allowing you to perform CRUD operations—create, read, update, delete—on your data with ease. You can leverage these capabilities to automate data synchronization, report generation, and event-based triggers that kick off workflows in other apps. With Pipedream's serverless platform, you can connect MySQL to hundreds of other services without managing infrastructure, crafting complex code, or handling authentication.

Connect MySQL#

import mysql from '@pipedream/mysql';

export default defineComponent({
  props: {
    mysql,
  },
  async run({steps, $}) {
    // Component source code:
    // https://github.com/PipedreamHQ/pipedream/tree/master/components/mysql

    const queryObj = {
      sql: "SELECT NOW()",
      values: [], // Ignored since query does not contain placeholders
    };
    const { rows } = await this.mysql.executeQuery(queryObj);
    return rows;
  },
});