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
1 ACCEPTED SOLUTION

Accepted Solutions
Nine Stars

Re: SOAP API: XML data, parse date

in tXMLMap check this... (see attachment)

3 REPLIES
Nine 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
Nine 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.