Connect Google BigQuery and JOIN

Both apps 33Google BigQuery 14JOIN 19

• 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
  Application Created

  Triggers when a new job application is received in JOIN.

• Trigger
  Job Published

  Triggers when a job is published (goes online) in JOIN.

• Trigger
  Job Unpublished

  Triggers when a job is taken offline or archived in JOIN.

• Action
  Add candidate note

  Adds a note to a candidate in JOIN.

• Action
  Add job

  Creates a job in JOIN. New jobs are activated and multiposted to job boards automatically.

• Action
  Add location

  Creates a new office location in JOIN that job ads can be assigned to.

• Action
  Create Application

  Creates an application for a candidate on a JOIN job, optionally attaching documents such as a CV.

• Action
  Get application

  Returns one job application, including its candidate, job, attachments, screening answers and pipeline stage.

• Action
  Get candidate

  Returns a single JOIN candidate by id, including contact details, tags, consent status and their applications, with notes optionally embedded.

• Action
  Get job

  Returns a single JOIN job by its ID, including its title, status, office and optionally its full content.

• Action
  Get Jobs

  Returns jobs in your JOIN account, optionally filtered by status, title, country, external id, or creation/update dates.

• Action
  Get Online Jobs

  Returns the jobs currently published (online) in your JOIN account, optionally filtered by title, country, dates or external id.

• Action
  List applications

  Returns the applications in your JOIN account, optionally filtered by job, dates, country, hiring state or pipeline stage.

• Action
  List candidate notes

  Returns all notes recorded on a candidate in JOIN, including replies.

• Action
  List candidates

  Returns the candidates in your JOIN company, optionally filtered by a name/email search or creation date.

• Action
  List candidate scorecards

  Returns the scorecards submitted for a candidate's job application, including each interviewer's overall recommendation, attribute ratings and question answers.

• Action
  List locations

  Returns the office locations in your JOIN account, optionally filtered by country or city.

• Action
  Update job

  Updates an existing job's details, such as title, description, office, salary, and application requirements. Fields you leave blank stay unchanged.

• Action
  Update Job Status

  Changes a JOIN job's status to online, offline or archived, and returns the job's ID.

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