Connect Google BigQuery and SwagUp

Both apps 31Google BigQuery 14SwagUp 17

• 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
  Low Credit Balance

  Triggers when your SwagUp credit balance is below the amount you choose, and again each time the low balance changes.

• Trigger
  Low Stock for a Product

  Triggers when a product in your SwagUp inventory is running low on stock, and again if its stock levels change while it stays low.

• Trigger
  New or Updated Order

  Triggers when an order is created or updated.

• Trigger
  New or Updated Shipment Status

  Triggers when a shipment is created or its delivery status changes.

• Trigger
  New or Updated Shipment Tracking

  Triggers when a shipment first gets a tracking number or its tracking number changes.

• Trigger
  New Redemption

  Triggered when a unique code in a code-validator campaign is redeemed. Fires each time the code's use count increases.

• Trigger
  Product Deactivated

  Triggers when a product in your SwagUp account is deactivated.

• Action
  Add Funds to Credit Balance

  Adds funds to the SwagUp account's credit balance and returns the amount added and the new current balance.

• Action
  Create a New Recipient

  Creates a new recipient (contact) in the SwagUp directory with their name, contact details and shipping address, and returns the created recipient.

• Action
  Find an Order

  Returns the SwagUp account orders that match a search term, such as an order number, with optional filters for status, proof, invoice and date.

• Action
  Find a Product by Name

  Returns the SwagUp products and packs in your account that match the specified name, with their stock, status and pack contents.

• Action
  Find a Recipient

  Returns the recipients in your SwagUp contact directory that match the search text, with optional filters such as company, external id, and creation or modification period.

• Action
  Find a Shipment

  Returns the shipments that match a search term, recipient, invoice, external ID or shipment IDs, with optional status and date filters.

• Action
  Find Inventory for Products

  Returns the current inventory of the specified products, including the stock quantity on hand for each size.

• Action
  Generate a Unique URL

  Creates a unique redemption code (token) on a SwagUp code-validator campaign, with its validity dates, usage limit and base URL, and returns the created token.

• Action
  Reorder an Existing Product

  Places a new SwagUp order for more units of a product already in your account, and returns the created order.

• Action
  Update Existing Recipient Information

  Updates the details of an existing recipient in your SwagUp directory, such as their name, contact details or shipping address, and returns the updated recipient.

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