Hello
Grantmaking getRequests API call recommends retrieving 20 records per page (per call) in response. One has to put the call in a loop to get all records. The issue is that each API call regardless of its page number, puts its auto-generated __key_requests and all the other keys on each sub-select back to 0. This causes a big issue when we are trying to call it from another software where we don't own the code and it doesn't handle json format gracefully. An example is Qlik Sense that breaks the nested json into multiple tables and links them through that very key. I had to manually multiply the page number by 20 and add it to all the keys in all tables and hope for the best.
So, some solutions would be:
To start the key based on the page number (like I did through multiplying the page number by the number of records and added that to the key ).
To retrieve real FK_Keys, PK_Keys.
To pass another piece of information from request into sub-selects such as request ID.
Thank you
Mehrnaz Ahmadi Joobaneh