Guild Wars 2

As a long-time coding admirer, I’ve always been interested in developing my own programs/apps, but haven’t had much opportunity to do so. I’ve read most of the stickies, and to be honest, I’m lost.

How do I actually use the API?

For example, I’d like to create a Google Sheet with 4 tabs: Ore, Cloth, Leather, Wood. On each sheet, I’d like a column for Type, Buy, and Sell. I’d like the Buy and Sell columns to show the current buy and sell orders for each item. However, I haven’t the slightest clue how to do so…

Is there some sort of tutorial out there? Or is there something more that I need to know?

The API is a JSON implementation. Basically, if you provide a url, it will return an array of information that you can parse through. I’d suggested going through https://forum-en.gw2archive.eu/forum/community/api/Welcome-to-the-API-Development-subforum , there’s a lot of useful information. If you’d rather not deal with the api itself and would instead like to use a wrapper, there’s a list of those here: http://wiki.guildwars2.com/wiki/API:List_of_wrappers