ConnectWise PSA
Microsoft SQL Server
Integrate ConnectWise PSA with Microsoft SQL Server within minutes using Conduitly. Connect your work apps with Conduitly’s no code integration platform and automate the flow of data, repetitive tasks, and workflows between ConnectWise PSA and Microsoft SQL Server.
Create automations for
ConnectWise PSA with Microsoft SQL Server in minutes
Supported Triggers & Actions
Expense Entry Added/Updated
Triggers when a expense entry is added/updated.
Trigger
Schedule
Invoice Added/Updated
Triggers when a invoice is added/updated.
Trigger
Schedule
Invoice Payment Added/Updated
Triggers when a invoice payment is added/updated.
Trigger
Schedule
Purchase Order Added/Updated
Triggers when a purchase order is added/updated.
Trigger
Schedule
Time Entry Added/Updated
Triggers when a new Time Entry is added/updated.
Trigger
Schedule
New Column Added
Get the latest column added to the table.
Trigger
Schedule
New Row Added
Get the latest row added to the table.
Trigger
Schedule
New Row Added (Custom Query)
Retrieve the latest row added based on the custom query in the database.
Trigger
Schedule
New Table Added
Get the latest table added to the database.
Trigger
Schedule
Updated Row
Get the latest row updated in the table based on provided column(s).
Trigger
Schedule
Add Expense Entry
Add expense entry.
Action
Write
Add GL Account
Add GL account.
Action
Write
Add Invoice
Add invoice.
Action
Write
Add Invoice Payment
Add invoice payment.
Action
Write
Add Purchase Order
Add purchase order.
Action
Write
Add Purchase Order Line Item
Add purchase order line item.
Action
Write
Add Time Entry
Add time entry.
Action
Write
Get Expense Entry
Get expense entry.
Action
Write
Get GL Account
Get GL Account.
Action
Write
Get GL Entry
Get GL entry.
Action
Write
Get Invoice
Get invoice.
Action
Write
Get Invoice Payment
Get invoice payment.
Action
Write
Get Purchase Order
Get purchase order.
Action
Write
Get Purchase Order Line Item
Get purchase order line item.
Action
Write
Get Time Entry
Get time entry.
Action
Write
List Expense Entries
Get list of expense entries.
Action
Write
List GL Accounts
Get list of GL accounts.
Action
Write
List GL Entries
Get list of GL entries.
Action
Write
List Invoice Payments
Get list of invoice payments.
Action
Write
List Invoices
Get list of invoices.
Action
Write
List Purchase Order Line Items
Get list of purchase order line items.
Action
Write
List Purchase Orders
Get list of purchase orders.
Action
Write
List Time Entries
Get list of time entries.
Action
Write
List Webhooks
Get list of webhooks.
Action
Write
Update Expense Entry
Update expense entry.
Action
Write
Update GL Account
Update GL account.
Action
Write
Update GL Entry
Update GL entry.
Action
Write
Update Invoice
Update invoice.
Action
Write
Update Invoice Payment
Update invoice payment.
Action
Write
Update Purchase Order
Update purchase order.
Action
Write
Update Purchase Order Line Item
Update purchase order line item.
Action
Write
Update Time Entry
Update time entry.
Action
Write
Find New Row
Find a new row in the table.
Action
Write
Find New Row Via Custom Query
Find a new row in the table via custom query.
Action
Write
Insert New Row
Insert a new row into the table.
Action
Write
Update Row
Update row(s) into the table.
Action
Write
Expense Entry Added/Updated
Triggers when a expense entry is added/updated.
Trigger
Schedule
Invoice Added/Updated
Triggers when a invoice is added/updated.
Trigger
Schedule
Invoice Payment Added/Updated
Triggers when a invoice payment is added/updated.
Trigger
Schedule
Purchase Order Added/Updated
Triggers when a purchase order is added/updated.
Trigger
Schedule
Time Entry Added/Updated
Triggers when a new Time Entry is added/updated.
Trigger
Schedule
New Column Added
Get the latest column added to the table.
Trigger
Schedule
New Row Added
Get the latest row added to the table.
Trigger
Schedule
New Row Added (Custom Query)
Retrieve the latest row added based on the custom query in the database.
Trigger
Schedule
New Table Added
Get the latest table added to the database.
Trigger
Schedule
Updated Row
Get the latest row updated in the table based on provided column(s).
Trigger
Schedule
Add Expense Entry
Add expense entry.
Action
Write
Add GL Account
Add GL account.
Action
Write
Add Invoice
Add invoice.
Action
Write
Add Invoice Payment
Add invoice payment.
Action
Write
Add Purchase Order
Add purchase order.
Action
Write
Add Purchase Order Line Item
Add purchase order line item.
Action
Write
Add Time Entry
Add time entry.
Action
Write
Get Expense Entry
Get expense entry.
Action
Write
Get GL Account
Get GL Account.
Action
Write
Get GL Entry
Get GL entry.
Action
Write
Get Invoice
Get invoice.
Action
Write
Get Invoice Payment
Get invoice payment.
Action
Write
Get Purchase Order
Get purchase order.
Action
Write
Get Purchase Order Line Item
Get purchase order line item.
Action
Write
Get Time Entry
Get time entry.
Action
Write
List Expense Entries
Get list of expense entries.
Action
Write
List GL Accounts
Get list of GL accounts.
Action
Write
List GL Entries
Get list of GL entries.
Action
Write
List Invoice Payments
Get list of invoice payments.
Action
Write
List Invoices
Get list of invoices.
Action
Write
List Purchase Order Line Items
Get list of purchase order line items.
Action
Write
List Purchase Orders
Get list of purchase orders.
Action
Write
List Time Entries
Get list of time entries.
Action
Write
List Webhooks
Get list of webhooks.
Action
Write
Update Expense Entry
Update expense entry.
Action
Write
Update GL Account
Update GL account.
Action
Write
Update GL Entry
Update GL entry.
Action
Write
Update Invoice
Update invoice.
Action
Write
Update Invoice Payment
Update invoice payment.
Action
Write
Update Purchase Order
Update purchase order.
Action
Write
Update Purchase Order Line Item
Update purchase order line item.
Action
Write
Update Time Entry
Update time entry.
Action
Write
Find New Row
Find a new row in the table.
Action
Write
Find New Row Via Custom Query
Find a new row in the table via custom query.
Action
Write
Insert New Row
Insert a new row into the table.
Action
Write
Update Row
Update row(s) into the table.
Action
Write
Don’t see the integration or actions you need? No problem.
Conduitly provides custom integration services to customers. If you need an integration that we don’t have, or you need additional triggers or actions to one we do, we can help.
Request An Integration