{"id":770,"date":"2016-09-07T16:01:07","date_gmt":"2016-09-07T16:01:07","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=770"},"modified":"2025-10-30T23:14:27","modified_gmt":"2025-10-30T23:14:27","slug":"ssis-extract-single-xml-node-using-xpath-soap-response","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/","title":{"rendered":"SSIS – Extract single XML node using XPath from SOAP response"},"content":{"rendered":"

Introduction<\/h2>\n

In this post, you will learn how to extract a single XML node value from your XML web response (SOAP Web service call) using an XPath expression in the SSIS REST API Web Service Task<\/span><\/em><\/a>\u00a0and the\u00a0XML Parser Task<\/a>.<\/span><\/p>\n

This article assumes you have basic knowledge of how to call a REST API or a SOAP Web service in SSIS. If you are not familiar with that, then refer to the following articles.<\/p>\n

Calling SOAP Web Service in SSIS (XML Source)<\/a><\/p>\n

Call REST API using SSIS Web Service Task \/ JSON \/ XML Source<\/a><\/p>\n

Calling REST \/ SOAP Web service using the SSIS REST API Task<\/h2>\n

Refer to the following video on how to call a REST API web service.<\/p>\n

\"\"<\/a>

Calling REST API in SSIS using REST API Task, Pass headers, Body, Url Parameters<\/p><\/div>\n

Extract the REST API Response into a file<\/h2>\n

Here is how you can save the response into a variable or a file. Go to the Response settings tab and select the check Response content option, as shown below. You can also Filter Response content (e.g., Extract only a single value from a node).<\/p>\n

\"\"<\/a>

SSIS Rest API Task – Extract data from a single XML node using XPath expression (Namespace used)<\/p><\/div>\n

Extract a single XML Node using XPath (XML with Namespace)<\/h2>\n

To extract a single value from the Response XML, you can define an XPath expression on the REST API Response tab as follows. If your response XML document contains namespaces (e.g., the node looks like this: <ns1:Body xmlns:ns1=”http:\/\/abc.com”><ns1:Data>abcdefg<\/ns1:Data><\/ns1:Body>), then you have to write XPath in a particular way, as shown below. Notice we have not specified the Namespace prefix ns1<\/p>\n

Sample XML Document (Or web response from SOAP Service)<\/strong><\/p>\n

<ns1:Body xmlns:ns1=\"http:\/\/abc.com\">\r\n\t<ns1:Data>abcdefg<\/ns1:Data>\r\n<\/ns1:Body><\/pre>\n
XPath Expression Example:<\/strong><\/p>\n
\/\/*[local-name()='Data']<\/pre>\n
XPath Output:<\/strong><\/p>\n
The above expression will produce the following result<\/p>\n
abcdefg<\/pre>\n
Extract Attribute Value using XPath local-name() function<\/h2>\n
Now, let’s find out how to extract the attribute value rather than the element.<\/p>\n
Consider the following XML. Let’s say we want to extract the id from the data node. In such a case, the previous XPath expression won’t work, so we need to use a slightly different XPath.<\/p>\n
<ns1:Body xmlns:ns1=\"http:\/\/abc.com\">\r\n\t<ns1:Data id=\"12345\">abcdefg<\/ns1:Data>\r\n<\/ns1:Body><\/pre>\n
Let’s use the XML Parser Task<\/a> to test XPath.<\/p>\n
Expression 1 – Get value by direct attribute name<\/h3>\n
Write the following expression as below and click Test<\/p>\n
\/\/@*[local-name()='id']<\/pre>\n
\"\"<\/a>
Extract XML Attribute Value using XPath expression (Use local-name function)<\/p><\/div>\n
Expression 2 – Get specific element attribute value<\/h3>\n
If you want to be specific and read the value of the `id` attribute from a particular `data` element, you can use an expression like this:<\/p>\n
\/\/*[local-name()='Data']\/@*[local-name()='id']<\/pre>\n
\"\"<\/a>
Extract XML Attribute Value using XPath expression 2<\/p><\/div>\n
Configure the SSIS Rest API Task to filter XML Response using XPath<\/h2>\n
The screenshot below shows how to filter XML data using an XPath expression. You can save extracted data to an SSIS Variable or save it to a file.<\/p>\n
\"\"<\/a>
SSIS Rest API Task – Extract data from a single XML node using XPath expression (Namespace used)<\/p><\/div>\n
More Examples of XPath expressions<\/h2>\n
XPath expression examples:\r\n============================\r\n\r\nExample1: Extract value of any element by node name (without namespace specified) \r\n\r\n<ns1:AuthInfo><ns1:Token>aaaaa<\/ns1:Token><\/ns1:AuthInfo>\r\n\r\nXPath Expression:  \/\/*[local-name() = 'Token']\r\nReturns: aaaaa\r\n----------------------------\r\nExample2: Extract text of element called Token \r\n\r\n<AuthInfo><Token>aaaaa<\/Token><\/AuthInfo>\r\n\r\nXPath Expression:  .\/AuthInfo\/Token\/text()\r\nReturns: aaaaa\r\n----------------------------\r\nExample3: Extract value of attribute called Version \r\n\r\n<Doc><Row Version=\"1\" \/><\/Doc>\r\n\r\nXPath Expression:  .\/Doc\/Row\/@Version\r\nReturns: 1\r\n----------------------------\r\nExample4: Extract value of following-sibling node or use preceding-sibling \r\n\r\n<Response>\r\n\t<Prop>\r\n\t\t<PropName>User<\/PropName>\r\n\t\t<PropVal>admin<\/PropVal>\r\n\t<\/Prop>\r\n\t<Prop>\r\n\t\t<PropName>SessionId<\/PropName>\r\n\t\t<PropVal>s_123456<\/PropVal>\r\n\t<\/Prop>\r\n<\/Response>\r\n\r\nExpression:  \/\/*[local-name()='PropName' and text()='SessionID']\/following-sibling::node()[local-name()='PropValue']\r\nReturns: s_123456\r\n----------------------------\r\nExample5: Extract node value with matching attribute \r\n\r\n<Response><Prop Name=\"SessionId\">s_1234<\/Prop><\/Response>\r\n\r\nXPath Expression:  \/\/*[local-name()='Prop' and @Name='SessionId']\r\nReturns: s_1234\r\n----------------------------\r\nExample6: Extract attribute value by name (without namespace specified) \r\n\r\ns_1234\r\n\r\nXPath Expression:  \/\/@*[local-name()='token']\r\nReturns: 123456\r\n----------------------------\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
Introduction In this post, you will learn how to extract a single XML node value from your XML web response (SOAP Web service call) using an XPath expression in the SSIS REST API Web Service Task\u00a0and the\u00a0XML Parser Task. This article assumes you have basic knowledge of how to call a REST API or a […]<\/p>\n","protected":false},"author":1,"featured_media":11523,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[3,67,12,4,144,140,7,143],"yoast_head":"\r\nSSIS - Extract single XML node using XPath from SOAP response | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to extract single XML node using XPath expression. Use SSIS REST Api Web service task to consume SOAP Web service or XML Web API in few clicks.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"SSIS - Extract single XML node using XPath from SOAP response | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to extract single XML node using XPath expression. Use SSIS REST Api Web service task to consume SOAP Web service or XML Web API in few clicks.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2016-09-07T16:01:07+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-10-30T23:14:27+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-REST-Api-Task-HTTP-POST-SSIS-Call-Web-Service.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"838\" \/>\r\n\t<meta property=\"og:image:height\" content=\"735\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/\",\"name\":\"SSIS - Extract single XML node using XPath from SOAP response | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-REST-Api-Task-HTTP-POST-SSIS-Call-Web-Service.png\",\"datePublished\":\"2016-09-07T16:01:07+00:00\",\"dateModified\":\"2025-10-30T23:14:27+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to extract single XML node using XPath expression. Use SSIS REST Api Web service task to consume SOAP Web service or XML Web API in few clicks.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-REST-Api-Task-HTTP-POST-SSIS-Call-Web-Service.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-REST-Api-Task-HTTP-POST-SSIS-Call-Web-Service.png\",\"width\":838,\"height\":735,\"caption\":\"Calling REST API in SSIS using REST API Task, Pass headers, Body, Url Parameters\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS – Extract single XML node using XPath from SOAP response\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSIS - Extract single XML node using XPath from SOAP response | ZappySys Blog","description":"Learn how to extract single XML node using XPath expression. Use SSIS REST Api Web service task to consume SOAP Web service or XML Web API in few clicks.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/","og_locale":"en_US","og_type":"article","og_title":"SSIS - Extract single XML node using XPath from SOAP response | ZappySys Blog","og_description":"Learn how to extract single XML node using XPath expression. Use SSIS REST Api Web service task to consume SOAP Web service or XML Web API in few clicks.","og_url":"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2016-09-07T16:01:07+00:00","article_modified_time":"2025-10-30T23:14:27+00:00","og_image":[{"width":838,"height":735,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-REST-Api-Task-HTTP-POST-SSIS-Call-Web-Service.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/","url":"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/","name":"SSIS - Extract single XML node using XPath from SOAP response | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-REST-Api-Task-HTTP-POST-SSIS-Call-Web-Service.png","datePublished":"2016-09-07T16:01:07+00:00","dateModified":"2025-10-30T23:14:27+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to extract single XML node using XPath expression. Use SSIS REST Api Web service task to consume SOAP Web service or XML Web API in few clicks.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-REST-Api-Task-HTTP-POST-SSIS-Call-Web-Service.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-REST-Api-Task-HTTP-POST-SSIS-Call-Web-Service.png","width":838,"height":735,"caption":"Calling REST API in SSIS using REST API Task, Pass headers, Body, Url Parameters"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-extract-single-xml-node-using-xpath-soap-response\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS – Extract single XML node using XPath from SOAP response"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/770"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=770"}],"version-history":[{"count":15,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/770\/revisions"}],"predecessor-version":[{"id":11596,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/770\/revisions\/11596"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/11523"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}