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.
Reject handling in web service transformer stage
Moderators: chulett, rschirm, roy
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
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Premium Member
- Posts: 70
- Joined: Thu Aug 14, 2003 6:24 am
- Contact:
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.
Sree Boyapati
Sr. ETL Architect
Certified Developer in DataStage, QualityStage, Information Analyzer.
Sr. ETL Architect
Certified Developer in DataStage, QualityStage, Information Analyzer.
Thanks a lot Erine.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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: