Answered

SQL Server GetRows changes the value of the key field from MyId to "ItemInternalID" -help?

Like (0) Share

Report

Posted on 24 Aug 2017 22:15:33 by fastlanebi

SQL Server GetRows changes the value of the key field from MyId to "ItemInternalID" - so what was say a key field called MyId in SQL Server, it is now gone when Flow sees the Fields via the On Premises Data Gateway and replaced with another field called "ItemInternalID" which is some random characters.

Can I just apply a function to convert the random characters back to an integer? Without these Key fields I can't relate one table to another to look up values. I'm thinking it's that SQL Server uses a binary storage for Keys, so the gateway converts to something more suitable for JSON? How can I get back to the value of the key?.

Thanks DT

All responses (2)

Answers (2)

Verified answer

fastlanebi 30 on 28 Aug 2017 at 20:27:21

Like (0)

Report

Re: SQL Server GetRows changes the value of the key field from MyId to "ItemInternalID" -h

The problem was a blank data type definition for the field:

You are correct Leo, Flow connector for SQL Server can't cope with that right now so can't be done.
I've also reported it as a bug but really it's a feature enhancement request to have the connector somehow cope with blank types. The database is one inside of a standard micrososft product and practice is across all tables - so not a solution to doctor all tables. For now - Flow can't cope.
Verified answer

Leo09 212 on 28 Aug 2017 at 09:42:21

Like (0)

Report

Re: SQL Server GetRows changes the value of the key field from MyId to "ItemInternalID" -h

I think this cannot be done so far.