Hi. The API documentation seems unfortunately lacking for basic usage. I have simliar goals as this poster How to search via API where I’d very much like to just retrieve some row or rows based on a criteria.
I can’t tell from the bug merge, but are user_field_names still broken/unimplemented?¹
Is it a known bug that trying to filter on a number, and giving a non-number, just returns everything, instead of properly nothing? (example: Numeric field, filter_field_1_equals=test returns all records instead of an error.)
Why are the field values starting at 200k+ instead of at 0 or 1, where it’d be easier and obvious?
But my biggest question is, how can someone use link_row_has???
Say I have two tables. Let’s call one ‘fruits’ and the other ‘type_details’.
Fruit has a row called ‘apples’ with some uninteresting columns, and a linked field to type_details. Type_details has a key field (a number I put in), stuff like name, weight, color, whatever, and the “fruit_type” that links back to apple. How can I run a query on my ‘type_details’ table to retrieve all records that refer to ‘apples’ in the other table? Or, if need be, conversely, if I get the row ‘apples’ from table ‘fruits’, how can I iterate the values in the link field to get those specific rows from ‘type_details’?
In caes my contrived example really sucks, I’m actually tracking a ‘thing’ that will have 5-10 related rows per. I want to run a query on the table with those 5-10 related rows and only return the ones that are linked to ‘thing’.
It’d really be great if the api docs provided some filter usage; it’s nice how they’re specific to the database and fields - that’s really very helpful already. There just doesn’t seem to be anything on this.
(I’m just doing this via curl, if that matters)