Connect Commerce Layer and SQL Server

Both apps 52Commerce Layer 41SQL Server 11

• Trigger
  New Attachment

  Triggers when a new Attachment is created.

• Trigger
  New Customer

  Triggers when a new Customer is created.

• Trigger
  New Customer Address Event

  Triggers when a customer address is created.

• Trigger
  New Customer Password Reset Event

  Triggers when a customer password reset is requested.

• Trigger
  New Customer Subscription Event

  Triggers when a given customer_subscription event (one of create or destroy) is fired.

• Trigger
  New Price

  Triggers when a new Price is created.

• Trigger
  New Price Import

  Fires when a new price import is created in Commerce Layer.

• Trigger
  New Price List

  Triggers when a new Price List is created.

• Trigger
  New Shipping Category

  Triggers when a Shipping Category is created.

• Trigger
  New SKU

  Triggers when a new SKU is created.

• Trigger
  New SKU Import

  Triggers when a new SKU import is created.

• Trigger
  New Stock Item Import

  Triggers when a new Stock Item import is created.

• Trigger
  New Stock Transfer Event

  Triggers when a given stock transfer event (one of create, upocoming, picking, in_transit, complete, cancel is fired).

• Action
  Add Customer Address

  Adds an existing address to a customer's address book.

• Action
  Add Customer Password Reset

  Requests a password reset for a customer, returning the reset token to send them.

• Action
  Add Customer Subscription

  Subscribes a customer email to a list, identified by a reference such as a newsletter id.

• Action
  Add Stock Transfer

  Moves a quantity of a SKU from one stock location to another.

• Action
  Balance Change Gift Card

  Change balance of a gift card.

• Action
  Create Address

  Creates a postal address that can be attached to customers, orders and stock locations.

• Action
  Create Attachment

  Creates a new Attachment.

• Action
  Create Customer

  Creates a new Customer.

• Action
  Create Gift Card

  Creates a new Gift Card.

• Action
  Create Price Import

  Creates a new Price Import.

• Action
  Create Price List

  Creates a new Price List.

• Action
  Create SKU

  Creates a new SKU.

• Action
  Find Attachment

  Finds a Attachment by name.

• Action
  Find Customer

  Finds a customer by id or reference.

• Action
  Find Gift Card

  Finds a gift card by id or reference.

• Action
  Find Price

  Finds a price by price list.

• Action
  Find Price Import

  Finds a Price Import by status.

• Action
  Find Price List

  Finds a Price List by name.

• Action
  Find Shipping Category

  Finds an Shipping Category by name.

• Action
  Find SKU

  Finds an SKU by code.

• Action
  Find SKU Import

  Finds an SKU Import by status.

• Action
  Find Stock Item Import

  Finds a Stock Item Import by status.

• Action
  Get Address

  Retrieves one address by id.

• Action
  Get Customer Address

  Retrieves one customer address link by id.

• Action
  Get Customer Password Reset

  Retrieves a customer password reset by id, returning customer_email, reset_password_token and reset_password_at.

• Action
  Get Customer Subscription

  Retrieves one customer subscription by id.

• Action
  Get Stock Transfer

  Retrieves one stock transfer by id.

• Action
  Update Customer Reference

  Update customer data setting external identifier.

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