Delete Row with Supabase API on New Ecwid Paid Orders from ecwid API

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

Trigger workflow on

New Ecwid Paid Orders from the ecwid API

Next, do this

Delete Row with the Supabase 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 ecwid trigger and Supabase action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Ecwid Paid Orders trigger
1. Configure timer
2. Configure Max Days Back
3. Configure Set order fulfilment status (Preferred)
4. Select a New Fulfilment Status
5. Connect your ecwid account
Configure the Delete Row action
1. Connect your Supabase account
2. Configure Table
3. Configure Column
4. Configure Value
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 Ecwid Paid Orders on ecwid

Description:Search for new orders which are PAID and AWAITING_PROCESSING. Emits events for each order and sets order fulfilment status to PROCESSING

Version:0.0.4

Key:ecwid-paid-orders

View on GitHub

ecwid Overview#

Ecwid's API offers dynamic access to an online store's data, allowing for the automation of tasks such as inventory management, order processing, and customer data analysis. With Pipedream's serverless integration platform, you can create custom workflows that trigger actions within Ecwid or synchronize data across various other apps and services. This capability can streamline operations, save time, and reduce the likelihood of human error.

Trigger Code#

import ecwid from "../../ecwid.app.mjs";
import { FULFILMENT_STATUS_LIST } from "../../commons/commons.mjs";
import { DEFAULT_POLLING_SOURCE_TIMER_INTERVAL } from "@pipedream/platform";

export default {
  name: "New Ecwid Paid Orders",
  version: "0.0.4",
  key: "ecwid-paid-orders",
  description: "Search for new orders which are PAID and AWAITING_PROCESSING. Emits events for each order and" +
    " sets order fulfilment status to PROCESSING",
  props: {
    timer: {
      type: "$.interface.timer",
      default: {
        intervalSeconds: DEFAULT_POLLING_SOURCE_TIMER_INTERVAL,
      },
    },
    history: {
      label: "Max Days Back",
      description: "Max number of days to get the orders from",
      type: "integer",
      default: 30,
    },
    setFulfilmentStatus: {
      label: "Set order fulfilment status (Preferred)",
      description: "Upon receiving the order, fulfilment status will be set to user defined value so that " +
        "the same order is not fetched again. If unchecked, it needs to be handled in the workflow",
      type: "boolean",
      default: true,
    },
    newFulfilmentStatus: {
      label: "New Fulfilment Status",
      description: "New Fulfilment Status to be updated in the order",
      type: "string",
      options: FULFILMENT_STATUS_LIST,
      default: "PROCESSING",
    },
    ecwid,
  },
  type: "source",
  methods: {},
  async run() {
    let ordersResponse = await this.ecwid.getOrders(this.history);
    for (const order of ordersResponse.items) {
      this.$emit(order, {
        id: order.id,
        summary: `Order ${order.id}`,
        ts: Date.now(),
      });
      if (this.setFulfilmentStatus) {
        let updateStatus = await this.ecwid.updateFulfilmentStatus(
          order.id,
          this.newFulfilmentStatus,
        );
        if (updateStatus.updateCount === 1)
          console.log("Updated Order Status of " + order.id +
            " to " + this.newFulfilmentStatus);
        else
          console.error("Error Updating Order Status of "
            + order.id + " to " + this.newFulfilmentStatus);
      }
    }
  },
};

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
	`timer`	`$.interface.timer`
Max Days Back	`history`	`integer`	Max number of days to get the orders from
Set order fulfilment status (Preferred)	`setFulfilmentStatus`	`boolean`	Upon receiving the order, fulfilment status will be set to user defined value so that the same order is not fetched again. If unchecked, it needs to be handled in the workflow
New Fulfilment Status	`newFulfilmentStatus`	`string`	Select a value from the drop down menu:`AWAITING_PROCESSINGPROCESSINGSHIPPEDDELIVEREDWILL_NOT_DELIVERRETURNEDREADY_FOR_PICKUPOUT_FOR_DELIVERY`
ecwid	`ecwid`	`app`	This component uses the ecwid app.

Trigger Authentication#

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

You must be on a paid ecwid plan to use this integration.

About ecwid#

Online store platform

Action#

Delete Row on Supabase

Description:Deletes row(s) in a database. [See the docs here](https://supabase.com/docs/reference/javascript/delete)

Version:0.1.2

Key:supabase-delete-row

View on GitHub

Supabase Overview#

Supabase is a real-time backend-as-a-service that provides developers with a suite of tools to quickly build and scale their applications. It offers database storage, authentication, instant APIs, and real-time subscriptions. With the Supabase API, you can perform CRUD operations on your database, manage users, and listen to database changes in real time. When integrated with Pipedream, you can automate workflows that react to these database events, synchronize data across multiple services, or streamline user management processes.

Action Code#

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

export default {
  key: "supabase-delete-row",
  name: "Delete Row",
  type: "action",
  version: "0.1.2",
  description: "Deletes row(s) in a database. [See the docs here](https://supabase.com/docs/reference/javascript/delete)",
  props: {
    supabase,
    table: {
      propDefinition: [
        supabase,
        "table",
      ],
      description: "Name of the table to delete row(s) from",
    },
    column: {
      propDefinition: [
        supabase,
        "column",
      ],
      description: "Search column to find row(s) to delete",
    },
    value: {
      propDefinition: [
        supabase,
        "value",
      ],
      description: "Value of the search column in the row(s) to delete",
    },
  },
  async run({ $ }) {
    const response = await this.supabase.deleteRow(this.table, this.column, this.value);
    $.export("$summary", `Successfully deleted ${response.length} row(s) from table ${this.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.

Label	Prop	Type	Description
Supabase	`supabase`	`app`	This component uses the Supabase app.
Table	`table`	`string`	Name of the table to delete row(s) from
Column	`column`	`string`	Search column to find row(s) to delete
Value	`value`	`string`	Value of the search column in the row(s) to delete

Action Authentication#

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

Supabase provides a Service Key to get started. You can find the service_role in the API Settings page.

Finding the Supabase subdomain

About Supabase#

Supabase is an open source Firebase alternative.

More Ways to Connect Supabase + ecwid#

Other Popular Integrations#

Ecwid Get Order with ecwid API on New Webhook Event (Instant) from Supabase API

Supabase + ecwid

Try it

Ecwid Get Order with ecwid API on New Row Added from Supabase API

Supabase + ecwid

Try it

Ecwid Update Order Status with ecwid API on New Webhook Event (Instant) from Supabase API

Supabase + ecwid

Try it

Ecwid Update Order Status with ecwid API on New Row Added from Supabase API

Supabase + ecwid

Try it

Insert Row with Supabase API on New Ecwid Paid Orders from ecwid API

ecwid + Supabase

Try it

Popular Triggers#

New Ecwid Paid Orders from the ecwid API

Search for new orders which are PAID and AWAITING_PROCESSING. Emits events for each order and sets order fulfilment status to PROCESSING

Try it

New Row Added from the Supabase API

Emit new event for every new row added in a table. See documentation here

Try it

New Webhook Event (Instant) from the Supabase API

Emit new event for every insert, update, or delete operation in a table. This source requires user configuration using the Supabase website. More information in the README. Also see documentation here

Try it