Parse a JSON string in a MS SQL2016 Stored procedure

I believe I can help you parse this json inside a MSSQL Stored Procedure from the external API url and store all of the data into your table, let's chat. We can do something like this -> Declare @Object as Int; DECLARE @hr int Declare @json as table(Json_Table nvarchar(max)) Exec @hr=sp_OACreate 'MSXML2.ServerXMLHTTP.6.0', @Object OUT; IF @hr <> 0 EXEC sp_OAGetErrorInfo @Object Exec @hr=sp_OAMethod @Object, 'open', NULL, 'get', '[login to view URL];retmode=json&amp;id=17784783,19505939,217873815946,30166592,30310060,30575739,30837262', 'false' IF @hr <> 0 EXEC sp_OAGetErrorInfo @Object Exec @hr=sp_OAMethod @Object, 'send' IF @hr <> 0 EXEC sp_OAGetErrorInfo @Object Exec @hr=sp_OAMethod @Object, 'responseText', @json OUTPUT IF @hr <> 0 EXEC sp_OAGetErrorInfo @Object (insert into table)

Hello I can give you this function back with corrections and it will parse all the json file. I can do this job super quikcly right away now. Manzoor

Hi. Simple project. Great app writer for your projects. I have writen vb.net, scraping, excel, json app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile

Hey there, ⭐⭐⭐ With more than 9 years of experience in this industry, I am a professional full-stack web developer. I’ve good hands-on experience in following Frameworks, CMSs- WordPress, Magento, Joomla, Drupal & PHP based framework like- Laravel, CodeIgniter, Yii, Prestashop. I am well equipped in Core PHP, MYSQL, JavaScript, JQUERY, AJAX and designing through Adobe Photoshop, including HTML5, CSS2/3, Bootstrap (responsive sites). I do take pride in my ability to produce themes which pass the validation for XHTML and CSS as per W3C standards. I’ve expertise in REST web service, RESTful services & RESTful programming model. I’ve worked with JSON format: a result of a request to Web Service/Site was in that format & we successfully parsed it in the web-app. I have extensive experience working with AWS environment. I worked on many projects using REST and SOAP web APIs. I'm experienced in integrating Google Map API with mobile apps. experienced with S3, RDS, IAM, Athena, EC2, EMR, Lambda services. BTW, I'm certified AWS developer as well as Architect. Look forward to discussing this work in more details with you. Thanks, Harry.