Connect Google BigQuery to SamCart

Both apps 29Google BigQuery 14SamCart 15

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

  Refunds a SamCart charge, either in full or for a partial amount. Returns the refund with its charge and order.

• Action
  Cancel subscription

  Cancels a SamCart subscription immediately, optionally without notifying the customer. Returns the updated subscription.

• Action
  Get charge

  Returns a single SamCart charge by its ID, including the customer, order, processor, currency, refund status and total.

• Action
  Get customer

  Returns a SamCart customer by ID, including name, email, phone, tags, lifetime value and addresses.

• Action
  Get order

  Returns a single SamCart order by its ID, including cart items, totals, shipping address, custom fields and UTM parameters.

• Action
  Get product

  Returns a single SamCart product by its ID, including price, pricing type, status, order bumps, bundled products and tags.

• Action
  Get subscription

  Returns a single SamCart subscription by its ID, including its status, pricing, coupon, cancellation schedule and next rebilling date.

• Action
  List charges

  Returns the charges in your SamCart marketplace, optionally filtered by creation date range and test mode.

• Action
  List customers

  Returns the customers in your SamCart marketplace, optionally filtered by email address or creation date range.

• Action
  List orders

  Returns the orders in your SamCart marketplace, optionally filtered by creation date range and test mode.

• Action
  List products

  Returns the products in your SamCart marketplace, optionally filtered by status, category, pricing type or creation date.

• Action
  List refunds

  Returns every refund issued in your SamCart marketplace, sorted by refund ID, with the refunded charge and order details.

• Action
  List subscriptions

  Returns the subscriptions in your SamCart marketplace, optionally filtered by status, type, test mode, and created, rebilling or canceled dates.

• Action
  Update order

  Updates the value of a custom field on an existing SamCart order.

• Action
  Update subscription

  Changes the next rebilling date of an active or delinquent SamCart subscription and returns the updated subscription.

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