NocoDB (self-hosted) | Operate As Docs

Connect your client's NocoDB (self-hosted) with a key they paste, and call its API through Operate As.

Website: nocodb.com
Connects by: Pasting a API token
Category: Spreadsheets and databases
Services: 1
Tools: Pass-through only

Service	Key	Base URL
NocoDB (self-hosted)	`nocodb-self-hosted`	`https://{site}/api/v2`

Your client also types their nocodb address (Where your NocoDB is, such as example.com, without https://).

Connecting

Your client makes a API token in their NocoDB (self-hosted) settings and pastes it on their link. Operate As tries it with NocoDB (self-hosted) before saving it, and stores it encrypted. See Services connected with an API key.

Check they're connected

curl https://api.operate.as/v1/me/clients \
  -H "Authorization: Bearer $OPERATE_AS_API_KEY"

curl https://api.operate.as/v1/me/clients \  -H "Authorization: Bearer $OPERATE_AS_API_KEY"

Response

[
  {
    "id": "6f1c2a7e-...",
    "name": "Miller Dental",
    "services": [
      "nocodb-self-hosted"
    ]
  }
]

[  {    "id": "6f1c2a7e-...",    "name": "Miller Dental",    "services": [      "nocodb-self-hosted"    ]  }]

Permissions

What the client reads	Permission it asks for
Use the NocoDB (self-hosted) key you paste, with only the access you gave that key	Chosen on the provider's screen

Pass-through

NocoDB (self-hosted) has no ready-made tools yet. Call any endpoint of its API through Operate As instead, with the client's access attached.

Add the client

In Clients, add your client and select NocoDB (self-hosted). Then send them their link.

Your client connects

They paste a API token from their NocoDB (self-hosted) settings.

Find the endpoint

Pick the call from NocoDB (self-hosted)'s own API docs. Your path is everything after https://{site}/api/v2, with the parts in braces filled in from your client's account.

Send it through Operate As

Use the client's ID, the service key nocodb-self-hosted and that path. Your Operate As key goes in Authorization; the client's access is added for you.

See Pass-through requests for the full request and response format.

Call any endpoint

curl "https://api.operate.as/v1/clients/6f1c2a7e-.../nocodb-self-hosted/..." \
  -H "Authorization: Bearer $OPERATE_AS_API_KEY"

curl "https://api.operate.as/v1/clients/6f1c2a7e-.../nocodb-self-hosted/..." \  -H "Authorization: Bearer $OPERATE_AS_API_KEY"

Response

{
  "status": 200,
  "data": {
    "…": "the service's own response"
  },
  "encoding": "json"
}

{  "status": 200,  "data": {    "…": "the service's own response"  },  "encoding": "json"}

When access ends

A key works until your client deletes it in NocoDB (self-hosted). They can paste a new one on the same link at any time, and your workflows carry on without changes.

See Keeping access alive and Removing access.

Calls answer, once the key is deleted

{
  "status": 401,
  "data": {
    "…": "the service's own error"
  },
  "encoding": "json"
}

{  "status": 401,  "data": {    "…": "the service's own error"  },  "encoding": "json"}