none
Connection to SQL Server RRS feed

  • Question

  • Are there any rest api to login and run a sql query in SQL Azure PaaS database

    Thanks

    Thursday, November 14, 2019 2:48 PM

Answers

  • This is a management API and cannot be used to run SQL queries against the database.

    You can use it for management operations like creating, deleting databases, modifying firewall rules etc

    • Marked as answer by VG2014 Monday, November 18, 2019 11:26 AM
    Friday, November 15, 2019 10:45 AM
    Moderator

All replies

  • I believe you are looking for an ODATA wrapper to expose data in Azure SQL via a REST endpoint.

    This capability is not available in Azure SQL server today.

    You can however build one using Logic apps or Azure functions.

    A tutorial is here.

    -

    If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .

    And, if you have any further query do let us know. 

    Thursday, November 14, 2019 3:03 PM
    Moderator
  • Hi VG2014,

    Did you check this link -> https://docs.microsoft.com/en-us/rest/api/sql/?

    regards!

    Thursday, November 14, 2019 3:03 PM
  • This is a management API and cannot be used to run SQL queries against the database.

    You can use it for management operations like creating, deleting databases, modifying firewall rules etc

    • Marked as answer by VG2014 Monday, November 18, 2019 11:26 AM
    Friday, November 15, 2019 10:45 AM
    Moderator