Skip to main content

Data API Features

Save Record (Create)

  • Single record.
  • Bulk records.
  • Bulk file uploads.

Query (Read)

  • Row Filtering with rSQL DSL.
  • Column Selection
  • Rename Columns / Alias
  • Join
  • Pagination - Limit & Offset
  • Sort / Order by
  • Count
  • Group By
  • Data Exports - csv, excel

Edit

  • Patch
  • Patch with row filtering

Purge (Delete)

  • Delete with row filter.
  • Safe delete.

Transactions

  • Readonly for Select
  • Supported for Save, Edit, Purge

Multi-tenancy

  • Tenant Id column
  • Schema per tenant
  • Database per tenant

Schema Support

  • Multiple schema support

Multiple Database Support

  • Support both relational and non-relational databases.
  • Support multiple databases in single instance of DB2Rest.

Database Support

  • Multiple Database support