Simple transformation to load CSV into CMDBOutput matching on CI Name for field Room, the following garbage is loaded:

Room = ‘[B@4a2d41f8’
Name = ‘[B@44eaa715’

This behaviour is related to the "Lazy conversion" option in the "CSV Input" Step on the Spoon transformation. Uncheck this option.



This is behaving exactly as designed - although admittedly the error and user experience could be improved.
Lazy conversion must not be used when you need to access the field value in your transformation. That's exactly what it does. The default should probably be off rather than on.

If the field is going directly to a database, then use it and it will be faster.

One can even have "partially lazy" streams, where one uses lazy conversion for speed, but then use Select Values step, to "un-lazify" the fields you want to access, whilst the remainder remain lazy.

Note: "Text Input" step can be used instead