public static HttpResponseMessage author(HttpRequestMessage req,
[HttpTrigger] AuthorRequest parameters,
[SQLDatabase(ConnectionString = "ConnectionString",
SQLQuery = "SELECT * FROM Book WHERE Author LIKE CHAR(37)+'{name}'+CHAR(37)")] String jsonTable,
TraceWriter log)
{
log.Info("author|json: C# HTTP trigger function processed a request.");
log.Info(jsonTable);
return(new HttpResponseMessage(HttpStatusCode.OK)
{
StatusCode = HttpStatusCode.OK,
Content = new StringContent("{ \"Data\": " + jsonTable + " }", Encoding.UTF8, "application/json")
});
}
public static HttpResponseMessage author(HttpRequestMessage req,
[HttpTrigger] AuthorRequest parameters,
[SQLDatabase(ConnectionString = "ConnectionString",
SQLQuery = "SELECT * FROM Book WHERE Author LIKE CHAR(37)+'{name}'+CHAR(37)")] DataTable table,
TraceWriter log)
{
log.Info("author|DataTable: C# HTTP trigger function processed a request.");
// Convert DataTable to JSON string
var objType = JArray.FromObject(table, JsonSerializer.CreateDefault(new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
})); //.FirstOrDefault(); // Get the first row
var js = objType.ToString();
return(new HttpResponseMessage(HttpStatusCode.OK)
{
StatusCode = HttpStatusCode.OK,
Content = new StringContent("{ \"Data\": " + js + " }", Encoding.UTF8, "application/json")
});
}
