topic Re: twebservice response error record capture in Data Quality

twebservice response error record capture

AAA999 — Sat, 16 Nov 2024 04:15:55 GMT

Gurus,

Is there a way to capture rejected response record from twebservice using wsdl file?

Below are some errors

INVALID_INPUT (Input record is not a valid VAT)

MS_UNAVAILABLE

I need to capture the rejected input records. Any help would be appreciated.

Thanks

Re: twebservice response error record capture

Anonymous — Mon, 28 Oct 2019 09:05:36 GMT

Hi
tWebservice does not capture rejected record, you can validate the input record before tWebservice if there exist rules.

Regards
Shong

Re: twebservice response error record capture

AAA999 — Mon, 28 Oct 2019 13:41:59 GMT

Hi Shong,

GM, The issue is not with the input record. The error occurs when the input record is validated against the EU webservice (example Member State 'BE' vat number xxxxxxxxx). Is there a way for the records that don't get validated be passed to the target table?

Thanks

Re: twebservice response error record capture

Anonymous — Wed, 30 Oct 2019 03:04:39 GMT

I think you can get the invalid input record by designing the jobs as beblow:
main job:
--read input data--tFlowToIterate--tRunJob
in the main job, pass the current input record to child job, see this documentation to learn how to pass values from parent job to child job.
https://help.talend.com/reader/1RJ7TatgS73nP1RPGjT50w/lkyIFfESkJEqjYRyJBOQfg

on tRunJob, call the child job and uncheck the 'die on error' option.

child job:
tFixedFlowInput1--main>tWebservcie-->
|
onsubjoberror
|
tFixedFlowInput2--main--target table

in child job, output the current input record to target table once an error occurs.

Regards
Shong