DEAR Systems

DEAR Inventory is a comprehensive inventory control application positioned as a complete back end management system with product planning, cost and development, manufacturing, sales, shipping and payment features.

Integrate the DEAR Systems API with the Supabase API

Setup the DEAR Systems API trigger to run a workflow which integrates with the Supabase API. Pipedream's integration platform allows you to integrate DEAR Systems and Supabase remarkably fast. Free for developers.

Delete Row with Supabase API on New Authorized Purchase Order from DEAR Systems API
DEAR Systems + Supabase
 
Try it
Delete Row with Supabase API on New Authorized Sale Order from DEAR Systems API
DEAR Systems + Supabase
 
Try it
Delete Row with Supabase API on New Authorized Sale Quote from DEAR Systems API
DEAR Systems + Supabase
 
Try it
Delete Row with Supabase API on New Available Stock Level Change from DEAR Systems API
DEAR Systems + Supabase
 
Try it
Delete Row with Supabase API on New Customer Updated from DEAR Systems API
DEAR Systems + Supabase
 
Try it
New Authorized Purchase Order from the DEAR Systems API

Emit new event when a purchase order is created and authorized

 
Try it
New Authorized Sale Order from the DEAR Systems API

Emit new event when a sale order is created and authorized

 
Try it
New Authorized Sale Quote from the DEAR Systems API

Emit new event when a sale quote is created and authorized

 
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 Available Stock Level Change from the DEAR Systems API

Emit new event when the available stock level changes. See the documentation

 
Try it
Delete Row with the Supabase API

Deletes row(s) in a database. See the docs here

 
Try it
Insert Row with the Supabase API

Inserts a new row into a database. See the docs here

 
Try it
Remote Procedure Call with the Supabase API

Call a Postgres function in a database. See the docs here

 
Try it
Select Row with the Supabase API

Selects row(s) in a database. See the docs here

 
Try it
Update Row with the Supabase API

Updates row(s) in a database. See the docs here

 
Try it

Overview of DEAR Systems

DEAR Systems offers an API that provides programmatic access to its inventory management platform, allowing for seamless integration with other apps for automating various business processes. Leveraging this API within Pipedream, you can create custom workflows to synchronize inventory levels, manage sales and purchase orders, and automate financial reporting among other tasks. By connecting DEAR Systems to Pipedream’s vast array of supported apps, you can achieve a high degree of automation, reducing manual entry and data errors, and gaining insights from real-time data processing.

Connect DEAR Systems

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    dear: {
      type: "app",
      app: "dear",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://inventory.dearsystems.com/ExternalApi/v2/me`,
      headers: {
        "api-auth-accountid": `${this.dear.$auth.account_id}`,
        "api-auth-applicationkey": `${this.dear.$auth.application_key}`,
      },
    })
  },
})

Overview of Supabase

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.

Connect Supabase

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    supabase: {
      type: "app",
      app: "supabase",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://${this.supabase.$auth.subdomain}.supabase.co/rest/v1/`,
      headers: {
        Authorization: `Bearer ${this.supabase.$auth.service_key}`,
        "apikey": `${this.supabase.$auth.service_key}`,
      },
    })
  },
})