Five Stars PK
Five Stars

XML file read in talend

Hi All,

I am trying to read below xml file in talend, but looks like it does not support format.

 

<supSmiley FrustratedupplierSubscriptionEvent xmlns:sup="http://supplier.subscription.partyconnec.com" xmlns:com="http://common.subscription.partyconnect.ge.com" xmlnsSmiley Tonguear="http://party.subscription.partyconnect.ge.com"> <com:schemaVersion>1.0-rc14</com:schemaVersion> <com:messageId>1111-1111-1111</com:messageId> <com:transactionId>2222-2222-2222</com:transactionId> <com:subsciptionId>11111</com:subsciptionId> <com:eventType>CREATE</com:eventType> <com:updatedBySso>502456517</com:updatedBySso> <!--1 or more repetitions:--> <com:downstreamSystem> <com:tier1>Transportation</com:tier1> <com:tier2>Transportation</com:tier2> <com:tier3>United Kingdom</com:tier3> <com:erpInstance>GET</com:erpInstance> <comSmiley SurprisedrgId>2329</comSmiley SurprisedrgId> <comSmiley SurprisedrgName>GETSUK</comSmiley SurprisedrgName> </com:downstreamSystem> <sup:dataDelta id="S00001" action="CREATE"> <com:version>1</com:version> <com:active>true</com:active> <!-- need to add blocking reason code --> <com:inactiveReason></com:inactiveReason> <par:countryCode>US</par:countryCode> <par:legalName>GENERAL ELECTRIC COMPANY</par:legalName> <par:legalNameTranslated>bla-bla</par:legalNameTranslated> <par:alternativeName>GE</par:alternativeName> <par:registrationId>111/111/111</par:registrationId> <par:alternateIds> <!--Zero or more repetitions:--> <com:alternateId value="123456" type="GSL6" active="true"/> </par:alternateIds> <par:diversities apply="true"> <!--Zero or more repetitions:--> <par:diversity type="ALASKA_NATIVE_CORP" apply="false"/> <par:diversity type="BLACK_OWNED" apply="false"/> <par:diversity type="HISTORICALY_BLACK_CUMI" apply="false"/> <par:diversity type="HUB_ZONE_B" apply="false"/> <par:diversity type="LGBT_BE" apply="false"/> <par:diversity type="MINORITY_BE" apply="false"/> <par:diversity type="SERVICE_DISABLED_VETERAN_OWNED_SB" apply="false"/> <par:diversity type="DISADVANTAGED_SB" apply="false"/> <par:diversity type="WOMEN_OWNED_SB" apply="false"/> <par:diversity type="VETERAN_OWNED_SB" apply="false"/> </par:diversities> <!--Zero or more repetitions:--> <par:address id="S00001001" action="CREATE"> <com:version>1</com:version> <com:active>true</com:active> <com:inactiveReason></com:inactiveReason> <par:siteId>101</par:siteId> <par:addressType>ORDER_FULFILLMENT</par:addressType> <par:alternateName>Fairfield spot</par:alternateName> <par:location> <par:countryCode>US</par:countryCode> <par:stateCode>CT</par:stateCode> <par:stateName>CONNECTICUT</par:stateName> <parSmiley TonguerovinceName></parSmiley TonguerovinceName> <par:countyName></par:countyName> <par:cityName>FAIRFIELD</par:cityName> <parSmiley TongueostalCode>06828-0001</parSmiley TongueostalCode> <par:addressLine1>3135 EASTON TPKE</par:addressLine1> <par:addressLine2></par:addressLine2> <par:addressLine3></par:addressLine3> <par:addressLine4></par:addressLine4> <parSmiley TongueoBoxNumber></parSmiley TongueoBoxNumber> </par:location> <par:emailForPurchaseOrders>po@ge.com</par:emailForPurchaseOrders> <par:emailForRemittance>remittance@ge.com</par:emailForRemittance> <par:watchlistScreeningStatus>PASS</par:watchlistScreeningStatus> <par:alternateIds> <!--Zero or more repetitions:--> <com:alternateId value="123456-001" type="GSL9" active="true"/> </par:alternateIds> <!--Zero or more repetitions:--> <par:bankAccount id="BA-0000-0000-0000-0001" action="CREATE"> <com:version>1</com:version> <com:active>true</com:active> <parSmiley TongueartyAccountName>TATA America International Corporation</parSmiley TongueartyAccountName> <parSmiley TongueartyAccountNameTranslated>TATA America International Corporation</parSmiley TongueartyAccountNameTranslated> <parSmiley TongueartyBankInfo> <par:bankName>BNP PARIBAS IP BELGIUM SA</par:bankName> <par:bankNameTranslated>BNP PARIBAS IP BELGIUM SA</par:bankNameTranslated> <par:branchName></par:branchName> <par:branchNameTranslated></par:branchNameTranslated> <par:bankRoutingNumber>111111</par:bankRoutingNumber> <par:accountNumber>222222</par:accountNumber> <par:accountCurrencyCode>EUR</par:accountCurrencyCode> <par:iban>FIMGBEBB</par:iban> <par:swift>FIMGBEBBXXX</par:swift> <par:bankAddress> <par:countryCode>BL</par:countryCode> <par:stateCode></par:stateCode> <par:stateName></par:stateName> <parSmiley TonguerovinceName></parSmiley TonguerovinceName> <par:countyName></par:countyName> <par:cityName>BRUSSELS</par:cityName> <parSmiley TongueostalCode>1210</parSmiley TongueostalCode> <par:addressLine1>AVENUE DU PROGRES 55</par:addressLine1> <par:addressLine2></par:addressLine2> <par:addressLine3></par:addressLine3> <par:addressLine4></par:addressLine4> </par:bankAddress> <par:watchlistScreeningStatus>PASS</par:watchlistScreeningStatus> </parSmiley TongueartyBankInfo> <par:useIntermediaryBank>true</par:useIntermediaryBank> <par:intermediaryBankInfo> <!-- same structure as partyBankInfo --> </par:intermediaryBankInfo> <par:useFurtherCreditTo>true</par:useFurtherCreditTo> <par:furtherCreditTo> <par:bankName>NATIONAL BANK OF ANGUILLA LTD.</par:bankName> <par:accountNumber>999999</par:accountNumber> <par:beneficiaryName>Mr X</par:beneficiaryName> </par:furtherCreditTo> <parSmiley TonguerimaryFlag>true</parSmiley TonguerimaryFlag> </par:bankAccount> <par:bankAccount id="BA-0000-0000-0000-0002" action="CREATE"> <com:version>1</com:version> <com:active>true</com:active> <parSmiley TongueartyAccountName>TATA America International Corporation</parSmiley TongueartyAccountName> <parSmiley TongueartyAccountNameTranslated>TATA America International Corporation</parSmiley TongueartyAccountNameTranslated> <parSmiley TongueartyBankInfo> <par:bankName>BNP PARIBAS IP BELGIUM SA</par:bankName> <par:bankNameTranslated>BNP PARIBAS IP BELGIUM SA</par:bankNameTranslated> <par:branchName></par:branchName> <par:branchNameTranslated></par:branchNameTranslated> <par:bankRoutingNumber>111111</par:bankRoutingNumber> <par:accountNumber>222222</par:accountNumber> <par:accountCurrencyCode>EUR</par:accountCurrencyCode> <par:iban>FIMGBEBB</par:iban> <par:swift>FIMGBEBBXXX</par:swift> <par:bankAddress> <par:countryCode>BL</par:countryCode> <par:stateCode></par:stateCode> <par:stateName></par:stateName> <parSmiley TonguerovinceName></parSmiley TonguerovinceName> <par:cityName>BRUSSELS</par:cityName> <parSmiley TongueostalCode>1210</parSmiley TongueostalCode> <par:addressLine1>AVENUE DU PROGRES 55</par:addressLine1> <par:addressLine2></par:addressLine2> <par:addressLine3></par:addressLine3> <par:addressLine4></par:addressLine4> </par:bankAddress> <par:watchlistScreeningStatus>PASS</par:watchlistScreeningStatus> </parSmiley TongueartyBankInfo> <par:useIntermediaryBank>true</par:useIntermediaryBank> <par:intermediaryBankInfo> <!-- same structure as partyBankInfo --> </par:intermediaryBankInfo> <par:useFurtherCreditTo>true</par:useFurtherCreditTo> <par:furtherCreditTo> <par:bankName>NATIONAL BANK OF ANGUILLA LTD.</par:bankName> <par:accountNumber>999999</par:accountNumber> <par:beneficiaryName>Mr X</par:beneficiaryName> </par:furtherCreditTo> <parSmiley TonguerimaryFlag>false</parSmiley TonguerimaryFlag> </par:bankAccount> <!--Zero or more repetitions:--> <par:contact id="CO-0000-0000-0000-0001" action="CREATE"> <com:version>1</com:version> <com:active>true</com:active> <par:contactType>REMITTANCE</par:contactType> <par:firstName>Michael</par:firstName> <par:lastName>Yashin</par:lastName> <par:email>michael.yashin@ge.com</par:email> <par:businessPhoneCountryPrefix>1</par:businessPhoneCountryPrefix> <par:businessPhoneNumber>555-555-5555</par:businessPhoneNumber> <par:mobilePhoneCountryPrefix>1</par:mobilePhoneCountryPrefix> <par:mobilePhoneNumber>555-555-5555</par:mobilePhoneNumber> <parSmiley TonguereferredContact>BUSINESS_PHONE</parSmiley TonguereferredContact> <par:watchlistScreeningStatus>PASS</par:watchlistScreeningStatus> </par:contact> <par:contact id="CO-0000-0000-0000-0002" action="CREATE"> <com:version>1</com:version> <com:active>true</com:active> <par:contactType>SALES</par:contactType> <par:firstName>Anton</par:firstName> <par:lastName>Abramkin</par:lastName> <par:email>anton.abramkin@ge.com</par:email> <par:businessPhoneCountryPrefix>1</par:businessPhoneCountryPrefix> <par:businessPhoneNumber>555-555-5555</par:businessPhoneNumber> <par:mobilePhoneCountryPrefix>1</par:mobilePhoneCountryPrefix> <par:mobilePhoneNumber>555-555-5555</par:mobilePhoneNumber> <parSmiley TonguereferredContact>BUSINESS_PHONE</parSmiley TonguereferredContact> <par:watchlistScreeningStatus>PASS</par:watchlistScreeningStatus> </par:contact> </par:address> <sup:group id="GE" name="General Electric Corporation"/> <sup:commodityTier1>Utilities</sup:commodityTier1> <sup:commodityTier2>Electricity</sup:commodityTier2> <sup:commodityTier3>Electric utilities</sup:commodityTier3> <sup:supplierSpeciality>MANUFACTURER</sup:supplierSpeciality> <sup:legalTax> <sup:taxClassification>Non Profit Organizaiton</sup:taxClassification> <sup:taxIdentificationNumber>444-44-4444</sup:taxIdentificationNumber> <sup:exemptFromWithholdingTax>true</sup:exemptFromWithholdingTax> </sup:legalTax> <sup:crossBorderTaxes> <!--Zero or more repetitions:--> <sup:crossBorderTax> <sup:countryCode>IT</sup:countryCode> <supSmiley TonguerovidedProduct>Services</supSmiley TonguerovidedProduct> <sup:taxRegistrationNumber>3333/333/3333</sup:taxRegistrationNumber> <sup:exemptFromWithholdingTax>true</sup:exemptFromWithholdingTax> </sup:crossBorderTax> </sup:crossBorderTaxes> <sup:vats> <!--Zero or more repetitions:--> <sup:vat> <sup:countryCode>IT</sup:countryCode> <sup:taxAuthority>Imposta sul Valore Aggiunto</sup:taxAuthority> <sup:taxRegistrationNumber>aaa-bbb-ccc</sup:taxRegistrationNumber> </sup:vat> </sup:vats> <!-- OU/ERP/Subscription-custom level data: START --> <supSmiley TongueaymentTerm> <sup:name>2.5%-2%-1.5% Disc. 10-20-30 Days, Net 60</sup:name> <sup:description>2.5%, 2%, 1.5% Discount if paid by Day 10, 20, 30 respectively, else total amount due on Day 60</sup:description> <sup:type>Multi Tier</sup:type> <sup:discount1 percent="2.5" days="10"/> <sup:discount2 percent="2" days="20"/> <sup:discount3 percent="1.5" days="30"/> <sup:netDays>60</sup:netDays> <supSmiley TongueaymentFrequency></supSmiley TongueaymentFrequency> <sup:dueDayOfMonth></sup:dueDayOfMonth> <sup:dueMonthsForward></sup:dueMonthsForward> </supSmiley TongueaymentTerm> <sup:incoTerm>CFR</sup:incoTerm> <sup:settlementProcess>EPCARD</sup:settlementProcess> <sup:customPaymentProcesses> <sup:customPaymentProcess>Payment Request</sup:customPaymentProcess> </sup:customPaymentProcesses> <!-- OU/ERP/Subscription-custom level data: END --> <sup:aspFlag>true</sup:aspFlag> <sup:aspFunction>Environmental</sup:aspFunction> <sup:directFlag>true</sup:directFlag> </sup:dataDelta> <!-- Snapshot not required on supplier create event --> <!--<sup:dataSnapshot>--> <!--</sup:dataSnapshot>--> </supSmiley FrustratedupplierSubscriptionEvent>

Can anyone help me with this requirement.

 

Regards

PK

  • Data Integration
Tags (1)
4 REPLIES
Six Stars

Re: XML file read in talend

Hi,

Can you tell me whether you saved these data into file or you extracting it from url?

Tell us your complete workflow.

Five Stars PK
Five Stars

Re: XML file read in talend

Hi,

 

I got this data in filename.xml and my requirement is to read the data from xml file and load into postgresql.

 

I tried to read the xml file using metadata->file xml but getting an error like "xml is not in correct format".

 

Six Stars

Re: XML file read in talend

Hi Pk,

some data is missing from the file.

error1.PNG

you are missing the xmlns:com link which is related to the data presented in your file.

 

say for an example : 

please look at the image below

error2.PNG

you are missing the link for  "par: " element.

 

Hope this helps you!

Six Stars

Re: XML file read in talend