Connect Oracle Database to inFakt

Both apps 24Oracle Database 12inFakt 12

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

• Action
  Add Cost

  Adds a cost to inFakt by uploading a scan or PDF of the cost document (PDF, JPG or PNG, up to 15 MB). The uploaded document appears on the costs list.

• Action
  Add Product

  Creates a product in the inFakt product catalog.

• Action
  Create Client

  Creates a new client in Infakt. Use this to add customers before invoicing or to import clients from external sources (CRM, spreadsheets, etc.).

• Action
  Delete Client

  Deletes a client from your inFakt account.

• Action
  Find Client

  Returns up to 100 inFakt clients matching the given company name, NIP, email or person name.

• Action
  Find Invoice

  Returns the VAT invoices whose number exactly matches the specified invoice number.

• Action
  Get Client

  Retrieves a single inFakt client (kontrahent) by its id, returning the full client record.

• Action
  Get Cost

  Retrieves a single cost document (cost, document scan or internal evidence) from inFakt by its UUID.

• Action
  Get Product

  Retrieves a single product from your inFakt product catalog by its ID.

• Action
  List Products

  Returns all products in the inFakt account, optionally filtered by exact product name.

• Action
  Update Client

  Updates an existing client in inFakt. Only the fields you fill in are changed; blank fields are left as they are.

• Action
  Update Product

  Updates an existing product in inFakt. Only the fields you fill in are changed; the full updated product is returned.

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