topic Re: tHMap date format for JSON in Talend Studio

tHMap date format for JSON

Tobi1 — Tue, 29 May 2018 14:19:15 GMT

Hello everyone,

I am using a tHMap to create a JSON object for a webservice. The webservice requires the following date format:

yyyy-MM-dd'T'HH:mm:ss'Z'

I cannot find this specific date format in the Date Formats of the structure. I neither could find a way to define a custom date format. Thus, I am using "Default" as date format at the moment and defined the desired format in the Talend Data Integration schema, which is used as the input for the tHMap. As a result I get the following date format:

yyyy-MM-dd'T'HH:mm:ss.SSS

Hence, my question: How can the date format of the tHMap JSON output be changed or customized?

Regards,

Tobi

Re: tHMap date format for JSON

vboppudi — Tue, 29 May 2018 15:01:50 GMT

in tMap you can try this

Regards,

Re: tHMap date format for JSON

Tobi1 — Tue, 29 May 2018 15:14:03 GMT

Hi vboppudi,

thank you for your input. I know how to do it in a tMap, this would be my workaround: Transforming the dates to a string and passing it to the tHMap as string. But from my point of view this is only a workaround and not an ideal solution, as I always have to do a null-safe explicit transformation instead of passing the values through.

Regards.

Re: tHMap date format for JSON

Anonymous — Tue, 07 May 2019 13:23:38 GMT

Were you able to resolve this? Can you help me?

Re: tHMap date format for JSON

Tobi1 — Tue, 07 May 2019 13:40:33 GMT

Hi varmav2,

we followed the suggested way in a tMap. Not the solution we wished for, but we are doing fine with it. We wrote a custom routine "getDateTimeString" and "getDateString", which returns the date null-safe in the desired string format. I suppose there is no better solution to this. Definitely not in the tHMap, we only use it for 1:1 document transformation (Talend > JSON, JSON > Talend, XML > Talend, etc.) without any field operations.

Hope this helps.

Regards

Tobias