Integrate the Linkish API with the MySQL API

module.exports = defineComponent({
  props: {
    linkish: {
      type: "app",
      app: "linkish",
    }
  },
  async run({steps, $}) {
    const axios = require('axios');
    let access_token = "";
    
    // Card details
    let type = "link", // either "link" or "text"
    		url = "https://www.youtube.com/watch?v=dQw4w9WgXcQ", // required if "type" is "link"
    		title = "", // card title, if empty it will be scraped from "url"
    		description = "", // card description, if empty it will be scraped from "url"
    		thumbnail = "", // preview image URL, if empty it will be scraped from "url"
    		parent = "", // collections[index].id recieved from get-collection API
    		tags = []; // an array of strings, items can also have comma separated strings
    
    // Get access token based on the linkish API key
    return await axios({
    	method  : "POST", 
    	url: "https://api.linkish.io/get-token",
    	data : JSON.stringify({
    		"api_key": this.linkish.$auth.api_key
    	}),
    	headers: {
    		"Content-Type": "application/json",
    		"Accept": "application/json",
    	}
    }).then(async (response) => {
    
    	// Get collections based on the access token
    	access_token = response.data.token;
    	return await axios({
    		method  : "GET",
    		url: "https://api.linkish.io/get-collections",
    		headers: {
    			"Authorization": `Bearer ${access_token}`,
    		}
    	})
    
    }).then((response) => {
    
    	// Return the data as the step export
    	return response.data;
    
    }).then(async (collections) => {
    
    	// Change parent collection ID here or keep it empty for adding links to root collection
    	parent = collections[0].id;
    
    	// Save link in linkish dashboard
    	return await axios({
    		method  : "POST",
    		url: "https://api.linkish.io/save-link",
    		data : JSON.stringify({
    			"type": type,
    			"url": url,
    			"title": title,
    			"desc": description,
    			"thumbnail": thumbnail,
    			"parent": parent,
    			"tags": tags,
    		}),
    		headers: {
    			"Authorization": `Bearer ${access_token}`,
    			"Content-Type": "application/json",
    			"Accept": "application/json",
    		}
    	})
    
    }).then((response) => {
    
    	// Return the data as the step export
    	return response.data
    
    })
  },
})

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
    };
    return await this.mysql.executeQuery(queryObj);
  },
});