with PostgreSQL and Pipedream Utils?
Emit new event when a new column is added to a table. See the documentation
Emit new event when a row is added or modified. See the documentation
Emit new event when a new row is added to a table. See the documentation
Emit new event when new rows are returned from a custom query that you provide. See the documentation
Emit new event when a new table is added to the database. See the documentation
Get memory usage statistics for the current Pipedream workflow.
Convert an object to a JSON format string
Finds a row in a table via a custom query. See the documentation
Add or subtract time from a given input
Get the duration between two dates in days, hours, minutes, and seconds along with checking if they are the same.
Format a date string to another date string. For more examples on formatting, see the Sugar Date Format documentation.
Format a number to a new style. Does not perform any rounding or padding of the number.
Convert valid HTML to Markdown text
Convert Markdown text to HTML
Find a match for a regular expression pattern. Returns all matched groups with start and end position.
Find matches for regular expressions. Returns all matched groups with start and end position.
Find an email address out of a text field. Finds the first email address only.
Find a number out of a text field. Finds the first number only.
Find a complete phone number out of a text field. Finds the first number only.
Find a web URL out of a text field. Finds the first URL only.
Replace all instances of any character, word or phrase in the text with another character, word or phrase.
Return a default value if the text is empty
Split the text on a character or word and return one or all segments
Removes leading and trailing whitespace
Accepts a base64-encoded string, returns a decoded UTF-8 string
Get the difference, intersection, union, or symetric difference of two arrays/sets.
Convert an amount between currencies. See the documentation
Converts an HTML string to the Slack mrkdwn format using
Accepts a JavaScript object, returns that object converted to a JSON string
Return the country name (in English) when given the 2-letter country code
Convert a CSV file to an array of objects.
Downloads a file to your workflow's /tmp directory
Export variables for use in your workflow
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.
Returns the current time, tied to this workflow invocation, in the target timezone
Returns an ISO string (UTC TZ) N days ago
Given an ISO 8601 timestamp, and a timezone, convert the time to the target timezone.
Pretty print a JavaScript object or value
Generate a random integer (whole number). Useful for random delays.
Returns a randomly selected value(s) from a user-defined list of options.
Retrieve all stories from one or more RSS feeds.
Gets new stories from a specified RSS feed that have not already been processed.
Sends an email using the nodemailer package
Send data to Amazon S3 using Pipedream's destination integration. See https://docs.pipedream.com/destinations/s3/
Trigger another Pipedream workflow in your workspace.
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.
import postgresql from "@pipedream/postgresql" export default defineComponent({ props: { postgresql, }, async run({ steps, $ }) { // Component source code: // https://github.com/PipedreamHQ/pipedream/tree/master/components/postgresql const queryObj = { text: "SELECT NOW()", values: [], // Ignored since query does not contain placeholders }; return await this.postgresql.executeQuery(queryObj); }, })
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.
export default defineComponent({ props: { pipedream_utils: { type: "app", app: "pipedream_utils", } }, async run({steps, $}) { }, })