Connect Google BigQuery and Partnero

Both apps 34Google BigQuery 14Partnero 20

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

  Triggers when a new customer is created in Partnero.

• Trigger
  Customer Deleted

  Triggers when a customer is deleted in Partnero.

• Trigger
  Customer Updated

  Triggers when a customer is updated in your Partnero program.

• Trigger
  Partner Created

  Triggers when a new partner is created in your Partnero program.

• Trigger
  Partner Deleted

  Triggers when a partner is deleted from your Partnero program.

• Trigger
  Partner Updated

  Triggers when a partner is updated in your Partnero program.

• Trigger
  Transaction Created

  Triggers when a new transaction is recorded in your Partnero program.

• Trigger
  Transaction Deleted

  Triggers when a transaction is deleted (refunded) in Partnero.

• Action
  Archive Partner

  Archives (soft-deletes) a partner so they lose portal access; the partner can be restored later.

• Action
  Create a New Customer

  Creates a customer in your Partnero affiliate program and attributes them to a partner for commission tracking.

• Action
  Create a New Partner

  Creates a new affiliate partner in your Partnero program and returns the partner record, including its referral link.

• Action
  Create a New Transaction

  Records a sales transaction for a customer so Partnero calculates the referring partner's commission. Can optionally create the customer in the same call.

• Action
  Delete Existing Customer

  Deletes an existing customer from your Partnero program by their customer key.

• Action
  Delete Existing Partner

  Deletes an existing partner from your Partnero program.

• Action
  Delete Existing Transaction

  Deletes an existing transaction in your Partnero program by its key.

• Action
  Find Partner

  Finds a partner in your Partnero program by partner ID and returns their details, referral statistics, commissions and referral links.

• Action
  Get Transaction

  Returns a single transaction by its key.

• Action
  Restore Partner

  Restores a previously archived partner and reactivates their portal access.

• Action
  Update Existing Customer

  Updates an existing customer's name, email, key or tags in your Partnero program.

• Action
  Update Existing Partner

  Updates an existing partner's name, email, password, referral key or tags in your Partnero program.

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