← Notion + AmeriCommerce integrations

Create Or Update Order with AmeriCommerce API on New Database from Notion API

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

Trigger workflow on
New Database from the Notion API
Next, do this
Create Or Update Order with the AmeriCommerce API
No credit card required
Intro to Pipedream
Watch us build a workflow
Watch us build a workflow
8 min
Watch now ➜

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

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo

Developers Pipedream

Getting Started

This integration creates a workflow with a Notion trigger and AmeriCommerce 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 Database trigger
    1. Connect your Notion account
    2. Configure timer
  3. Configure the Create Or Update Order action
    1. Connect your AmeriCommerce account
    2. Optional- Select a Order ID
    3. Optional- Select a Customer ID
    4. Optional- Select a Order Status ID
    5. Optional- Select a Order Shipping Address ID
    6. Optional- Select a Order Billing Address ID
    7. Optional- Select a Customer Type ID
    8. Optional- Configure Special Instructions
    9. Optional- Configure Subtotal
    10. Optional- Configure Tax Total
    11. Optional- Configure Shipping Total
    12. Optional- Configure Discount Total
    13. Optional- Configure Grand Total
    14. Optional- Configure Cost Total
    15. Optional- Select a Selected Shipping Method
    16. Optional- Configure Referrer
    17. Optional- Configure Admin Comments
    18. Optional- Configure Source
    19. Optional- Configure Search Phrase
    20. Optional- Select a Store ID
    21. Optional- Configure Is PPC
    22. Optional- Configure PPC Keyword
    23. Optional- Configure Handling Total
    24. Optional- Configure Is Payment Order Only
    25. Optional- Configure Selected Shipping Provider Service
    26. Optional- Configure Additional Fees
    27. Optional- Select a Adcode ID
    28. Optional- Configure Is Gift
    29. Optional- Configure Gift Message
    30. Optional- Configure Public Comments
    31. Optional- Configure Instructions
    32. Optional- Configure Source Group
    33. Optional- Select a From Subscription ID
    34. Optional- Configure Discounted Shipping Total
    35. Optional- Configure Order Number
    36. Optional- Configure Coupon Code
    37. Optional- Configure Order Type
    38. Optional- Configure Expires
    39. Optional- Configure Campaign Code
    40. Optional- Configure Reward Points Credited
    41. Optional- Select a Channel
    42. Optional- Configure Device
    43. Optional- Configure Due Date
  4. Deploy the workflow
  5. Send a test event to validate your setup
  6. 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

Description:Emit new event when a database is created. Note: Databases must be shared with your Pipedream Integtration to trigger event.
Version:0.0.8
Key:notion-new-database

Notion Overview

Notion's API allows for the creation, reading, updating, and deleting of pages, databases, and their contents within Notion. Using Pipedream's platform, you can build workflows that connect Notion with various other services to automate tasks such as content management, task tracking, and data synchronization. With Pipedream's serverless execution, you can trigger these workflows on a schedule, or by external events from other services, without managing any infrastructure.

Trigger Code

import base from "../common/base.mjs";
import sampleEmit from "./test-event.mjs";
import constants from "../common/constants.mjs";

export default {
  ...base,
  key: "notion-new-database",
  name: "New Database",
  description: "Emit new event when a database is created. Note: Databases must be shared with your Pipedream Integtration to trigger event.",
  version: "0.0.8",
  type: "source",
  async run() {
    const databases = [];
    const params = this.lastCreatedSortParam();
    const lastCreatedTimestamp = this.getLastCreatedTimestamp();

    do {
      const response = await this.notion.listDatabases(params);

      for (const database of response.results) {
        if (!this.isResultNew(database.created_time, lastCreatedTimestamp)) {
          params.start_cursor = null;
          break;
        }
        databases.push(database);
      }

      params.start_cursor = response.next_cursor;
    } while (params.start_cursor);

    databases.reverse().forEach((database) => {
      const meta = this.generateMeta(
        database,
        constants.types.DATABASE,
        constants.timestamps.CREATED_TIME,
        constants.summaries.DATABASE_ADDED,
      );
      this.$emit(database, meta);
    });

    const lastCreatedTime = databases[databases.length - 1]?.created_time;
    if (lastCreatedTime) {
      this.setLastCreatedTimestamp(Date.parse(lastCreatedTime));
    }
  },
  sampleEmit,
};

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
NotionnotionappThis component uses the Notion app.
N/Adb$.service.dbThis component uses $.service.db to maintain state between executions.
timer$.interface.timer

Trigger Authentication

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

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

About Notion

Notion is a new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.

Action

Description:Creates a new order or updates an existing one. [See the documentation here](https://developers.cart.com/docs/rest-api/3f2ab73188031-create-an-order) and [here](https://developers.cart.com/docs/rest-api/e2649bb3adba9-update-an-order).
Version:0.0.1
Key:americommerce-create-update-order

Action Code

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

export default {
  key: "americommerce-create-update-order",
  name: "Create Or Update Order",
  description: "Creates a new order or updates an existing one. [See the documentation here](https://developers.cart.com/docs/rest-api/3f2ab73188031-create-an-order) and [here](https://developers.cart.com/docs/rest-api/e2649bb3adba9-update-an-order).",
  version: "0.0.1",
  type: "action",
  props: {
    app,
    orderId: {
      propDefinition: [
        app,
        "orderId",
      ],
    },
    customerId: {
      optional: true,
      propDefinition: [
        app,
        "customerId",
      ],
    },
    orderStatusId: {
      propDefinition: [
        app,
        "orderStatusId",
      ],
    },
    orderShippingAddressId: {
      label: "Order Shipping Address ID",
      description: "The ID of the order's shipping address.",
      propDefinition: [
        app,
        "orderAddressId",
      ],
    },
    orderBillingAddressId: {
      label: "Order Billing Address ID",
      description: "The ID of the order's billing address.",
      propDefinition: [
        app,
        "orderAddressId",
      ],
    },
    customerTypeId: {
      propDefinition: [
        app,
        "customerTypeId",
      ],
    },
    specialInstructions: {
      type: "string",
      label: "Special Instructions",
      description: "Special instructions for the order.",
      optional: true,
    },
    subtotal: {
      type: "string",
      label: "Subtotal",
      description: "The subtotal of the order.",
      optional: true,
    },
    taxTotal: {
      type: "string",
      label: "Tax Total",
      description: "The total tax for the order or tax added to the order.",
      optional: true,
    },
    shippingTotal: {
      type: "string",
      label: "Shipping Total",
      description: "The total shipping cost for the order or shipping added to the order.",
      optional: true,
    },
    discountTotal: {
      type: "string",
      label: "Discount Total",
      description: "The total discount for the order.",
      optional: true,
    },
    grandTotal: {
      type: "string",
      label: "Grand Total",
      description: "The grand total of the order.",
      optional: true,
    },
    costTotal: {
      type: "string",
      label: "Cost Total",
      description: "The total cost of the order.",
      optional: true,
    },
    selectedShippingMethod: {
      label: "Selected Shipping Method",
      description: "The selected shipping method for the order.",
      propDefinition: [
        app,
        "shippingMethodId",
        () => ({
          mapper: ({
            shipping_method_id: value,
            shipping_method: label,
          }) => ({
            label,
            value: String(value),
          }),
        }),
      ],
    },
    referrer: {
      type: "string",
      label: "Referrer",
      description: "The referrer for the order.",
      optional: true,
    },
    adminComments: {
      type: "string",
      label: "Admin Comments",
      description: "Comments from the admin about the order.",
      optional: true,
    },
    source: {
      type: "string",
      label: "Source",
      description: "The source of the order.",
      optional: true,
    },
    searchPhrase: {
      type: "string",
      label: "Search Phrase",
      description: "The search phrase for the order.",
      optional: true,
    },
    storeId: {
      propDefinition: [
        app,
        "storeId",
      ],
    },
    isPpc: {
      type: "boolean",
      label: "Is PPC",
      description: "Whether the order is a PPC order.",
      optional: true,
    },
    ppcKeyword: {
      type: "string",
      label: "PPC Keyword",
      description: "The PPC keyword for the order.",
      optional: true,
    },
    handlingTotal: {
      type: "string",
      label: "Handling Total",
      description: "The handling total for the order.",
      optional: true,
    },
    isPaymentOrderOnly: {
      type: "boolean",
      label: "Is Payment Order Only",
      description: "Whether the order is a payment order only.",
      optional: true,
    },
    selectedShippingProviderService: {
      type: "string",
      label: "Selected Shipping Provider Service",
      description: "The selected shipping provider service for the order.",
      optional: true,
    },
    additionalFees: {
      type: "string",
      label: "Additional Fees",
      description: "Additional fees for the order.",
      optional: true,
    },
    adcodeId: {
      propDefinition: [
        app,
        "adcodeId",
      ],
    },
    isGift: {
      type: "boolean",
      label: "Is Gift",
      description: "Whether the order is a gift.",
      optional: true,
    },
    giftMessage: {
      type: "string",
      label: "Gift Message",
      description: "The gift message for the order.",
      optional: true,
    },
    publicComments: {
      type: "string",
      label: "Public Comments",
      description: "Public comments about the order.",
      optional: true,
    },
    instructions: {
      type: "string",
      label: "Instructions",
      description: "Instructions for the order.",
      optional: true,
    },
    sourceGroup: {
      type: "string",
      label: "Source Group",
      description: "The source group for the order.",
      optional: true,
    },
    fromSubscriptionId: {
      label: "From Subscription ID",
      description: "The ID of the subscription.",
      propDefinition: [
        app,
        "subscriptionId",
      ],
    },
    discountedShippingTotal: {
      type: "string",
      label: "Discounted Shipping Total",
      description: "The discounted shipping total for the order.",
      optional: true,
    },
    orderNumber: {
      type: "string",
      label: "Order Number",
      description: "The order number.",
      optional: true,
    },
    couponCode: {
      type: "string",
      label: "Coupon Code",
      description: "The coupon code for the order.",
      optional: true,
    },
    orderType: {
      type: "string",
      label: "Order Type",
      description: "The type of order.",
      optional: true,
    },
    expires: {
      type: "boolean",
      label: "Expires",
      description: "Whether the order expires.",
      optional: true,
    },
    campaignCode: {
      type: "string",
      label: "Campaign Code",
      description: "The campaign code for the order.",
      optional: true,
    },
    rewardPointsCredited: {
      type: "boolean",
      label: "Reward Points Credited",
      description: "Whether the reward points are credited.",
      optional: true,
    },
    channel: {
      type: "string",
      label: "Channel",
      description: "The channel for the order.",
      optional: true,
      options: [
        "Online",
        "InStore",
        "Chat",
        "Phone",
        "Email",
      ],
    },
    device: {
      type: "string",
      label: "Device",
      description: "The device for the order.",
      optional: true,
    },
    dueDate: {
      type: "string",
      label: "Due Date",
      description: "The due date for the order. Eg. `2021-05-14`",
      optional: true,
    },
  },
  methods: {
    createOrder(args = {}) {
      return this.app.post({
        path: "/orders",
        ...args,
      });
    },
    updateOrder({
      orderId, ...args
    } = {}) {
      return this.app.put({
        path: `/orders/${orderId}`,
        ...args,
      });
    },
  },
  async run({ $ }) {
    const {
      createOrder,
      updateOrder,
      orderId,
      customerId,
      orderStatusId,
      orderShippingAddressId,
      orderBillingAddressId,
      customerTypeId,
      specialInstructions,
      subtotal,
      taxTotal,
      shippingTotal,
      discountTotal,
      grandTotal,
      costTotal,
      selectedShippingMethod,
      referrer,
      adminComments,
      source,
      searchPhrase,
      storeId,
      isPpc,
      ppcKeyword,
      handlingTotal,
      isPaymentOrderOnly,
      selectedShippingProviderService,
      additionalFees,
      adcodeId,
      isGift,
      giftMessage,
      publicComments,
      instructions,
      sourceGroup,
      fromSubscriptionId,
      discountedShippingTotal,
      orderNumber,
      couponCode,
      orderType,
      expires,
      campaignCode,
      rewardPointsCredited,
      channel,
      device,
      dueDate,
    } = this;

    const isCreate = !orderId;

    if (
      isCreate
        && (
          !customerId
          || !orderStatusId
          || !orderShippingAddressId
          || !orderBillingAddressId
          || !taxTotal
          || !shippingTotal
        )
    ) {
      throw new ConfigurationError("The **Customer ID**, **Order Status ID**, **Order Shipping Address ID**, **Order Billing Address ID**, **Tax Total**, and **Shipping Total** are required to create a new order.");
    }

    const data = {
      customer_id: customerId,
      order_status_id: orderStatusId,
      order_shipping_address_id: orderShippingAddressId,
      order_billing_address_id: orderBillingAddressId,
      customer_type_id: customerTypeId,
      special_instructions: specialInstructions,
      subtotal,
      tax_total: taxTotal,
      shipping_total: shippingTotal,
      discount_total: discountTotal,
      grand_total: grandTotal,
      cost_total: costTotal,
      selected_shipping_method: selectedShippingMethod,
      referrer,
      admin_comments: adminComments,
      source,
      search_phrase: searchPhrase,
      store_id: storeId,
      is_ppc: isPpc,
      ppc_keyword: ppcKeyword,
      handling_total: handlingTotal,
      is_payment_order_only: isPaymentOrderOnly,
      selected_shipping_provider_service: selectedShippingProviderService,
      additional_fees: additionalFees,
      adcode_id: adcodeId,
      is_gift: isGift,
      gift_message: giftMessage,
      public_comments: publicComments,
      instructions,
      source_group: sourceGroup,
      from_subscription_id: fromSubscriptionId,
      discounted_shipping_total: discountedShippingTotal,
      order_number: orderNumber,
      coupon_code: couponCode,
      order_type: orderType,
      expires,
      campaign_code: campaignCode,
      reward_points_credited: rewardPointsCredited,
      channel,
      device,
      due_date: dueDate,
    };

    if (isCreate) {
      const response = await createOrder({
        $,
        data,
      });
      $.export("$summary", `Successfully created the order with ID \`${response.id}\`.`);
      return response;
    }

    const response = await updateOrder({
      $,
      orderId,
      data,
    });
    $.export("$summary", `Successfully updated the order with ID \`${response.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.

LabelPropTypeDescription
AmeriCommerceappappThis component uses the AmeriCommerce app.
Order IDorderIdstringSelect a value from the drop down menu.
Customer IDcustomerIdstringSelect a value from the drop down menu.
Order Status IDorderStatusIdstringSelect a value from the drop down menu.
Order Shipping Address IDorderShippingAddressIdstringSelect a value from the drop down menu.
Order Billing Address IDorderBillingAddressIdstringSelect a value from the drop down menu.
Customer Type IDcustomerTypeIdstringSelect a value from the drop down menu.
Special InstructionsspecialInstructionsstring

Special instructions for the order.

Subtotalsubtotalstring

The subtotal of the order.

Tax TotaltaxTotalstring

The total tax for the order or tax added to the order.

Shipping TotalshippingTotalstring

The total shipping cost for the order or shipping added to the order.

Discount TotaldiscountTotalstring

The total discount for the order.

Grand TotalgrandTotalstring

The grand total of the order.

Cost TotalcostTotalstring

The total cost of the order.

Selected Shipping MethodselectedShippingMethodstringSelect a value from the drop down menu.
Referrerreferrerstring

The referrer for the order.

Admin CommentsadminCommentsstring

Comments from the admin about the order.

Sourcesourcestring

The source of the order.

Search PhrasesearchPhrasestring

The search phrase for the order.

Store IDstoreIdstringSelect a value from the drop down menu.
Is PPCisPpcboolean

Whether the order is a PPC order.

PPC KeywordppcKeywordstring

The PPC keyword for the order.

Handling TotalhandlingTotalstring

The handling total for the order.

Is Payment Order OnlyisPaymentOrderOnlyboolean

Whether the order is a payment order only.

Selected Shipping Provider ServiceselectedShippingProviderServicestring

The selected shipping provider service for the order.

Additional FeesadditionalFeesstring

Additional fees for the order.

Adcode IDadcodeIdstringSelect a value from the drop down menu.
Is GiftisGiftboolean

Whether the order is a gift.

Gift MessagegiftMessagestring

The gift message for the order.

Public CommentspublicCommentsstring

Public comments about the order.

Instructionsinstructionsstring

Instructions for the order.

Source GroupsourceGroupstring

The source group for the order.

From Subscription IDfromSubscriptionIdstringSelect a value from the drop down menu.
Discounted Shipping TotaldiscountedShippingTotalstring

The discounted shipping total for the order.

Order NumberorderNumberstring

The order number.

Coupon CodecouponCodestring

The coupon code for the order.

Order TypeorderTypestring

The type of order.

Expiresexpiresboolean

Whether the order expires.

Campaign CodecampaignCodestring

The campaign code for the order.

Reward Points CreditedrewardPointsCreditedboolean

Whether the reward points are credited.

ChannelchannelstringSelect a value from the drop down menu:OnlineInStoreChatPhoneEmail
Devicedevicestring

The device for the order.

Due DatedueDatestring

The due date for the order. Eg. 2021-05-14

Action Authentication

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

About AmeriCommerce

The B2B Commerce Platform for Digital Transformations.

More Ways to Connect AmeriCommerce + Notion

Change Order Status with AmeriCommerce API on New Database from Notion API
Notion + AmeriCommerce
 
Try it
Change Order Status with AmeriCommerce API on New Page in Database from Notion API
Notion + AmeriCommerce
 
Try it
Change Order Status with AmeriCommerce API on Page or Subpage Updated from Notion API
Notion + AmeriCommerce
 
Try it
Change Order Status with AmeriCommerce API on Updated Page ID from Notion API
Notion + AmeriCommerce
 
Try it
Create Or Update Order with AmeriCommerce API on New Page in Database from Notion API
Notion + AmeriCommerce
 
Try it
New Database from the Notion API

Emit new event when a database is created. Note: Databases must be shared with your Pipedream Integtration to trigger event.

 
Try it
New Page in Database from the Notion API

Emit new event when a page in a database is created

 
Try it
Page or Subpage Updated from the Notion API

Emit new event when a page or one of its sub-pages is updated.

 
Try it
Updated Page ID from the Notion API

Emit new event when a selected page is updated

 
Try it
Updated Page in Database from the Notion API

Emit new event when a page in a database is updated. To select a specific page, use Updated Page ID instead

 
Try it
Append Block to Parent with the Notion API

Creates and appends blocks to the specified parent. See the documentation

 
Try it
Create Page with the Notion API

Creates a page from a parent page. The only valid property is title. See the documentation

 
Try it
Create Page from Database with the Notion API

Creates a page from a database. See the docs

 
Try it
Duplicate Page with the Notion API

Creates a new page copied from an existing page block. See the docs

 
Try it
Find a Page with the Notion API

Searches for a page by its title. See the docs

 
Try it

Explore Other Apps

1
-
24
of
2,400+
apps by most popular

HTTP / Webhook
HTTP / Webhook
Get a unique URL where you can send HTTP or webhook requests
Node
Node
Anything you can do with Node.js, you can do in a Pipedream workflow. This includes using most of npm's 400,000+ packages.
Python
Python
Anything you can do in Python can be done in a Pipedream Workflow. This includes using any of the 350,000+ PyPi packages available in your Python powered workflows.
OpenAI (ChatGPT)
OpenAI (ChatGPT)
OpenAI is an AI research and deployment company with the mission to ensure that artificial general intelligence benefits all of humanity. They are the makers of popular models like ChatGPT, DALL-E, and Whisper.
Premium
Salesforce
Salesforce
Web services API for interacting with Salesforce
Premium
HubSpot
HubSpot
HubSpot's CRM platform contains the marketing, sales, service, operations, and website-building software you need to grow your business.
Premium
Zoho CRM
Zoho CRM
Zoho CRM is an online Sales CRM software that manages your sales, marketing, and support in one CRM platform.
Premium
Stripe
Stripe
Stripe powers online and in-person payment processing and financial solutions for businesses of all sizes.
Shopify
Shopify
Shopify is a complete commerce platform that lets anyone start, manage, and grow a business. You can use Shopify to build an online store, manage sales, market to customers, and accept payments in digital and physical locations.
Premium
WooCommerce
WooCommerce
WooCommerce is the open-source ecommerce platform for WordPress.
Premium
Snowflake
Snowflake
A data warehouse built for the cloud
Premium
MongoDB
MongoDB
MongoDB is an open source NoSQL database management program.
Supabase
Supabase
Supabase is an open source Firebase alternative.
MySQL
MySQL
MySQL is an open-source relational database management system.
PostgreSQL
PostgreSQL
PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.
Premium
AWS
AWS
Amazon Web Services (AWS) offers reliable, scalable, and inexpensive cloud computing services.
Premium
Twilio SendGrid
Twilio SendGrid
Send marketing and transactional email through the Twilio SendGrid platform with the Email API, proprietary mail transfer agent, and infrastructure for scalable delivery.
Amazon SES
Amazon SES
Amazon SES is a cloud-based email service provider that can integrate into any application for high volume email automation
Premium
Klaviyo
Klaviyo
Email Marketing and SMS Marketing Platform
Premium
Zendesk
Zendesk
Zendesk is award-winning customer service software trusted by 200K+ customers. Make customers happy via text, mobile, phone, email, live chat, social media.
Notion
Notion
Notion is a new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.
Slack
Slack
Slack is a channel-based messaging platform. With Slack, people can work together more effectively, connect all their software tools and services, and find the information they need to do their best work — all within a secure, enterprise-grade environment.
Microsoft Teams
Microsoft Teams
Microsoft Teams has communities, events, chats, channels, meetings, storage, tasks, and calendars in one place.
Schedule
Schedule
Trigger workflows on an interval or cron schedule.