Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

2 REPLIES 2

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.