Connect Booqable to SQL Server

Both apps 34Booqable 23SQL Server 11

• Trigger
  Completed Payment

  Triggers when a payment is completed.

• Trigger
  Finalize Invoice

  Triggers when an invoice is finalized.

• Trigger
  New Customer

  Triggers when a new customer is added.

• Trigger
  New Product

  Fires when a new product is created in the catalog. Poll GET /api/boomerang/products sorted by created_at.

• Trigger
  Reserved Order

  Triggers when an order is reserved.

• Trigger
  Started Order

  Triggers when an order is started.

• Trigger
  Stopped Order

  Triggers when an order is stopped.

• Trigger
  Updated Order

  Triggers when an order is updated.

• Action
  Create Coupon

  Creates a discount coupon in Booqable with a code, a discount type and value, and optional validity dates, redemption limits and eligible items.

• Action
  Create Customer

  Creates a customer in Booqable with name, email and billing defaults, plus any of the account's own customer custom fields.

• Action
  Create Order

  Creates a rental order in Booqable for a customer over a rental period, with pickup or delivery locations, deposit and discount settings, and any of the account's own order custom fields.

• Action
  Find Customer - By ID

  Returns one Booqable customer by its id, including the account's own customer custom fields.

• Action
  Find Customer - By Name or Email

  Finds Booqable customers whose name contains the text you give, or whose email matches exactly. Give either one or both.

• Action
  Find Order - By ID

  Returns one Booqable order by its id, including totals, rental period, locations and the account's own order custom fields.

• Action
  Find Product - By ID

  Returns one Booqable product by its id, including pricing, tracking settings and the product group's custom fields.

• Action
  List Customers

  Returns a page of Booqable customers, newest or sorted as you choose, with each customer's core details and custom field values.

• Action
  List Documents

  Returns a page of Booqable documents - invoices, quotes, contracts and packing slips - optionally narrowed to one document type, order or customer.

• Action
  List Locations

  Returns the rental locations set up in Booqable, with their addresses and whether pickup or delivery is enabled.

• Action
  List Orders

  Returns a page of Booqable orders with their rental period, status and totals, optionally narrowed to one status or customer.

• Action
  List Payments

  Returns a page of Booqable payments - charges, authorizations and refunds - optionally narrowed to one order or customer.

• Action
  List Products

  Returns a page of Booqable products with their pricing and tracking settings, optionally narrowed to one product group.

• Action
  List Stock Items

  Returns a page of Booqable stock items with their identifier, status and location, optionally narrowed to one product, product group or location.

• Action
  Update Customer

  Updates an existing Booqable customer. Fields you leave blank keep their current values, including custom fields.

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected SQL Server database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected SQL Server database.

• Action
  Add Row

  Add one row to a table on the connected SQL Server database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected SQL Server database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

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