Connect Google BigQuery to Priority

Both apps 30Google BigQuery 14Priority 16

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

  Creates a new record in the Priority form (entity) you choose, such as CUSTOMERS or ORDERS, and returns the created record.

• Action
  Add Shipping Charges to an Order

  Adds a shipping charge to an existing Priority sales order as an order line for your shipping part, with the charge amount as its price.

• Action
  Create a New Sales Order

  Creates a sales order for a customer in Priority, optionally with order lines.

• Action
  Create Exist Customer Sales Order

  Creates a sales order in Priority for an existing customer, optionally with order lines.

• Action
  Create Potential Customer

  Creates a potential customer record in Priority.

• Action
  Delete record

  Deletes a record from a Priority form, such as a customer or an order, by its key.

• Action
  Find Customer by Email

  Finds customers in Priority whose email address matches the one you provide.

• Action
  Find records by filter

  Returns the records of a Priority form (such as CUSTOMERS or ORDERS) that match a filter expression.

• Action
  Find the Country Name by Two Letter Code

  Looks up a country in Priority by its two-letter code and returns the country's name.

• Action
  Get Campaigns

  Returns the marketing campaigns defined in Priority, optionally filtered and sorted.

• Action
  Get Customers

  Returns customers from Priority, optionally filtered, sorted and limited to chosen fields.

• Action
  Get Lead Types

  Returns the lead types defined in Priority, optionally filtered and sorted.

• Action
  Get record

  Returns a single record from a Priority form (such as a customer or order) by its key.

• Action
  List records

  Returns records from a Priority form, such as customers or orders, optionally filtered, sorted and limited.

• Action
  Update record

  Updates an existing record in any API-enabled Priority form, changing only the fields you supply, and returns the updated record.

• Action
  Update Sales Order Status

  Changes the status of an existing sales order in Priority.

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