Connect UniBee to SQL Server

Both apps 37UniBee 26SQL Server 11

• Trigger
  New Invoice Event

  Triggers when an invoice event occurs (created, paid, process, cancelled, failed, or reversed).

• Trigger
  New Payment Event

  Triggers when a payment event occurs (created, authorised need, success, cancelled, or failure).

• Trigger
  New Refund Event

  Triggers when a refund event occurs (created, success, failure, cancelled, or reversed).

• Trigger
  New Subscription Activated

  Triggers when a subscription becomes active.

• Trigger
  New Subscription Event

  Triggers when a subscription event occurs (created, activated, updated, cancelled, expired, etc.).

• Trigger
  New Subscription Onetime Addon Event

  Triggers when a subscription onetime addon event occurs (created, success, cancelled, or expired).

• Trigger
  New Subscription Pending Update Event

  Triggers when a subscription pending update event occurs (create, success, or cancelled).

• Trigger
  New User Event

  Triggers when a user event occurs (created, updated, metric update, or subscription update).

• Trigger
  New User Plan Change

  Triggers when a user subscription or subscription change occurs.

• Action
  Add Discount Code

  Create a new discount/promo code. Endpoint: POST /merchant/discount/new (New Discount Code).

• Action
  Add Invoice

  Create a new invoice. Endpoint: POST /merchant/invoice/new (New Invoice).

• Action
  Add Payment

  Record/create a new payment. Endpoint: POST /merchant/payment/new (New Payment).

• Action
  Add Plan

  Create a new subscription plan. Endpoint: POST /merchant/plan/new (Create Plan).

• Action
  Add Product

  Create a new product. Endpoint: POST /merchant/product/new (Create Product).

• Action
  Add Subscription

  Create a new subscription for a user against a plan. Endpoint: POST /merchant/subscription/new (Create Subscription).

• Action
  Add User

  Create a new customer/user record in UniBee. Endpoint: POST /merchant/user/new (New User).

• Action
  Cancel Subscription

  Cancel a subscription immediately. Endpoint: POST /merchant/subscription/cancel (Cancel Subscription Immediately).

• Action
  Get Invoice

  Fetch a single invoice's detail by invoice id. Endpoint: GET /merchant/invoice/detail (Invoice Detail).

• Action
  Get Payment

  Fetch a single payment's detail by payment id. Endpoint: GET /merchant/payment/detail (Payment Detail).

• Action
  Get Plan

  Fetch a single plan's detail by plan id. Endpoint: GET /merchant/plan/detail (Plan Detail).

• Action
  Get Subscription

  Fetch a single subscription's detail by subscription id. Endpoint: GET /merchant/subscription/detail (Subscription Detail).

• Action
  Get User

  Fetch a single user's profile by user id. Endpoint: GET /merchant/user/profile (Get User Profile).

• Action
  List Discount Codes

  List discount codes with pagination/filters. Endpoint: GET /merchant/discount/list (Get Discount Code List).

• Action
  List Products

  List products with pagination/filters. Endpoint: GET /merchant/product/list (Get Product List).

• Action
  List Users

  List/search customer users with pagination. Endpoint: GET /merchant/user/list (User List).

• Action
  Update User

  Update an existing user's profile fields. Endpoint: POST /merchant/user/update_profile (Update User Profile).

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