Do everything in one place
Customize your Barista and JDBC integration with the following
triggers and actions.
Triggers
When this happens…
JDBC
- New rowNew row in a table in JDBC source
- New rows BatchNew batch of rows in a table in JDBC source
- New rows via custom SQL BatchNew batch of rows via custom SQL in JDBC source
- Scheduled query BatchScheduled query using custom SQL in JDBC source
- New/updated rows via custom SQL BatchNew/updated batch of rows via custom SQL in JDBC source
Any other trigger you can think up
Actions
Do this…
Barista
- Onboard EmployeeCreate Employee in 'Barista
- Post KBCreate KB in 'Barista
- Delete EmployeeDelete Employee in Barista
- Generate Integration TokenGenerate Integration Token in ' 'Barista
- Get All EmployeesGET All Employees from Barista
- Get All KBsGET All KBs from Barista
- Get Conversation from ChannelGET Conversation from Channel
- Get Employee by EmailSearch Employee in Barista
- Get Employee by IDSearch Employee in Barista
- Get Report9 by ESP FiltersGET Report9 Data in ' 'Barista
- Get TaskGet Task from ' 'Barista
- Get Task by Channel IDGet Task from ' 'Barista
- Parse CSV DataParse CSV Data in Barista
- Parse CSV Status CheckParse CSV Status Check in Barista
- Patch KBPatch KB in 'Barista
- Post Data To ChannelPost Data to Barista channel
- Post Sync IDsPost Sync IDs in Barista
- Search EmployeesSearch Employees in Barista
- Terminate EmployeeTerminate Employee in Barista
- Update Channel Live Agent Session ModePerforms a PATCH to a Channel Object to set sys_custom_fields.start_live_agent_suppor=True/False
- Update EmployeeUpdate Employee in ' 'Barista
- Update Reference Number on TaskUpdate Reference Number in ' 'Barista Task
- Update Report9 DataUpdate Report9 Data in ' 'Barista
- Update TaskUpdate Task in ' 'Barista
- Update Task OwnerChange Owner on Tasks
- Update Task StatusChange Status on Tasks
- Update Task Live Agent Session ModePerforms a PATCH to a Task Object to set sys_custom_fields.start_live_agent_suppor=True/False
- Upload CSV file to baristaUpload CSV File to Barista
Any other action you can think up
JDBC
- Export query resultExport query result as a CSV file in JDBC source
- Run custom SQL BatchRun custom SQL in JDBC source
- Run long query using custom SQLRun long query using custom SQL in JDBC source
- Select rows BatchSelect rows in a table in JDBC source
- Select rows using custom SQL BatchSelect rows using custom SQL in JDBC source
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