How to use a value in a query as a looping query

I'm trying to use the data from an API of an application we use to manage construction projects.   The query only returns the first 100 rows and a link to the next page.   It keeps re...