Call any web api & Service From MS SQL Server

preview_player
Показать описание
in this video we can call any web api from sql server and get json data in tabuler format

My blog & My personal application

Рекомендации по теме
Комментарии
Автор

Thank you very much for this excellent example and solution, please can you give me a help, actully I have successfuly run this on my local windows 10 Sql Server 2012, but when I try to run it on Windows Server 2012 R2 SQL Server 2012, it return NULL and when I log it with Error Object Return its shows SrvParms erorr
Thank you

basitbaig
Автор

if we can create a package of this to store data in sql server DB table . please provide the solution

jhyvjzs
Автор

Hi, kinda new to API. I'm told i need to add my connect.sid to my api call and i'm nut sure where to go from here. How would one incorporate this?

iLUUVESCENEi
Автор

I have created same code which is executing when i pass parameter and executing manually but same is not working in stored procedure (created stored procedure of same code and pasing variable)

chandrashekhardhamal
Автор

can we make SSIS package of this script

jhyvjzs
Автор

I am also getting null value on remote server, do you have a solution to this?

JenniferHartnett
Автор

Return null value when using remote server

chandangniit