Connect Google BigQuery and ProAbono

Both apps 28Google BigQuery 14ProAbono 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.

• Trigger
  Event(s) Related to a Customer

  Triggers when a customer is created or updated in ProAbono (name, email, status, language or other customer details change).

• Action
  Anonymize a Customer

  Anonymizes a customer in ProAbono, clearing their personal details such as name and email. Returns the anonymized customer.

• Action
  Bill a Customer

  Invoices a customer's current balance right away instead of waiting for the next billing cycle, optionally adding a note to the invoice.

• Action
  Create a Line in the Customer Balance

  Adds a one-time debit or credit line to a customer's balance in ProAbono. The line is invoiced with the customer's next billing.

• Action
  Create or Update a Customer

  Creates a customer in ProAbono, or updates the existing customer that has the same customer reference. Returns the customer record with its customer-portal links.

• Action
  Get invoice

  Returns a single ProAbono invoice by its ID, including its number, state, amounts, customer and links to view or pay it.

• Action
  List customers

  Returns the customers in your ProAbono account, optionally only those in one segment or those with an active subscription that includes a given feature.

• Action
  Retrieve a Customer

  Returns a customer by your own customer reference, including their status, segment, metadata and customer portal links.

• Action
  Retrieve Billing Address of a Customer

  Returns the billing address of a customer, looked up by your own customer reference.

• Action
  Retrieve Full Invoice (PDF)

  Returns a full invoice by its ID, including its amounts, status and a link to download the invoice PDF.

• Action
  Retrieve Payment Settings of a Customer

  Returns a customer's payment settings: payment type, billing mode, grey-list status, invoice note and next billing date.

• Action
  Suspend a Customer

  Suspends a customer so they can no longer access the customer portal, download invoices, use their payment method or receive emails. Returns the updated customer.

• Action
  Update Billing Address of a Customer

  Sets or updates the billing address of a ProAbono customer, and returns the saved address.

• Action
  Update Payment Settings of a Customer

  Updates a customer's payment settings in ProAbono, such as a manual payment method, billing mode, next billing date or the note shown on their invoices, and returns the saved settings.

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