<?xml version="1.0"?> <CallValidate><CreditApplicationID>1258412</CreditApplicationID><BankEnhanced><RawResponse><![CDATA[<?xml version="1.0" encoding="UTF-8"?> <Results xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="C:/Users/hughc/PhpstormProjects/callvalidate/mantis-setup/Schema/5.7.0/Customer-Output-V5-7-0.xsd" APIVERSION="5.7.0 - 20150811"> <Result RID="" PID="LTJ-OLS3-2479-15147-95584-1603" DateTime="01-01-2018 08:33"> <Displays> <ChecksCompleted> <BankStandard>yes</BankStandard> <BankEnhanced>yes</BankEnhanced> <CardLive>no</CardLive> <CardEnhanced>no</CardEnhanced> <IDEnhanced>yes</IDEnhanced> <NCOAAlert>no</NCOAAlert> <CallValidate3D>no</CallValidate3D> <TheAffordabilityReport>no</TheAffordabilityReport> <DeliveryFraud>no</DeliveryFraud> <CreditScore>no</CreditScore> <Zodiac>no</Zodiac> <BankAccountPlus>no</BankAccountPlus> <BankOFA>no</BankOFA> <CardOFA>no</CardOFA> <RealTimeFraudAlerts>no</RealTimeFraudAlerts> <DeviceRisk>no</DeviceRisk> <MobileRisk>no</MobileRisk> </ChecksCompleted> <InputData> <Individual> <Dateofbirth>26/04/1977</Dateofbirth> <Title>Mrs</Title> <Firstname>xyz</Firstname> <Surname>abcr</Surname> <Emailaddress>abcxyz@gmail.com</Emailaddress> <IPAddress>2.111.222.77</IPAddress> </Individual> <Address> <Abodenumber>6</Abodenumber> <Buildingname>all </Buildingname> <Address1>NY</Address1> <Town>Westyorkshire</Town> <Postcode>LS123AJ</Postcode> </Address> </InputData> <BankcheckStandard> <Date_of_last_change>18/07/2017</Date_of_last_change> <BACS_Status>M</BACS_Status> <BACS_Settlement_Bank>0004</BACS_Settlement_Bank> <Settlement_section>02</Settlement_section> <Settlement_Subsection>14</Settlement_Subsection> <Handling_Bank>0004</Handling_Bank> <Account_numbered_flag>Y</Account_numbered_flag> <DDI_voucher_flag>N</DDI_voucher_flag> <CHAPS_Effective_date_of_last_change>09/07/2001</CHAPS_Effective_date_of_last_change> <CCCC_Settlement_bank>4</CCCC_Settlement_bank> <Debit_agency_sort_code>000004</Debit_agency_sort_code> <GB_Northern_Ireland_Indicator>GB</GB_Northern_Ireland_Indicator> <Branch_type_indicator>M</Branch_type_indicator> <Major_Location_Name>NY, KY</Major_Location_Name> <Branch_Name_or_Place>NY, KY</Branch_Name_or_Place> <Full_Branch_title_part_1>NY, KY(771408)</Full_Branch_title_part_1> <Address_line_1>PO Box 1000</Address_line_1> <Address_County>Essex</Address_County> <Post_Code_major_part>BX1</Post_Code_major_part> <Post_Code_minor_part>1LT</Post_Code_minor_part> <Telephone_1_area>0345</Telephone_1_area> <Telephone_1_number>3000000</Telephone_1_number> <Supervisory_Body>A</Supervisory_Body> <Bank_Code_of_owning_bank>0004</Bank_Code_of_owning_bank> <Full_name_of_owning_bank_line_1>LLOYDS BANK PLC</Full_name_of_owning_bank_line_1> <Short_name_of_owning_bank>LLOYDS BANK PLC</Short_name_of_owning_bank> <Short_Branch_title>LEEDS ARMLEY (771408)</Short_Branch_title> <Sub_Branch_suffix>00</Sub_Branch_suffix> <BIC_branch>N60</BIC_branch> <BIC_bank>LOYDGB21</BIC_bank> <sortcode>123654</sortcode> <CCCC_Effective_date_of_last_change>18/07/2017</CCCC_Effective_date_of_last_change> <CCCC_Status>M</CCCC_Status> <Date_closed_in_CHAPS_Euro_clearing>23/09/2008</Date_closed_in_CHAPS_Euro_clearing> <CHAPSE_Status>N</CHAPSE_Status> <CHAPS_routing_BIC_branch>XXX</CHAPS_routing_BIC_branch> <CHAPS_routing_BIC_bank>LOYDGB2L</CHAPS_routing_BIC_bank> <CHAPS_settlement_member>004</CHAPS_settlement_member> <CHAPS_Status>I</CHAPS_Status> <BACS_Date_of_last_change>06/06/2005</BACS_Date_of_last_change> <FPS_Status>M</FPS_Status> <FPS_DateLastChanged>23/02/2008</FPS_DateLastChanged> <FPS_SettlementBankConnection>01</FPS_SettlementBankConnection> <FPS_SettlementBankCode>0004</FPS_SettlementBankCode> <FPS_HandlingBankConnection>01</FPS_HandlingBankConnection> <FPS_HandlingBankCode>0004</FPS_HandlingBankCode> <FPS_AccountNumbersFlag>Y</FPS_AccountNumbersFlag> </BankcheckStandard> <BankcheckEnhanced> <Result>Pass</Result> <Score>75</Score> <AccountIssuer>LLOYDS BANK PLC</AccountIssuer> <OtherAccountsFoundForIssuer>no</OtherAccountsFoundForIssuer> <AccountStartDate>2014-08-01</AccountStartDate> </BankcheckEnhanced> <IdentityCheck> <addresspicklistfound>false</addresspicklistfound> <appverified>Yes</appverified> <cifas/> <confirmatorydobs>7</confirmatorydobs> <currentaddressmatched>4, LEYWELL TERRACE, LEEDS, LS12 3AJ</currentaddressmatched> <dvlawarning>false</dvlawarning> <ervalid>1</ervalid> <grodeceased>false</grodeceased> <halomatch>false</halomatch> <IDBasic/> <levelofconfidencebai>0</levelofconfidencebai> <levelofconfidenceccjs>0</levelofconfidenceccjs> <levelofconfidencedob>3</levelofconfidencedob> <levelofconfidenceer>5</levelofconfidenceer> <levelofconfidenceinvestors>0</levelofconfidenceinvestors> <levelofconfidenceshare>5</levelofconfidenceshare> <lorwarning>false</lorwarning> <matchlevel>IndividualReport</matchlevel> <namematched>MRS SRAIA AFSAR</namematched> <namepicklistfound>false</namepicklistfound> <numaddresslinks>0</numaddresslinks> <numbais>0</numbais> <numccjs>0</numccjs> <numcorroborativechecks>6</numcorroborativechecks> <numcorroborativeotheridsconfirmed>0</numcorroborativeotheridsconfirmed> <numinvestors>0</numinvestors> <numprimarychecks>8</numprimarychecks> <numprimaryotheridsconfirmed>0</numprimaryotheridsconfirmed> <numsharerecords>12</numsharerecords> <pafvalid>true</pafvalid> <passportwarning>false</passportwarning> <readmatch>false</readmatch> <sharelorwarning>true</sharelorwarning> <totaldobs>7</totaldobs> </IdentityCheck> <AgeVerify> <Age>40</Age> <DateOfBirth>1977-04-26</DateOfBirth> <Over18>yes</Over18> </AgeVerify> <OtherChecks> <IdentityResult>Pass</IdentityResult> <IdentityScore>0</IdentityScore> </OtherChecks> <DeviceRisk/> <Phone> <MobileRisk> <Standard/> <Live/> <Score/> </MobileRisk> </Phone> <Warnings> <NonGBRCardWarning>false</NonGBRCardWarning> <NamePicklistWarning>false</NamePicklistWarning> <AddressPicklistWarning>false</AddressPicklistWarning> <PAFNonValidWarning>false</PAFNonValidWarning> <CardAccountClosedWarning>false</CardAccountClosedWarning> <BankAccountClosedWarning>false</BankAccountClosedWarning> </Warnings> </Displays> </Result> <Errors/> </Results>]]></RawResponse></BankEnhanced></CallValidate>
I have to extract data using etl tool informatica but it doesnt read the xml tags but read the inner tags as data and store in database tables.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)