Import ZenDesk JSON Data to SQL Server using VB.Net

Question

I am a complete newby to API's and JSON, however I know what I am doing with SQL and I would say I am an amateur at VB.Net/ASP.Net. We use ZenDesk as our ticketing system, and understand that the link to get the data from it into JSON format is the following url: "https://COMPANYNAME.zendesk.com/api/v2/tickets.json". I've looked at a lot of 'solutions' on how to get this data into SQL, but none are working for me. I've never used the httpGetWebRequest in VB.Net before, so can please someone explain to me how to go about doing this? I would be very grateful for any assistance people could give me to this - it's doing my nut in!!

Kind Regards,

Miles

Answer 1

ZenDesk offers multiple Authentication methods to call their REST APIs.

1. Using basic Authentication (Use userid (e.g. email) and password)
2. Using API Token
3. Using OAuth 2.0

Key thing to understand is passing credentials, parsing JSON response into columns and then looping though multiple responses to extract full data set (REST URL paging)