This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 73%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Hi
We need to expose some data in SQL server to a third party org who are outside our firewall. (We do have a VPN over a private circuit though).
We could allow them to connect to the sql box via firewall rules, or export data to files and push these to an SFTP server for them to download.
However we were wondering of there is a way to expose data in SQL via a restful API, without having to do too much additional work.
Is there an option to allow access to data in a sql database via an API without too much work/expense ?
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Greg Booth ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
SQL Server do not have a build-in API like REST or SOAP, you would have to create your own API.
thanks Olaf - do you know what the best microsoft toolset to do that with is ?
Thanks!
Thanks Olaf - do you know what the best microsoft toolset to do that with is ?
what the best microsoft toolset to do that with is ?
Best tool ever is Visual Studio and as API technology is Web ASP.NET with OData: Create an OData v4 Endpoint Using ASP.NET Web API
Hi @Greg Booth ,
Welcome to Microsoft Q&A!
Please read this article which may give you some help.
https://www.mssqltips.com/sqlservertip/6803/build-secure-sql-server-rest-api-minutes/
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.