Integrate the REIPro API with the MySQL API

The REIPro API provides a suite of tools designed for real estate investors and professionals, enabling access to a wealth of property data, lead management, and marketing campaign functionalities. Leveraging the REIPro API within Pipedream, users can automate multifaceted real estate tasks, from syncing property information to various platforms, managing leads effectively, to executing timely follow-ups and nurturing campaigns. The API's capabilities can be harnessed to streamline operations, improve data accuracy, and connect various stages of the real estate investment lifecycle for enhanced decision-making and efficiency.

Connect REIPro#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    reipro: {
      type: "app",
      app: "reipro",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.myreipro.com/api/VerifyApiKey`,
      params: {
        ApiKey: `${this.reipro.$auth.api_key}`,
      },
    })
  },
})

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;
  },
});