Insert and patch Azure SQL

[Anonymous]

Hi, I'm trying to update an existing record and also trying to insert a new record in Azure SQL DB but I'm getting "The specific record was not found: Resource not found". I'm using patch formula as I use it to update the records in the SharePoint online. I don't see PatchRow UpdateRow etc syntax working, it's only recognizing Patch(). Also it does recognize the columns that should not be null and display the message that this column cannot be null, that tells me the Patch should work. 

I can read and display the Azure SQL DB records just fine.

For Insert I'm using

Patch(products, Defaults(products),{product_id:11, product_sku:"Insert function test"})

For Update existing record I'm using

Patch(products, Defaults(products),{product_id:11, product_sku:"Update function test"})

where products is my Azure SQL and when I set that to Gallery I can see all items in that table.

Thanks,

-Sal

[Anonymous · Accepted solution]

I just had to remove and re-add the connection, now it's working fine with the same Patch() function to insert new rows and update existing ones.