Two related tables: Users and Properties - API setup question

Matt

Properties table contains a field that allows multiple user IDs.

When I attempt to get all records under the Properties table where the User ID is present in this field, it only returns a single record (even though there are three).

This is probably something to do with my response/output, but I need a little guidance.

Pawel Magdanski

Hi,

First I would check if the query is not set to single insead of a list in output tab of a query.

Can you show a bit more? For example you custom query conditions and how the table looks like?

Matt

Yes, my Output for the API shows "list" here.

Generally I'm trying to use the User ID of the person who's authenticated to pull from the properties field, where that user ID is present. This particular field allows for multiple users as shown in my original post.

Matt

Quick update.

This might have been a user error - I'm actually getting the responses according to the database. Maybe I overlooked that for the user I was testing, there was only one related record.

Good news is we can consider this resolved! Thanks for the help, too.