Replies: 1 comment 6 replies
-
Hi @sclu1034, If you would like to see some specific information related to linked records you can use a Lookup column (https://docs.nocodb.com/fields/field-types/links-based/lookup) or Rollup column for aggregated information (https://docs.nocodb.com/fields/field-types/links-based/rollup/). If you would like to get linked records via API you can use Let me know if this is enough for your use-case, otherwise I can help with manually recognizing the relations as well (for quick overview all information stored within columns part of table read API, and relation information is stored within colOptions of your column (mm table, child/parent columns etc.). we provide API's to fetch linked records without bothering with all the underlying stuff so I hope that would be enough for your use-case) |
Beta Was this translation helpful? Give feedback.
-
I have two tables
Songs
&Playlists
. Each have a column that points to the other, with a M2M relationship.When querying
Playlists
via the API, I get a fieldSongs
(which matches the name in the UI), but its content is just a number. The field holding the actual data has some generated namenc_o9qt___nc_m2m_odp0l09uz_s
.Since I haven't found any documentation, I've already been digging through the source code and found a few "meta" API routes, but especially the table meta contains quite a lot of stuff.
What series of API calls and their combination do I need to figure out the JSON field name for a M2M column, assuming that the only info I have are the human-readable strings in the UI (i.e. table names, column names)?
Beta Was this translation helpful? Give feedback.
All reactions