[Bug Report] "Id" not showing up in Request types in openapi.json

1

Using the following command to retrieve an openapi.json file for our first party base:

curl -H "xc-token: <token>" https://app.nocodb.com/api/v1/db/meta/projects/<project id>/swagger.json

I noticed that after the recent changes to the openapi.json, the openapi json no longer has “Id” as a field in Request types. For example:
openapi json prior to API change:

 "Table 1Request": {
                "title": "Table 1 Request",
                "type": "object",
                "description": "",
                "x-internal": false,
                "properties": {
                    "Id": {
                        "type": "integer"
                    },
                    ...

And after API change:

 "Table 1Request": {
                "title": "Table 1 Request",
                "type": "object",
                "description": "",
                "x-internal": false,
                "properties": {
                  <no "Id" property present>
                    ...

Another thing maybe worth noting is link columns remain type integer, whereas Id columns are type number(when they appear in Response types).

2

Thanks for pointing out the issue, I’m working on a fix and soon we will rollout the fix. Meanwhile may I know couple of details to handle this issue in a better way,

  • Is the table belongs to an external source ? If yes what’s the DB type ?
3

Thanks for your speedy response. This is using a nocodb cloud first party base, and the table does not belong to an external source.

1 Like
4

I also notice fields with the type

{
    "type": "string",
     "format": "date"
},

Seem to be missing from the request types as well.

1 Like
5

Thanks for your quick reply and I made a fix for both issues here. We will rollout the production soon.

1 Like