can't figure out txmlmap date format "2020-04-12T23:00:00Z"
I'm really struggling with this date format for some reason, even though it looks simple. I'm calling a rest service which is giving me back an xml document, and I'm splitting it into columns with a txmlmap. I've tried a hundred permutations of date formats, but I just can't seem to receive these dates successfully. Anybody know what the format should be?
<start_time>2020-04-12T23:00:00Z</start_time>
Exception in component tXMLMap_1_TXMLMAP_OUT (ListMeetings) java.lang.RuntimeException: Unparseable date: "2020-04-12T23:00:00Z"
Thank you but nevermind, I figured it out. Using txmlmap instead of tmap it's necessary to edit the schema on the left side in the "Tree Schema Editor".. so I had the right format, but in the wrong place. "dd-MM-yyyy'T'HH:mm:ss'Z'" was right all along. I thought I was going crazy!!
Same runtime error, but thank you. In the formats dropdown, Talend provides this one "yyyy-MM-dd'T'HH:mm:ss'000Z'" which I've been using as the basis for my attempts, but I can't seem to get it. I think I do need HH instead of hh due to 24 hour format.
Thank you but nevermind, I figured it out. Using txmlmap instead of tmap it's necessary to edit the schema on the left side in the "Tree Schema Editor".. so I had the right format, but in the wrong place. "dd-MM-yyyy'T'HH:mm:ss'Z'" was right all along. I thought I was going crazy!!
