When you have a "Link to other records" column in your table and you have created some links to the current or another table, you can use this request to query each row's linked records' IDs and display values.
In the request body (see example request for demonstration):
table_idis the ID of the table you are querying;
keyof the "Link to other records" column. Attention: do not use the
link_idof the link column here.
rowsis an array. Include the following details of each row you are querying in every object:
row_idis the ID of the row you are querying;
offsetis the beginning number of your query. If your record is linked to multiple records, use e.g.
0to start quering from the 1st element or e.g.
5to start querying from the 6th element, etc. Attention: The returned list of linked rows is not ordered by its original order on the web interface, but rather by created time (
limitlets you to set a limit to the number of records returned. Use e.g.
10to return no more than 10 records.
In the response: -
row_id is the ID of each linked record; -
display_value is how this record is displayed on the web interface.
To get more information about each linked record, retrieve their
row_id and use the Query with SQL request, for example:
SELECT * FROM Table2 WHERE _id IN (row_id1, row_id2, ...);