Skip to main content

"listSessions"

JSON ADMIN "listSessions" action returns a list of active sessions

The "listSessions" action returns a list of active sessions that the logged-in account is authorized to see. The list can be filtered to include sessions from specific usernames.

Request examples

Minimal request

{
  "api": "admin",
  "authToken": "anAuthorizationTokenFromTheServer",
  "action": "listSessions"
}

Maximal request

{
  "requestId": "2",
  "authToken": "anAuthorizationTokenFromTheServer",
  "api": "admin",
  "action": "listSessions",
  "params": {
    "usernameFilter": [
      "jim"
    ]
  },
  "responseOptions": {
    "binaryFormat": "hex",
    "dataFormat": "objects",
    "numberFormat": "string"
  },
  "apiVersion": "1.0",
  "debug": "max"
}

Response examples

Successful response

{
    "result": {
        "sessions": [
            {
                "authToken": "anAuthorizationTokenFromTheServer",
                "username": "ADMIN",
                "description": "optional user description of session for troubleshooting"
            }
        ]
    },
    "requestId": "00000045",
    "errorCode": 0,
    "errorMessage": ""
}

Failure response

{
  "authToken": "invalidAuthtoken",
  "requestId": "2",
  "debugInfo": {
    "request": {
      "authToken": "invalidAuthtoken",
      "api": "admin",
      "action": "listSessions",
      "requestId": "2"
    }
  },
  "errorCode": 12031,
  "errorMessage": "'authToken' does not match any existing session. Use a valid 'authToken' or use 'createSession' to create a valid 'authToken'."
}

Use the listSessions API action to return a list of active sessions that the logged-in account is authorized to see

API actionsJSON ADMIN APIjsonActionadmin sessionlistSessionlistSessionslistsSessionlistsSessionslist session

"params"

The "params" property is an object that contains an action's parameters. Each action defines its own required and optional properties.

Properties summary

Table 1. "params" properties summary

Property

Description

Default

Type

Limits (inclusive)

usernameFilter

contains strings of usernames of accounts in order to filter a list of sessions

[]

array

1 to 64 bytes



"result"

The "result" property is a required object set by the server that contains the result of an action.

Essential information:

Properties summary

Table 2. "result" properties summary

Property

Description

Type

Limits (inclusive)

sessions

contains session objects where each session minimally describes a session

array of objects

session
.authtoken

signifies that the client is authenticated and authorized

string

0 to 225 bytes

session
.defaultBinaryFormat

specifies the default value for the "binaryFormat" property, which tells the server how to parse binary data from the client when the binary format is not specified in the action request

string

"base64"
"hex"
"utf8"
session
.defaultDatabaseName

specifies the default value of the "databaseName" property

string

1 to 64 bytes

session
.defaultResponseOptions

specifies a default value for "responseOptions" that is used by default in all other action calls. "includeFields" and "excludeFields" are mutually exclusive and "includePaths" and "excludePaths" are mutually exclusive

object

session
.defaultOwnerName

specifies the initial value of the "defaultOwnerName" property used by JSON APIs and FairCom's web application

string

0 to 256 bytes

session
.description

specifies an object for later identification

string

0 to 65,500 bytes

session
.hostname

specifies the name of the host device

string

session
.hostUuid

specifies the universal identifier of the server instance

string

session
.hostIpAddresses

specifies the IP addresses of the host

array of strings

session
.hostServerNamePort

specifies the server's ISAM port or server name

string

session
.hostSQLPort

contains the server's SQL port

string

session
.idleConnectionTimeoutSeconds

specifies the number of seconds that a session with no activity will stay open

integer

0 to 2147483647

session
.idleCursorTimeoutSeconds

specifies the number of seconds to keep a cursor open

integer

0 to 2147483647

session
.sessionStartTimestamp

specifies the UTC date and time (in ISO 8601 format) when the session was created

string

session
.sessionLastAccessedTimestamp

specifies the UTC date and time (in ISO 8601 format) when the session last received a JSON Action message, including the last time the session was pinged

string

session
.username

specifies the account name of a user or application

string

1 to 64 bytes



"sessions"

The "sessions" property is an array of session objects where each session object minimally describes a session.