How to make API Request in SQL Server | Pt. 2

Now that we made our request, we need to parse the response. In this part, we will get exposed to the OPENJSON functionality provided by SQL Server (Compatibility 130 or Greater) that allows us to take JSON objects and parse them for values. Quickly creating a way for us to make a standard table with our JSON data.

Video Resources:
--------------------------------------------------
Resource: GitHub File
Link: github.com/areed1192/sigma_coding_youtube/tree/…


Resources:
--------------------------------------------------
Facebook Page: facebook.com/codingsigma
Facebook Group: facebook.com/groups/sigmacoding
GitHub Sigma Coding: github.com/areed1192/sigma_coding_youtube

Support Sigma Coding:
--------------------------------------------------
Patreon: patreon.com/sigmacoding
Amazon Associates: amzn.to/3bsTI5P **

Related Topics:
--------------------------------------------------
Title: How to make API Request in SQL Server | Pt. 2
Link: youtu.be/IUWfBgQT6kw

Title: How to make API Request in SQL Server | Pt. 1
Link: youtu.be/93q8joTcRpQ

Title: Working with Excel Files in SQL Server
Link: youtu.be/Jj_n2YP00Jc

Title: Using Pivot in TSQL | Pt. 1
Link: youtu.be/YXN5aZhPE7E

Title: Using Pivot in TSQL | Pt. 2
Link: youtu.be/LgFpeOK502E


**Amazon Associates Disclosure:
--------------------------------------------------
I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel.

Tags:
--------------------------------------------------
#SQL #API #JSON