{"repo":"geral2/SQL-APIConsumer","free":true,"listed":false,"github":"https://github.com/geral2/SQL-APIConsumer","clone":"git clone https://github.com/geral2/SQL-APIConsumer.git","description":"Database Project with generic procedures to consume API through GET/POST methods.","language":"TSQL","stars":147,"topics":["clr","sql-server","sql","sqlclr","api","apicaller","sql-api","clrsql","sql-apiconsumer","clr-stored-procedures"],"license":"MIT","category":"databases-storage","readme_excerpt":"SQL-APIConsumer Welcome to SQL-APIConsumer project!. It's Database Project built in C# whose main purpose it's allow consuming API GET/POST methods on SQL Server through CLR generics stored procedures. Keep in mind that it was developed and tested on SQL Server 2016 and later versions . If you need to deploy in an older version read the Built with section. Getting Started The main procedure of this project is APICaller Web Extended, which can be used to call API of different web methods. It return an extended result including headers, and data of the server, within the result. In case we do need all these details, just need the results, instead we could use APICaller WebMethod. With these two extended procedures we are able to change the content-type, through the header parameter. 1. SqlInt32 APICaller Web Extended(SqlString httpMethod, SqlString URL, SqlString Headers, SqlString JsonBody) 1. SqlInt32 APICaller WebMethod(SqlString httpMethod, SqlString URL, SqlString JsonBody) APICaller Web Extended Below parameters received. This procedure return an integer depending on the execution. 0: Sucess. -1: Failed. Parameter Description Posible Value Sample :---: :---: :--- :--- @httpMethod HTTP Method that would be call GET, POST, PUT,DELETE,PATCH 'GET' @URL URL intended to call Valid URL 'https://www.routingnumbers.info/api/name.json?rn=122242597' @Headers Header related to request, if needed. '' '[{\"Name\": \"Content-Type\", \"Value\" :\"text/javascript; charset=utf-8\" }]' @JsonBody Js","default_branch":null,"files":null,"tree":[],"storefront":"/r/geral2","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/geral2/SQL-APIConsumer/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}