0

API endpoints for Public Cloud

In this article

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

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:

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

  2. 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"

Reply

null
Login to reply

In this article

Related articles
Integrations
API endpoints for Public Cloud
API endpoints for Private Cloud/On-Premises
API calls in Ninox script
Tables, fields, and records
Introduction to Ninox API

Content aside

Categories

View all topics
  • 5 mths agoMon, November 4, 2024 at 12:54 PM UTCLast active
  • 696Views
  • 1 Following