Integrate the Jotform API with the Columns Ai API

import { axios } from "@pipedream/platform"

export default defineComponent({
  props: {
    jotform: {
      type: "app",
      app: "jotform",
    }
  },
  methods: {
    _getBaseUrl() {
      let baseUrl = `https://${this.jotform.$auth.region}.jotform.com/`;
      const standardSubdomains = [
        "api",
        "eu-api",
        "hipaa-api",
      ];
      if (!standardSubdomains.includes(this.jotform.$auth.region)) {
        baseUrl += "API/";
      }
      return baseUrl;
    },
  },
  async run({steps, $}) {
    const baseUrl = this._getBaseUrl(); 
    return await axios($, {
      url: `${baseUrl}user`, 
      params: {
        apiKey: `${this.jotform.$auth.api_key}`,
      },
    })
  },
})

import { ChartType } from 'columns-graph-model';
import { Columns } from 'columns-sdk';

export default defineComponent({
  props: {
    columns_ai: {
      type: "app",
      app: "columns_ai",
    }
  },
  async run({steps, $}) {    
    const rows = [{
        "value": 312,
        "state": "WA",
        "parent": "US"
      }];// rows is an example data set where you should organize your data in a similar way.

    //Instantiates a Columns SDK object with your API Key.  
    const columns = new Columns(this.columns_ai.$auth.api_key);
    const data = columns.data(['state'], ['value'], rows);
    const graph = columns.graph(data);

    // switch to different chart types: BAR, PIE, DOUGHGUT, LINE, AREA, SCATTER, etc.
    graph.type = ChartType.COLUMN;

    // customise the graph (lots of options in its data model)
    graph.settings.general.palette = ['#ff0000', '#00ff00', '#0000ff'];
    graph.settings.general.background = '#00000002';
    
    return graph;          
  },
})