0

I host my database on Azure. I would like to search data on the table in that database. I am trying to use B4I and the tech help their said I need to use REST API's. I am pretty sure I need to use ODATA. I have the auth token but I am not sure if this is even possible.

Graemem
  • 11
  • 3
  • Are you using Azure SQL, something on a VM, Cosmos DB or Table storage? The access options will vary depending on what service you are using. ex. Cosmos DB uses API as it's primary method of access whereas you would need a layer on top of Azure SQL to accomplish this. – PerfectlyPanda Mar 29 '19 at 17:22
  • I believe I am using Azure SQL, what would I need to use to query the tables? – Graemem Mar 29 '19 at 18:33

1 Answers1

0

In order to query Azure SQL with an API you need to add a layer between it and the destination. As mentioned in this question, OData is a specification that can be implemented fairly easily as there are plenty of libraries that will take care of the bulk of the code for you.

As far as where to host the API, you have several options within Azure. The most common being App Services, Azure Functions, and Logic Apps.

PerfectlyPanda
  • 3,271
  • 1
  • 6
  • 17