Tables and columns metadata

[egidiocaprino]

Hello.

Do you know anyway we can retrieve tables and columns metadata through the REST APIs? What we need is a list of existing tables and, for each table a list of columns with name and type.

sys_dictionary table should contains information about the columns but the labels are not human readable. I think I need to join another table but I cannot find any. Maybe sys_documentation but I cannot find the join field.

Can you please help us?

Thank you,

Egidio

[User140988]

Hi Egidio,

sys_db_object holds the table names, sys_dictionary holds the column names (also it has the column label), sys_documentation holds the label names. sys_dictionary column name is same as element in sys_documentation.

Regards,

Chandana

[egidiocaprino]

Thank you Chandana for you kind reply.

I have a field called short_description in my incident table. If I search in the sys_dictionary table for a record with name column equals to short_description I get no results. Do you know why?

How do I select from sys_dictionary only the columns from a specific table?

Thank you,

Egidio

[User140988]

Hi Egidio,

short_description is a field on task table , which is the parent table of incident. That is the reason you are not seeing it on incident table list. You have to select both task, incident in the filter condition. Look at the screenshot attached. Instead of putting a filter on incident table, go to list of incidents, right click, choose configure--> dictionary and see the columns. For one entry in sys_dictionary, there could be multiple entries in sys_documentation.

Regards,

Chandana

[egidiocaprino]

Thank you Chandana! It helped!

The last two things I cannot figure out are:

- How to map columns to tables. Is there a column in the sys_dictionary table?

- I need the API name of the column, but the only field I can find in the sys_dictionary is the column_label.