Power Platform Community Forum Thread Details

Hello,

I would like to get data from API and load it to SQL server by using data gateway. When I try to get table that I wanted I am facing this error:

Werte konnten nicht abgerufen werden. Fehler bei der Anforderung für dynamische Aufrufe: { "status": 400, "message": "Microsoft SQL: Invalid column name 'Created_Date_ID'.\r\n inner exception: Microsoft SQL: Invalid column name 'Created_Date_ID'.\r\nclientRequestId: 1df1ed4a-ab3d-457a-9bc4-ca186158e586", "error": { "message": "Microsoft SQL: Invalid column name 'Created_Date_ID'.\r\n inner exception: Microsoft SQL: Invalid column name 'Created_Date_ID'." }, "source": "sql-we.azconn-we-002.p.azurewebsites.net" }.

This is my flow. In the beginning of my flow, I can get the tables by using getting row module (So I understand that my data gateway is working). But I cannot insert data to that table because, insert row module does not work and I dont understand why. Can you help me to solve this problem?