title: Azure LogicApp cannot get rowid from SQL Server
body: <p>I have an Azure logicapp that connects to a SQL Server database in Azure. The table has a <code>uniqueidentifier</code> column as the primary key. In the logic app the delete or update requires the <code>rowid</code> in order to perform update, the primary key does not work here and throws an error when running, stating that the table does not have a primary key. It does, and is additionally confirmed when inserting a row twice in the logicapp it knows about the primary key's constraint, being unique. </p>
  
  <p>If I <code>Get Rows</code> and filter by the primary key column, the resulting array lists each item found (the one obviously) but does not make available the rowid as a dynamic expression. </p>
  
  <p>How is one to actually get the rowid? Is it possible to update a row using just the primary key?</p>
  
  <p>UPDATE:</p>
  
  <p>The <code>uuid</code> is generated outside of the logicapp and is passed to it as a string.
  It should be noted that inserting works just fine.</p>
  
  <p>Here the logicapp requires a rowid specifier, but using the <code>uuid</code> fails. I thought I could then instead get all rows filtered by uuid and update them, as a work around, but I could not get the <code>rowid</code>. Another person had a similar issue (<a href="https://stackoverflow.com/a/43516709/1298523">https://stackoverflow.com/a/43516709/1298523</a>) and could not get the <code>rowid</code> without editing the source code; however this method of adding the rowid in the body section of the code no longer seems to work as the result is empty.
  <a href="https://i.stack.imgur.com/S49W0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/S49W0.png" alt="enter image description here"></a>
  The logicapp error I receive during an <code>update</code> or <code>delete</code> when using the uuid is:</p>
  
  <p><code>{
    "status": 400,
    "message": "Execution Failure\r\n     inner exception: The specified table has no primary key. Update and delete operations are not supported.\r\nclientRequestId: 555",
    "source": "sql-555.p.azurewebsites.net"
  }</code></p>
  
  <p>With that said the <code>insert</code> goes fine and the <code>uuid</code> I pass get's placed into the table.</p>
  
  <p>Insert result:
  <a href="https://i.stack.imgur.com/TTsBC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TTsBC.png" alt="enter image description here"></a></p>