title: insert row in Azuresqldatabase by using Azure Logic Apps
body: <p>I am having Azure SQL database and I want to perform Insert,Update,Delete Operations by using Logic Apps
  and <strong>is it  necessary to have a gateway</strong> while Connecting to Azure SQL DB to Sqlserver Connector in Logic -app I have Three properties 1)Id 2)Name 3)Department in <strong>Azure SqlDB</strong></p>
  
  <pre><code>**When HTTP Request is Received Code:**
  {
  "headers": {
      "Accept": "application/json",
      "Content-Type": "application/json"
  },
  "properties": {
      "Department": {
          "type": "string"
      },
      "Name": {
          "type": "string"
      },
      "id": {
          "type": "integer"
      }
  },
  "type": "object"
  </code></pre>
  
  <p>}
  <a href="https://i.stack.imgur.com/HsAYQ.jpg" rel="nofollow noreferrer">Http Request is Received</a></p>
  
  <p>In sql Connector it showing Bad request:
  <a href="https://i.stack.imgur.com/GnAd3.jpg" rel="nofollow noreferrer">Insert -row Connector</a></p>
  
  <p>The Body element of properties are null</p>
  
  <pre><code>{ "Department": null, "Name": null,  "id": null  }
  </code></pre>
  
  <p>The Output of Insert Row Connector
    {</p>
  
  <pre><code>"statusCode": 400,
  "headers": {
      "Pragma": "no-cache",
      "x-ms-request-id": "3332d425-3e10-4f04-b618-63f359168acc",
      "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
      "X-Content-Type-Options": "nosniff",
      "X-Frame-Options": "DENY",
      "Timing-Allow-Origin": "*",
      "x-ms-apihub-cached-response": "false",
      "Cache-Control": "no-store, no-cache",
      "Date": "Mon, 04 May 2020 08:16:24 GMT",
      "Content-Length": "468",
      "Content-Type": "application/json",
      "Expires": "-1"
  },
  "body": {
      "status": 400,
      "message": "Microsoft SQL: Cannot insert the value NULL into column 'id', table '.dbo.Details'; column does not allow nulls. INSERT fails.\r\nclientRequestId: 3332d425-3e10-4f04-b618-63f359168acc",
      "error": {
          "message": "Microsoft SQL: Cannot insert the value NULL into column 'id', table 'dbo.Details'; column does not allow nulls. INSERT fails."
      },
      "source": "sql-eus2.azconn-eus2.p.azurewebsites.net"
  }
  </code></pre>
  
  <p>}</p>
  
  <p>Note:I am not using any gate-way please guide me on the above task if you have any resource please let me 
  know</p>
  
  <p>Logic App-Defination:
  <a href="https://i.stack.imgur.com/F1LH2.jpg" rel="nofollow noreferrer">Designer</a></p>
  
  <p>previous error history:
  <a href="https://i.stack.imgur.com/AhT2F.jpg" rel="nofollow noreferrer">error</a>:</p>
  
  <p>data I am Passing in Payload schema:
  <a href="https://i.stack.imgur.com/5gsDo.jpg" rel="nofollow noreferrer">enter image description here</a></p>