How to parse XML file in service mapping pattern

[NeenaP]

I have below xml file to parse with xml parsing operation in service mapping pattern. Can anyone help me to parse this?

<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
<section name="cachingConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Caching.Configuration.CacheManagerSettings, Microsoft.Practices.EnterpriseLibrary.Caching, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<section name="validatorModule" type="Tjoc.Web.Validator.ValidatorConfigHandler, Tjoc.Web.Validator" />
<section name="csrfSettings" type="Idunno.AntiCsrf.Configuration.CsrfSettings, Idunno.AntiCsrf" />
<sectionGroup name="Acidaes.Communication.Fax">
<section name="FaxProvider" type="System.Configuration.SingleTagSectionHandler" allowDefinition="MachineToApplication" restartOnExternalChanges="true" />
</sectionGroup>
<section name="spClientConfig" type="DotNetIceClient.Configuration.IceClientConfiguration" />
<sectionGroup name="jsEngineSwitcher">
<section name="core" type="JavaScriptEngineSwitcher.Core.Configuration.CoreConfiguration, JavaScriptEngineSwitcher.Core" />
<section name="msie" type="JavaScriptEngineSwitcher.Msie.Configuration.MsieConfiguration, JavaScriptEngineSwitcher.Msie" />
<section name="v8" type="JavaScriptEngineSwitcher.V8.Configuration.V8Configuration, JavaScriptEngineSwitcher.V8" />
</sectionGroup>
</configSections>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
</startup>
<csrfSettings cookieName="__CRMCSRFCOOKIE" formFieldName="__CRMCSRFTOKEN" detectionResult="RaiseException" errorPage="" />

<connectionStrings>
<add name="DeploymentConfigConnectionString" connectionString="Persist Security Info=False;Integrated Security=SSPI;data source=XX.XXX.XX;initial catalog=ABC_Live;packet size=4096;enlist=false" providerName="System.Data.SqlClient" />
<add name="ConnectionString" connectionString="data source=qwe.hbctx.com,1435;initial catalog=ABC_Live;Integrated Security=SSPI;persist security info=True;packet size=4096;enlist=false;application name = AAfc " providerName="System.Data.SqlClient" />

<add name="AdminConnectionString" connectionString="data source=rmtdb.hbctx.com,1435;initial catalog=ABC_Live;persist security info=True;packet size=4096;enlist=false" providerName="System.Data.SqlClient" />

</connectionStrings>

Regards,

Nick

[Community Alums]

Hi @NeenaP ,

You can refer to this thread: https://www.servicenow.com/community/itom-forum/discovery-pattern-to-parse-xml-with-attributes/td-p/...

[NeenaP]

Hi Sandeep,

Thank you for replying. I already gone through it however it doesnot help as this xml has multiple sections and I am not aware how to do this. 

I want to extract "data source=XX.XXX.XX;" value fron connectionstring section.