← PostgreSQL + Pipedream Utils integrations

Formatting - [Numbers] Format Currency with Pipedream Utils API on New Column from PostgreSQL API

Pipedream makes it easy to connect APIs for Pipedream Utils, PostgreSQL and 2,800+ other apps remarkably fast.

Trigger workflow on
New Column from the PostgreSQL API
Next, do this
Formatting - [Numbers] Format Currency with the Pipedream Utils 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 PostgreSQL trigger and Pipedream Utils 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 Column trigger
    1. Connect your PostgreSQL account
    2. Configure Polling Interval
    3. Select a Schema
    4. Select a Table
  3. Configure the Formatting - [Numbers] Format Currency action
    1. Connect your Pipedream Utils account
    2. Configure Input
    3. Select a Currency
    4. Select a Currency Format
  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 new column is added to a table. [See the documentation](https://node-postgres.com/features/queries)
Version:2.0.8
Key:postgresql-new-column

PostgreSQL Overview

On Pipedream, you can leverage the PostgreSQL app to create workflows that automate database operations, synchronize data across platforms, and react to database events in real-time. Think handling new row entries, updating records from webhooks, or even compiling reports on a set schedule. Pipedream's serverless platform provides a powerful way to connect PostgreSQL with a variety of apps, enabling you to create tailored automation that fits your specific needs.

Trigger Code

import common from "../common.mjs"; export default { ...common, name: "New Column", key: "postgresql-new-column", description: "Emit new event when a new column is added to a table. [See the documentation](https://node-postgres.com/features/queries)", version: "2.0.8", type: "source", props: { ...common.props, schema: { propDefinition: [ common.props.postgresql, "schema", ], }, table: { propDefinition: [ common.props.postgresql, "table", (c) => ({ schema: c.schema, }), ], }, }, async run() { const previousColumns = this._getPreviousValues() || []; const columns = await this.postgresql.getColumns(this.table, this.schema); const newColumns = columns.filter((column) => !previousColumns.includes(column)); for (const column of newColumns) { const meta = this.generateMeta(column); this.$emit(column, meta); } this._setPreviousValues(columns); }, }; 

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

Pipedream will poll the API on this schedule

SchemaschemastringSelect a value from the drop down menu.
TabletablestringSelect a value from the drop down menu.

Trigger Authentication

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

Connecting to Restricted Databases

Either enable the shared static IP for this account below, or configure a VPC to deploy any workflow in your workspace to a private network with a dedicated static IP. Learn more in our docs

SSL Setup

Configure SSL on your PostgreSQL database by providing the CA (Certificate Authority), and choosing between Full Verification, Verify Certificate Authority (CA), or Skip Verification. Skipping verification is not recommended as this has serious security implications

About PostgreSQL

PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.

Action

Description:Format a number as a currency
Version:0.0.6
Key:pipedream_utils-format-currency

Pipedream Utils Overview

The Pipedream Utils app is a set of pre-built functions that streamline common tasks in your workflows. It acts like a Swiss Army knife for developers, providing essential tools such as format conversion, date manipulation, and text processing. By leveraging these functions, you can reduce the boilerplate code needed for routine operations, speeding up the development of intricate automations. The Helper Functions API can be a game changer when it comes to tasks like parsing dates in user-friendly formats, encoding and decoding data, or generating UUIDs, making them more efficient and less error-prone.

Action Code

import { ConfigurationError } from "@pipedream/platform"; import { CURRENCY_OPTIONS } from "../../common/numbers/currencies.mjs"; import { CURRENCY_FORMAT_OPTIONS } from "../../common/numbers/currencyFormats.mjs"; import formatNumber from "../../common/numbers/formatNumber.mjs"; import pipedream_utils from "../../pipedream_utils.app.mjs"; export default { name: "Formatting - [Numbers] Format Currency", description: "Format a number as a currency", key: "pipedream_utils-format-currency", version: "0.0.6", annotations: { destructiveHint: false, openWorldHint: false, readOnlyHint: false, }, type: "action", props: { pipedream_utils, input: { label: "Input", description: "Number you would like to format as a currency.", type: "string", }, currency: { label: "Currency", description: "Specify the currency to be used for formatting", type: "string", options: CURRENCY_OPTIONS, }, currencyFormat: { label: "Currency Format", description: "Specify the format to be used for the currency formatting. Use the unicode currency symbol `¤` for special formatting options. [Formatting rules can be found here](http://www.unicode.org/reports/tr35/tr35-numbers.html#Number_Format_Patterns)", type: "string", options: CURRENCY_FORMAT_OPTIONS, }, }, async run({ $ }) { const { currency, currencyFormat, } = this; const input = this.input.toString(); const [ isoCode, currencySymbol, currencyName, ] = currency.split(" - "); let result = (currencyFormat.startsWith("¤") && currencySymbol) || ""; const [ integer, decimal, ] = input.split(input.includes(".") ? "." : ","); if (isNaN(Number(integer))) { throw new ConfigurationError("**Invalid number** - please check your input."); } const numberString = formatNumber(integer, (decimal?.length > 1 ? decimal : (decimal ?? "0") + "0"), currencyFormat.includes(",") ? "," : ""); result += numberString; switch (currencyFormat.match(/¤+$/g)?.[0].length) { default: break; // ¤¤ - ISO currency symbol: USD, BRL, etc. case 2: result += ` ${isoCode}`; break; // ¤¤¤ - Currency display name: United States dollar, Brazilian real, etc. case 3: result += ` ${currencyName}`; break; } $.export("$summary", "Successfully formatted as currency"); return result; }, }; 

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
Pipedream Utilspipedream_utilsappThis component uses the Pipedream Utils app.
Inputinputstring

Number you would like to format as a currency.

CurrencycurrencystringSelect a value from the drop down menu:{ "label": "United States dollar", "value": "USD - $ - United States dollar" }{ "label": "Euro", "value": "EUR - € - Euro" }{ "label": "Japanese yen", "value": "JPY - ¥ - Japanese yen" }{ "label": "Brazilian real", "value": "BRL - R$ - Brazilian real" }{ "label": "Russian ruble", "value": "RUB - ₽ - Russian ruble" }{ "label": "Sterling", "value": "GBP - £ - Sterling" }{ "label": "Canadian dollar", "value": "CAD - $ - Canadian dollar" }{ "label": "Afghan afghani", "value": "AFN - Af - Afghan afghani" }{ "label": "Albanian lek", "value": "ALL - Lek - Albanian lek" }{ "label": "Algerian dinar", "value": "DZD - DA - Algerian dinar" }{ "label": "Angolan kwanza", "value": "AOA - Kz - Angolan kwanza" }{ "label": "Eastern Caribbean dollar", "value": "XCD - $ - Eastern Caribbean dollar" }{ "label": "Argentine peso", "value": "ARS - $ - Argentine peso" }{ "label": "Armenian dram", "value": "AMD - ֏ - Armenian dram" }{ "label": "Aruban florin", "value": "AWG - ƒ - Aruban florin" }{ "label": "Saint Helena pound", "value": "SHP - £ - Saint Helena pound" }{ "label": "Australian dollar", "value": "AUD - $ - Australian dollar" }{ "label": "Azerbaijani manat", "value": "AZN - ₼ - Azerbaijani manat" }{ "label": "Bahamian dollar", "value": "BSD - $ - Bahamian dollar" }{ "label": "Bahraini dinar", "value": "BHD - BD - Bahraini dinar" }{ "label": "Bangladeshi taka", "value": "BDT - ৳ - Bangladeshi taka" }{ "label": "Barbadian dollar", "value": "BBD - $ - Barbadian dollar" }{ "label": "Belarusian ruble", "value": "BYN - Rbl - Belarusian ruble" }{ "label": "Belize dollar", "value": "BZD - $ - Belize dollar" }{ "label": "West African CFA franc", "value": "XOF - Fr - West African CFA franc" }{ "label": "Bermudian dollar", "value": "BMD - $ - Bermudian dollar" }{ "label": "Bhutanese ngultrum", "value": "BTN - Nu - Bhutanese ngultrum" }{ "label": "Indian rupee", "value": "INR - ₹ - Indian rupee" }{ "label": "Bolivian boliviano", "value": "BOB - Bs - Bolivian boliviano" }{ "label": "Bosnia and Herzegovina convertible mark", "value": "BAM - KM - Bosnia and Herzegovina convertible mark" }{ "label": "Botswana pula", "value": "BWP - P - Botswana pula" }{ "label": "Brunei dollar", "value": "BND - $ - Brunei dollar" }{ "label": "Singapore dollar", "value": "SGD - $ - Singapore dollar" }{ "label": "Bulgarian lev", "value": "BGN - Lev - Bulgarian lev" }{ "label": "Burundian franc", "value": "BIF - Fr - Burundian franc" }{ "label": "Cambodian riel", "value": "KHR - CR - Cambodian riel" }{ "label": "Central African CFA franc", "value": "XAF - Fr - Central African CFA franc" }{ "label": "Cape Verdean escudo", "value": "CVE - $ - Cape Verdean escudo" }{ "label": "Cayman Islands dollar", "value": "KYD - $ - Cayman Islands dollar" }{ "label": "Chilean peso", "value": "CLP - $ - Chilean peso" }{ "label": "Renminbi", "value": "CNY - ¥ - Renminbi" }{ "label": "Colombian peso", "value": "COP - $ - Colombian peso" }{ "label": "Comorian franc", "value": "KMF - Fr - Comorian franc" }{ "label": "Congolese franc", "value": "CDF - Fr - Congolese franc" }{ "label": "New Zealand dollar", "value": "NZD - $ - New Zealand dollar" }{ "label": "Costa Rican colón", "value": "CRC - ₡ - Costa Rican colón" }{ "label": "Cuban peso", "value": "CUP - $ - Cuban peso" }{ "label": "Netherlands Antillean guilder", "value": "ANG - ƒ - Netherlands Antillean guilder" }{ "label": "Czech koruna", "value": "CZK - Kč - Czech koruna" }{ "label": "Danish krone", "value": "DKK - kr - Danish krone" }{ "label": "Djiboutian franc", "value": "DJF - Fr - Djiboutian franc" }{ "label": "Dominican peso", "value": "DOP - $ - Dominican peso" }{ "label": "Egyptian pound", "value": "EGP - LE - Egyptian pound" }{ "label": "Eritrean nakfa", "value": "ERN - Nkf - Eritrean nakfa" }{ "label": "Swazi lilangeni", "value": "SZL - L - Swazi lilangeni" }{ "label": "South African rand", "value": "ZAR - R - South African rand" }{ "label": "Ethiopian birr", "value": "ETB - Br - Ethiopian birr" }{ "label": "Falkland Islands pound", "value": "FKP - £ - Falkland Islands pound" }{ "label": "Fijian dollar", "value": "FJD - $ - Fijian dollar" }{ "label": "CFP franc", "value": "XPF - Fr - CFP franc" }{ "label": "Gambian dalasi", "value": "GMD - D - Gambian dalasi" }{ "label": "Georgian lari", "value": "GEL - ₾ - Georgian lari" }{ "label": "Ghanaian cedi", "value": "GHS - ₵ - Ghanaian cedi" }{ "label": "Gibraltar pound", "value": "GIP - £ - Gibraltar pound" }{ "label": "Guatemalan quetzal", "value": "GTQ - Q - Guatemalan quetzal" }{ "label": "Guinean franc", "value": "GNF - Fr - Guinean franc" }{ "label": "Guyanese dollar", "value": "GYD - $ - Guyanese dollar" }{ "label": "Haitian gourde", "value": "HTG - G - Haitian gourde" }{ "label": "Honduran lempira", "value": "HNL - L - Honduran lempira" }{ "label": "Hong Kong dollar", "value": "HKD - $ - Hong Kong dollar" }{ "label": "Hungarian forint", "value": "HUF - Ft - Hungarian forint" }{ "label": "Icelandic króna", "value": "ISK - kr - Icelandic króna" }{ "label": "Indonesian rupiah", "value": "IDR - Rp - Indonesian rupiah" }{ "label": "Iranian rial", "value": "IRR - Rl - Iranian rial" }{ "label": "Iraqi dinar", "value": "IQD - ID - Iraqi dinar" }{ "label": "Israeli new shekel", "value": "ILS - ₪ - Israeli new shekel" }{ "label": "Jamaican dollar", "value": "JMD - $ - Jamaican dollar" }{ "label": "Jordanian dinar", "value": "JOD - JD - Jordanian dinar" }{ "label": "Kazakhstani tenge", "value": "KZT - ₸ - Kazakhstani tenge" }{ "label": "Kenyan shilling", "value": "KES - Sh - Kenyan shilling" }{ "label": "North Korean won", "value": "KPW - ₩ - North Korean won" }{ "label": "South Korean won", "value": "KRW - ₩ - South Korean won" }{ "label": "Kuwaiti dinar", "value": "KWD - KD - Kuwaiti dinar" }{ "label": "Kyrgyz som", "value": "KGS - som - Kyrgyz som" }{ "label": "Lao kip", "value": "LAK - ₭ - Lao kip" }{ "label": "Lebanese pound", "value": "LBP - LL - Lebanese pound" }{ "label": "Lesotho loti", "value": "LSL - L - Lesotho loti" }{ "label": "Liberian dollar", "value": "LRD - $ - Liberian dollar" }{ "label": "Libyan dinar", "value": "LYD - LD - Libyan dinar" }{ "label": "Swiss franc", "value": "CHF - Fr - Swiss franc" }{ "label": "Macanese pataca", "value": "MOP - MOP$ - Macanese pataca" }{ "label": "Malagasy ariary", "value": "MGA - Ar - Malagasy ariary" }{ "label": "Malawian kwacha", "value": "MWK - K - Malawian kwacha" }{ "label": "Malaysian ringgit", "value": "MYR - RM - Malaysian ringgit" }{ "label": "Maldivian rufiyaa", "value": "MVR - Rf - Maldivian rufiyaa" }{ "label": "Mauritanian ouguiya", "value": "MRU - UM - Mauritanian ouguiya" }{ "label": "Mauritian rupee", "value": "MUR - Re - Mauritian rupee" }{ "label": "Mexican peso", "value": "MXN - $ - Mexican peso" }{ "label": "Moldovan leu", "value": "MDL - Leu - Moldovan leu" }{ "label": "Mongolian tögrög", "value": "MNT - ₮ - Mongolian tögrög" }{ "label": "Moroccan dirham", "value": "MAD - DH - Moroccan dirham" }{ "label": "Mozambican metical", "value": "MZN - Mt - Mozambican metical" }{ "label": "Burmese kyat", "value": "MMK - K - Burmese kyat" }{ "label": "Namibian dollar", "value": "NAD - $ - Namibian dollar" }{ "label": "Nepalese rupee", "value": "NPR - Re - Nepalese rupee" }{ "label": "Nicaraguan córdoba", "value": "NIO - C$ - Nicaraguan córdoba" }{ "label": "Nigerian naira", "value": "NGN - ₦ - Nigerian naira" }{ "label": "Macedonian denar", "value": "MKD - DEN - Macedonian denar" }{ "label": "Turkish lira", "value": "TRY - ₺ - Turkish lira" }{ "label": "Norwegian krone", "value": "NOK - kr - Norwegian krone" }{ "label": "Omani rial", "value": "OMR - RO - Omani rial" }{ "label": "Pakistani rupee", "value": "PKR - Re - Pakistani rupee" }{ "label": "Panamanian balboa", "value": "PAB - B/ - Panamanian balboa" }{ "label": "Papua New Guinean kina", "value": "PGK - K - Papua New Guinean kina" }{ "label": "Paraguayan guaraní", "value": "PYG - ₲ - Paraguayan guaraní" }{ "label": "Peruvian sol", "value": "PEN - S/ - Peruvian sol" }{ "label": "Philippine peso", "value": "PHP - ₱ - Philippine peso" }{ "label": "Polish złoty", "value": "PLN - zł - Polish złoty" }{ "label": "Qatari riyal", "value": "QAR - QR - Qatari riyal" }{ "label": "Romanian leu", "value": "RON - Leu - Romanian leu" }{ "label": "Rwandan franc", "value": "RWF - Fr - Rwandan franc" }{ "label": "Samoan tālā", "value": "WST - $ - Samoan tālā" }{ "label": "São Tomé and Príncipe dobra", "value": "STN - Db - São Tomé and Príncipe dobra" }{ "label": "Saudi riyal", "value": "SAR - Rl - Saudi riyal" }{ "label": "Serbian dinar", "value": "RSD - DIN - Serbian dinar" }{ "label": "Seychellois rupee", "value": "SCR - Re - Seychellois rupee" }{ "label": "Sierra Leonean leone", "value": "SLE - Le - Sierra Leonean leone" }{ "label": "Solomon Islands dollar", "value": "SBD - $ - Solomon Islands dollar" }{ "label": "Somali shilling", "value": "SOS - Sh - Somali shilling" }{ "label": "Sri Lankan rupee", "value": "LKR - Re - Sri Lankan rupee" }{ "label": "Sudanese pound", "value": "SDG - LS - Sudanese pound" }{ "label": "Surinamese dollar", "value": "SRD - $ - Surinamese dollar" }{ "label": "Swedish krona", "value": "SEK - kr - Swedish krona" }{ "label": "Syrian pound", "value": "SYP - LS - Syrian pound" }{ "label": "New Taiwan dollar", "value": "TWD - $ - New Taiwan dollar" }{ "label": "Tajikistani somoni", "value": "TJS - SM - Tajikistani somoni" }{ "label": "Tanzanian shilling", "value": "TZS - Sh - Tanzanian shilling" }{ "label": "Thai baht", "value": "THB - ฿ - Thai baht" }{ "label": "Tongan pa'anga", "value": "TOP - T$ - Tongan pa'anga" }{ "label": "Trinidad and Tobago dollar", "value": "TTD - $ - Trinidad and Tobago dollar" }{ "label": "Tunisian dinar", "value": "TND - DT - Tunisian dinar" }{ "label": "Turkmenistani manat", "value": "TMT - m - Turkmenistani manat" }{ "label": "Ugandan shilling", "value": "UGX - Sh - Ugandan shilling" }{ "label": "Ukrainian hryvnia", "value": "UAH - ₴ - Ukrainian hryvnia" }{ "label": "United Arab Emirates dirham", "value": "AED - Dh - United Arab Emirates dirham" }{ "label": "Uruguayan peso", "value": "UYU - $ - Uruguayan peso" }{ "label": "Uzbekistani sum", "value": "UZS - soum - Uzbekistani sum" }{ "label": "Vanuatu vatu", "value": "VUV - VT - Vanuatu vatu" }{ "label": "Venezuelan sovereign bolívar", "value": "VES - Bs.S - Venezuelan sovereign bolívar" }{ "label": "Venezuelan digital bolívar", "value": "VED - Bs.D - Venezuelan digital bolívar" }{ "label": "Vietnamese đồng", "value": "VND - ₫ - Vietnamese đồng" }{ "label": "Yemeni rial", "value": "YER - Rl - Yemeni rial" }{ "label": "Zambian kwacha", "value": "ZMW - K - Zambian kwacha" }
Currency FormatcurrencyFormatstringSelect a value from the drop down menu:{ "label": "$1,000.00", "value": "¤#,##0.00" }{ "label": "$1,000.00 USD", "value": "¤#,##0.00 ¤¤" }{ "label": "$1,000.00 United States dollar", "value": "¤#,##0.00 ¤¤¤" }{ "label": "$1000.00", "value": "¤###0.00" }{ "label": "1,000.00", "value": "#,##0.00" }{ "label": "1000.00", "value": "###0.00" }

Action Authentication

The Pipedream Utils API does not require authentication.

About Pipedream Utils

Utility functions to use within your Pipedream workflows

More Ways to Connect Pipedream Utils + PostgreSQL

Formatting - [Date/Time] Add/Subtract Time with Pipedream Utils API on New Column from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Helper Functions - Base64 Decode String with Pipedream Utils API on New Column from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Formatting - [Date/Time] Add/Subtract Time with Pipedream Utils API on New or Updated Row from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Helper Functions - Base64 Decode String with Pipedream Utils API on New or Updated Row from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Formatting - [Date/Time] Add/Subtract Time with Pipedream Utils API on New Row Custom Query from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Helper Functions - Base64 Decode String with Pipedream Utils API on New Row Custom Query from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Formatting - [Date/Time] Add/Subtract Time with Pipedream Utils API on New Row from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Helper Functions - Base64 Decode String with Pipedream Utils API on New Row from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Formatting - [Date/Time] Add/Subtract Time with Pipedream Utils API on New Table from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Helper Functions - Base64 Decode String with Pipedream Utils API on New Table from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Helper Functions - Compare Arrays with Pipedream Utils API on New Column from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Helper Functions - Compare Arrays with Pipedream Utils API on New or Updated Row from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Helper Functions - Compare Arrays with Pipedream Utils API on New Row Custom Query from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Helper Functions - Compare Arrays with Pipedream Utils API on New Row from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Helper Functions - Compare Arrays with Pipedream Utils API on New Table from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Formatting - [Date/Time] Compare Dates with Pipedream Utils API on New Column from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Formatting - [Date/Time] Compare Dates with Pipedream Utils API on New or Updated Row from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Formatting - [Date/Time] Compare Dates with Pipedream Utils API on New Row Custom Query from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Formatting - [Date/Time] Compare Dates with Pipedream Utils API on New Row from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
Formatting - [Date/Time] Compare Dates with Pipedream Utils API on New Table from PostgreSQL API
PostgreSQL + Pipedream Utils
 
Try it
New Column from the PostgreSQL API

Emit new event when a new column is added to a table. See the documentation

 
Try it
New or Updated Row from the PostgreSQL API

Emit new event when a row is added or modified. See the documentation

 
Try it
New Row from the PostgreSQL API

Emit new event when a new row is added to a table. See the documentation

 
Try it
New Row Custom Query from the PostgreSQL API

Emit new event when new rows are returned from a custom query that you provide. See the documentation

 
Try it
New Table from the PostgreSQL API

Emit new event when a new table is added to the database. See the documentation

 
Try it
Execute SQL Query with the PostgreSQL API

Execute a custom PostgreSQL query. See our docs to learn more about working with SQL in Pipedream.

 
Try it
Delete Row(s) with the PostgreSQL API

Deletes a row or rows from a table. See the documentation

 
Try it
Find Row with the PostgreSQL API

Finds a row in a table via a lookup column. See the documentation

 
Try it
Find Row With Custom Query with the PostgreSQL API

Finds a row in a table via a custom query. See the documentation

 
Try it
Insert Row with the PostgreSQL API

Adds a new row. See the documentation

 
Try it
Query SQL Database with the PostgreSQL API

Execute a SQL Query. See our docs to learn more about working with SQL in Pipedream.

 
Try it
Update Row with the PostgreSQL API

Updates an existing row. See the documentation

 
Try it
Upsert Row with the PostgreSQL API

Adds a new row or updates an existing row. See the documentation

 
Try it
Debug Memory Usage with the Pipedream Utils API

Get memory usage statistics for the current Pipedream workflow.

 
Try it
Formatting - [Data] Convert JSON to String with the Pipedream Utils API

Convert an object to a JSON format string

 
Try it
Formatting - [Data] Parse JSON with the Pipedream Utils API

Parse a JSON string

 
Try it
Formatting - [Date/Time] Add/Subtract Time with the Pipedream Utils API

Add or subtract time from a given input

 
Try it
Formatting - [Date/Time] Compare Dates with the Pipedream Utils API

Get the duration between two dates in days, hours, minutes, and seconds along with checking if they are the same.

 
Try it
Formatting - [Date/Time] Format with the Pipedream Utils API

Format a date string to another date string. For more examples on formatting, see the Sugar Date Format documentation.

 
Try it
Formatting - [Numbers] Format Currency with the Pipedream Utils API

Format a number as a currency

 
Try it
Formatting - [Numbers] Format Number with the Pipedream Utils API

Format a number to a new style. Does not perform any rounding or padding of the number.

 
Try it
Formatting - [Text] Convert HTML to Markdown with the Pipedream Utils API

Convert valid HTML to Markdown text

 
Try it
Formatting - [Text] Convert HTML to text with the Pipedream Utils API

Convert valid HTML to text

 
Try it
Formatting - [Text] Convert Markdown to HTML with the Pipedream Utils API

Convert Markdown text to HTML

 
Try it
Formatting - [Text] Decode URL with the Pipedream Utils API

Decode a URL string

 
Try it
Formatting - [Text] Encode URL with the Pipedream Utils API

Encode a string as a URL

 
Try it
Formatting - [Text] Extract by Regular Expression with the Pipedream Utils API

Find a match for a regular expression pattern. Returns all matched groups with start and end position.

 
Try it
Formatting - [Text] Extract by Regular Expressions List (Regex) with the Pipedream Utils API

Find matches for regular expressions. Returns all matched groups with start and end position.

 
Try it
Formatting - [Text] Extract Email Address with the Pipedream Utils API

Find an email address out of a text field. Finds the first email address only.

 
Try it
Formatting - [Text] Extract Number with the Pipedream Utils API

Find a number out of a text field. Finds the first number only.

 
Try it
Formatting - [Text] Extract Phone Number with the Pipedream Utils API

Find a complete phone number out of a text field. Finds the first number only.

 
Try it
Formatting - [Text] Extract URL with the Pipedream Utils API

Find a web URL out of a text field. Finds the first URL only.

 
Try it
Formatting - [Text] Replace Text with the Pipedream Utils API

Replace all instances of any character, word or phrase in the text with another character, word or phrase.

 
Try it
Formatting - [Text] Set Default Value with the Pipedream Utils API

Return a default value if the text is empty

 
Try it
Formatting - [Text] Split Text with the Pipedream Utils API

Split the text on a character or word and return one or all segments

 
Try it
Formatting - [Text] Transform Case with the Pipedream Utils API

Transform case for a text input

 
Try it
Formatting - [Text] Trim Whitespace with the Pipedream Utils API

Removes leading and trailing whitespace

 
Try it
Helper Functions - Base64 Decode String with the Pipedream Utils API

Accepts a base64-encoded string, returns a decoded UTF-8 string

 
Try it
Helper Functions - Compare Arrays with the Pipedream Utils API

Get the difference, intersection, union, or symetric difference of two arrays/sets.

 
Try it
Helper Functions - Convert Currency with the Pipedream Utils API

Convert an amount between currencies. See the documentation

 
Try it
Helper Functions - Convert HTML to Slack mrkdwn format with the Pipedream Utils API

Converts an HTML string to the Slack mrkdwn format using

 
Try it
Helper Functions - Convert JavaScript Object to JSON String with the Pipedream Utils API

Accepts a JavaScript object, returns that object converted to a JSON string

 
Try it
Helper Functions - Country name, given code (2-letter) with the Pipedream Utils API

Return the country name (in English) when given the 2-letter country code

 
Try it
Helper Functions - CSV File To Objects with the Pipedream Utils API

Convert a CSV file to an array of objects.

 
Try it
Helper Functions - Download File To /tmp with the Pipedream Utils API

Downloads a file to your workflow's /tmp directory

 
Try it
Helper Functions - Export Variables with the Pipedream Utils API

Export variables for use in your workflow

 
Try it
Helper Functions - Format ISO8601 Date/Time for Google Sheets with the Pipedream Utils API

Use the moment.js npm package to format an ISO8601 date/time as Google Sheets friendly formats. This action exports an object with compound date/time, date-only, and time-only values.

 
Try it
Helper Functions - Get Current Time in Timezone with the Pipedream Utils API

Returns the current time, tied to this workflow invocation, in the target timezone

 
Try it
Helper Functions - Get ISO String N Days Ago with the Pipedream Utils API

Returns an ISO string (UTC TZ) N days ago

 
Try it
Helper Functions - Get Time in Timezone with the Pipedream Utils API

Given an ISO 8601 timestamp, and a timezone, convert the time to the target timezone.

 
Try it
Helper Functions - HTML to Markdown with the Pipedream Utils API

Convert via turndown

 
Try it
Helper Functions - Pipedream Task Scheduler - Schedule Task with the Pipedream Utils API

Schedule a task with an existing task scheduler source. See here for more details.

 
Try it
Helper Functions - Pretty Print JSON with the Pipedream Utils API

Pretty print a JavaScript object or value

 
Try it
Helper Functions - Random Integer with the Pipedream Utils API

Generate a random integer (whole number). Useful for random delays.

 
Try it
Helper Functions - Random Item(s) from List with the Pipedream Utils API

Returns a randomly selected value(s) from a user-defined list of options.

 
Try it
Helper Functions - Retrieve all RSS Stories with the Pipedream Utils API

Retrieve all stories from one or more RSS feeds.

 
Try it
Helper Functions - Retrieve New RSS Stories with the Pipedream Utils API

Gets new stories from a specified RSS feed that have not already been processed.

 
Try it
Helper Functions - Send email with Nodemailer with the Pipedream Utils API

Sends an email using the nodemailer package

 
Try it
Helper Functions - Send to Amazon S3 with the Pipedream Utils API

Send data to Amazon S3 using Pipedream's destination integration. See https://docs.pipedream.com/destinations/s3/

 
Try it
Helper Functions - Trigger Workflow with the Pipedream Utils API

Trigger another Pipedream workflow in your workspace.

 
Try it
Helper Functions - XML to JSON with the Pipedream Utils API

See xml-js

 
Try it

Explore Other Apps

1
-
24
of
2,800+
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.
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.
Premium
ServiceNow
ServiceNow
The smarter way to workflow
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.