NocoDB | Operate As Docs

Connect your client's NocoDB 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	`nocodb`	`https://app.nocodb.com/api/v2`

Connecting

Your client makes a API token in their NocoDB settings and pastes it on their link. Operate As tries it with NocoDB 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"
    ]
  }
]

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

Permissions

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

Pass-through

NocoDB 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. Then send them their link.

Your client connects

They paste a API token from their NocoDB settings.

Find the endpoint

Pick the call from NocoDB's own API docs. Your path is everything after https://app.nocodb.com/api/v2.

Send it through Operate As

Use the client's ID, the service key nocodb 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/meta/bases/" \
  -H "Authorization: Bearer $OPERATE_AS_API_KEY"

curl "https://api.operate.as/v1/clients/6f1c2a7e-.../nocodb/meta/bases/" \  -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. 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"}