search table by multiple properties

REST
1

Is there a way to search a table by more than one property? I have a table Latency and I would like to search by requestId, locationId, and carrierId. I have tried

GET https://api.backendless.com/v1/data/Latency?where=requestId='12345'&locationId='1'

GET https://api.backendless.com/v1/data/Latency?where=requestId='12345'&locationId=1

and even

GET https://api.backendless.com/v1/data/Latency?where=requestId='12345'&locationId%20IS%201

using SQL Search, which is probably wrong.

They all result in:

{"code":1025,"message":"Invalid data query parameter: locationId"}

If it’s not possible, I can use sortBy with where, but the ability to search by multiple properties would make things much faster and easier. Thanks!

2

Hello, Eric!

Try using AND instead of &. So, the clause would look like “requestId=‘12345’%20AND%20locationId=‘1’”

best regards,
Alex

3

Awesome. Thanks Alex.