API to Azure SQL Database RSS

• • Reply
  shabbir_215

  Member

  179 Points

  714 Posts

  API to Azure SQL Database

  Jun 16, 2020 05:32 PM|shabbir_215|LINK

  Hi All,

  Is there a way can we straight insert API json data into Azure SQL Database also is it possible to do scheduling ?

  Thanks,

  Shabbir

• • Reply
  bruce (sqlwo...

  All-Star

  56394 Points

  14756 Posts

  Re: API to Azure SQL Database

  Jun 16, 2020 11:26 PM|bruce (sqlwork.com)|LINK

  Sure, azure sql, just like Sqlserver stores json in a text column. You use the azure scheduler for scheduled events

     https://docs.microsoft.com/en-us/azure/scheduler/scheduler-intro
  
  

  bruce (sqlwork.com)
• • Reply
  shabbir_215

  Member

  179 Points

  714 Posts

  Re: API to Azure SQL Database

  Jun 17, 2020 03:58 AM|shabbir_215|LINK

  Thanks can you give an example to use Azure sql to call API and deserialise Json and store into sql table.
  
  Many thanks
  Shabbir
• • Reply
  bruce (sqlwo...

  All-Star

  56394 Points

  14756 Posts

  Re: API to Azure SQL Database

  Jun 17, 2020 03:37 PM|bruce (sqlwork.com)|LINK

  var data = new {
      message = "hello"
  };
  
  using (var conn = new SqlConnection(connectionString))
  {
     using (var cmd = conn.CreateCommand())
     {
         conn.Open();
         cmd.CommandText = "INSERT MyTable (JsonData) Values (@data)";
         cmd.Parameters.AddWithValue("@data", JsonConvert.SerializeObject(data));
         cmd.ExecuteNonQuery();
     }
  }

  bruce (sqlwork.com)