Public Cloud APIs

updated 1 mth ago

All available Ninox Public 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://api.ninox.com/v1/teams

Retrieves data from multiple teams

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

200 The workspace ids and workspace names are displayed in the response

[
    {
        "id": "mnPLY6DMsvq9wz4id",
        "name": "Public Cloud Test Team"
    },
    {
        "id": "Cf8fqfNeCaAvBrjkS",
        "name": "Public Cloud Test Team_1"
    }
]

Sample request

curl https://api.ninox.com/v1/teams
-X GET
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"

Get a single workspace

GET https://api.ninox.com/v1/teams/{teamid}

Retrieves data from a single team

Path Parameters

Name	Type	Description
teamid*	string	workspace id

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

200 The workspace id and workspace name are displayed in the response

{
    "id": "mnPLY6DMsvq9wz4id",
    "name": "My Team 1"
}

Sample request

curl https://api.ninox.com/v1/teams/mnPLY6DMsvq9wz4id
-X GET
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"

Get multiple databases

GET https://api.ninox.com/v1/teams/{teamid}/databases

Retrieves data from multiple databases

Path Parameters

Name	Type	Description
teamid*	string	workspace id

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

200 The database id and name are displayed in the response

[
    {
        "id": "gt5k36w957yt",
        "name": "Contacts"
    }
]

Sample request

curl https://api.ninox.com/v1/teams/mnPLY6DMsvq9wz4id/databases
-X GET
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"

Get a schema for a single database

GET https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}

Retrieves data from a schema for a single database

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

200 Data from a schema for a database is displayed in the response

{
    "settings": {
        "name": "Contacts",
        "icon": "i-db-icon-big i-db i-team",
        "color": "#6691FF",
        "backgroundClass": "background-file",
        "backgroundTimestamp": 1505809647759
    },
    "schema": {
        "seq": 223,
        "version": 7,
        "nextTypeId": 10,
        "types": {
        },
        "afterOpenBehavior": "restoreNavigation",
        "fileSync": "full"
    }
}

404 A "Database Not Found" message is displayed in the response

{
    "message": "Database Not Found"
}

Sample request

curl https://api.ninox.com/v1/teams/mnPLY6DMsvq9wz4id/databases/gt5k36w957yt
-X GET
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"

Execute a read-only query with GET

GET https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/{query}

Executes a read-only query in a database

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id

Query Parameters

Name	Type	Description
query*	string	string of a query \| e.g., `(select Contact).'First Name'`

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

200 The first names of records in a specified table are displayed in the response

[
    "Tim",
    "Chalie",
    "John",
    "Caroline",
    "Sophie",
    "Hans",
    "Alfred ",
    "Nadin"
]

Sample request

curl https://api.ninox.com/v1/teams/mnPLY6DMsvq9wz4id/databases/pt53j1tburs8/query?query=(select Contact).'First Name'
-X GET
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"

Execute a read-only query with POST

POST https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/{query}

Executes a read-only query in a database

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

Request Body

Name	Type	Description
query*	string	string of a query \| e.g., `(select Contact).'First Name'`

200 The first names of records in a specified table are displayed in the response

[
    "Tim",
    "Chalie",
    "John",
    "Caroline",
    "Sophie",
    "Hans",
    "Alfred ",
    "Nadin"
]

Sample request

curl https://api.ninox.com/v1/teams/mnPLY6DMsvq9wz4id/databases/gt5k36w957yt/query
-X POST
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"
-D {
    "query": "(select Contact).'First Name'"
}

Execute a writable query

POST https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/exec

Executes a writable query in a database

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

Request Body

Name	Type	Description
query*	string	string of a query \| e.g., `users()`

200 A list of users is displayed in the response

[
    "anm2jMxL7kRuatXW9"
]

Sample request

curl https://api.ninox.com/v1/teams/mnPLY6DMsvq9wz4id/databases/gt5k36w957yt/exec
-X POST
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"
-D '{
    "query": "users()"
}'

Get a schema for multiple tables

GET https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables

Retrieves data from a schema for multiple tables

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

200 Data from a schema for tables is displayed in the response

[
    {
        "id": "A",
        "name": "Contact",
        "fields": [
        ]
    },
    {
        "id": "B",
        "name": "Contact Email",
        "fields": [
        ]
    },
    {
        "id": "C",
        "name": "Contact Phone",
        "fields": [
        ]
    },
    {
        "id": "D",
        "name": "Contact Address",
        "fields": [
        ]
    },
    {
        "id": "E",
        "name": "Contact Internet",
        "fields": [
        ]
    },
    {
        "id": "F",
        "name": "Contact instant messenger accounts",
        "fields": [
        ]
    },
    {
        "id": "G",
        "name": "Contact social profiles",
        "fields": [
        ]
    },
    {
        "id": "H",
        "name": "Table1",
        "fields": [
        ]
    },
    {
        "id": "I",
        "name": "Table2",
        "fields": [
        ]
    }
]

Sample request

curl https://api.ninox.com/v1/teams/mnPLY6DMsvq9wz4id/databases/gt5k36w957yt/tables
-X GET
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"

Get a schema for a single table

GET https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}

Retrieves data from a schema for a single table

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

200 Data from a schema for a table is displayed in the response

{
    "id": "A",
    "name": "Contact",
    "fields": [
        {
            "id": "A",
            "name": "Kind",
            "type": "choice",
            "choices": [
                {
                    "id": "1",
                    "caption": "Person",
                    "captions": {}
                },
                {
                    "id": "2",
                    "caption": "Company",
                    "captions": {}
                }
            ]
        }
    ]
}

Sample request

curl https://api.ninox.com/v1/teams/mnPLY6DMsvq9wz4id/databases/gt5k36w957yt/tables/A
-X GET
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"

Get multiple records

GET https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records

Retrieves data from multiple records in a table

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id
tid*	string	table id

Query Parameters

Name	Type	Description
choiceStyle	string	ids \| names
choice	string	ids \| names

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

200 Data from records is displayed in the response

[
    {
        "id": 1,
        "createdAt": "",
        "createdBy": 0,
        "modifiedAt": "2017-08-01T16:52:12",
        "modifiedBy": "EPZ2zSxuC7jt6WF2D",
        "fields": {
        }
    }
    {
        "id": 4,
        "createdAt": "",
        "createdBy": "EPZ2zSxuC7jt6WF2D",
        "modifiedAt": "2017-08-01T17:06:52",
        "modifiedBy": "EPZ2zSxuC7jt6WF2D",
        "fields": {
        }
    }
]

Sample request

curl https://api.ninox.com/v1/teams/Cf8fqfNeCaAvBrjkS/databases/zvdufqsrxwr2/tables/A/records
-X GET
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"

Get a single record

GET https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}

Retrieves data from a single record in a table

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id
tid*	string	table id
rid*	string	record id

Query Parameters

Name	Type	Description
choiceStyle	string	ids \| names
style	string	ids \| names

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

200 Data from a record is displayed in the response

{
    "id": 1,
    "createdAt": "",
    "createdBy": 0,
    "modifiedAt": "2017-08-01T16:52:12",
    "modifiedBy": "EPZ2zSxuC7jt6WF2D",
    "fields": {
    }
}

Sample request

curl https://api.ninox.com/v1/teams/Cf8fqfNeCaAvBrjkS/databases/zvdufqsrxwr2/tables/A/records/1
-X GET
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"

Update a single record with PUT

PUT https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}

Updates a single record in a table

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id
tid*	string	table id
rid*	string	record id

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

Request Body

Name	Type	Description
fields	object	object of a field \| e.g., `"First name": "Jane"`

200 Updated data from a record is displayed in the response

{
    "id": 8,
    "sequence": 207,
    "createdAt": "",
    "createdBy": "EPZ2zSxuC7jt6WF2D",
    "modifiedAt": "2021-09-23T14:47:09",
    "modifiedBy": "admin",
    "fields": {
        "First name": "Jane"
    }
}

Sample request

curl https://api.ninox.com/v1/teams/Cf8fqfNeCaAvBrjkS/databases/zvdufqsrxwr2/tables/A/records/8
-X PUT
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"
-D '{
    "fields": {
        "First name": "Jane"
    }
}'

Look up/search a single record with GET

GET https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records

Looks up/searches a single record in a table

Path Parameters

Name	Type	Description
teamid	string	workspace id
dbid	string	database id
tid	string	table id

Query Parameters

Name	Type	Description
filters	object	object of filters \| e.g., `"L": "Stanley"`

Headers

Name	Type	Description
Authorization	string	Bearer {accessToken}
Content-Type	string	application/json

200: OK Data from a record is displayed in the response

{
    "id": 1,
    "sequence": 133,
    "createdAt": "",
    "createdBy": 0,
    "modifiedAt": "2022-02-04T09:51:59",
    "modifiedBy": "root",
    "fields": {
        "Customer No": "K0001",
        "Title": "Mr",
        "Last Name": "Potts",
        "Email": "Stanley.Potts@cba.zyx",
        "First Name": "Stanley",
        "Image": "shutterstock_1519120589.jpg",
        "To Do": [
            23
        ],
        "Language": "DE",
        "Company": 1,
        "Status": "Active",
        "Meetings": [
            8,
            9
        ]
    }
}

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(see below).

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

Sample request

curl https://api.ninox.com/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": "Stanley"
    }
}'

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://api.ninox.com/v1/teams/u14mwnoutm14yrcnf/databases/w41fzot5t5wt/tables/A/records?filters={"L":"Stanley"}

Look up/search a single record with POST

POST https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/record

Looks up/searches a single record in a table

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id
tid*	string	table id

Query Parameters

Name	Type	Description
style	string	ids \| names
dateStyle	string	ids \| names
choiceStyle	string	ids \| names

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

Request Body

Name	Type	Description
filters	object	object of filters \| e.g., "A": `"A": "Sophie"`

200 Data from a record is displayed in the response

{
    "id": 6,
    "sequence": 90,
    "createdAt": "2021-09-28T09:32:42",
    "createdBy": "anm2jMxL7kRuatXW9",
    "modifiedAt": "2021-09-28T09:35:07",
    "modifiedBy": "EPZ2zSxuC7jt6WF2D",
    "fields": {
        "First name": "Sophie",
        "Last name": "Baxter",
        "Birthday": "1980-05-10",
        "Concatenate of City": "London",
        "Job title": "Head of Logistics",
        "Organization": "Hub City, Ltd.",
        "Department": "Import",
        "First of Address": "bax@hubcity.com"
    }
}

The endpoint is /record, not /records.

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

Sample request

curl https://api.ninox.com/v1/teams/u14mwnoutm14yrcnf/databases/w41fzot5t5wt/tables/A/record
-X POST
-H "Content-Type": "application/json"
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
-D '{
    "filters": {
        "L": "Stanley"
    }
}'

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://api.ninox.com/v1/teams/u14mwnoutm14yrcnf/databases/w41fzot5t5wt/tables/A/record?filters={"L":"Stanley"}

Create/update multiple records with POST

POST https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records

Creates/updates multiple records in a table

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id
tid*	string	table id

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

Request Body

Name	Type	Description
fields, rid	array	array of fields and record ids \| e.g.,`"1"` `"First name": "Tom"` `"First name": "Andrea"`

200 Data from an existing and from a newly created record is displayed in the response

[
    {
        "id": 1,
        "createdAt": "",
        "createdBy": 0,
        "modifiedAt": "2021-09-23T17:05:42",
        "modifiedBy": "admin",
        "fields": {
            "First name": "Tom",
        }
    },
    {
        "id": 12,
        "createdAt": "2021-09-23T17:05:42",
        "createdBy": "admin",
        "modifiedAt": "2021-09-23T17:05:42",
        "modifiedBy": "admin",
        "fields": {
            "First name": "Andrea",
        }
    }
]

Sample request

curl https://api.ninox.com/v1/teams/Cf8fqfNeCaAvBrjkS/databases/zvdufqsrxwr2/tables/A/records
-X POST
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"
-D [{
    "id": 1,
    "fields": {
        "First name": "Tom"
    }
},{
    "fields": {
        "First name": "Andrea"
    }
}]

To update an existing record, specify a record id and the fields you wish to update in a record.

To create a new record, do not specify the record id, only specify the fields you wish to create in a record.

Upsert (update/insert) multiple records with POST

POST https://api.ninox.com/v1/teams/{tid}/databases/{dbid}/tables/{tid}/records

Updates records if they exist or inserts new records in a table

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id
tid*	string	table id

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

Request Body

Name Type Description

_upsert boolean true | "_upsert": true

fields, rid*

array

Name	Type	Description
_upsert	boolean	true \| `"_upsert": true`
fields, rid*	array	array of fields and record ids \| e.g., `"_id": 43,` `"E": "Alfred",` `"G": "Becker"`

array of fields and record ids | e.g.,

"_id": 43,

"E": "Alfred",

"G": "Becker"

200: OK Data from an existing or from a newly created record is displayed in the response

[
    {
        "_id": 43,
        "_cu": "admin",
        "_cd": "2023-09-19T13:07:40",
        "_mu": "admin",
        "_md": "2023-09-19T13:07:40",
        "A": "Person",
        "E": "Alfred",
        "G": "Becker",
        "O": ""
    },
    {
        "_id": 44,
        "_cu": "admin",
        "_cd": "2023-09-19T13:07:40",
        "_mu": "admin",
        "_md": "2023-09-19T13:07:40",
        "A": "Person",
        "E": "Caroline",
        "G": "Schultz",
        "O": ""
    },
    {
        "_id": 45,
        "_cu": "admin",
        "_cd": "2023-09-19T13:07:40",
        "_mu": "admin",
        "_md": "2023-09-19T13:07:40",
        "A": "Person",
        "E": "Hans",
        "G": "Copeland",
        "O": ""
    }
]

Sample request

curl https://api.ninox.com/v1/teams/XFND77BerC5NNoxK4/databases/vibpwezinpsx/tables/A/records
-X POST
-H "Authorization": "Bearer ff184e50-0699-11ee-86e5-e581bf9dd2fe"
-H "Content-Type": "application/json"
-D '[{
"_upsert": true,
"_id": 43,
"E": "Alfred",
"G": "Becker"
}, {
"_upsert": true,
"_id": 44,
"E": "Caroline",
"G": "Schultz"
}, {
"_upsert": true,
"_id": 45,
"E": "Hans",
"G": "Copeland"
}]'

Use the upsert database operation when you need to update a single record or multiple records of the same record ID. This is especially useful when multiple tables are related to each other.

For example, upsert allows you to sync changes between multiple tables while maintaining the record IDs:

Get changes in a table with sequence number from a source table.

Apply those changes to a target table with Upsert (update/insert) multiple records with POST.

Get changes in a database with sequence number

GET https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/changes?sinceSq={sequence}

Retrieves changes in a database starting with a specified sequence number

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id

Query Parameters

Name	Type	Description
sinceSq={sequence}*	integer	changes since sequence number \| e.g., `sinceSq=1`

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

200: OK Updates of all records in all tables in a database are displayed in the response

{
    "config": {},
    "nextRids": {
        "A": 2
    },
    "updates": {
        "A1": {
            "_id": "A1",
            "_cu": "whQnZogNQm2XaWWgL",
            "_cd": 1695050930216,
            "_mu": "whQnZogNQm2XaWWgL",
            "_md": 1695050930216
        }
    },
    "removes": [],
    "files": [],
    "views": {
        "OLUnKwMQJaibWUzI": {
            "id": "OLUnKwMQJaibWUzI",
            "order": 10,
            "type": "A",
            "caption": "(all)",
            "config": {
                "type": "A"
            },
            "seq": 2
        }
    },
    "reports": {},
    "seq": 3
}

Sample request

curl https://api.ninox.com/v1/teams/XFND77BerC5NNoxK4/databases/a2jufgz7xu1w/changes?sinceSq=1
-X GET
-H "Authorization": "Bearer fbf2d4a0-5628-11ee-bac8-87316d8c232f"
-H "Content-Type": "application/json"

Get changes in a table with sequence number

GET https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/changes?sinceSq={sequence}

Retrieves changes in a table starting with a specified sequence number

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id
tid*	string	table id

Query Parameters

Name	Type	Description
sinceSq={sequence}*	integer	changes since sequence number \| e.g., `sinceSq=1`

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

200: OK Updates of all records in a table are displayed in the response

{
    "nextRid": 11,
    "updates": {},
    "removes": [
        "A8"
    ],
    "files": [],
    "views": {},
    "reports": {},
    "seq": 207
}

Sample request

curl https://api.ninox.com/v1/teams/XFND77BerC5NNoxK4/databases/vibpwezinpsx/tables/A/changes?sinceSq=1
-X GET
-H "Authorization": "Bearer fbf2d4a0-5628-11ee-bac8-87316d8c232f"
-H "Content-Type": "application/json"

Get changes in a single record with sequence number

GET api.ninox.com/v1/teams/{teamid}/databases/(dbid}/tables/{tid}/records/{rid}/changes?sinceSq={sequence}

Retrieves changes in a single record starting with a specified sequence number

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id
tid*	string	table id
rid*	string	record id

Query Parameters

Name	Type	Description
sinceSq={sequence}*	integer	changes since sequence number \| e.g., `sinceSq=1`

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

200: OK Updates of a single record in a table are displayed in the response

{
    "nextRid": 11,
    "updates": {
        "A1": {
            "_id": "A1",
            "_cu": 0,
            "_mu": "whQnZogNQm2XaWWgL",
            "_md": 1695051764090,
            "A": "1",
            "B": "1",
            "D": 315532800000,
            "E": "George",
            "G": "Hunter",
            "J": "Apricote AG",
            "K": "Marketing",
            "L": "Marketing manager"
        }
    },
    "removes": [],
    "files": [],
    "seq": 214
}

Sample request

curl https://api.ninox.com/v1/teams/XFND77BerC5NNoxK4/databases/vibpwezinpsx/tables/A/records/1/changes?sinceSq=1
-X GET
-H "Authorization": "Bearer fbf2d4a0-5628-11ee-bac8-87316d8c232f"
-H "Content-Type": "application/json"

Delete a single record

DELETE https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}

Deletes a single record from a table

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id
tid*	string	table id
rid*	string	record id

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

200 An empty object is displayed in the response

{}

404 A "Not Found" message is displayed in the response

{"message":"Not Found"}

Sample request

curl https://api.ninox.com/v1/teams/mnPLY6DMsvq9wz4id/databases/gt5k36w957yt/tables/A/records/8
-X DELETE
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"

Delete multiple records

DELETE https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records

Deletes multiple records from a table

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id
tid*	string	table id

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

Request Body

Name	Type	Description
record ids*	array	array of record ids

204 The response is empty

Sample request

curl https://api.ninox.com/v1/teams/mnPLY6DMsvq9wz4id/databases/gt5k36w957yt/tables/A/records
-X DELETE
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"
-D '[23,24]'

Get a single file

GET https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}/files/{file}

Retrieves a single file from a record

Path Parameters

Name	Type	Description
teamid	string	workspace id
dbid	string	database id
tid	string	table id
rid	string	record id
file	string	file name

Headers

Name	Type	Description
Authorization	string	Bearer {accessToken}
Content-Type	string	application/json

200 A file from a record is displayed in the response

Sample request

curl https://api.ninox.com/v1/teams/mnPLY6DMsvq9wz4id/databases/gt5k36w957yt/tables/A/records/5/files/mobile-phone.jpeg
-X GET
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"

Upload a single file with POST

POST https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}/files

Uploads a single file to a record

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id
tid*	string	table id
rid*	string	record id

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	multipart/form-data

Request Body

Name	Type	Description
file*	object	object of a file as multipart/form-data

202 A "File Uploaded Successfully" message is displayed in the response

File Uploaded Successfully

Sample request

curl https://api.ninox.com/v1/teams/Cf8fqfNeCaAvBrjkS/databases/zvdufqsrxwr2/tables/A/records/4/files
-X POST
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "multipart/form-data"
-F 'file=@"/Users/anastasiya/Downloads/iStock-184877012.jpeg"'

Delete a single file

DELETE https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}/files/{file}

Deletes a single file in a record from a record

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id
tid*	string	table id
rid*	string	record id
file*	string	file name

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

204 The response is empty

Sample request

curl https://api.ninox.com/v1/teams/Cf8fqfNeCaAvBrjkS/databases/zvdufqsrxwr2/tables/A/records/10/files/iStock-184877012.jpeg
-X DELETE
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"

Get metadata for multiple files

GET https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}/files

Retrieves metadata for multiple files from a record

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id
tid*	string	table id
rid*	string	record id

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

200 Metadata for files is displayed in the response

[
    {
        "name": "ninox_logo.png",
        "contentType": "image/png",
        "size": 238483,
        "modifiedDate": 1632733575298,
        "modifiedUser": "anm2jMxL7kRuatXW9",
        "seq": 214
    },
    {
        "name": "shutterstock_562246966_resized.jpeg",
        "contentType": "image/jpeg",
        "size": 278467,
        "modifiedDate": 1632733761006,
        "modifiedUser": "anm2jMxL7kRuatXW9",
        "seq": 218
    }
]

Sample request

curl https://api.ninox.com/v1/teams/Cf8fqfNeCaAvBrjkS/databases/zvdufqsrxwr2/tables/A/records/25/files
-X GET
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"

Get metadata for a single file

GET https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}/files/{file}/metadata

Retrieves metadata for a single file from a record

Path Parameters

Name	Type	Description
teamid*	string	workspace id
dbid*	string	database id
tid*	string	table id
rid*	string	record id
file*	string	file name

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/j

200 Metadata for a file is displayed in the response

{
    "name": "iStock-184877012.jpeg",
    "contentType": "image/jpeg",
    "size": 9771508,
    "modifiedDate": 1632407495923,
    "modifiedUser": "anm2jMxL7kRuatXW9",
    "seq": 253
}

Sample request

curl https://api.ninox.com/v1/teams/mnPLY6DMsvq9wz4id/databases/gt5k36w957yt/tables/A/records/5/files/iStock-184877012.jpeg/metadata
-X GET
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"

Get a thumbnail for a single file

GET https://api.ninox.com/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}/files/{file}/thumb.jpg

Retrieves a thumbnail for a single file from a record

Path Parameters

Name	Type	Description
file*	string	file name
teamid*	string	workspace id
dbid*	string	database id
tid*	string	table id
rid*	string	record id

Headers

Name	Type	Description
Authorization*	string	Bearer {accessToken}
Content-Type	string	application/json

200 The thumbnail of a file is displayed in the response

Sample request

curl https://api.ninox.com/v1/teams/mnPLY6DMsvq9wz4id/databases/gt5k36w957yt/tables/A/records/5/files/iStock-184877012.jpeg/thumb.jpg
-X GET
-H "Authorization": "Bearer c0da1580-1a26-11ec-ba4d-f9d8817e4f95"
-H "Content-Type": "application/json"

Content aside

Public Cloud APIs

Private Cloud APIs

API calls in Ninox script

Tables, fields, and records

Introduction to Ninox API