Skip to main content

Datastore REST API

A customer account is required to read the description of all the REST services provided with the ActivePivot application.

When exposed, the Datastore REST API offers a way to discover and manipulate the datastore using Mongo-like requests, including the branches.

Disclaimer: Note that the REST API provides a way to edit the datastore but should not be considered as an optimized and efficient data source. To fill a datastore efficiently please read Datastore ETL section

Configuration

The datastore REST API is part of the REST APIs included in ActiveViamRestServicesConfig that you can simply import in your application via the @Import Spring annotation.

Discovery

The discovery endpoint provides a full description of the datastore structure which includes:

  • tables, their fields and access permissions
  • joins between the tables
  • branches created on the datastore.

It also exposes information regarding specific aspect of the datastore. For instance, it is possible to get the description of a particular table.

Data

The data endpoint provides a way to update or retrieve datastore data. It is possible to make queries to:

  • see data
  • update data
  • delete data
  • retrieve the size of the tables in the datastore.

It is possible to choose the branch of the datastore to act on.

It is possible to add conditions to filter the data that are affected by the query. Most common conditions are supported: equal, greater than, lesser than, in, like, and, or and not.

Branches

The datastore can have branches a bit like in git. Learn more here

The branches API offers a way to interact with the datastore branches to:

  • create a new branch
  • give it security permissions, i.e. to restrict its visibility
  • delete a branch
  • fast-forward a branch to another.