I have an On-Prem SQL which I am accessing in my Logic App using On-Prem Data Gateway. I have created a table in my SQL database as per below: From a Logic App, I am trying to insert rows using “Insert row (V2)” action but it does not populate any tables: If I try any other SQL action in a
Tag: azure-logic-apps
Azure data upload and SQL database update failure for filename tracking
I have a scenario, in which I upload the file to Azure and will get the uploaded filename. Now I would need to store the filename (received for Azure upload) to SQL database. In case, if database down means it will fail to capture the filename (received for Azure upload) to SQL database but the File upload to…
Excel into Azure Data Factory into SQL
I read a few threads on this but noticed most are outdated, with excel becoming an integration in 2020. I have a few excel files stored in Drobox, I would like to automate the extraction of that data into azure data factory, perform some ETL functions with data coming from other sources, and finally push the …
Azure LogicApp cannot get rowid from SQL Server
I have an Azure logicapp that connects to a SQL Server database in Azure. The table has a uniqueidentifier column as the primary key. In the logic app the delete or update requires the rowid in order to perform update, the primary key does not work here and throws an error when running, stating that the table…