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!
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