Connect Google BigQuery and Repsly

Both apps 33Google BigQuery 14Repsly 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
  New Audit With Items

  Triggers when a new retail audit is submitted in Repsly, returning the audit with its client, representative and audited items.

• Trigger
  New client note

  Triggers when a representative adds a new note to a client in Repsly.

• Trigger
  New Client With Details

  Triggers when a new client is added in Repsly, returning the client's code, name, address, contact details, territory and assigned representative.

• Trigger
  New Form With Details

  Triggers when a representative submits a new form in Repsly, returning the form with its client, representative and answers.

• Trigger
  New Order

  Triggers when a new order or other sales document is created in Repsly, returning the document with its client, representative, status and line items.

• Trigger
  New photo

  Triggers when a new photo is taken in Repsly, returning the photo URL, note, client and representative.

• Trigger
  New Visit Start

  Triggers when a representative starts a new client visit in Repsly, returning the visit's client, representative, start time and location.

• Trigger
  New Workday Start

  Triggers when a representative starts a new workday in Repsly, returning the workday's start time, mileage and representative.

• Action
  Add account

  Creates or updates a place account in Repsly by its unique code.

• Action
  Add pricelist

  Adds a product with its price to an existing Repsly pricelist (or updates it), via an asynchronous import job.

• Action
  Add schedule

  Creates or updates a visit schedule in Repsly for a client and representative.

• Action
  Add user

  Creates a user in Repsly, or updates the existing user with the same code.

• Action
  Create Client

  Creates a client in Repsly, or updates it when the code already exists. Repsly processes the import in the background and returns the import job ID.

• Action
  Create Product

  Creates a product in Repsly, or updates it when the code already exists. Repsly processes the import in the background and returns the import job ID.

• Action
  Get client

  Returns a single client (place) from Repsly by its client code, including address, contact, territory, representatives and custom attributes.

• Action
  Get import job status

  Returns the status of a Repsly import job, including counts of inserted, updated and invalid rows plus any warnings and errors.

• Action
  List pricelists

  Returns all pricelists in your Repsly account, with their name, default flag and active status.

• Action
  List products

  Returns the products in your Repsly account, with their codes, names, prices, barcodes, packaging and custom attributes.

• Action
  Update sales document status

  Changes the status of a Repsly sales document, such as a purchase order, to another valid status for its document type.

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