How to retrieve a list of objects with objectid

General
1

Is there a way to pass a list of objectids to Backendless.find and retrieve the corresponding records as a list? How can I implement this?

2

Hi.
I do not know what api you use.
But in common you can just create where clause where all objectIds will be pointed.
objectId in ('id1', 'id2', ...)

How to create requests with where clause is described in our documentation.

3

Thank you, this is exactly what I wanted. But what happens if one of the objectids is not found?
Will I get a list of the records found or will the entire operation be aborted with error?

1 Like
4

You’ll get the list of only existing objects.

5

Thank you

6

Can’t I use a user defined field in this manner? For example am not getting any response with
ProductId in ('id1', 'id2', ...)

7

Hello @Nkekere_Tommy_Minimann

Yes, you can

Is this ProductId a String column?

8

Yes it’s a string column. But response.size is giving me 0

9

Have you tested your where clause in Backendless REST Console?

10

Yes sir. ProductId in (‘AN3x388PlGH’) works in the REST console, but ProductId in (‘AN3x388PlGH’,‘BOnz5gTUXz4’) Says invalid whereClause

11

Make sure to use this character for single quotes:

'

Mark

12

Yes that’s the same character am using

13

I edited my answer, see above

14

There are only 2 of such single quotes on my keyboard. When I use the other one like this
ProductId in ( AN3x388PlGH , BOnz5gTUXz4 )

I get Column AN3x388PIGH does not exist in the Master table

`

15

could you please share your appId? and provide what table you use for getting this records

16

I’ve now done it correctly,
ProductId in (‘AN3x388PlGH’,‘BOnz5gTUXz4’,‘art’)
Works in the REST console but am having problems with making it work in code

17

C2AE98FF-1A1D-BF10-FF3E-64CD97C40D00
Master table

18

I’m glad to see you handled it :+1:

Do you use our SDK? what lang do you use?

19

Java SDK

20

Could you set a breakpoint in the code where the where clause is being composed and show what it looks like in the debugger? (please attach a screenshot)