Very nice presentation. Informative without over-explaining. I'm a DBA of 25+ years and recently ran into a developer calling CURL from xp_cmdshell to perform API operations knowing there had to be a better way. She is now simplifying her code and building out our API call libraries using your method. Thanks for putting this up sir!
Muchas gracias por el tutorial, me está sirviendo mucho y qué pena que tengas tantas vistas y pocos hayan agradecido tu esfuerzo, no les costaba nada dejar un LIKE. Gracias!
Hey, thank you for the video. This is all very new to me but I am super eager to learn about all this. I only recently got started with the whole ETL process, SQLs and APIs etc. My goal is to visualize data in Power BI and connect it to an SQL database. The connecting Power BI to a database is no problem, but the query result should be stored as table in the database. So my question would be: How would one store this query result in a table in your database? I am using SQL server management studio. Thank you in advance :)
I am using the same approach but I am getting error 'JSON text is not properly formatted. Unexpected character '"' found at some position. How to handle this?
@@garimapatel7444 If you did not find a solution, dm me and I can help. There are one or two sythax errors with the JSON text. I want to be sure you are not having a different error.
Awesome video. It really helped. I've implemented your process and it works. The only issue I'm having is when scheduling a job to run my SP. It's dying out due to what seems like a malformed JSON response from the API itself. Odd thing is I call the stored procedure manually and it works just fine. It's only when the job calls the executing of my stored procedure that it throws an error. Question: any way to edit the 'responseText' to remove/replace the "double-quotes" which seem to be what's causing my scheduled job to error out? Or any way to limit the "fields/properties" that are returned in the JSON 'responseText'?
what could be my mistake if i only get half a json string back? It returns a string of 65536 characters but in postman I get a string of 400k characters.
@@marcusholm2227 I have some code on GitHub that might make this process easier for you. Here is the link: github.com/areed1192/sigma_coding_youtube/blob/master/t%20sql/Making%20API%20Requests%20-%20Insert.sql Now this will insert it into a Non-Existing Table but it should give you an idea of how to take it to the next step. Let me know if you run into any issues.
Awesome! Just finished watching parts 1 & 2. Explanations were clear and concise. Thanks so much for putting this out there!
Very nice presentation. Informative without over-explaining. I'm a DBA of 25+ years and recently ran into a developer calling CURL from xp_cmdshell to perform API operations knowing there had to be a better way. She is now simplifying her code and building out our API call libraries using your method. Thanks for putting this up sir!
Thank you so much for this video and for part 1. Super helpful and easy to follow!!
Muchas gracias por el tutorial, me está sirviendo mucho y qué pena que tengas tantas vistas y pocos hayan agradecido tu esfuerzo, no les costaba nada dejar un LIKE. Gracias!
This was fantastic. Thank you so much.
Great video. Many thanks
Beautiful!
Great video! Thank you. Let’s see if I can put this in practice....
Best of luck :)
How would one POST a file in this case? I'm having issues getting it to work.
when i'm formatting json with 'with' keyword its putting null values in table
Me too
keep the original names, work for me
Hey, thank you for the video. This is all very new to me but I am super eager to learn about all this. I only recently got started with the whole ETL process, SQLs and APIs etc. My goal is to visualize data in Power BI and connect it to an SQL database. The connecting Power BI to a database is no problem, but the query result should be stored as table in the database.
So my question would be: How would one store this query result in a table in your database? I am using SQL server management studio. Thank you in advance :)
I am using the same approach but I am getting error 'JSON text is not properly formatted. Unexpected character '"' found at some position. How to handle this?
If anyone has any idea, please provide the solution. Thanks in advance.
@@garimapatel7444 If you did not find a solution, dm me and I can help. There are one or two sythax errors with the JSON text. I want to be sure you are not having a different error.
Awesome video. It really helped. I've implemented your process and it works. The only issue I'm having is when scheduling a job to run my SP. It's dying out due to what seems like a malformed JSON response from the API itself. Odd thing is I call the stored procedure manually and it works just fine. It's only when the job calls the executing of my stored procedure that it throws an error. Question: any way to edit the 'responseText' to remove/replace the "double-quotes" which seem to be what's causing my scheduled job to error out? Or any way to limit the "fields/properties" that are returned in the JSON 'responseText'?
try putting SET TEXTSIZE -1 before calling the sp, fixed it for me
You could use the REPLACE() function to replace/remove any quotes that are giving you grief 😀
Hi there Im getting a null response. Is there any email i cant write you? I cant send you url here cause the site is blocking it.
gracias
what could be my mistake if i only get half a json string back? It returns a string of 65536 characters but in postman I get a string of 400k characters.
Great video!
Currently I'm having trouble with joining the parsed values to a table in my own database. Any tips?
Are you trying to parse the values and insert it directly into an existing table?
@@SigmaCoding That's exactly what I'm trying to do.
@@marcusholm2227 I have some code on GitHub that might make this process easier for you. Here is the link: github.com/areed1192/sigma_coding_youtube/blob/master/t%20sql/Making%20API%20Requests%20-%20Insert.sql
Now this will insert it into a Non-Existing Table but it should give you an idea of how to take it to the next step. Let me know if you run into any issues.
Getting an unexpected 0x80072EE2 on the Send doing a GET which I have working in POSTMAN.