Connect Commerce Tools and Google BigQuery

Both apps 37Commerce Tools 23Google BigQuery 14

• Trigger
  New customer

  Triggers when a new customer is created in your commercetools project.

• Trigger
  New order

  Triggers when a new order is created in the commercetools project.

• Action
  Add cart

  Creates a new shopping cart in your commercetools project, optionally with line items, customer, addresses and discount codes.

• Action
  Add category

  Creates a category in your commercetools project for organizing products.

• Action
  Add customer

  Creates a customer in your commercetools project and returns the new customer record.

• Action
  Add order from cart

  Creates an order from an existing cart, optionally setting its order number and initial order, payment and shipment states.

• Action
  Add product

  Creates a product in your commercetools project with its product type, name, slug and optional variants, prices, categories and attributes.

• Action
  Delete customer

  Deletes a customer, optionally erasing all of their related personal data. Returns the deleted customer.

• Action
  Delete product

  Deletes a product from the catalog and returns the product as it was when deleted.

• Action
  Find categories

  Finds categories in your commercetools project that match a filter, such as a key, slug or name.

• Action
  Find customers

  Finds customers matching a filter condition, such as an email address or last name.

• Action
  Find inventory entries

  Returns the inventory entries (stock quantities per SKU and supply channel) that match a filter.

• Action
  Find orders

  Finds orders in the commercetools project that match a filter condition.

• Action
  Find products

  Finds products in your commercetools project that match a filter condition, such as a product key or name.

• Action
  Get cart

  Returns a cart by its id, including its line items, totals, addresses and state.

• Action
  Get customer

  Returns a single customer by its id, including addresses and custom fields.

• Action
  Get order

  Returns an order by its id, including line items, totals, state and custom fields.

• Action
  Get product

  Returns a product by its id, including its current and staged data, variants and prices.

• Action
  Update cart

  Updates a cart by applying one or more update actions, such as adding line items or setting the shipping address, and returns the updated cart.

• Action
  Update customer

  Applies one or more update actions to an existing customer, such as changing their email, name or addresses, and returns the updated customer.

• Action
  Update inventory entry

  Updates an inventory entry, for example adding, removing or setting its stock quantity, and returns the updated entry.

• Action
  Update order

  Updates an order by applying one or more update actions, such as changing its order, shipment or payment state.

• Action
  Update product

  Updates a product by applying one or more update actions, and returns the updated product.

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

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