Connect SQL Server to ManyRequests

Both apps 38SQL Server 11ManyRequests 27

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

• Action
  Add invoice

  Adds a new invoice for a client from catalog services, pricing variations or custom line items, and returns the new invoice's id. The invoice is emailed to the client unless it is created as a draft.

• Action
  Add organization

  Creates a new organization in your ManyRequests portal along with its owner client user. Returns the organization that was added.

• Action
  Add organization member

  Adds a member to an organization, creating a new client user if no user with that email exists yet.

• Action
  Add subscription to organization

  Adds a recurring service subscription to a client organization and returns the new subscription.

• Action
  Add time entry

  Logs time worked on a request for a team member, from a start time to an end time.

• Action
  Cancel Client Subscription

  Cancels an active recurring service subscription belonging to a client organization.

• Action
  Create Client

  Creates a client user in a ManyRequests organization. If a user with the email already exists, they are added to the organization.

• Action
  Create Comment

  Adds a comment to a request, posted as the chosen user, optionally internal-only or scheduled for later delivery.

• Action
  Create organization brand

  Creates a new brand within an organization.

• Action
  Create Request

  Creates a new service request for a client under one of your services, with an optional description, priority, status, due date, brand, assignees and tags.

• Action
  Delete client

  Deletes a client and removes them from their organization. A client who is the sole owner of an organization with active subscriptions cannot be deleted.

• Action
  Delete organization

  Deletes an organization and all of its members from your ManyRequests portal.

• Action
  Delete request

  Deletes a request in ManyRequests.

• Action
  Find Comments for Request

  Returns the comments on a ManyRequests request, optionally limited to internal or non-internal comments.

• Action
  Find Organization

  Finds organizations whose name, owner name or owner email matches the search text, optionally narrowed by tags or subscription status.

• Action
  Find Request

  Returns the service requests that match your search text or filters, such as status, priority, client, organization, assignee or request number.

• Action
  Get client

  Returns a single client by ID, including their name, email and organization.

• Action
  Get invoice

  Returns a single invoice with its status, number, notes, payment details and dates, optionally with its line items, taxes, client, coupon and payment gateway.

• Action
  Get organization

  Returns a single organization by its ID, with its name, logo and dates, plus any related records you ask to include. An error occurs if the organization is not found.

• Action
  Get request

  Returns a single service request by its ID or slug, with optional related records such as status, client, service, tags and form fields.

• Action
  List clients

  Returns the clients in your ManyRequests portal, with optional search, organization filter and sorting.

• Action
  List services

  Returns the services offered in your ManyRequests portal, optionally filtered by search text, type, allocation or sale status.

• Action
  List team members

  Returns the portal admins, admins and team members in your ManyRequests portal, optionally filtered by email or role.

• Action
  Update client

  Updates a client's name and/or email address.

• Action
  Update organization

  Updates the name of an existing organization and returns the updated organization.

• Action
  Update Request

  Updates an existing request's title, description, priority, status, due date, brand, assignees, tags or form fields.

• Action
  Update Request Status

  Moves a ManyRequests request to a different status.

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