Get XML Data won’t parse XML object – Pentaho

I had an issue with Pentaho today. It wasn’t able to simply parse this XML that I was fetching from Amazon Marketplace Webservice.

Here’s the data I got :

<SubmitFeedResponse xmlns="http://mws.amazonaws.com/doc/2009-01-01/">
<SubmitFeedResult>
<FeedSubmissionInfo>
<FeedSubmissionId>MY_FEED_ID</FeedSubmissionId>
<FeedType>_POST_INVENTORY_AVAILABILITY_DATA_</FeedType>
<SubmittedDate>2016-08-01T19:28:30+00:00</SubmittedDate>
<FeedProcessingStatus>_SUBMITTED_</FeedProcessingStatus>
</FeedSubmissionInfo>
</SubmitFeedResult>
<ResponseMetadata>
<RequestId>MY_REQUEST_ID</RequestId>
</ResponseMetadata>
</SubmitFeedResponse>

The step “Get XML Data” couldn’t parse it because of the xmlns attribute tag. So I had to add a step “Replace in string” that would delete this attribute.

Screenshot from 2016-08-01 17:18:56

Write a new task using Capistrano
FieldHelper cannot be cast to java.lang.String pentaho

Leave a Reply

Your email address will not be published / Required fields are marked *