Comment on page
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
https://{private-cloud}.ninoxdb.de
/v1/teams
Get multiple workspaces
1
curl https://anastasiya.ninoxdb.de/v1/teams
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}
Get a single workspace
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases
Get multiple databases
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}
Get a schema for a single database
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/views
Get a schema for multiple views
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/views
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/query
Execute a read-only query with GET
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/query?query=(select Contact).'First Name'
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
post
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/query
Execute a read-only query with POST
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/query
2
-X POST
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
5
-D '{
6
"query": "(select Contact).'First Name'"
7
}'
post
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/exec
Execute a writable query
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/exec
2
-X POST
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
5
-D '{
6
"query": "users()"
7
}'
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables
Get a schema for multiple tables
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
get
https://{private-cloud}.ninoxdb.de
/v1/teams{teamid}/databases/{dbid}/tables/{tid}
Get a schema for a single table
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/D
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/views
Get a schema of multiple views
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/views
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/views/yCuVS0Uw23MePfDN/share
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/views/yCuVS0Uw23MePfDN/share
2
-X POST
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/views/yCuVS0Uw23MePfDN/share
2
-X DELETE
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records
Get multiple records
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/records
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}
Get a single record
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/records/1
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
put
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}
Update a single record with PUT
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/D/records/1
2
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
3
-H "Content-Type": "application/json"
4
-D '{
5
"fields": {
6
"First name": "Jane"
7
}
8
}'
get
https://{private-cloud}.ninoxdb.de/
v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records
Look up/search a single record with GET
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.1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/w41fzot5t5wt/tables/A/records
2
-X GET
3
-H "Content-Type": "application/json"
4
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
5
-D '{
6
"filters": {
7
"L": "Jane"
8
}
9
}'
An alternative notation of the example sample request above is to include the parameter
filters
in the URL and leave D
(data) empty.1
https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/w41fzot5t5wt/tables/A/records?filters={"L":"Jane"}
post
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/record
Look up/search a single record with POST
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.1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/D/record
2
-X POST
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
5
-D '{
6
"filters": {
7
"L": "Jane"
8
}
9
}'
An alternative notation of the example sample request above is to include the parameter
filters
in the URL and leave D
(data) empty.1
https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/D/record?filters={"L":"Jane"}
post
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records
Create/update multiple records with POST
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/D/records
2
-X POST
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
5
-D '[{
6
"id": 2,
7
"fields": {
8
"First name": "Dennis"
9
}
10
},{
11
"fields": {
12
"First name": "Jody"
13
}
14
}]'
- 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.
post
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records
Upsert (update/insert) multiple records with POST
1
curl https://anastasiya.ninoxdb.de/v1/teams/c1w72a5wl28zzmpn9/databases/m8u2w3ulmgt3/tables/A/records
2
-X POST
3
-H "Authorization": "Bearer 90472720-5244-11ee-966b-d50b6af8825c"
4
-H "Content-Type": "application/json"
5
-D '[{
6
"_upsert": true,
7
"_id": 43,
8
"E": "Alfred",
9
"G": "Becker"
10
}, {
11
"_upsert": true,
12
"_id": 44,
13
"E": "Caroline",
14
"G": "Schultz"
15
}, {
16
"_upsert": true,
17
"_id": 45,
18
"E": "Hans",
19
"G": "Copeland"
20
}]'
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.
- 2.
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/changes?sinceSq={sequence}
Get changes in a database with sequence number
1
curl https://anastasiya.ninoxdb.de/v1/teams/c1w72a5wl28zzmpn9/databases/k6lj89vm8vsl/changes?sinceSq=1
2
-X GET
3
-H "Authorization": "Bearer 90472720-5244-11ee-966b-d50b6af8825c"
4
-H "Content-Type": "application/json"
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/changes?sinceSq={sequence}
Get changes in a table with sequence number
1
curl https://anastasiya.ninoxdb.de/v1/teams/c1w72a5wl28zzmpn9/databases/qjheo7dnp4fk/tables/A/changes?sinceSq=1
2
-X GET
3
-H "Authorization": "Bearer 90472720-5244-11ee-966b-d50b6af8825c"
4
-H "Content-Type": "application/json"
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}/changes?sinceSq={sequence}
Get changes in a single record with sequence number
1
curl https://anastasiya.ninoxdb.de/v1/teams/c1w72a5wl28zzmpn9/databases/m8u2w3ulmgt3/tables/A/records/8/changes?sinceSq=1
2
-X GET
3
-H "Authorization": "Bearer 90472720-5244-11ee-966b-d50b6af8825c"
4
-H "Content-Type": "application/json"
delete
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}
Delete a single record
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/D/records/1
2
-X DELETE
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
delete
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records
Delete multiple records
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/D/records
2
-X DELETE
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
5
-D '[7,8]'
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}/files/{file}
Get a single file
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/records/5/files/iStock-184877012.jpeg
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
post
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}/files
Upload a single file with POST
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/records/5/files
2
-X POST
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "multipart/form-data"
5
-F 'file=@"/Users/anastasiya/Downloads/iStock-184877012.jpeg"'
delete
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}/files/{file}
Delete a single file
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/records/5/files/iStock-184877012.jpeg
2
-X DELETE
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}/files
Get metadata for multiple files
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/records/5/files
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}/files/{file}/metadata
Get metadata for a single file
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/records/5/files/123.jpeg/metadata
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
get
https://{private-cloud}.ninoxdb.de
/v1/teams/{teamid}/databases/{dbid}/tables/{tid}/records/{rid}/files/{file}/thumb.jpg
Get a thumbnail for a single file
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/records/5/files/123jpeg/thumb.jpg
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/records/5/files/iStock-184877012.jpeg/share
2
-X GET
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/records/5/files/mobile-phone.jpeg/share
2
-X POST
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
1
curl https://anastasiya.ninoxdb.de/v1/teams/u14mwnoutm14yrcnf/databases/pnum1qq8tpao/tables/B/records/5/files/iStock-184877012.jpeg/share
2
-X DELETE
3
-H "Authorization": "Bearer e66e5190-14ad-11ec-aa6f-3502731d486c"
4
-H "Content-Type": "application/json"
Last modified 2mo ago