Connect Google BigQuery to InfoLobby

Both apps 28Google BigQuery 14InfoLobby 14

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

• Action
  Add File

  Uploads a file (base64 content) and appends it to a file field on an InfoLobby record. Existing attachments on the field are kept.

• Action
  Add Table

  Create a new table in a space.

• Action
  Add Task

  Creates a task attached to a record in an InfoLobby table.

• Action
  Create Comment

  Posts a comment on an InfoLobby record, optionally with file attachments and without notifying the record's followers.

• Action
  Create Record

  Creates a new record in an InfoLobby table.

• Action
  Delete a Record

  Deletes a record from an InfoLobby table.

• Action
  Delete File

  Removes one attachment from a file field on a record. Other attachments on the field and on other file fields are untouched.

• Action
  Filter Table Records

  Returns the records in an InfoLobby table that match the given filters, search term or saved view.

• Action
  Get Record

  Fetches a record by ID from an InfoLobby table. An error occurs if the record is not found.

• Action
  Get Table

  Returns a table's metadata and its field definitions (schema).

• Action
  List Spaces

  Lists every workspace (space) the connected API key has access to.

• Action
  List Tables

  Returns all tables in an InfoLobby workspace (space).

• Action
  Query Table Records

  Query and filter the records of an InfoLobby table, returning one page of up to 100 matching rows.

• Action
  Update a Record

  Updates an existing record in an InfoLobby table by ID. Only the fields you supply are changed.

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