SQLite Cloud

LIST APIKEYS

Syntax

LIST APIKEYS [USER username]

Privileges

USERADMIN

Description

The LIST APIKEYS command retrieves all the APIKEYS created on the server. The USER parameter can be used to filter the result further.

Return

A Rowset with the following columns:

  • username: user name
  • key: API KEY
  • name: mnemonic name
  • creation_date: API KEY creation date and time
  • expiration_date: API KEY expiration date and time (if any)
  • restriction: always 0 in this version

Example

> LIST APIKEYS
----------|---------------------------------------------|--------------|---------------------|---------------------|-------------|
 username | key                                         | name         | creation_date       | expiration_date     | restriction |
----------|---------------------------------------------|--------------|---------------------|---------------------|-------------|
 admin    | 4AsBcAEWda7eSbEJL7aSXECB8spDJDfFOkpvtufPX2Y | WebService 1 | 2022-08-25 11:16:24 | NULL                | 0           |
 admin    | 8QguErOFPuYvAtTR1QVobc6aytIfaal7ujeLFEVmutE | WebService 3 | 2022-08-25 11:17:04 | 2022-09-25 11:17:05 | 0           |
 admin    | aJcdAL6P1JwJHquTP5iK1ahk7b3tAicBBufPSmnkIb4 | Bind Test    | 2022-09-01 18:27:29 | 2022-09-21 18:27:29 | 1           |
 admin    | Hyl0E8y2Md49r5se7YEAzpE4npW8J5BJl1whyvQr4TU | test1        | 2022-09-01 18:31:23 | NULL                | 0           |
 admin    | bxnIddbMRyNlcZTZQApkdonUvrB2gwgQ2wndzrSMiDI | test1        | 2022-09-01 18:33:07 | NULL                | 0           |
 admin    | 94tJ9EUJJiiBZ8nAxuzLjqBFPw0IAvUGtlSU61lZ6W0 | key2         | 2022-09-02 05:09:45 | NULL                | 0           |
 admin    | roEylpydmHsKJSZKDc5acYTzu9vBwSQ9OeKTog02aow | test         | 2023-02-09 08:42:19 | NULL                | 0           |
----------|---------------------------------------------|--------------|---------------------|---------------------|-------------|