Connect Google BigQuery and Loyalzoo

Both apps 33Google BigQuery 14Loyalzoo 19

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

  Triggers when a customer checks in at your Loyalzoo place, and returns that customer's details.

• Trigger
  Customer Updated

  Triggers when a customer of your Loyalzoo place changes, such as their contact details, points or memberships.

• Trigger
  Membership Created

  Triggers when a new membership is created for a customer of the place. Returns the membership along with the customer who holds it.

• Trigger
  Membership Ended

  Triggers when a customer's membership at the place is no longer active, returning the membership and the customer who held it.

• Trigger
  New Charge

  Triggers when a customer's membership is charged at your place, each time the membership's last payment date changes.

• Trigger
  New Counter Event

  Triggers when a customer's membership counter first appears or its count changes, returning the counter's id and count with the customer's details.

• Trigger
  New Customer Created

  Triggers when a new customer is added to the merchant's place.

• Trigger
  Points Given

  Triggers when a customer is given points, returning the customer with their new points balance and the amount of the latest change.

• Action
  Create New Customer

  Creates a new customer and associates them with your Loyalzoo place, returning the customer's id.

• Action
  Export Latest Customer Data

  Returns the latest data for all customers of your Loyalzoo place, including their points, rewards, memberships and payment methods.

• Action
  Export Latest Transaction Data

  Returns a customer's transaction history at the merchant's place, as an ordered list of actions such as charges, points and rewards.

• Action
  Get Customer Payment Method

  Returns the saved payment methods of one Loyalzoo customer, including card details and which method is the default.

• Action
  Get Membership

  Returns one membership held by a customer of your place, including its amount, billing dates and status.

• Action
  Get Merchant Info

  Returns the details of your Loyalzoo place, including its contact details, address, plans and loyalty scheme, and optionally its counter events.

• Action
  Give Points

  Adds points to, or subtracts points from, a customer's loyalty balance at a place, and returns the updated customer.

• Action
  Increase Counter

  Increases one of a customer's counters, which track behaviours, benefits or membership allowances, by the amount you choose.

• Action
  Retrieve Customer Details

  Returns the details of one customer of the merchant's place, including their points, rewards, memberships and payment methods.

• Action
  Search for Loyalty Customer via Email

  Returns the customers of your Loyalzoo place whose email address matches the one you specify.

• Action
  Update Customer

  Updates an existing Loyalzoo customer at your place with the values provided and returns the full customer record.

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