Do everything in one place
Customize your Google BigQuery and Jira integration with the following
triggers and actions.
Triggers
When this happens…
Google BigQuery
- New job completedNew job completed in BigQuery
- New rowNew row in a table in BigQuery
- New rows BatchNew batch of rows in a table in BigQuery
- Scheduled query BatchNew scheduled query using custom SQL in BigQuery
Any other trigger you can think up
Jira
- Deleted object Real-timeDeleted object in Jira
- Export new issues in JiraExport new issues in Jira
- Export new/updated issues in JiraExport new/updated issues in Jira
- New event Real-timeNew event in Jira
- New issueNew issue in Jira
- New issue BatchNew issue in Jira
- New/updated comment Real-timeNew/updated comment in Jira
- Updated issueUpdated issue in Jira
- Updated issue BatchUpdated issue in Jira
- New/updated issue Real-timeNew/updated issue in Jira
- New/updated worklog Real-timeNew/updated worklog in Jira
Any other trigger you can think up
Actions
Do this…
Google BigQuery
- Custom actionCustom action in Google BigQuery (Custom)
- Get batch of rows by Job ID BatchGet batch of rows from query result in BigQuery
- Insert rowInsert a row in table in BigQuery
- Insert rows BatchInsert rows in table in BigQuery
- Load data into BigQueryLoad data into table on BigQuery
- Load data from Google Cloud Storage into BigQueryLoad data from Google Cloud Storage into table on BigQuery
- Run custom SQL in BigQueryRun custom SQL in BigQuery
- Select rows (Old) BatchSelect rows asynchronously in a table in BigQuery
- Select rows BatchSelect rows in a table in BigQuery
- Select rows using custom SQL (Old) BatchSelect rows asynchronously using custom SQL in BigQuery
- Select rows using custom SQL BatchSelect rows using custom SQL in BigQuery
- Select rows using custom SQL and insert into table BatchSelect rows using custom SQL and insert into table in BigQuery
Any other action you can think up
Jira
- Custom actionCustom action in Jira (Custom)
- Assign user to issueAssign user to issue in Jira
- Create commentCreate comment for issue in Jira
- Create issueCreate issue in Jira
- Create userCreate user in Jira
- Get user detailsGet user in Jira
- Download attachmentDownload attachment from issue in Jira
- Get changelog of an issueGet changelog of an issue in Jira
- Get issueGet issue details from Jira
- Get issue comments BatchGet list of issue comments for issue in Jira
- Get issue schemaGet issue schema for Jira
- Search assignable users BatchSearch assignable users for issue in Jira
- Search issues BatchSearch issues in Jira
- Search issues by JQL BatchSearch issues by JQL in Jira
- Update commentUpdate comment for issue in Jira
- Update issueUpdate issue in Jira
- Update issue statusUpdate status of issue in Jira
- Upload attachmentUpload attachment to issue in Jira
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