Connect Device Magic and Oracle Database

Both apps 29Device Magic 17Oracle Database 12

• Trigger
  New Submission

  Triggers when a form receives a new submission in its Device Magic Database. The form's Device Magic Database destination must be active.

• Action
  Approve Device

  Approves a device that is waiting to join your organization. Approving an already-approved device has no effect.

• Action
  Create Group

  Creates a new group in your organization.

• Action
  Delete Form

  Deletes a form from your organization.

• Action
  Delete Group

  Deletes a group from your organization.

• Action
  Get Device

  Returns one device in your organization by its numeric ID or device identifier.

• Action
  Get Form

  Returns a form's definition: its title and questions.

• Action
  List Devices

  Returns the devices joined to your Device Magic organization, with owner, groups and approval status.

• Action
  List Dispatches

  Returns the dispatched forms still outstanding across all devices in your organization.

• Action
  List Forms

  Returns the forms in your organization with their namespace, version and group.

• Action
  List Groups

  Returns the groups in your organization with their form and device IDs, optionally filtered by name.

• Action
  List Resources

  Returns the resources (uploaded files such as images, spreadsheets and PDFs) in your organization.

• Action
  List Submissions

  Returns submissions stored in a form's Device Magic Database. The form's Device Magic Database destination must be active.

• Action
  Remove Device

  Removes a device from your organization.

• Action
  Revoke Dispatch

  Revokes a dispatched form from a device.

• Action
  Update Device

  Updates a device's owner, description or groups. Fields left blank are unchanged.

• Action
  Update Group

  Renames a group in your organization.

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