SOAP API: XML data, parse date

Kunal_Navale — Fri, 06 Jul 2018 23:37:12 GMT

i make a SOAP API (tSOAP) call, which returns SOAP XML data. When i import the SOAP XML data file, one of the attributes get imported with Date as Type. The data in this attribute is formatted as: "yyyy-MM-dd'T'HH:mm:ssXXX". The actual data comes in as: 2011-12-23T21:07:16-08:00.

My process is really simple, since i wanted to finalize the formatting:

tSOAP >> tXMLMap >> tLogRow

For tSOAP, i have checked the box: 'Output in Document'

For tXMLMap, i imported the XML schema from file (please refer attached image - schema_description.jpg)

For tLogRow, the dragged attribute (granted) is of type Date, and formatted as: "yyyy-MM-dd'T'HH:mm:ssXXX"

When i execute this process, i get below error:

Exception in component tXMLMap_1_TXMLMAP_OUT
java.lang.RuntimeException: Unparseable date: "2011-12-23T21:07:16-08:00"
   at routines.system.ParserUtils.parseTo_Date(ParserUtils.java:308)
   at idm.jb_acct_test_0_1.jb_acct_test$1TreeNode_API_tXMLMap_1_TXMLMAP_OUT.get_Date(jb_acct_test.java:644)
   at idm.jb_acct_test_0_1.jb_acct_test.tSOAP_1Process(jb_acct_test.java:861)
   at idm.jb_acct_test_0_1.jb_acct_test.runJobInTOS(jb_acct_test.java:1439)
   at idm.jb_acct_test_0_1.jb_acct_test.main(jb_acct_test.java:1273)
[FATAL]: idm.jb_acct_test_0_1.jb_acct_test - tXMLMap_1_TXMLMAP_OUT Unparseable date: "2011-12-23T21:07:16-08:00"

Can someone please review and advise as regards what needs to be corrected? Thank you!

Re: SOAP API: XML data, parse date

Jesperrekuh — Mon, 09 Jul 2018 06:51:56 GMT

in tXMLMap check this... (see attachment)

xmlmap.jpg

Re: SOAP API: XML data, parse date

Kunal_Navale — Wed, 11 Jul 2018 17:34:30 GMT

Spot on! I changed per your recommendation, and it worked! Thank you so much, Dijke!

Re: SOAP API: XML data, parse date

Jesperrekuh — Wed, 11 Jul 2018 19:22:55 GMT

Great! frustrating when you cant find what you're looking for ) and then ... yes ... glad to be of help.

topic Re: SOAP API: XML data, parse date in Talend Studio

SOAP API: XML data, parse date

Re: SOAP API: XML data, parse date

Re: SOAP API: XML data, parse date

Re: SOAP API: XML data, parse date