PostgreSQL and RecipeOps by Workato integrations and automations

Do everything in one place

Customize your PostgreSQL and RecipeOps by Workato integration with the following triggers and actions.

Triggers

When this happens…

PostgreSQL
  • New row
    New row in a table in PostgreSQL
  • New rows Batch
    New batch of rows in a table in PostgreSQL
  • New/updated row
    New/updated row in a table in PostgreSQL
  • New/updated rows Batch
    New/updated batch of rows in a table in PostgreSQL

    • Any other trigger you can think up

RecipeOps by Workato
  • Usage threshold reached Real-time
    Triggers when usage thresholds are reached in 10% intervals
  • API concurrency threshold exceeded Real-time
    API concurrency threshold exceeded in workspace
  • On-prem agent disconnected Real-time
    On-prem agent disconnected
  • Job failed Real-time
    Receive notification when a job fails in specified recipes
  • Member invitation accepted Real-time
    Receive notification when an invitation is accepted
  • Package deployed Real-time
    Receive notification when a package is deployed
  • Recipe started Real-time
    Receive notification when a recipe is started
  • Recipe stopped by user Real-time
    Receive notification when a recipe is stopped by a user
  • Account connected Real-time
    Receive notification when an app is connected
  • Account disconnected Real-time
    Receive notification when an app is disconnected
  • Account credentials refresh failed Real-time
    Receive notification when an App fails to refresh its access credentials
  • Recipe stopped by Workato Real-time
    Receive notification when a recipe is stopped due to errors

    • Any other trigger you can think up

Actions

Do this…

PostgreSQL
  • Delete rows Batch
    Delete rows in a table in PostgreSQL
  • Export query result
    Export query result as a CSV file in PostgreSQL
  • Insert row
    Insert row in a table in PostgreSQL
  • Run custom SQL Batch
    Run custom SQL in PostgreSQL
  • Run long query using custom SQL
    Run long query using custom SQL in PostgreSQL
  • Select rows Batch
    Select rows in a table in PostgreSQL
  • Select rows using custom SQL Batch
    Select rows using custom SQL in PostgreSQL
  • Get table schema
    Get table schema for PostgreSQL
  • Update rows
    Update rows in a table in PostgreSQL
  • Upsert rows Batch
    Upsert batch of rows in a table in PostgreSQL

    • Any other action you can think up

RecipeOps by Workato
  • Get recipe details
    Get recipe details of specified recipe
  • Search job history Batch
    Search job history of specified recipe
  • Rerun jobs Batch
    Rerun specified jobs
  • List connections Batch
    List connections
  • List recipes Batch
    List all recipes
  • Search recipes Batch
    Search recipes
  • Start recipe
    Start an inactive recipe
  • Stop recipe
    Stop an active recipe
  • Get account details
    Get account details

    • Any other action you can think up

The wonders of Workato

Easily set up as many intelligent automations you need.
  • 1000s of ready-to-use templates
  • Accelerate work with intelligent automation
  • Do it yourself, faster
  • Build bots. Put them to work

Market leaders run on Workato

  • mgm
  • adobe
  • att
  • atlassian
  • slack

Let’s start automating

Schedule a Demo