Issue with scheduling refresh due to dynamic data source

to confirm, the second query is the query which includes all the pagination and table formatting, the first query is only grabbing the api data and loading it and then i have a second query to put it into the table which i havent posted here but its basically the same as the bottom half of query 2