Support Questions

Find answers, ask questions, and share your expertise

ConvertJSONToSQL - Ignores underscore in update keys

avatar
Contributor

Eg: Update table table_name emp_name=? where empid=?

 

But My column name is emp_id

2020-03-23 14_07_19-NiFi Flow.png

1 ACCEPTED SOLUTION

avatar
Contributor

Finally fixed the issue by myself. have changed all the columns to Uppercase and made the Translate Field Names to false.. That works for me.

View solution in original post

3 REPLIES 3

avatar
Contributor

Anybody has answer for this- I get this issue on PutDatabaseRecord as well. When I check java code of PutDatabaseRecord. I could see below  replace with - underscore.

 

MPraveen_0-1586150104815.png

 

avatar
Contributor

Finally fixed the issue by myself. have changed all the columns to Uppercase and made the Translate Field Names to false.. That works for me.

avatar
New Contributor

I set the Translate Field Names to false, it started working, before this it was converting the primary key field to upper case, removing the underscore, so when I run the putSQL, it was throwing error, working fine now, thanks to your answer!