Reject handling in web service transformer stage

srai · Post by **srai** » Mon Mar 09, 2009 3:53 am

Hi All,

Does anybody has any idea how to handle reject rows in WSTransformer stage.

My job is something like this-

SQLserver database will be source to WStransformer stage and based on the input it will call WSDL operation and WSDL will update Salesforce.com internally.
Lets suppose there are 10 rows coming from source and out of which 6 are able to call WSDL and update SF.com successfully. Now there are 4 failed update. I need to store these 4 records in the Sequential file.

Could anybody help in cofiguring Reject handling in Ws Transformer stage?

Thanks in advance.

Thanks.

eostic · Post by **eostic** » Mon Mar 09, 2009 6:18 am

The failure code (assuming that the call to sf.com worked) should be in the response body......parse out the body in a downstream transformer, and then send your logical rejects to an appropriate location.

Ernie

s_boyapati · Post by **s_boyapati** » Mon Mar 09, 2009 7:42 am

It is advisable to generate sequence number and use in naming convensions for file name in "appropriate location". Also extract return code from mesage body for further filtering and error handling purposes, if you have that requirement.

srai · Post by **srai** » Tue Mar 10, 2009 2:40 am

eostic wrote:The failure code (assuming that the call to sf.com worked) should be in the response body......parse out the body in a downstream transformer, and then send your logical rejects to an appropriate location.

Ernie

Thanks a lot Erine.

One doubt about parsing. Do we need to use XML input stage only to parse the SOAP message to tabular form. I am getting some error with XML input stage. Is there any workaround of this available in DataStage.

Thanks
Santosh

ray.wurlod · Post by **ray.wurlod** » Tue Mar 10, 2009 3:45 pm

"Some error"?!!! Get serious. We charge a lot extra to read your mind.

WHAT error?