Support Questions

Find answers, ask questions, and share your expertise

ConvertJSONToSQL - Ignores underscore in update keys

Explorer

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

Explorer

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

Explorer

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

 

Explorer

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.