← Typeform + Snowflake integrations

Insert Row with Snowflake API on New Submission from Typeform API

Pipedream makes it easy to connect APIs for Snowflake, Typeform and 1000+ other apps remarkably fast.

Trigger workflow on
New Submission from the Typeform API
Next, do this
Insert Row with the Snowflake API
No credit card required
Into to Pipedream
Watch us build a workflow
Watch us build a workflow
7 min
Watch now ➜
Trusted by 250,000+ developers from startups to Fortune 500 companies:
Trusted by 250,000+ developers from startups to Fortune 500 companies

Developers Pipedream

Getting Started

This integration creates a workflow with a Typeform trigger and Snowflake action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

  1. Select this integration
  2. Configure the New Submission trigger
    1. Connect your Typeform account
    2. Select a Form
  3. Configure the Insert Row action
    1. Connect your Snowflake account
    2. Select a Table Name
    3. Select one or more Columns
    4. Configure Values
  4. Deploy the workflow
  5. Send a test event to validate your setup
  6. Turn on the trigger

Details

This integration uses pre-built, open source components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger

Description:Emit new submission
Version:0.0.5
Key:typeform-new-submission

Typeform Overview

With the Typeform API, you can easily create beautiful, interactive forms that
allow people to share their information with you in an engaging way. Here are
some examples of what you can build with the Typeform API:

  • A contact form for your website that allows people to easily get in touch
    with you
  • An order form for your product or service that allows people to place orders
    easily and securely
  • A survey form that allows you to collect data and feedback from people
  • A registration form for your event or conference that allows people to sign
    up easily and securely

Trigger Code

import { createHmac } from "crypto";
import { uuid } from "uuidv4";
import common from "../common.mjs";
import constants from "../../constants.mjs";
import utils from "../utils.mjs";

const { typeform } = common.props;
const { parseIsoDate } = utils;

export default {
  ...common,
  key: "typeform-new-submission",
  name: "New Submission",
  version: "0.0.5",
  type: "source",
  description: "Emit new submission",
  props: {
    ...common.props,
    http: "$.interface.http",
    db: "$.service.db",
    formId: {
      propDefinition: [
        typeform,
        "formId",
      ],
    },
  },
  methods: {
    ...common.methods,
    generateSecret() {
      return "" + Math.random();
    },
  },
  hooks: {
    ...common.hooks,
    async activate() {
      const secret = this.generateSecret();
      this._setSecret(secret);

      let tag = this._getTag();
      if (!tag) {
        tag = uuid();
        this._setTag(tag);
      }

      return await this.typeform.createHook({
        endpoint: this.http.endpoint,
        formId: this.formId,
        tag,
        secret,
      });
    },
    async deactivate() {
      const tag = this._getTag();

      return await this.typeform.deleteHook({
        formId: this.formId,
        tag,
      });
    },
  },
  async run(event) {
    const {
      body,
      headers,
    } = event;

    const { [constants.TYPEFORM_SIGNATURE]: typeformSignature } = headers;

    if (typeformSignature) {
      const secret = this._getSecret();

      const hmac =
        createHmac(constants.ALGORITHM, secret)
          .update(body)
          .digest(constants.ENCODING);

      const signature = `${constants.ALGORITHM}=${hmac}`;

      if (typeformSignature !== signature) {
        throw new Error("signature mismatch");
      }
    }

    let formResponseString = "";
    const data = Object.assign({}, body.form_response);
    data.form_response_parsed = {};

    for (let i = 0; i < body.form_response.answers.length; i++) {
      const field = body.form_response.definition.fields[i];
      const answer = body.form_response.answers[i];

      let parsedAnswer;
      let value = answer[answer.type];

      if (value.label) {
        parsedAnswer = value.label;

      } else if (value.labels) {
        parsedAnswer = value.labels.join();

      } else if (value.choice) {
        parsedAnswer = value.choice;

      } else if (value.choices) {
        parsedAnswer = value.choices.join();

      } else {
        parsedAnswer = value;
      }

      data.form_response_parsed[field.title] = parsedAnswer;
      formResponseString += `### ${field.title}\n${parsedAnswer}\n`;
    }

    data.form_response_string = formResponseString;
    data.raw_webhook_event = body;

    if (data.landed_at) {
      data.landed_at = parseIsoDate(data.landed_at);
    }

    if (data.submitted_at) {
      data.submitted_at = parseIsoDate(data.submitted_at);
    }

    data.form_title = body.form_response.definition.title;
    delete data.answers;
    delete data.definition;

    this.$emit(data, {
      summary: JSON.stringify(data),
      id: data.token,
    });
  },
};

Trigger Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.
LabelPropTypeDescription
TypeformtypeformappThis component uses the Typeform app.
N/Ahttp$.interface.httpThis component uses $.interface.http to generate a unique URL when the component is first instantiated. Each request to the URL will trigger the run() method of the component.
N/Adb$.service.dbThis component uses $.service.db to maintain state between component invocations.
FormformIdstringSelect a value from the drop down menu.

Trigger Authentication

Typeform uses OAuth authentication. When you connect your Typeform account, Pipedream will open a popup window where you can sign into Typeform and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Typeform API.

Pipedream requests the following authorization scopes when you connect your account:

offlineaccounts:readforms:writeforms:readimages:writeimages:readthemes:writethemes:readresponses:readresponses:writewebhooks:readwebhooks:writeworkspaces:readworkspaces:write

About Typeform

People-Friendly Forms and Surveys

Action

Description:Insert a row into a table
Version:0.0.1
Key:snowflake-insert-row

Action Code

import snowflake from "../../snowflake.app.mjs";
import { ConfigurationError } from "@pipedream/platform";

export default {
  type: "action",
  key: "snowflake-insert-row",
  name: "Insert Row",
  description: "Insert a row into a table",
  version: "0.0.1",
  props: {
    snowflake,
    tableName: {
      propDefinition: [
        snowflake,
        "tableName",
      ],
      description: "The name of the table to insert a new row",
    },
    columns: {
      propDefinition: [
        snowflake,
        "columns",
        (c) => ({
          tableName: c.tableName,
        }),
      ],
    },
    values: {
      propDefinition: [
        snowflake,
        "values",
      ],
    },
  },
  async run({ $ }) {
    if (this.columns.length !== this.values.length) {
      throw new ConfigurationError("`Columns` length is different than `Values` length");
    }

    const response = await this.snowflake.insertRow(this.tableName, this.columns, this.values);
    $.export("$summary", `Sucessfully inserted row to ${this.tableName} table`);
    return response;
  },
};

Action Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

LabelPropTypeDescription
SnowflakesnowflakeappThis component uses the Snowflake app.
Table NametableNamestringSelect a value from the drop down menu.
Columnscolumnsstring[]Select a value from the drop down menu.
Valuesvaluesstring[]

Insert values for the selected columns respectively. For string values, wrap them in single quotes. Example: 'This is a string'

Action Authentication

Snowflake uses API keys for authentication. When you connect your Snowflake account, Pipedream securely stores the keys so you can easily authenticate to Snowflake APIs in both code and no-code steps.

  1. Enter the username, password, and other details for your Snowflake database below. We recommend you create a read-only account if you only need to query Snowflake.

  2. Enter your Snowflake account identifier in the account field. You may need to include the full identifier and region as a part of this string, e.g. au12345.us-east-1. Please consult your instance and Snowflake docs for more detail.

About Snowflake

A data warehouse built for the cloud

More Ways to Connect Snowflake + Typeform

Create a Form with Typeform API on Query Results from Snowflake API
Snowflake + Typeform
 
Try it
Create a Form with Typeform API on New Row from Snowflake API
Snowflake + Typeform
 
Try it
Create an Image with Typeform API on Query Results from Snowflake API
Snowflake + Typeform
 
Try it
Create an Image with Typeform API on New Row from Snowflake API
Snowflake + Typeform
 
Try it
Delete Form with Typeform API on Query Results from Snowflake API
Snowflake + Typeform
 
Try it
New Submission from the Typeform API

Emit new submission

 
Try it
New Query Results from the Snowflake API

Emit new event with the results of an arbitrary query

 
Try it
New Row from the Snowflake API

Emit new event when a row is added to a table

 
Try it
Create a Form with the Typeform API

Creates a form with its corresponing fields. See the docs here

 
Try it
Create an Image with the Typeform API

Adds an image in your Typeform account. See the docs here

 
Try it
Delete an Image with the Typeform API

Deletes an image from your Typeform account. See the docs here

 
Try it
Delete Form with the Typeform API

Select a form to be deleted. See the docs here.

 
Try it
Duplicate a Form with the Typeform API

Duplicates an existing form in your Typeform account and adds "(copy)" to the end of the title. See the docs here

 
Try it