Connect Google BigQuery and timelink

Both apps 41Google BigQuery 14timelink 27

• 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
  Deleted Time Entry

  Triggers when a time entry is deleted.

• Trigger
  New Time Entry

  Triggers when a new time entry is created.

• Trigger
  Updated Time Entry

  Triggers when a time entry is updated.

• Action
  Create Client

  Creates a new client in timelink.

• Action
  Create Project

  Creates a new project in timelink, optionally assigned to a client.

• Action
  Create Service

  Creates a new service (a type of work you track time against) in timelink.

• Action
  Create Time Entry

  Creates a time entry for a user in timelink, optionally linked to a client, project and service.

• Action
  Delete client

  Deletes a client in timelink.

• Action
  Delete project

  Deletes a project in timelink.

• Action
  Delete service

  Deletes a service in timelink.

• Action
  Delete time entry

  Deletes a time entry from timelink.

• Action
  Find Client

  Finds clients whose details match the search text, optionally filtered by active status or ids.

• Action
  Find Project

  Searches projects by name or other text and returns the matching projects, optionally narrowed to one client or to active/inactive projects.

• Action
  Find Service

  Searches your timelink services by text, for example part of the service name, and returns the matching services.

• Action
  Find Time Entry

  Searches time entries by text and optional filters such as date range, client, project, service, user and billing status, returning the matching entries.

• Action
  Get client

  Returns a single client by its ID.

• Action
  Get project

  Returns a single timelink project by its ID, including its client, color, acronym and active/billable flags.

• Action
  Get service

  Returns a single service (activity type) by its ID, including name, color, acronym and billable/active status.

• Action
  Get time entry

  Returns a single time entry by its ID, including its client, project, service, description, billing flags and start/end times.

• Action
  Get user

  Returns a single timelink user by ID, including name, email, active status, timezone and language.

• Action
  List clients

  Returns the clients in your timelink account, optionally filtered by search text or active status.

• Action
  List services

  Returns the services (billable activities) in your timelink account, optionally filtered by text, active status or specific ids.

• Action
  List users

  Returns the users in your timelink company, optionally filtered by search text, active status or specific user ids.

• Action
  Update Client

  Updates an existing client in timelink. Only the fields you fill in are changed.

• Action
  Update Project

  Updates an existing project's name, client, color, billing and other details. Only the fields you fill in are changed.

• Action
  Update Service

  Updates an existing service in timelink, such as its name, color, billable or active status.

• Action
  Update Time Entry

  Updates an existing time entry in timelink, changing only the details you fill in, such as its times, description, client, project or service.

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