Pulling json or csv data from a url

I don't even know if this is possible, but I would like to try to make this work. I want to create a function in a spreadsheet that will pull information from a website that contains a json or csv file with the information it needs. I have a java code that does this already. But as far as I can tell, I can not implement this into VBA. However if there is anybody who understands both codes and can possibly translate it that would be awesome. So, here is the Java code:

Please Login or Register  to view this content.

Thank you

Can you post the json?

What is it that you need? The json file or the link to it?

The reason I ask is because the file will vary according to what ID number you are looking for. This holds true for the url as well.

Thanks Leith, yes, I was asking for the json string, your code suggests the data should be very easy to get, but there's no built in json parser in excel vba, so you'd normally use string manipulation to get the data you want, but to give you a solution for that, I'd need to see the data.

Edit: true, but the structure of the json wont

Okay I thought it might be the format you where interested in a link to an item in the json would be http://www.gw2spidy.com/api/v0.9/json/item/76

Does that java actually work for the link you posted? I'd guess not since there's no "price" in that json string. Which data is it specifically that you're after?

Based on the json structure you provided:

Please Login or Register  to view this content.

I've included item as string since there's a possibility that all the items aren't numbers and it doesn't affect the process.

Works like a charm, thank you very much. One other question, when can I get these items to update? Will it do it upon open or can I put it on a time schedule?

I think you need to give a bit more detail on your project, since I have no idea how you are using the code, it's a little difficult to comment