Skip to main content
MPraveen
MPraveen
Gold ⭐️
March 23, 2020
Solved

ConvertJSONToSQL - Ignores underscore in update keys

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

    MPraveen
    MPraveenAnswer
    Gold ⭐️
    April 6, 2020

    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 in thread

    3 replies

    MPraveen
    MPraveenAuthor
    Gold ⭐️
    April 6, 2020

    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

     

    Translate
    MPraveen
    MPraveenAuthorAnswer
    Gold ⭐️
    April 6, 2020

    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.

    Translate
      SS_Jin
      Silver ⭐️⭐️⭐️
      October 10, 2024

      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!

      Translate
        Terms & ConditionsAccessibility statement