SOAP API: XML data, parse date

Five Stars

SOAP API: XML data, parse date

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!

Kunal Navale

Accepted Solutions
Ten Stars

Re: SOAP API: XML data, parse date

in tXMLMap check this... (see attachment)


All Replies
Ten Stars

Re: SOAP API: XML data, parse date

in tXMLMap check this... (see attachment)

Five Stars

Re: SOAP API: XML data, parse date

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

Kunal Navale
Ten Stars

Re: SOAP API: XML data, parse date

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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download