Connect Moxo and Oracle Database

Both apps 36Moxo 24Oracle Database 12

• Trigger
  New Account

  Triggers when a new client account is created in Moxo.

• Trigger
  New User

  Triggers when a new user (team member or client) is added to Moxo.

• Action
  Add Data Table Record

  Adds a record to a data table.

• Action
  Cancel Flow

  Cancels a running flow.

• Action
  Complete Step

  Completes a step in a flow, optionally with a note.

• Action
  Create Account

  Creates a client account (company) in Moxo.

• Action
  Create Group Conversation

  Creates a group conversation with the given participants.

• Action
  Create User

  Creates an internal team member or an external (client) user in Moxo, optionally sending an invitation.

• Action
  Deactivate User

  Deactivates a Moxo user so they can no longer sign in.

• Action
  Get Account

  Returns one client account with its users.

• Action
  Get Action

  Returns one action with its status and assignees.

• Action
  Get Flow

  Returns one flow with its template, status and progress.

• Action
  Get User

  Returns one Moxo user by ID, with their name, email, kind, status, accounts and personas.

• Action
  List Accounts

  Returns the client accounts (companies) in your Moxo organization.

• Action
  List Conversations

  Returns your conversations.

• Action
  List Data Tables

  Returns your data tables with their columns.

• Action
  List Flows

  Returns flows, optionally filtered by status, template, account or search term.

• Action
  List Templates

  Returns the flow templates in your Moxo organization.

• Action
  Post Flow Chat Message

  Posts a chat message in a flow's conversation.

• Action
  Send Action

  Sends a standalone action (form, approval, acknowledgement, file request, to-do and more) to one or more people.

• Action
  Send Conversation Message

  Sends a message to a conversation.

• Action
  Start Flow

  Starts a new flow from a published Moxo template, optionally naming it and setting a due date.

• Action
  Update Account

  Updates a client account's name, domain or status.

• Action
  Update User

  Updates a Moxo user's profile: name, title, department, phone or account.

• Trigger
  New Column

  Fires when a new column appears on an Oracle table you choose.

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

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected Oracle user's own schema.

• Action
  Add Row

  Add one row to a table on the connected Oracle 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 Oracle database and returns every row it matches.

• Action
  Find Row via Custom Query

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

• Action
  Run Custom Statement

  Runs a statement you write against the connected Oracle 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.