Connect Google BigQuery and OfficeRnD

Both apps 56Google BigQuery 14OfficeRnD 42

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

  Triggers when a new booking is added.

• Trigger
  New Company

  Triggers when a new company is added.

• Trigger
  New Contract

  Triggers when a new contract is added.

• Trigger
  New Event

  Triggers when a new event is added.

• Trigger
  New Invoice

  Triggers when a new invoice is added.

• Trigger
  New Member/Member Status Updated

  Triggers when a new member is added or a member's status changes.

• Trigger
  New Membership

  Triggers when a new membership is added.

• Trigger
  New Opportunity

  Triggers when a new opportunity is added.

• Trigger
  New Post

  Triggers when a new community post is added.

• Trigger
  New Visitor Check-In

  Triggers when a visitor checks in.

• Action
  Add ticket

  Creates a new help-desk ticket in OfficeRnD on behalf of a member.

• Action
  Add ticket comment

  Adds a comment to an existing OfficeRnD ticket on behalf of a member.

• Action
  Add visit

  Records a new visit by a visitor at one of your locations, optionally hosted by a member.

• Action
  Check in member

  Checks a member in to a location in OfficeRnD, returning the new check-in.

• Action
  Create Booking

  Creates a booking of a room, desk or other resource.

• Action
  Create Company

  Creates a new company at a location.

• Action
  Create Event

  Creates a community event at a location.

• Action
  Create Member

  Creates a new member at a location.

• Action
  Create Membership

  Creates a membership on a plan for a member or company.

• Action
  Create One-Off Fee

  Creates a one-off fee for a member or company.

• Action
  Create Opportunity

  Creates a sales opportunity for a member or company.

• Action
  Create Post

  Publishes a community post to one or more locations.

• Action
  Create Visitor

  Registers a new visitor.

• Action
  Delete member

  Deletes a member from your OfficeRnD organization and returns the deleted member's details.

• Action
  Find Booking

  Finds a booking by ID or reference and returns the first match.

• Action
  Find Company

  Finds a company by ID, name or email and returns the first match.

• Action
  Find Location

  Finds a location by ID or name and returns the first match.

• Action
  Find Member

  Finds a member by ID, name or email and returns the first match.

• Action
  Find opportunities

  Returns the opportunities that match the filters you give — by opportunity, company, member, or created/modified date.

• Action
  Find payments

  Finds invoices, credit notes and overpayments matching filters such as member, company, number, status or date range.

• Action
  Find plans

  Finds billing plans by name, code, ID, location or date, returning the matching plans.

• Action
  Find resources

  Finds rooms, desks and other space resources by name, ID, location or type.

• Action
  Find tickets

  Returns support tickets matching the filters you give, such as status, company, member or location.

• Action
  Find visitors

  Finds visitors in your OfficeRnD organization by ID, name, email or visitor type, returning up to 50 matches.

• Action
  Terminate contract

  Terminates a signed contract in OfficeRnD as of the given date. Only signed contracts that are not already terminated or expired can be terminated.

• Action
  Update Booking

  Updates the time, resource or details of an existing booking.

• Action
  Update company

  Updates an existing company in OfficeRnD, such as its name, contact details, address, billing details or custom properties.

• Action
  Update event

  Updates the title or venue of an existing community event in OfficeRnD.

• Action
  Update member

  Updates an existing member's details, such as name, email, phone, address, billing details, portal privacy, social profiles, tags and custom properties.

• Action
  Update membership

  Updates an existing membership's price, start date, end date or custom properties.

• Action
  Update opportunity

  Updates an existing opportunity's name, start date, status or custom properties in OfficeRnD.

• Action
  Update ticket

  Updates an existing support ticket's subject, message, severity, priority or status.

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