Connect Google BigQuery and Sirv

Both apps 48Google BigQuery 14Sirv 34

• Trigger
  New Job Completed

  Triggers when a BigQuery job in the project finishes, whether it succeeded or failed.

• Trigger
  New Row

  Triggers when a new row is added to a table. New rows are detected by a column you name that increases for newer rows, such as a creation time or a sequential ID.

• Trigger
  Query Job Completed (With Row Data)

  Triggers when a SELECT query job in the project finishes successfully, and includes its result rows.

• Trigger
  Updated Row

  Triggers when a row in a table is added or changed, detected by a last-updated timestamp column you name.

• Action
  Create Row

  Creates a new row of data in a table. Note: Does not create a job.

• Action
  Create Rows

  Creates new rows of data in a table (accepts line items). Note: Does not create a job.

• Action
  Delete Rows

  Deletes every row in a table whose match column equals the value you give.

• Action
  Find One Row

  Finds the first row in a table whose column equals the value you give.

• Action
  Get Rows for Job Completed

  Returns the result rows of a finished query job.

• Action
  Import Data

  Imports a JSON, CSV, Avro or Parquet file from Cloud Storage into a table. Waits up to about 40 seconds for the import to finish; larger imports keep running in BigQuery and return state RUNNING.

• Action
  List Datasets

  Returns the datasets in a Google Cloud project.

• Action
  List Tables

  Returns the tables in a BigQuery dataset.

• Action
  Run a Query

  Runs a SQL query against a table in BigQuery.

• Action
  Update Row(s)

  Updates every row in a table whose match column equals the value you give, setting the columns you choose.

• Trigger
  New File

  Triggers when a new file appears in a folder of your Sirv account, and hands on that file's name, type, size and dimensions.

• Trigger
  New Tagged File

  Triggered when a new file carrying the chosen tag appears in your Sirv account.

• Action
  Add Advanced Watermark

  Builds the Sirv image URL that shows one of your images with a watermark laid over it, using the position, size, opacity and rotation you choose.

• Action
  Add Canvas or Border

  Puts a coloured canvas and/or border around a Sirv image and returns the new image URL. Nothing is re-uploaded — the original file is untouched.

• Action
  Add Tags to File

  Adds meta tags to a file in your Sirv account.

• Action
  Apply Color Effects

  Adjusts the colours of a Sirv image — hue, saturation, lightness, tint, tone and levels — and returns the new image URL. The original file is untouched.

• Action
  Convert Spin to Video

  Turns a 360 spin stored in your Sirv account into an MP4 video and returns the path of the video that was created.

• Action
  Convert Video to Spin

  Converts a video in your Sirv account into a 360-degree spin and returns the spin that was created.

• Action
  Copy File

  Copies a file in your Sirv account to another path, leaving the original in place.

• Action
  Create Folder

  Creates an empty folder in your Sirv account at the path you give.

• Action
  Create Thumbnail

  Builds the Sirv image URL that serves a resized, optionally cropped thumbnail of one of your images.

• Action
  Delete File

  Deletes a file, or an empty folder, from your Sirv account.

• Action
  Delete file tags

  Removes one or more tags from a file in your Sirv account.

• Action
  Download File

  Downloads a file from your Sirv account and returns its contents.

• Action
  Fetch File From URL

  Pulls a file from a web address straight into your Sirv account, saving it at the path you choose, and reports whether the fetch succeeded.

• Action
  Find File

  Searches the files in your Sirv account by name, folder, type, size, tags, description or date, and returns the matching files.

• Action
  Get API Limits

  Returns your Sirv API rate limits and how much of each you have used.

• Action
  Get batch delete job

  Returns the progress and results of a batch delete job you started earlier.

• Action
  Get CDN URL

  Returns the public web address of a file in your Sirv account.

• Action
  Get File Info

  Returns the details Sirv holds on one file — its type, size, dates and image information.

• Action
  Get File Metadata

  Returns everything Sirv stores about a file: its title, description, tags, product details and any other metadata held against it.

• Action
  Get File Tags

  Returns the tags attached to a file in your Sirv account.

• Action
  Get product metadata

  Returns the product information stored on a file in your Sirv account.

• Action
  Get Storage Info

  Returns how much storage your Sirv account is using and how much it is allowed.

• Action
  Get Usage Report

  Returns how much your Sirv account has served — the number of file requests and the bytes transferred, broken down by day.

• Action
  Get ZIP Job

  Returns the progress and results of a zip job, including the archive it produced.

• Action
  List Folder Contents

  Lists the files and sub-folders inside a folder of your Sirv account, with each item's name, size, type and when it was last changed.

• Action
  Make API Call

  Makes any Sirv API call you specify, for endpoints that do not yet have their own action. You supply the method, the path and any data; the connected account's credentials are applied for you.

• Action
  Rename or Move File

  Renames a file or folder, or moves it to another folder, by giving its new path.

• Action
  Set File Metadata

  Sets the title, description, tags and product details held against a file in your Sirv account. Anything left blank is left as it is.

• Action
  Set Product Metadata

  Attaches product details — code, name, brand and categories — to a file in your Sirv account.

• Action
  Update account

  Changes your Sirv account settings — file minification and where missing files are fetched from. Only the settings you fill in are sent; the rest are left as they are.

• Action
  Upload File

  Uploads a file to your Sirv account from a web address.

• Action
  Zip Files

  Starts a job that packs the files and folders you name into a single zip in your Sirv account, and returns the job so you can check when it is ready.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.