it seems the component tWriteJSONField doesn't respect the data types of incoming columns and just writes all values in Strings.
My expectation is, that numeric values are not enclosed in quotes in the output of the component.
This causes me big trouble in a use-case, where I have to transform an Excel file with several columns to a JSON String, since the numeric values are all quoted and thus the application parsing the file fails...
I'm working with TOS 220.127.116.1160704_1411.
Are there any known workarounds?
According to the documentation: https://help.talend.com/search/all?query=tWriteJSONField
...the default type of all elements is String. If you want an element to be numeric, you need to add an attribute named "type" and give it the static value of the type you want.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema