Get database records using list of ids

[wrone]

Hi!

I have a list of ids (standard ids that are generated when a record is inserted). I need to query or retrieve the records using this list of ids.

As far as I understand, the method notion.pages.retrieve(page_id=page_id) accepts only 1 id. I can put the retrieve method in a loop and retrieve each record separately, but I would like to avoid that approach.

I was not able to query records using filters and self.notion.databases.query() with the ids. For some reason, I could make it work only with my custom properties, but not with the standard id.

---

Just to provide more details, maybe there is another approach.

I have 2 databases:

1. Clients
2. Deals - each deal is referencing a client

First, I query deals using my custom property "Order Id". Then, I take the ids of the clients from the query result (I don't see any custom properties in the query result, only the id). Now I need to get clients using the collected ids and this is where I'm stuck.

[wrone]

I found a workaround for my issue. I added rollup fields to the Deals database, these rollup fields are showing the Client fields. Not sure what are the disadvantages of this approach, but it's working fine