topic Re: tWriteJSONField does not allow header names with special characters in Talend Studio

tWriteJSONField does not allow header names with special characters

Edith1 — Fri, 14 May 2021 22:46:32 GMT

The schema used to POST data by calling a rest API has required header names that contain special characters like asterisk * and question symbol ?. I would like to use the tWriteJSONField to create the schema for the trestclient input. However, tWriteJSONField does not allow names with special characters. Any idea, how would I pass the header columns with * or ? to the input of the rest call?

Re: tWriteJSONField does not allow header names with special characters

Anonymous — Sat, 15 May 2021 03:35:26 GMT

Talend studio is Java code generator, the column name will be translated to a Java variable, so the column name is not allowed to contain special characters.

Regards

Shong

Re: tWriteJSONField does not allow header names with special characters

gjeremy1617088143 — Wed, 19 May 2021 16:19:05 GMT

HI I try to bypassed it via unicode ex \u022A for * tWriteJsonField allow it in the element name but after it throw exception from the dom4j.QName.validateName() class :

java.lang.IllegalArgumentException: Illegal character in name: 'gghh*'.

at org.dom4j.QName.validateName(QName.java:340)

Re: tWriteJSONField does not allow header names with special characters

gjeremy1617088143 — Wed, 19 May 2021 16:30:53 GMT

So I think the better way is to write the json with non special char and then add them to the string with some replaceAll().