Connect 5pm and Google BigQuery

Both apps 425pm 28Google BigQuery 14

• Trigger
  New Progress

  Triggers when a new task progress is created.

• Trigger
  New Project

  Fires when a new project is created in 5pm.

• Trigger
  New Task

  Triggers when a new support task is created.

• Trigger
  New User

  Triggers when a new support user is created.

• Trigger
  Updated Project

  Fires when a project is updated in 5pm.

• Trigger
  Updated Task

  Triggers when a new support task is updated.

• Trigger
  Updated User

  Triggers when a new support user is updated.

• Action
  Add Task Progress

  Add Task Progress (progress in percent and house down).

• Action
  Add User

  Create a new user in the 5pm account (UsersService add).

• Action
  Create Note

  Creates a new note in task.

• Action
  Create Project

  Creates a new project.

• Action
  Create Task
• Action
  Delete Note

  Remove an activity note/progress message (ActivityService remove).

• Action
  Delete Project

  Remove a project (ProjectsService remove).

• Action
  Delete Task

  Remove a task from a 5pm project (TasksService remove).

• Action
  Delete User

  Remove a user from the account (UsersService remove).

• Action
  Find Project by Id

  Retrieve a single project by its id (ProjectsService getById).

• Action
  Find Task

  Finds a task in the application.

• Action
  Find Task by Id

  Finds a task by Id in the application.

• Action
  Find User by Email

  Retrieve a user by their email address (UsersService getByEmail).

• Action
  Find User by Id

  Finds a user by Id in the system.

• Action
  List Notes

  List activity notes/progress messages on a task (ActivityService getList).

• Action
  List Projects

  List all projects in the account (ProjectsService getAll/getList).

• Action
  List Users

  List all users in the account (UsersService getAll).

• Action
  Update Note

  Update an activity note/progress message (ActivityService update).

• Action
  Update Project

  Update a project's fields (ProjectsService update).

• Action
  Update Task

  Update task in the application.

• Action
  Update User

  Update a user's fields (UsersService update).

• 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.

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