← Supabase + Remote integrations

Create Expense with Remote API on New Webhook Event (Instant) from Supabase API

Pipedream makes it easy to connect APIs for Remote, Supabase and 3,000+ other apps remarkably fast.

Trigger workflow on
New Webhook Event (Instant) from the Supabase API
Next, do this
Create Expense with the Remote 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 Supabase trigger and Remote 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 Webhook Event (Instant) trigger
    1. Connect your Supabase account
    2. Configure Table
    3. Optional- Configure Row Identifier
  3. Configure the Create Expense action
    1. Connect your Remote account
    2. Configure Amount
    3. Select a Currency
    4. Select a Employment ID
    5. Select a Expense Category Slug
    6. Configure Expense Date
    7. Configure Receipt Content File Path
    8. Configure Receipt File Name
    9. Configure Reviewed At
    10. Optional- Configure Tax Amount
    11. Optional- Configure Timezone
    12. Configure Title
    13. Configure syncDir
  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 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](https://supabase.com/docs/guides/database/webhooks#creating-a-webhook)
Version:0.0.6
Key:supabase-new-webhook-event

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.

Trigger Code#

import base from "../common/base.mjs";
import constants from "../../common/constants.mjs";
export default {
 key: "supabase-new-webhook-event",
 name: "New Webhook Event (Instant)",
 description: "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](https://supabase.com/docs/guides/database/webhooks#creating-a-webhook)",
 version: "0.0.6",
 type: "source",
 props: {
 ...base.props,
 http: {
 type: "$.interface.http",
 },
 },
 hooks: {
 async deploy() {
 const client = await this.supabase._client();
 const query = client
 .from(this.table)
 .select()
 .range(0, constants.HISTORICAL_EVENT_LIMIT);
 const { data } = await query;
 for (const row of data) {
 this.$emit({
 record: row,
 }, {
 summary: "Historical row in table",
 });
 }
 },
 },
 async run(event) {
 const { body: data } = event;
 let summary = `New ${data.type} event in table`;
 if (data.record?.[this.rowIdentifier]) {
 summary = `${summary}: ${data.record[this.rowIdentifier]}`;
 }
 this.$emit(data, {
 summary,
 });
 },
};

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
SupabasesupabaseappThis component uses the Supabase app.
Tabletablestring

The name of the table to watch for new rows

Row IdentifierrowIdentifierstring

The column name to use as the row identifier

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.

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

About Supabase#

Supabase is an open source Firebase alternative.

Action#

Description:Create an expense in Remote. [See the documentation](https://developer.remote.com/reference/post_create_expense)
Version:0.0.1
Key:remote-create-expense

Remote Overview#

The Remote API on Pipedream allows you to automate tasks related to global payroll, benefits, taxes, and compliance for a remote team. By integrating the Remote API with Pipedream’s serverless platform, you can create workflows that react to events within Remote, or from other sources. Automate employee onboarding, offboarding, and data sync between Remote and your HR systems. Effectively, you can connect Remote to 3,000+ other apps to streamline HR processes, gather insights, and maintain up-to-date records across all your platforms.

Action Code#

import { getFileStreamAndMetadata } from "@pipedream/platform";
import remote from "../../remote.app.mjs";
export default {
 key: "remote-create-expense",
 name: "Create Expense",
 description: "Create an expense in Remote. [See the documentation](https://developer.remote.com/reference/post_create_expense)",
 version: "0.0.1",
 annotations: {
 destructiveHint: false,
 openWorldHint: true,
 readOnlyHint: false,
 },
 type: "action",
 props: {
 remote,
 amount: {
 type: "integer",
 label: "Amount",
 description: "The amount of the expense",
 },
 currency: {
 type: "string",
 label: "Currency",
 description: "The currency of the expense",
 options: [
 "USD",
 "EUR",
 "CAD",
 ],
 },
 employmentId: {
 propDefinition: [
 remote,
 "employmentId",
 ],
 },
 expenseCategorySlug: {
 propDefinition: [
 remote,
 "expenseCategorySlug",
 ({ employmentId }) => ({
 employmentId,
 }),
 ],
 },
 expenseDate: {
 type: "string",
 label: "Expense Date",
 description: "Date of the purchase, which must be in the past. **Format: YYYY-MM-DD**",
 },
 receiptContentFilePath: {
 type: "string",
 label: "Receipt Content File Path",
 description: "The file of the receipt. Provide either a file URL or a path to a file in the `/tmp` directory (for example, `/tmp/myFile.pdf`)",
 },
 receiptFileName: {
 type: "string",
 label: "Receipt File Name",
 description: "The file name",
 },
 reviewedAt: {
 type: "string",
 label: "Reviewed At",
 description: "The date and time that the expense was reviewed in ISO8601 format. If not provided, it defaults to the current datetime. **Format: YYYY-MM-DDTHH:MM:SS**",
 },
 taxAmount: {
 type: "integer",
 label: "Tax Amount",
 description: "The tax amount of the expense",
 optional: true,
 },
 timezone: {
 type: "string",
 label: "Timezone",
 description: "The timezone of the expense. [TZ identifier](https://www.iana.org/time-zones)",
 optional: true,
 },
 title: {
 type: "string",
 label: "Title",
 description: "The title of the expense",
 },
 syncDir: {
 type: "dir",
 accessMode: "read",
 sync: true,
 },
 },
 methods: {
 async streamToBase64(stream) {
 return new Promise((resolve, reject) => {
 const chunks = [];
 stream.on("data", (chunk) => {
 chunks.push(chunk);
 });
 stream.on("end", () => {
 const buffer = Buffer.concat(chunks);
 resolve(buffer.toString("base64"));
 });
 stream.on("error", (err) => {
 reject(err);
 });
 });
 },
 },
 async run({ $ }) {
 const {
 stream, metadata,
 } = await getFileStreamAndMetadata(this.receiptContentFilePath);
 const base64String = await this.streamToBase64(stream);
 const response = await this.remote.createExpense({
 $,
 data: {
 amount: this.amount,
 currency: this.currency,
 employment_id: this.employmentId,
 expense_date: this.expenseDate,
 title: this.title,
 receipt: {
 content: `data:${metadata.contentType};base64,${base64String}`,
 name: this.receiptFileName,
 },
 expense_category_slug: this.expenseCategorySlug,
 reviewed_at: this.reviewedAt,
 tax_amount: this.taxAmount,
 timezone: this.timezone,
 },
 });
 $.export("$summary", `Successfully created expense with ID: ${response?.data?.expense?.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
RemoteremoteappThis component uses the Remote app.
Amountamountinteger

The amount of the expense

CurrencycurrencystringSelect a value from the drop down menu:USDEURCAD
Employment IDemploymentIdstringSelect a value from the drop down menu.
Expense Category SlugexpenseCategorySlugstringSelect a value from the drop down menu.
Expense DateexpenseDatestring

Date of the purchase, which must be in the past. Format: YYYY-MM-DD

Receipt Content File PathreceiptContentFilePathstring

The file of the receipt. Provide either a file URL or a path to a file in the /tmp directory (for example, /tmp/myFile.pdf)

Receipt File NamereceiptFileNamestring

The file name

Reviewed AtreviewedAtstring

The date and time that the expense was reviewed in ISO8601 format. If not provided, it defaults to the current datetime. Format: YYYY-MM-DDTHH:MM:SS

Tax AmounttaxAmountinteger

The tax amount of the expense

Timezonetimezonestring

The timezone of the expense. TZ identifier

Titletitlestring

The title of the expense

syncDirsyncDirdir

Action Authentication#

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

About Remote#

The easier way to employ internationally 🌍. Remote builds belonging for your distributed workforce with global payroll, benefits and compliance solutions.

More Ways to Connect Remote + Supabase#

Create Expense with Remote API on New Row Added from Supabase API
Supabase + Remote
Try it
List Employments with Remote API on New Row Added from Supabase API
Supabase + Remote
Try it
List Employments with Remote API on New Webhook Event (Instant) from Supabase API
Supabase + Remote
Try it
Show Time Off Balance with Remote API on New Row Added from Supabase API
Supabase + Remote
Try it
Show Time Off Balance with Remote API on New Webhook Event (Instant) from Supabase API
Supabase + Remote
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
New Contract Amendment Done (Instant) from the Remote API

Emit new event when a contract amendment is done. See the documentation

Try it
New Custom Field Value Updated (Instant) from the Remote API

Emit new event when a custom field is updated. See the documentation

Try it
New Employment Onboarding Started (Instant) from the Remote API

Emit new event when an employment onboarding is started. See the documentation

Try it
Batch Insert Rows with the Supabase API

Inserts new rows into a database. 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

Explore Other Apps#

1
-
24
of
3,000+
apps by most popular

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.
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.
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.
Anthropic (Claude)
Anthropic (Claude)
AI research and products that put safety at the frontier. Introducing Claude, a next-generation AI assistant for your tasks, no matter the scale.
Google Sheets
Google Sheets
Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.
Telegram
Telegram
Telegram, is a cloud-based, cross-platform, encrypted instant messaging (IM) service.
Google Drive
Google Drive
Google Drive is a file storage and synchronization service which allows you to create and share your work online, and access your documents from anywhere.
HTTP / Webhook
HTTP / Webhook
Get a unique URL where you can send HTTP or webhook requests
Google Calendar
Google Calendar
With Google Calendar, you can quickly schedule meetings and events and get reminders about upcoming activities, so you always know what’s next.
Schedule
Schedule
Trigger workflows on an interval or cron schedule.
Pipedream Utils
Pipedream Utils
Utility functions to use within your Pipedream workflows
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.
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.
AWS
AWS
Premium
Amazon Web Services (AWS) offers reliable, scalable, and inexpensive cloud computing services.
Twilio SendGrid
Twilio SendGrid
Premium
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
Klaviyo
Klaviyo
Premium
Klaviyo unifies your data, channels, and AI agents in one platform—text, WhatsApp, email marketing, and more—driving growth with every interaction.
Zendesk
Zendesk
Premium
Zendesk is award-winning customer service software trusted by 200K+ customers. Make customers happy via text, mobile, phone, email, live chat, social media.
ServiceNow
ServiceNow
Premium
Beta
The smarter way to workflow
Slack
Slack
Slack is the AI-powered platform for work bringing all of your conversations, apps, and customers together in one place. Around the world, Slack is helping businesses of all sizes grow and send productivity through the roof.
Microsoft Teams
Microsoft Teams
Microsoft Teams has communities, events, chats, channels, meetings, storage, tasks, and calendars in one place.
a b c d e f g h i j k l m n o p q r s t u v w x y z #
Pipedream, Inc. — San Francisco, CA
About Twitter Docs Community Terms Privacy Cookie Settings Try String

AltStyle によって変換されたページ (->オリジナル) /