Table name suffix [Feb 18]

Discord-Discussions
1

:raising_hand_man: sherfin asked

Hi, developer from ToolJet.com here :raised_hand_with_fingers_splayed:

We were trying to create an integration for NocoDB in ToolJet. And we bumped into a confusion:

When I create a table named users , the api endpoint generated contains the table named suffixed with a certain string to make it users_h9x6 . I don’t see a way to obtain that using the table name alone.

Is there a way to obtain this full table name from NocoDB UI itself? Or do we have to ask the user to go into the swagger API and have them copy the extended table name from there?

2

:raising_hand_man: wkw replied

are u creating the table via GUI?

3

:raising_hand_man: wkw replied

table names shouldnt be followed by a suffix. or u mean project id?

4

:raising_hand_man: sherfin replied

I’m creating table from GUI, however, the corresponding API endpoints being generated contains a string formed by the table name plus a random four-letter string.

So if I asked the user to enter the table name, then there is no way for my implementation to know what this random generated string is, while trying to hit the end-point.

5

:raising_hand_man: wkw replied

can you show the full endpoint here

6

:raising_hand_man: sherfin replied

http://tj-noco.herokuapp.com/nc/test_h9x6/api/v1/users

7

:raising_hand_man: sherfin replied

table name is test , but I have to ask the user to go to the swagger documentation and collect the string test_h9x6 and supply to ToolJet for integration.

8

:raising_hand_man: wkw replied

that s project id

9

:raising_hand_man: wkw replied

/nc/postgres_sd7s/api/v1/tableA

/nc/{PROJECT_ID}/api/v1/{TABLE_NAME}

10

:person_tipping_hand: o1lab replied

can u paste project info (from right top menu) sherfin@discord

11

:raising_hand_man: wkw replied

just checked the code. when we create a project, your project name will be converted to lower case, if there s space, it ll be converted to ‘_’, then followed by another 4 random characters with another underscore

12

:raising_hand_man: wkw replied

for tables, we wont add a random characters after it

13

:raising_hand_man: sherfin replied

Hi, thank you so much for this in depth support!, yes its the project id and not the table id, I stand corrected :sweat:

This is the project info o1lab@discord ```Node: v12.22.6

Arch: x64

Platform: linux

Docker: false

Database: pg

ProjectOnRootDB: true

RootDB: pg

PackageVersion: 0.84.10```

I’m wondering if there is a way to obtain this project id from the UI itself?

14

:person_tipping_hand: o1lab replied

you would 've to look up projectList apiin the home page

15

:raising_hand_man: sherfin replied

Alright, let me see, thanks!

16

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs