post__systemevent

POST /systemevent

Query System Events

Query system events from the SystemEvent table with advanced filtering and pagination capabilities. This endpoint allows users to retrieve audit logs and system activity events based on various criteria including timestamps, context, event types, users, and workspaces.

Key Features:

• Advanced filtering by timestamp range, context, event type, user, and workspace

• Role-based access control (OWNER/ADMIN can query any user's events, regular users limited to their own)

• Pagination support with configurable skip and take parameters

• Default 24-hour time window when no timestamps are specified

• Context and event type translation from numeric indices to human-readable strings

• Comprehensive audit logging for security and compliance

Authentication:

• Requires valid Bearer token authentication

• User must be associated with an organization

• Role-based permissions determine data access scope

Access Control:

• OWNER/ADMINISTRATORS: Can query events for any user and workspace within their organization

• Regular Users: Limited to querying their own events and workspaces they belong to

• All users can only access events from their own organization

Filtering Options:

• Timestamp Range: Filter events by from_timestamp and to_timestamp (ISO 8601 format)

• Context: Filter by context type (workspace, bucket, repo, user, org, etc.)

• Event Type: Filter by event type (created, updated, deleted)

• User: Filter by specific user ID (role-dependent)

• Workspace: Filter by specific workspace ID (role-dependent)

• Context ID: Filter by specific context identifier

Pagination:

• skip: Number of records to skip (default: 0, minimum: 0)

• take: Number of records to return (default: 20, minimum: 1, maximum: 100)

Context Types:

• workspace (0)

• bucket (1)

• repo (2)

• user (3)

• org (4)

• workspaceuser (5)

• apikey (6)

• usersettings (7)

• orgsettings (8)

• flashbacknode (9)

• orgkey (10)

Event Types:

• created (0)

• updated (1)

• deleted (2)

TypeScript Client Library

public getSystemEvents = async (data: SystemEventQueryRequest): Promise<SystemEventQueryResponse> => {
  return this.makeRequest<SystemEventQueryResponse>('systemevent', 'POST', data);
};

Code Samples

Shell

# Query system events for the last 24 hours
curl -X POST https://backend.flashback.tech/systemevent \
  -H 'Content-Type: application/json' \
  -H 'Accept: application/json' \
  -H 'Authorization: Bearer your-jwt-token' \
  -d '{
    "skip": 0,
    "take": 20
  }'

# Query events for a specific time range and context
curl -X POST https://backend.flashback.tech/systemevent \
  -H 'Content-Type: application/json' \
  -H 'Accept: application/json' \
  -H 'Authorization: Bearer your-jwt-token' \
  -d '{
    "from_timestamp": "2024-01-01T00:00:00.000Z",
    "to_timestamp": "2024-01-31T23:59:59.999Z",
    "context": 0,
    "event": 0,
    "skip": 0,
    "take": 50
  }'

HTTP

POST https://backend.flashback.tech/systemevent HTTP/1.1
Host: backend.flashback.tech
Content-Type: application/json
Accept: application/json
Authorization: Bearer your-jwt-token

{
  "from_timestamp": "2024-01-01T00:00:00.000Z",
  "to_timestamp": "2024-01-31T23:59:59.999Z",
  "contextId": "workspace-123",
  "context": 0,
  "event": 0,
  "userId": "user-456",
  "workspaceId": "workspace-789",
  "skip": 0,
  "take": 20
}

JavaScript

const inputBody = {
  "from_timestamp": "2024-01-01T00:00:00.000Z",
  "to_timestamp": "2024-01-31T23:59:59.999Z",
  "contextId": "workspace-123",
  "context": 0,
  "event": 0,
  "userId": "user-456",
  "workspaceId": "workspace-789",
  "skip": 0,
  "take": 20
};

const headers = {
  'Content-Type': 'application/json',
  'Accept': 'application/json',
  'Authorization': 'Bearer your-jwt-token'
};

fetch('https://backend.flashback.tech/systemevent', {
  method: 'POST',
  body: JSON.stringify(inputBody),
  headers: headers
})
.then(function(res) {
  return res.json();
}).then(function(body) {
  console.log(body);
});

Ruby

require 'rest-client'
require 'json'

headers = {
  'Content-Type' => 'application/json',
  'Accept' => 'application/json',
  'Authorization' => 'Bearer your-jwt-token'
}

body = {
  'from_timestamp' => '2024-01-01T00:00:00.000Z',
  'to_timestamp' => '2024-01-31T23:59:59.999Z',
  'contextId' => 'workspace-123',
  'context' => 0,
  'event' => 0,
  'userId' => 'user-456',
  'workspaceId' => 'workspace-789',
  'skip' => 0,
  'take' => 20
}

result = RestClient.post 'https://backend.flashback.tech/systemevent',
  body.to_json, headers: headers

p JSON.parse(result)

Python

import requests
import json

headers = {
  'Content-Type': 'application/json',
  'Accept': 'application/json',
  'Authorization': 'Bearer your-jwt-token'
}

body = {
  'from_timestamp': '2024-01-01T00:00:00.000Z',
  'to_timestamp': '2024-01-31T23:59:59.999Z',
  'contextId': 'workspace-123',
  'context': 0,
  'event': 0,
  'userId': 'user-456',
  'workspaceId': 'workspace-789',
  'skip': 0,
  'take': 20
}

r = requests.post('https://backend.flashback.tech/systemevent', 
                  headers=headers, 
                  data=json.dumps(body))

print(r.json())

PHP

<?php

require 'vendor/autoload.php';

$headers = array(
    'Content-Type' => 'application/json',
    'Accept' => 'application/json',
    'Authorization' => 'Bearer your-jwt-token',
);

$body = array(
    'from_timestamp' => '2024-01-01T00:00:00.000Z',
    'to_timestamp' => '2024-01-31T23:59:59.999Z',
    'contextId' => 'workspace-123',
    'context' => 0,
    'event' => 0,
    'userId' => 'user-456',
    'workspaceId' => 'workspace-789',
    'skip' => 0,
    'take' => 20
);

$client = new \GuzzleHttp\Client();

try {
    $response = $client->request('POST','https://backend.flashback.tech/systemevent', array(
        'headers' => $headers,
        'json' => $body,
       )
    );
    print_r($response->getBody()->getContents());
 }
 catch (\GuzzleHttp\Exception\BadResponseException $e) {
    // handle exception or api errors.
    print_r($e->getMessage());
 }

 // ...

Java

URL obj = new URL("https://backend.flashback.tech/systemevent");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("POST");
con.setRequestProperty("Content-Type", "application/json");
con.setRequestProperty("Accept", "application/json");
con.setRequestProperty("Authorization", "Bearer your-jwt-token");

String jsonInputString = "{\"from_timestamp\":\"2024-01-01T00:00:00.000Z\",\"to_timestamp\":\"2024-01-31T23:59:59.999Z\",\"contextId\":\"workspace-123\",\"context\":0,\"event\":0,\"userId\":\"user-456\",\"workspaceId\":\"workspace-789\",\"skip\":0,\"take\":20}";

con.setDoOutput(true);
try(OutputStream os = con.getOutputStream()) {
    byte[] input = jsonInputString.getBytes("utf-8");
    os.write(input, 0, input.length);
}

int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
    new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
    response.append(inputLine);
}
in.close();
System.out.println(response.toString());

Go

package main

import (
       "bytes"
       "net/http"
       "encoding/json"
)

func main() {
    body := map[string]interface{}{
        "from_timestamp": "2024-01-01T00:00:00.000Z",
        "to_timestamp": "2024-01-31T23:59:59.999Z",
        "contextId": "workspace-123",
        "context": 0,
        "event": 0,
        "userId": "user-456",
        "workspaceId": "workspace-789",
        "skip": 0,
        "take": 20,
    }

    jsonData, _ := json.Marshal(body)

    headers := map[string][]string{
        "Content-Type": []string{"application/json"},
        "Accept": []string{"application/json"},
        "Authorization": []string{"Bearer your-jwt-token"},
    }

    data := bytes.NewBuffer(jsonData)
    req, err := http.NewRequest("POST", "https://backend.flashback.tech/systemevent", data)
    req.Header = headers

    client := &http.Client{}
    resp, err := client.Do(req)
    // ...
}

Body parameter

{
  "from_timestamp": "2024-01-01T00:00:00.000Z",
  "to_timestamp": "2024-01-31T23:59:59.999Z",
  "contextId": "workspace-123",
  "context": 0,
  "event": 0,
  "userId": "user-456",
  "workspaceId": "workspace-789",
  "skip": 0,
  "take": 20
}

Parameters

Name	In	Type	Required	Description
body	body	object	true	System event query parameters
» from_timestamp	body	string	false	Start timestamp for filtering events (ISO 8601 format)
» to_timestamp	body	string	false	End timestamp for filtering events (ISO 8601 format)
» contextId	body	string	false	Specific context identifier to filter by
» context	body	number	false	Context type index (0-10)
» event	body	number	false	Event type index (0-2)
» userId	body	string	false	User ID to filter by (role-dependent access)
» workspaceId	body	string	false	Workspace ID to filter by (role-dependent access)
» skip	body	number	true	Number of records to skip (minimum: 0)
» take	body	number	true	Number of records to return (minimum: 1, maximum: 100)

Context Type Values

Index	Context Type	Description
0	workspace	Workspace-related events
1	bucket	Bucket-related events
2	repo	Repository-related events
3	user	User-related events
4	org	Organization-related events
5	workspaceuser	Workspace user events
6	apikey	API key events
7	usersettings	User settings events
8	orgsettings	Organization settings events
9	flashbacknode	Flashback node events
10	orgkey	Organization key events

Event Type Values

Index	Event Type	Description
0	created	Resource created
1	updated	Resource updated
2	deleted	Resource deleted

Example responses

200 Response

{
  "events": [
    {
      "id": 12345,
      "timestamp": "2024-01-15T10:30:00.000Z",
      "contextId": "workspace-123",
      "context": "workspace",
      "event": "created",
      "orgId": "org-456",
      "userId": "user-789",
      "workspaceId": "workspace-123",
      "jsonData": "{\"name\":\"My Workspace\",\"description\":\"A new workspace\"}"
    },
    {
      "id": 12344,
      "timestamp": "2024-01-15T10:25:00.000Z",
      "contextId": "bucket-456",
      "context": "bucket",
      "event": "updated",
      "orgId": "org-456",
      "userId": "user-789",
      "workspaceId": "workspace-123",
      "jsonData": "{\"name\":\"Updated Bucket\",\"region\":\"us-east-1\"}"
    }
  ],
  "total": 150,
  "skip": 0,
  "take": 20
}

400 Response

{
  "error": "skip must be >= 0"
}

401 Response

{
  "error": "Unauthorized"
}

403 Response

{
  "error": "Insufficient permissions to query other users' events"
}

500 Response

{
  "error": "Internal server error"
}

Responses

Status	Meaning	Description	Schema
200	OK	System events retrieved successfully	Inline
400	Bad Request	Validation error or invalid parameters	Inline
401	Unauthorized	Authentication required or user not found	Inline
403	Forbidden	Insufficient permissions for requested data	Inline
500	Internal Server Error	Internal server error	Inline

Response Schema

Status Code 200

Name	Type	Required	Restrictions	Description
» events	array	true	none	Array of system events
»» id	number	true	none	Unique event identifier
»» timestamp	string	true	none	Event timestamp in ISO 8601 format
»» contextId	string	true	none	Context identifier
»» context	string	true	none	Human-readable context type
»» event	string	true	none	Human-readable event type
»» orgId	string	true	none	Organization ID
»» userId	string	true	none	User ID who triggered the event
»» workspaceId	string	false	none	Workspace ID (null if not applicable)
»» jsonData	string	false	none	Additional event data in JSON format
» total	number	true	none	Total number of events matching the query
» skip	number	true	none	Number of records skipped
» take	number	true	none	Number of records returned

Status Code 400

Name	Type	Required	Restrictions	Description
» error	string	true	none	Error message describing the validation issue

Status Code 401

Name	Type	Required	Restrictions	Description
» error	string	true	none	Error message indicating authentication failure

Status Code 403

Name	Type	Required	Restrictions	Description
» error	string	true	none	Error message indicating insufficient permissions

Status Code 500

Name	Type	Required	Restrictions	Description
» error	string	true	none	Error message describing the internal error

This operation requires authentication via Bearer token and enforces role-based access control for data security.