Do everything in one place

Customize your Bill.com and SQL Server secondary integration with the following triggers and actions.

Triggers

When this happens…

Bill.com
  • New record
    New object in Bill.com
  • New/updated record
    New/updated object in Bill.com
  • Any other trigger you can think up

SQL Server secondary
  • New row
    New row in a table in SQL Server secondary
  • New rows Batch
    New batch of rows in a table in SQL Server secondary
  • New rows via custom SQL Batch
    New batch of rows via custom SQL in SQL Server secondary
  • Scheduled query Batch
    Scheduled query using custom SQL in SQL Server secondary
  • New/updated row
    New/updated row in a table in SQL Server secondary
  • New/updated rows Batch
    New/updated batch of rows in a table in SQL Server secondary
  • New/updated rows via custom SQL Batch
    New/updated batch of rows via custom SQL in SQL Server secondary
  • Any other trigger you can think up

Actions

Do this…

Bill.com
  • Custom action
    Custom action in Bill.com (Custom)
  • Add line to invoice
    Add line item to invoice in Bill.com
  • Create record
    Create object in Bill.com
  • Delete record
    Delete object in Bill.com
  • Get disbursement data
    Get disbursement data in Bill.com
  • Get record details by ID
    Get object by ID in Bill.com
  • Search record
    Search object in Bill.com
  • Update record
    Update object in Bill.com
  • Any other action you can think up

  • Show all 8
SQL Server secondary
  • Delete rows
    Delete rows in a table in SQL Server secondary
  • Execute stored procedure
    Execute stored procedure in SQL Server secondary
  • Export query result Bulk
    Export result of custom SQL in SQL Server secondary
  • Insert row
    Insert row in a table in SQL Server secondary
  • Insert rows Batch
    Insert batch of rows in a table in SQL Server secondary
  • Run custom SQL
    Run custom SQL in SQL Server secondary
  • Run long query using custom SQL
    Run long query using custom SQL in SQL Server secondary
  • Select rows
    Select rows in a table in SQL Server secondary
  • Select rows using custom SQL
    Select rows using custom SQL in SQL Server secondary
  • Replicate rows Batch
    Replicate batch of rows to table in SQL Server secondary
  • Update rows
    Update rows in a table in SQL Server secondary
  • Update rows Batch
    Update batch of rows in a table in SQL Server secondary
  • Upsert row
    Upsert row in a table in SQL Server secondary
  • Upsert rows Batch
    Upsert batch of rows in a table in SQL Server secondary
  • Any other action you can think up

  • Show all 14

Let us tailor your Bill.com and SQL Server secondary integrations

Pre-built Bill.com and SQL Server secondary Automations

See more

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