CODEWITHSUNDEEP
sqlsql-serverazure-logic-appsdata-gateway
user13747070
user13747070

Reputation:

Why SQL (On-Prem using Data Gateway) Insert row (V2) action in Logic App does not populate tables?

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:

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Temp_Emp_CC](
    [Timestamp] [timestamp] NOT NULL,
    [EmployeeCode] [int] IDENTITY(1,1) NOT NULL,
    [CostCentreCode] [varchar](50) NOT NULL,
 CONSTRAINT [PK_Temp_Emp_CC] PRIMARY KEY CLUSTERED 
(
    [EmployeeCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Data Filegroup 1]
) ON [Data Filegroup 1]
GO

From a Logic App, I am trying to insert rows using "Insert row (V2)" action but it does not populate any tables:

enter image description here

If I try any other SQL action in a Logic App, for example, "Get rows (V2)" or "Execute a stored procedure (V2)" they work fine for the same connection/database server/database. So, my assumption is I'm doing right things with creating a connection!

From some forum I have learnt that a table needs to have an Identity Column and a Timestamp column, which I have added already; however issue still persist.

enter image description here

Upvotes: 0

Views: 614

Answers (1)

user13747070
user13747070

Reputation:

I think I have figured this out. Although there is still a question but a separate one.

The SQL database I was trying to access has so many tables - at least 100+ of them. I didn't want to write to all of them but only a few. So, I have restricted my SQL account's access to those specific tables only, and they populated fine in my Logic App.

The existing question is, does Logic App/APIConnection/On-Prem Data Gateway have any limit on accessing the tables?

Anyway, the main issue is resolved so I will close this one now. Thanks all your helps. :-)

Upvotes: 1

Related Questions