I am using a tHMap to create a JSON object for a webservice. The webservice requires the following date format:
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:
Hence, my question: How can the date format of the tHMap JSON output be changed or customized?
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.
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables