Private Cloud APIs

All available Ninox Private Cloud API endpoints

Content in curly brackets { } signifies a placeholder. Both the curly brackets and the content within must be replaced for the request to work.

Get multiple workspaces

GET https://{private-cloud}.ninoxdb.de/v1/teams

Retrieves data from multiple teams

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

    {
        "id": "u14mwnoutm14yrcnf",
        "name": "Private Cloud Test Team"
    },
    {
        "id": "s7qijy0myyie9xitp",
        "name": "Private Cloud Test Team_1"
    }
]

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams
-X GET
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"

Get a single workspace

GET https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}

Retrieves data from a single team

Path Parameters

NameTypeDescription

teamid*

string

workspace id

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

{
    "id": "u14mwnoutm14yrcnf",
    "name": "Private Cloud Test Team"
}

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf
-X GET
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"

Get multiple databases

GET https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases

Retrieves data from multiple databases

Path Parameters

NameTypeDescription

teamid*

string

workspace id

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

[
    {
        "id": "pnum1qq8tpao",
        "name": "Private Cloud Test Database"
    }
]

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases
-X GET
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"

Get a schema for a single database

GET https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases/{dbid}

Retrieves data from a schema for a single database

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

{
    "settings": {
        "name": "Private Cloud Test Database",
        "icon": "database",
        "color": "#9da9ce",
        "bgType": "image",
        "backgroundClass": "background-file",
        "backgroundTimestamp": 1631793054608
    },
    "schema": {
        "seq": 58,
        "version": 10,
        "nextTypeId": 4,
        "types": {
        },
        "afterOpenBehavior": "restoreNavigation",
        "fileSync": "full"
    }
}

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao
-X GET
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"

Get a schema for multiple views

GET https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases/{dbid}/views

Retrieves data from a schema for multiple views in a database

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

[
    {
        "id": "DXaXkMZ54PN7Qstd",
        "order": 10,
        "type": "A",
        "caption": "(all)",
        "config": {
            "type": "A"
        },
        "seq": 2
    },
    {
        "id": "k3G0efinn6PL2vjJ",
        "order": 10,
        "type": "C",
        "caption": "(all)",
        "config": {
            "type": "C"
        },
        "seq": 56
    },
    {
        "id": "yCuVS0Uw23MePfDN",
        "order": 10,
        "type": "B",
        "caption": "(all)",
        "config": {
            "type": "B",
            "sort": 1,
            "descending": false,
            "cols": [
            ]
        },
        "seq": 43
    }
]

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/views
-X GET
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"

Execute a read-only query with GET

GET https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases/{dbid}/query

Executes a read-only query in a database

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

Query Parameters

NameTypeDescription

query*

string

string of a query | e.g., (select Contact).'First Name'

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

[
    "Naeem",
    "Anna"
]

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/query?query=(select Contact).'First Name'
-X GET
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"

Execute a read-only query with POST

POST https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases/{dbid}/query

Executes a read-only query in a database

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

Request Body

NameTypeDescription

query*

string

string of a query | e.g., (select Contact).'First Name'

[
    "Naeem",
    "Anna"
]

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/query
-X POST
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"
-D '{
    "query": "(select Contact).'First Name'"
}'

Execute a writable query

POST https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases/{dbid}/exec

Executes a writable query in a database

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

Request Body

NameTypeDescription

query*

string

string of a query | e.g., users()

[
    "root"
]

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/exec
-X POST
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"
-D '{
    "query": "users()"
}'

Get a schema for multiple tables

GET https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases/{dbid}/tables

Retrieves data from a schema for multiple tables

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

[
    {
        "id": "B",
        "name": "Contact",
        "fields": [
        ]
    },
    {
        "id": "D",
        "name": "Contact_1",
        "fields": [
        ]
    }
]

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables
-X GET
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"

Get a schema for a single table

GET https://{private-cloud}.ninoxdb.de/v1/teams{teamid}/databases/{dbid}/tables/{tid}

Retrieves data from a schema for a single table

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

tid*

string

table id

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

{
    "id": "D",
    "name": "Contact_1",
    "fields": [
        {
            "id": "A",
            "name": "First name",
            "type": "string"
        }
    ]
}

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/D
-X GET
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"

Get a schema of multiple views

GET https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/views

Retrieves data from a schema for multiple views of a table

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

tid*

string

table id

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

[
    {
        "id": "yCuVS0Uw23MePfDN",
        "order": 10,
        "type": "B",
        "caption": "(all)",
        "config": {
            "type": "B",
            "sort": 1,
            "descending": false,
            "cols": [
            ]
        },
        "seq": 43
    }
]

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/views
-X GET
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"

Get a shared view

GET https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/views/{viewid}/share

Retrieves a shared view of a table

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

tid*

string

table id

viewid*

string

view id

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

{
    "url": "https://anastasiya.ninoxdb.de/share/z571nojpwo86dhd6ycystohgl7oj72h0jb0v",
    "options": {
        }
    }
}

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/views/yCuVS0Uw23MePfDN/share
-X GET
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"

Create/update a shared view with POST

POST https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/views/{viewid}/share

Creates/updates a shared view of a table

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

tid*

string

table id

viewid*

string

view id

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

{
    "url": "https://anastasiya.ninoxdb.de/share/z571nojpwo86dhd6ycystohgl7oj72h0jb0v",
    "options": {
        }
}

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/views/yCuVS0Uw23MePfDN/share
-X POST
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"

Delete a shared view

DELETE https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/views/{viewid}/share

Deletes a shared view of a table

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

tid*

string

table id

viewid*

string

view id

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/views/yCuVS0Uw23MePfDN/share
-X DELETE
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"

Get multiple records

GET https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records

Retrieves data from multiple records in a table

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

tid*

string

table id

Query Parameters

NameTypeDescription

choiceStyle

string

ids | names

style

string

ids | names

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

[
    {
        "id": 5,
        "sequence": 47,
        "createdAt": "2021-09-13T18:24:26",
        "createdBy": "root",
        "modifiedAt": "2021-09-15T16:04:19",
        "modifiedBy": "a01n83X86",
        "fields": {
        }
    },
    {
        "id": 11,
        "sequence": 60,
        "createdAt": "2021-09-20T18:58:12",
        "createdBy": "a01n83X86",
        "modifiedAt": "2021-09-20T18:58:12",
        "modifiedBy": "a01n83X86",
        "fields": {
        }
    }
]

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/records
-X GET
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"

Get a single record

GET https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}

Retrieves data from a single record in a table

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

tid*

string

table id

rid*

string

record id

Query Parameters

NameTypeDescription

choiceStyle

string

ids | names

style

string

ids | names

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

[
    {
        "id": 1,
        "sequence": 4,
        "createdAt": "2021-09-13T18:24:26",
        "createdBy": "root",
        "modifiedAt": "2021-09-13T18:24:26",
        "modifiedBy": "root",
        "fields": {
        }
    }
]

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/records/1
-X GET
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"

Update a single record with PUT

PUT https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}

Updates a single record in a table

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

tid*

string

table id

rid*

string

record id

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

Request Body

NameTypeDescription

fields*

object

object of a field | e.g., "First name": "Jane"

{
    "id": 1,
    "sequence": 79,
    "createdAt": "2021-09-21T14:32:42",
    "createdBy": "root",
    "modifiedAt": "2021-09-22T21:12:01",
    "modifiedBy": "a01n83X86",
    "fields": {
        "First name": "Jane"
    }
}

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/D/records/1
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"
-D '{
    "fields": {
        "First name": "Jane"
    }
}'

Look up/search a single record with GET

GET https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records

Looks up/searches a single record in a table

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

tid*

string

table id

Query Parameters

NameTypeDescription

filters

object

object of filters | e.g., "L": "Jane"

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

[
    {
        "_id": 21,
        "_sq": 164,
        "_cu": 0,
        "_cd": "",
        "_mu": "root",
        "_md": "2022-02-04T16:26:56",
        "A": "K0021",
        "B": 2,
        "D": "Garza",
        "K": "Julissa.Garza@torvus.com",
        "L": "Jane",
        "V": "Kundin Kopie.jpg",
        "W": [
            13,
            18
        ],
        "C1": 2,
        "D1": 3,
        "H1": 1,
        "I1": [
            3
        ]
    }
]

To identify which filters are mapped to which ids, send a GET request to retrieve the schema of a single table.

To look up a record with GET, make sure the endpoint is/records. The result will be the same as in Look up/search a single record with POST.

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/w41fzot5t5wt/tables/A/records
-X GET
-H "Content-Type": "application/json"
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-D '{
    "filters": {
        "L": "Jane"
    }
}'

Alternative notation

An alternative notation of the example sample request above is to include the parameter filters in the URL and leave D (data) empty.

https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/w41fzot5t5wt/tables/A/records?filters={"L":"Jane"}

Look up/search a single record with POST

POST https://{private-cloud}.ninoxdb.de/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/record

Looks up/searches a single record in a table

Path Parameters

NameTypeDescription

teamid*

string

workspace id

dbid*

string

database id

tid*

string

table id

Query Parameters

NameTypeDescription

style

string

ids | names

choiceStyle

string

ids | names

dateStyle

string

ids | names

Headers

NameTypeDescription

Authorization*

string

Bearer {accessToken}

Content-Type

string

application/json

Request Body

NameTypeDescription

filters

object

object of filters | e.g., "L": "Jane"

{
    "id": 1,
    "sequence": 79,
    "createdAt": "2021-09-21T14:32:42",
    "createdBy": "root",
    "modifiedAt": "2021-09-22T21:12:01",
    "modifiedBy": "a01n83X86",
    "fields": {
        "First name": "Jane",
        "Last name": "Morris",
        "Birthday": "1990-07-12",
        "Concatenate of City": "Leed",
        "Job title": "Declarant",
        "Organization": "DJFK Software",
        "Department": "Export",
        "First of Address": "jkgdkf@mail.com"
    }
}

To identify which filters are mapped to which ids, send a GET request to retrieve the schema of a single table.

To look up a record with POST, make sure the endpoint is/record. The result will be the same as in Look up/search a single record with GET.

Sample request

curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/D/record
-X POST
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-H "Content-Type": "application/json"
-D '{
    "filters": {
        "L": "Jane"
    }
}'

Alternative notation

An alternative notation of the example sample request above is to include the parameter filters in the URL and leave D (data) empty.