Guild Wars 2

After spending over an hour trying to find the answer to this, my brain in numb. and I know it’s probably an easy answer.

I am trying to get the list of just exotic runes in csv, I understand how to get

http:// www .gw2spidy.com/api/v0.9/csv/items/17/6

into the excel program, but it only gives me the first 100… How would I write that link to only ask for the exotic runes?

list of rarities: http: //www.gw2spidy.com/api/v0.9/json/rarities
08:26 <Drakie> all exotics; http:// www.gw2spidy.com/api/v0.9/json/items/17/0?rarity=5
08:27 <Drakie> there are 246 though
08:27 <Drakie> so you can’t get them all in 1 request
08:28 <Drakie> http:// www.gw2spidy.com/api/v0.9/json/items/17/0?rarity=5&perpage=250
08:28 <Drakie> fixed
08:28 <Drakie> cant get more than 250
08:29 <reanne> tyvm
08:29 <Drakie> tbh, if you’re interested in < 50 items you can use http:// www.gw2spidy.com/api/v0.9/json/items/all?filter_ids=1,2
08:30 <Drakie> you’ll have to gather the ids first for that though