How to use API rowsearch on a relationship field

[unkinected]

I can't tell if I'm doing something wrong or the rowsearch feature isn't working correctly. My setup is pretty simple to start: I have two tables: EmployeeAssets and Assets. Each has 1 row and have a relationship field to link the two.

EmployeeAssets

• _id: ro_ta_EA; EmployeeName: Bob Smith; Assets: Computer <- this last column is a relationship field to Assets table

Assets

• _id: ro_ta_A; Name: Computer; Employee: Bob Smith <- this last column is a relationship field to EmployeeAssets table

When I run a rowsearch on EmployeeAssets like so:
{ "query": { "equals": { "Assets": "ro_ta_1" } } }

It returns the single row from that table. But why? The only asset ID I have in there is ro_ta_A, I don't have ro_ta_1.

Worse, if I try this query:
{ "query": { "equals": { "_id": "blah" } } }

I STILL get my single row back. How is that happening? The _id of my 1 row is ro_ta_EA. It seems no matter what I pass in to the query body, as long as it's a real column, I'm still getting the single row back.

If I try this, I get no records back:
{ "query": { "equals": { "Assets._id": "ro_ta_A" } } }

"Assets._id" is not a real column name.

I've tried various search operators: contains, string, equals, etc. I tried passing a complex json object into the query to match the returned data exactly, but that doesn't work either.

I hope I'm just missing something obvious. FWIW, these results are the same whether I write custom code or use the "Try It" feature in the API docs. Would appreciate any help!

[mikesealey]

Hey @unkinected

I've been looking into this, and I think you're right, there does seem to be some unexpected/unintended behaviour happening with the public API.

I've raised an issue here: #16254