Connect Moneybird and Oracle Database

Both apps 41Moneybird 29Oracle Database 12

• Trigger
  New Contact

  Triggers when a new contact is created.

• Trigger
  New Quote

  Triggers when a new quote is created.

• Trigger
  New Sales Invoice

  Triggers when a new sales invoice is created.

• Action
  Add Attachment to New Document

  Creates a new document in the Moneybird inbox and attaches a file to it, ready to be classified as a purchase invoice or receipt.

• Action
  Add external sales invoice

  Imports an invoice created in another system (webshop, marketplace, POS) into Moneybird as an external sales invoice.

• Action
  Add payment to sales invoice

  Registers a payment against an existing Moneybird sales invoice.

• Action
  Add product

  /api/v2/{administration_id}/products.json - create a product.

• Action
  Add project

  /api/v2/{administration_id}/projects.json - create a project.

• Action
  Add time entry

  Records a time entry (time spent by a user, optionally on a project and for a contact) in a Moneybird administration.

• Action
  Create Contact

  Creates a contact (customer, supplier or other business relation) in a Moneybird administration, including any contact custom fields.

• Action
  Create Document

  Creates a new typeless document (a document whose type is not yet known, such as an uploaded receipt or bill) in a Moneybird administration.

• Action
  Create Quote

  Create a new quote

• Action
  Create Sales Invoice

  Create a new sales invoice

• Action
  Delete contact

  Deletes a contact from a Moneybird administration.

• Action
  Find Contact

  Returns the Moneybird contacts that match a free-text search (name, contact people, email, phone, customer id, tax number, chamber of commerce number, IBAN or address), optionally narrowed by filters.

• Action
  Find ledger accounts

  Returns the ledger accounts in a Moneybird administration whose name or account code contains the search text, optionally limited to one account type.

• Action
  Find products by criteria

  Returns the products in a Moneybird administration that match the search text and optional filters.

• Action
  Find sales invoices by criteria

  Returns up to 100 sales invoices that match the specified state, period, reference, contact, recurring invoice, workflow or created/updated time.

• Action
  Find Tax Rate

  Returns up to 100 tax rates in a Moneybird administration that match the specified name, partial name, percentage or other criteria.

• Action
  Get contact

  Returns all information about a Moneybird contact, including its contact people, notes, custom field values and event history.

• Action
  Get external sales invoice

  Returns one external sales invoice in a Moneybird administration, including its reference, contact, lines and totals.

• Action
  Get project

  Returns one project in a Moneybird administration, including its name, state and budget.

• Action
  Get Quote

  Returns one quote (estimate) in a Moneybird administration, including its reference, contact, texts, lines and totals.

• Action
  Get sales invoice

  Fetches a sales invoice by ID. An error occurs if the sales invoice is not found.

• Action
  Get time entry

  Returns one time entry in a Moneybird administration, including its description, times, project and contact.

• Action
  Get typeless document

  Returns one typeless document in a Moneybird administration, including its reference, contact and attachments.

• Action
  Send Sales Invoice

  Send a sales invoice

• Action
  Update contact

  Updates an existing Moneybird contact. Only the fields you fill in are changed; blank fields keep their current value.

• Action
  Update sales invoice

  /api/v2/{administration_id}/sales_invoices/{id}.json - update a sales invoice.

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