Dumping all the records in SQL SERVER table from JSON API with looping all the pages

jprajapati

Hi Team,

I am trying to dump all the records from all the pages (JSON API) Into SQL SERVER table.
So, I am trying to loop page numbers in URL till I get the last page.
The loop runs fine. However, It is just dumping all the records from the first. 
I tried to print URL just to make sure It changes the page parameter and It changes that parameter.
Just not dumping the records.

Russell D

As this looks like a more general SQL query, it's probably better to post this over on somewhere like https://www.sqlservercentral.com/forums.