I have a report (1) for which I make 1 API call to get 200 records. Each record is connected via lookup (2_id) to another report (2).
Now I want to get some fields from report 2 for each record in report 1. (without adding every field as a lookup)

I tried doing that by noting the "2_id" for each record and then make an API call for that specific ID, this also means that it generates 200 API calls, which soon hit the API Limit.

The second report has 1000+ records, and i can only get 200 at once, thats why tried solo calls with the "2_id" as criteria.

How would I do this with less API calls? Maybe just do 10x 200records Calls, and then search through them?
I am calling the getrecords inside a CRM function. Can/should I use COQL calls instead in CRM?