Need to change a value within a function for each row in a Google Sheet

Question

In Google Sheets

=ArrayFormula(row(1:100))  

fills 100 columns with numbers 1-100.

=ImportJSON("http://www.domain.com/sample1.json", "")

inserts my JSON data keys and values into corresponding rows.

How can I set this up so that for each column, I change the number for the JSON file?

I tried combining these two functions but it just errors. =ArrayFormula(ImportJSON("http://www.domain.com/sample&row(1:100)&.json", ""))

Now this works:

=ArrayFormula(row(1:100)&ImportJSON("http://www.domain.com/sample1.json", ""))

but it's not putting the number in the desired spot. It's just adding it before each cell.

Answer 1

I think you forgot to separate the first part of the url, the formula and the second part with quotations, deeming them as strings, note there are quotes around "http://www.domain.com/sample" then a function insertion then the rest of the string ".json"

=arrayformula("http://www.domain.com/sample"&row(1:100)&".json")