Create a Parcel with Sendcloud API on New Role from Snowflake API

Pipedream makes it easy to connect APIs for Sendcloud, Snowflake and 2,400+ other apps remarkably fast.

Trigger workflow on

New Role from the Snowflake API

Next, do this

Create a Parcel with the Sendcloud API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

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

Select this integration
Configure the New Role trigger
1. Connect your Snowflake account
2. Configure timer
Configure the Create a Parcel action
1. Connect your Sendcloud account
2. Configure Name
3. Configure Address
4. Configure City
5. Configure House Number
6. Configure Postal Code
7. Select a country
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Details#

This integration uses pre-built, source-available 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#

New Role on Snowflake

Description:Emit new event when a role is created

Version:0.1.2

Key:snowflake-new-role

View on GitHub

Snowflake Overview#

Snowflake offers a cloud database and related tools to help developers create robust, secure, and scalable data warehouses. See Snowflake's Key Concepts & Architecture.

Getting Started

1. Create a user, role and warehouse in Snowflake

Snowflake recommends you create a new user, role, and warehouse when you integrate a third-party tool like Pipedream. This way, you can control permissions via the user / role, and separate Pipedream compute and costs with the warehouse. You can do this directly in the Snowflake UI.

We recommend you create a read-only account if you only need to query Snowflake. If you need to insert data into Snowflake, add permissions on the appropriate objects after you create your user.

2. Enter those details in Pipedream

Visit https://pipedream.com/accounts. Click the button to Connect an App. Enter the required Snowflake account data.

You'll only need to connect your account once in Pipedream. You can connect this account to multiple workflows to run queries against Snowflake, insert data, and more.

3. Build your first workflow

Visit https://pipedream.com/new to build your first workflow. Pipedream workflows let you connect Snowflake with 1,000+ other apps. You can trigger workflows on Snowflake queries, sending results to Slack, Google Sheets, or any app that exposes an API. Or you can accept data from another app, transform it with Python, Node.js, Go or Bash code, and insert it into Snowflake.

Learn more at Pipedream University.

Trigger Code#

import common from "../common.mjs";

export default {
  ...common,
  type: "source",
  key: "snowflake-new-role",
  name: "New Role",
  description: "Emit new event when a role is created",
  version: "0.1.2",
  methods: {
    ...common.methods,
    alwaysRunInSingleProcessMode() {
      return true;
    },
    generateMeta({
      row,
      timestamp: ts,
    }) {
      return {
        id: row.name,
        summary: row.name,
        ts,
      };
    },
    getStatement() {
      return {
        sqlText: "show roles",
      };
    },
  },
};

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.

Label	Prop	Type	Description
Snowflake	`snowflake`	`app`	This component uses the Snowflake app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`	Watch for changes on this schedule

Trigger 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.

We recommend you create a read-only account if you only need to query Snowflake. If you need to insert data into Snowflake, add permissions on the appropriate objects after you create your user.

About Snowflake#

A data warehouse built for the cloud

Action#

Create a Parcel on Sendcloud

Description:Creates a new parcel under your Sendcloud API credentials. [See the documentation](https://api.sendcloud.dev/docs/sendcloud-public-api/parcels/operations/create-a-parcel)

Version:0.0.1

Key:sendcloud-create-a-parcel

View on GitHub

Sendcloud Overview#

The Sendcloud API offers a suite of tools for streamlining shipping processes for e-commerce businesses. Using the API, you can create and manage shipments, print shipping labels, track packages, and handle returns with ease. When integrated with Pipedream, the Sendcloud API enables you to automate your shipping workflow, connect with other apps and services, and create custom notifications and actions based on shipping events.

Action Code#

import app from "../../sendcloud.app.mjs";

export default {
  key: "sendcloud-create-a-parcel",
  name: "Create a Parcel",
  description: "Creates a new parcel under your Sendcloud API credentials. [See the documentation](https://api.sendcloud.dev/docs/sendcloud-public-api/parcels/operations/create-a-parcel)",
  version: "0.0.1",
  type: "action",
  props: {
    app,
    name: {
      propDefinition: [
        app,
        "name",
      ],
    },
    address: {
      propDefinition: [
        app,
        "address",
      ],
    },
    city: {
      propDefinition: [
        app,
        "city",
      ],
    },
    houseNumber: {
      propDefinition: [
        app,
        "houseNumber",
      ],
    },
    postalCode: {
      propDefinition: [
        app,
        "postalCode",
      ],
    },
    country: {
      propDefinition: [
        app,
        "country",
      ],
    },
  },
  async run({ $ }) {
    const response = await this.app.createParcel({
      $,
      data: {
        parcel: {
          name: this.name,
          address: this.address,
          city: this.city,
          house_number: this.houseNumber,
          postal_code: this.postalCode,
          country: this.country,
        },
      },
    });

    $.export("$summary", `Successfully created parcel with ID: ${response.parcel.id}`);

    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.

Label	Prop	Type	Description
Sendcloud	`app`	`app`	This component uses the Sendcloud app.
Name	`name`	`string`	Name of the recipient
Address	`address`	`string`	Address of the recipient
City	`city`	`string`	City of the recipient
House Number	`houseNumber`	`string`	House number of the recipient
Postal Code	`postalCode`	`string`	Zip code of the recipient
country	`country`	`string`	Select a value from the drop down menu:`{ "label": "Andorra", "value": "AD" }{ "label": "United Arab Emirates", "value": "AE" }{ "label": "Afghanistan", "value": "AF" }{ "label": "Antigua and Barbuda", "value": "AG" }{ "label": "Anguilla", "value": "AI" }{ "label": "Albania", "value": "AL" }{ "label": "Armenia", "value": "AM" }{ "label": "Angola", "value": "AO" }{ "label": "Antarctica", "value": "AQ" }{ "label": "Argentina", "value": "AR" }{ "label": "American Samoa", "value": "AS" }{ "label": "Austria", "value": "AT" }{ "label": "Australia", "value": "AU" }{ "label": "Aruba", "value": "AW" }{ "label": "Åland Islands", "value": "AX" }{ "label": "Azerbaijan", "value": "AZ" }{ "label": "Bosnia and Herzegovina", "value": "BA" }{ "label": "Barbados", "value": "BB" }{ "label": "Bangladesh", "value": "BD" }{ "label": "Belgium", "value": "BE" }{ "label": "Burkina Faso", "value": "BF" }{ "label": "Bulgaria", "value": "BG" }{ "label": "Bahrain", "value": "BH" }{ "label": "Burundi", "value": "BI" }{ "label": "Benin", "value": "BJ" }{ "label": "Saint Barthélemy", "value": "BL" }{ "label": "Bermuda", "value": "BM" }{ "label": "Brunei Darussalam", "value": "BN" }{ "label": "Bolivia, Plurinational State of", "value": "BO" }{ "label": "Bonaire, Sint Eustatius and Saba", "value": "BQ" }{ "label": "Brazil", "value": "BR" }{ "label": "Bahamas", "value": "BS" }{ "label": "Bhutan", "value": "BT" }{ "label": "Bouvet Island", "value": "BV" }{ "label": "Botswana", "value": "BW" }{ "label": "Belarus", "value": "BY" }{ "label": "Belize", "value": "BZ" }{ "label": "Canada", "value": "CA" }{ "label": "Cocos (Keeling) Islands", "value": "CC" }{ "label": "Congo, Democratic Republic of the", "value": "CD" }{ "label": "Central African Republic", "value": "CF" }{ "label": "Congo", "value": "CG" }{ "label": "Switzerland", "value": "CH" }{ "label": "Côte d'Ivoire", "value": "CI" }{ "label": "Cook Islands", "value": "CK" }{ "label": "Chile", "value": "CL" }{ "label": "Cameroon", "value": "CM" }{ "label": "China", "value": "CN" }{ "label": "Colombia", "value": "CO" }{ "label": "Costa Rica", "value": "CR" }{ "label": "Cuba", "value": "CU" }{ "label": "Cabo Verde", "value": "CV" }{ "label": "Curaçao", "value": "CW" }{ "label": "Christmas Island", "value": "CX" }{ "label": "Cyprus", "value": "CY" }{ "label": "Czechia", "value": "CZ" }{ "label": "Germany", "value": "DE" }{ "label": "Djibouti", "value": "DJ" }{ "label": "Denmark", "value": "DK" }{ "label": "Dominica", "value": "DM" }{ "label": "Dominican Republic", "value": "DO" }{ "label": "Algeria", "value": "DZ" }{ "label": "Ecuador", "value": "EC" }{ "label": "Estonia", "value": "EE" }{ "label": "Egypt", "value": "EG" }{ "label": "Western Sahara", "value": "EH" }{ "label": "Eritrea", "value": "ER" }{ "label": "Spain", "value": "ES" }{ "label": "Ethiopia", "value": "ET" }{ "label": "Finland", "value": "FI" }{ "label": "Fiji", "value": "FJ" }{ "label": "Falkland Islands (Malvinas)", "value": "FK" }{ "label": "Micronesia, Federated States of", "value": "FM" }{ "label": "Faroe Islands", "value": "FO" }{ "label": "France", "value": "FR" }{ "label": "Gabon", "value": "GA" }{ "label": "United Kingdom of Great Britain and Northern Ireland", "value": "GB" }{ "label": "Grenada", "value": "GD" }{ "label": "Georgia", "value": "GE" }{ "label": "French Guiana", "value": "GF" }{ "label": "Guernsey", "value": "GG" }{ "label": "Ghana", "value": "GH" }{ "label": "Gibraltar", "value": "GI" }{ "label": "Greenland", "value": "GL" }{ "label": "Gambia", "value": "GM" }{ "label": "Guinea", "value": "GN" }{ "label": "Guadeloupe", "value": "GP" }{ "label": "Equatorial Guinea", "value": "GQ" }{ "label": "Greece", "value": "GR" }{ "label": "South Georgia and the South Sandwich Islands", "value": "GS" }{ "label": "Guatemala", "value": "GT" }{ "label": "Guam", "value": "GU" }{ "label": "Guinea-Bissau", "value": "GW" }{ "label": "Guyana", "value": "GY" }{ "label": "Hong Kong", "value": "HK" }{ "label": "Heard Island and McDonald Islands", "value": "HM" }{ "label": "Honduras", "value": "HN" }{ "label": "Croatia", "value": "HR" }{ "label": "Haiti", "value": "HT" }{ "label": "Hungary", "value": "HU" }{ "label": "Indonesia", "value": "ID" }{ "label": "Ireland", "value": "IE" }{ "label": "Israel", "value": "IL" }{ "label": "Isle of Man", "value": "IM" }{ "label": "India", "value": "IN" }{ "label": "British Indian Ocean Territory", "value": "IO" }{ "label": "Iraq", "value": "IQ" }{ "label": "Iran, Islamic Republic of", "value": "IR" }{ "label": "Iceland", "value": "IS" }{ "label": "Italy", "value": "IT" }{ "label": "Jersey", "value": "JE" }{ "label": "Jamaica", "value": "JM" }{ "label": "Jordan", "value": "JO" }{ "label": "Japan", "value": "JP" }{ "label": "Kenya", "value": "KE" }{ "label": "Kyrgyzstan", "value": "KG" }{ "label": "Cambodia", "value": "KH" }{ "label": "Kiribati", "value": "KI" }{ "label": "Comoros", "value": "KM" }{ "label": "Saint Kitts and Nevis", "value": "KN" }{ "label": "Korea, Democratic People's Republic of", "value": "KP" }{ "label": "Korea, Republic of", "value": "KR" }{ "label": "Kuwait", "value": "KW" }{ "label": "Cayman Islands", "value": "KY" }{ "label": "Kazakhstan", "value": "KZ" }{ "label": "Lao People's Democratic Republic", "value": "LA" }{ "label": "Lebanon", "value": "LB" }{ "label": "Saint Lucia", "value": "LC" }{ "label": "Liechtenstein", "value": "LI" }{ "label": "Sri Lanka", "value": "LK" }{ "label": "Liberia", "value": "LR" }{ "label": "Lesotho", "value": "LS" }{ "label": "Lithuania", "value": "LT" }{ "label": "Luxembourg", "value": "LU" }{ "label": "Latvia", "value": "LV" }{ "label": "Libya", "value": "LY" }{ "label": "Morocco", "value": "MA" }{ "label": "Monaco", "value": "MC" }{ "label": "Moldova, Republic of", "value": "MD" }{ "label": "Montenegro", "value": "ME" }{ "label": "Saint Martin (French part)", "value": "MF" }{ "label": "Madagascar", "value": "MG" }{ "label": "Marshall Islands", "value": "MH" }{ "label": "North Macedonia", "value": "MK" }{ "label": "Mali", "value": "ML" }{ "label": "Myanmar", "value": "MM" }{ "label": "Mongolia", "value": "MN" }{ "label": "Macao", "value": "MO" }{ "label": "Northern Mariana Islands", "value": "MP" }{ "label": "Martinique", "value": "MQ" }{ "label": "Mauritania", "value": "MR" }{ "label": "Montserrat", "value": "MS" }{ "label": "Malta", "value": "MT" }{ "label": "Mauritius", "value": "MU" }{ "label": "Maldives", "value": "MV" }{ "label": "Malawi", "value": "MW" }{ "label": "Mexico", "value": "MX" }{ "label": "Malaysia", "value": "MY" }{ "label": "Mozambique", "value": "MZ" }{ "label": "Namibia", "value": "NA" }{ "label": "New Caledonia", "value": "NC" }{ "label": "Niger", "value": "NE" }{ "label": "Norfolk Island", "value": "NF" }{ "label": "Nigeria", "value": "NG" }{ "label": "Nicaragua", "value": "NI" }{ "label": "Netherlands, Kingdom of the", "value": "NL" }{ "label": "Norway", "value": "NO" }{ "label": "Nepal", "value": "NP" }{ "label": "Nauru", "value": "NR" }{ "label": "Niue", "value": "NU" }{ "label": "New Zealand", "value": "NZ" }{ "label": "Oman", "value": "OM" }{ "label": "Panama", "value": "PA" }{ "label": "Peru", "value": "PE" }{ "label": "French Polynesia", "value": "PF" }{ "label": "Papua New Guinea", "value": "PG" }{ "label": "Philippines", "value": "PH" }{ "label": "Pakistan", "value": "PK" }{ "label": "Poland", "value": "PL" }{ "label": "Saint Pierre and Miquelon", "value": "PM" }{ "label": "Pitcairn", "value": "PN" }{ "label": "Puerto Rico", "value": "PR" }{ "label": "Palestine, State of", "value": "PS" }{ "label": "Portugal", "value": "PT" }{ "label": "Palau", "value": "PW" }{ "label": "Paraguay", "value": "PY" }{ "label": "Qatar", "value": "QA" }{ "label": "Réunion", "value": "RE" }{ "label": "Romania", "value": "RO" }{ "label": "Serbia", "value": "RS" }{ "label": "Russian Federation", "value": "RU" }{ "label": "Rwanda", "value": "RW" }{ "label": "Saudi Arabia", "value": "SA" }{ "label": "Solomon Islands", "value": "SB" }{ "label": "Seychelles", "value": "SC" }{ "label": "Sudan", "value": "SD" }{ "label": "Sweden", "value": "SE" }{ "label": "Singapore", "value": "SG" }{ "label": "Saint Helena, Ascension and Tristan da Cunha", "value": "SH" }{ "label": "Slovenia", "value": "SI" }{ "label": "Svalbard and Jan Mayen", "value": "SJ" }{ "label": "Slovakia", "value": "SK" }{ "label": "Sierra Leone", "value": "SL" }{ "label": "San Marino", "value": "SM" }{ "label": "Senegal", "value": "SN" }{ "label": "Somalia", "value": "SO" }{ "label": "Suriname", "value": "SR" }{ "label": "South Sudan", "value": "SS" }{ "label": "Sao Tome and Principe", "value": "ST" }{ "label": "El Salvador", "value": "SV" }{ "label": "Sint Maarten (Dutch part)", "value": "SX" }{ "label": "Syrian Arab Republic", "value": "SY" }{ "label": "Eswatini", "value": "SZ" }{ "label": "Turks and Caicos Islands", "value": "TC" }{ "label": "Chad", "value": "TD" }{ "label": "French Southern Territories", "value": "TF" }{ "label": "Togo", "value": "TG" }{ "label": "Thailand", "value": "TH" }{ "label": "Tajikistan", "value": "TJ" }{ "label": "Tokelau", "value": "TK" }{ "label": "Timor-Leste", "value": "TL" }{ "label": "Turkmenistan", "value": "TM" }{ "label": "Tunisia", "value": "TN" }{ "label": "Tonga", "value": "TO" }{ "label": "Turkey", "value": "TR" }{ "label": "Trinidad and Tobago", "value": "TT" }{ "label": "Tuvalu", "value": "TV" }{ "label": "Taiwan, Province of China", "value": "TW" }{ "label": "Tanzania, United Republic of", "value": "TZ" }{ "label": "Ukraine", "value": "UA" }{ "label": "Uganda", "value": "UG" }{ "label": "United States Minor Outlying Islands", "value": "UM" }{ "label": "United States of America", "value": "US" }{ "label": "Uruguay", "value": "UY" }{ "label": "Uzbekistan", "value": "UZ" }{ "label": "Holy See", "value": "VA" }{ "label": "Saint Vincent and the Grenadines", "value": "VC" }{ "label": "Venezuela, Bolivarian Republic of", "value": "VE" }{ "label": "Virgin Islands, British", "value": "VG" }{ "label": "Virgin Islands, U.S.", "value": "VI" }{ "label": "Viet Nam", "value": "VN" }{ "label": "Vanuatu", "value": "VU" }{ "label": "Wallis and Futuna", "value": "WF" }{ "label": "Samoa", "value": "WS" }{ "label": "Yemen", "value": "YE" }{ "label": "Mayotte", "value": "YT" }{ "label": "South Africa", "value": "ZA" }{ "label": "Zambia", "value": "ZM" }{ "label": "Zimbabwe", "value": "ZW" }`

Action Authentication#

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

To retrieve your API Keys,

Navigate to your Sendcloud account and sign in
Click on the settings menu with the gear icon on the top right
Go to “Integrations”
Search for “API” within the Search Integrations box, and click Connect