Data Management API

The Data Management API allows participants to upload and retrieve data associated with transactions and the safe deposit database.

Endpoints

This endpoint inserts data into the specified table of the input schema within the transaction database.
The path parameter participantId acts as the client participant for authentication and authorization.
Data is inserted using the json_to_record function.
The specified table must already exist in the database.
The transactionId ensures that data is associated with the correct transaction.
The query is limited to 1000 records per request.

Endpoint:
POST /api/v1/participants/{participantId}/data

Payload:

{
  "data": [
      "{\"key1\":\"value1\",\"key2\":\"value2\"}"
  ],
  "table": "string",
  "transactionId": "string"
}

This endpoint retrieves data from the output schema of the transaction database.
The path parameter participantId acts as the client participant for authentication and authorization.
Results are returned in JSON format.
Data is fetched using the row_to_json function.
If correlationId is provided:
The database table needs to have a correlationId column.
A WHERE clause is added to filter results from the database:
```
WHERE correlationId = {correlationId}
```

Endpoint:
GET /api/v1/participants/{participantId}/data

Query Parameters:

Response:

[
  "{\"key1\":\"value1\",\"key2\":\"value2\"}",
  "{\"key1\":\"value3\",\"key2\":\"value4\"}"
]

This endpoint inserts data into the specified table of the safedeposit schema within the safedeposit database.
The path parameter participantId acts as the client participant for authentication and authorization.
Data is inserted using the json_to_record function.
The specified table must already exist in the database.
The appId ensures that data is associated with the correct app.
The query is limited to 1000 records per request.

Endpoint:
POST /api/v1/participants/{participantId}/persistentdata

Payload:

{
  "data": [
      "{\"key1\":\"value1\",\"key2\":\"value2\"}"
  ],
  "table": "string",
  "appId": "string"
}

This endpoint retrieves data from the safedeposit schema of the safedeposit database.
The path parameter participantId acts as the client participant for authentication and authorization.
Results are returned in JSON format.
Data is fetched using the row_to_json function.

Endpoint:
GET /api/v1/participants/{participantId}/persistentdata

Query Parameters:

Response:

[
  "{\"key1\":\"value1\",\"key2\":\"value2\"}",
  "{\"key1\":\"value3\",\"key2\":\"value4\"}"
]

Certain data types are not supported:

Data types with ranges, such as char(4), are automatically handled as char, which may result in range exceptions.
ENUM fields and other custom types are not supported.

Access to the following endpoints is restricted (besides being an authenticated client):