Connect Google BigQuery and LeanKit

Both apps 54Google BigQuery 14LeanKit 40

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

  Polling trigger: fires when a new board is created.

• Trigger
  New card

  Polling trigger: fires when a new card is added to the specified board.

• Trigger
  New card in lane

  Polling trigger: fires when a new card is added to the specified lane in the specified board.

• Action
  Add Card Connections

  Create parent and child connections — LeanKit AgilePlace v2 API (connections/create)

• Action
  Add Comment

  Create a comment — LeanKit AgilePlace v2 API (comment/create)

• Action
  Archive a board

  Archive a board — LeanKit AgilePlace v2 API (board/archive)

• Action
  Assign or unassign one or more users or teams to cards

  Assign or unassign one or more users or teams to cards — LeanKit AgilePlace v2 API (card/assign-members)

• Action
  Create a card

  Create a card — LeanKit AgilePlace v2 API (card/create)

• Action
  Create an attachment

  Create an attachment — LeanKit AgilePlace v2 API (attachment/create)

• Action
  Create a new board

  Create a new board — LeanKit AgilePlace v2 API (board/create)

• Action
  Create a new planning increment

  Create a new planning increment — LeanKit AgilePlace v2 API (planning-series/create-increment)

• Action
  Create a new planning series

  Create a new planning series — LeanKit AgilePlace v2 API (planning-series/create-series)

• Action
  Create a team

  Create a team — LeanKit AgilePlace v2 API (team/create)

• Action
  Create dependencies

  Create dependencies — LeanKit AgilePlace v2 API (dependencies/create)

• Action
  Delete a board

  Delete a board — LeanKit AgilePlace v2 API (board/delete)

• Action
  Delete an attachment

  Delete an attachment — LeanKit AgilePlace v2 API (attachment/delete)

• Action
  Delete a planning increment by id

  Delete a planning increment by id — LeanKit AgilePlace v2 API (planning-series/delete-increment)

• Action
  Delete a team

  Delete a team — LeanKit AgilePlace v2 API (team/delete)

• Action
  Delete Card

  Delete a card by id — LeanKit AgilePlace v2 API (card/delete)

• Action
  Delete multiple cards

  Delete multiple cards — LeanKit AgilePlace v2 API (card/delete-many)

• Action
  Get a list of attachments for a card

  Get a list of attachments for a card — LeanKit AgilePlace v2 API (attachment/list)

• Action
  Get a list of cards

  Get a list of cards — LeanKit AgilePlace v2 API (card/list)

• Action
  Get a list of leaf lanes for a board (lanes that can hold cards)

  Get a list of leaf lanes for a board (lanes that can hold cards) — LeanKit AgilePlace v2 API (board/leaf-lanes)

• Action
  Get a list of parent cards

  Get a list of parent cards — LeanKit AgilePlace v2 API (connections/parents)

• Action
  Get a list of planning series for an account

  Get a list of planning series for an account — LeanKit AgilePlace v2 API (planning-series/list-series)

• Action
  Get a list of tags on a board

  Get a list of tags on a board — LeanKit AgilePlace v2 API (tags/list)

• Action
  Get a list of task cards for a card

  Get a list of task cards for a card — LeanKit AgilePlace v2 API (card/list-tasks)

• Action
  Get an attachment's contents

  Get an attachment's contents — LeanKit AgilePlace v2 API (attachment/get)

• Action
  Get a specified planning series

  Get a specified planning series — LeanKit AgilePlace v2 API (planning-series/get-series)

• Action
  Get Board

  Retrieve a board by ID, including its lanes.

• Action
  Get Card

  Get card details by card id — LeanKit AgilePlace v2 API (card/get)

• Action
  Get User

  Retrieve a user by ID.

• Action
  List Boards

  List boards on the account.

• Action
  List Board Users

  List board users — LeanKit AgilePlace v2 API (board/user-roles)

• Action
  List Comments

  List comments on a card.

• Action
  List Users

  List users on the account.

• Action
  Move Card

  Move a card — LeanKit AgilePlace v2 API (card/move)

• Action
  Search Cards

  Search cards on a board with filters.

• Action
  Unarchive a board

  Unarchive a board — LeanKit AgilePlace v2 API (board/unarchive)

• Action
  Update Card

  Update a card — LeanKit AgilePlace v2 API (card/update)

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