MySQL

Open-source relational database

Go to site

Integrate the MySQL API with the SWAPI - Star Wars API

Setup the MySQL API trigger to run a workflow which integrates with the SWAPI - Star Wars API. Pipedream's integration platform allows you to integrate MySQL and SWAPI - Star Wars remarkably fast. Free for developers.

Return Random Character Name
 
Try it
Get People Resource

A people resource is an individual person or character within the Star Wars universe.

 
Try it
Get Film Resource

A film resource is a single film.

 
Try it
Get Planet Resource

A Planet resource is a large mass, planet or planetoid in the Star Wars Universe, at the time of 0 ABY.

 
Try it
Get Species Resource

A Species resource is a type of person or character within the Star Wars Universe.

 
Try it

Connect MySQL

const mysql = require('mysql2/promise');

const { host, port, username, password, database } = auths.mysql

const connection = await mysql.createConnection({
  host,
  port,
  user: username,
  password,
  database,
});

const [rows, fields] = await connection.execute('SELECT NOW()');
console.log(rows)

Connect SWAPI - Star Wars

return await require("@pipedreamhq/platform").axios(this, {
  url: `https://swapi.dev/api/films/1/`,
})