Lookup field in API

My question is about Inserting rows with API. Suppose I have 2 tables - table1 and table2. Table1 has a lookup field which refers to table2. Also let’s assume that I have 2 rows in table2 that have the same name values. How can I use API to specify which row should be taken from table2 when creating a record in table1? Because API takes row name, not row ID in value field - https://i.imgur.com/X6YFuPx.png



Hi @i.iskhakov, good question! For the two rows in table2, I assume you mean the Display Value is the same for both? Is it possible to give each row a unique Display Value? With the API, you can put the text value of the lookup in the request body (see this answer for details)

1 Like