How do I parse a SOAP document in ColdFusion?
Hi,
I'm consuming a .NET SOAP-based web service that returns the following SOAP document utilizing cfhttp. How would I parse the following document into a ColdFusion object such as a query, array, struct, etc.? I could do with even a simplified XML document. Thanks!!
//assignment
<cfset parsedResult = XmlParse(cfhttp.FileConten
//actual SOAP result set
<?xml version="1.0" encoding="utf-8"?><soap:En
I'm consuming a .NET SOAP-based web service that returns the following SOAP document utilizing cfhttp. How would I parse the following document into a ColdFusion object such as a query, array, struct, etc.? I could do with even a simplified XML document. Thanks!!
//assignment
<cfset parsedResult = XmlParse(cfhttp.FileConten
//actual SOAP result set
<?xml version="1.0" encoding="utf-8"?><soap:En
You can get the results in an ARRAY... here is how you do it.. use XMLSEARCH for the webServiceResult...
<cfprocessingdirective suppresswhitespace="yes">
<cfsavecontent variable="soap">
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://www.w3.org/2003/05/soap-envelope" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:tns="http://YourWDSLHere.com/webservice/2008" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" >
<SOAP-ENV:Body>
<tns:Query xmlns:tns="http://YourWDSLHere.com/webservice/2008">
<tns:Type>NDC</tns:Type>
<tns:QueryString>00006-0464-05</tns:QueryString>
<tns:Token>YourTokenHere</tns:Token>
</tns:Query>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
</cfsavecontent>
<cfhttp url="http://www.YourWDSLHere.com/wspHVLookup.asmx" method="post" proxyserver="indiaproxy.india.cypress.com" proxyport="8080">
	 <cfhttpparam type="header" name="content-type" value="text/xml">
<cfhttpparam type="header" name="SOAPAction" value="http://YourWDSLHere.com/webservice/2008/Query">
<cfhttpparam type="header" name="content-length" value="#len(soap)#">
<cfhttpparam type="header" name="charset" value="utf-8">
<cfhttpparam type="xml" name="message" value="#trim(soap)#">
</cfhttp>
<cfset response = XMLParse(trim(cfhttp.FileContent)) >
<cfset responseNodes = xmlSearch(
response,
"//*[ local-name() = 'WebServiceResult' ]"
) />
<cfdump var="#responseNodes#">
</cfprocessingdirective>ASKER
Thanks for responding again to my post :-)
Assigning it to an array really helps. After reviewing the array output, how would you reference the individual XML elements...specifically the name/value pairs?
Assigning it to an array really helps. After reviewing the array output, how would you reference the individual XML elements...specifically the name/value pairs?
A little bit involved, but you can parse as below..
<cfprocessingdirective suppresswhitespace="yes">
<cfsavecontent variable="soap">
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://www.w3.org/2003/05/soap-envelope" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:tns="http://YourWDSLHere.com/webservice/2008" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" >
<SOAP-ENV:Body>
<tns:Query xmlns:tns="http://YourWDSLHere.com/webservice/2008">
<tns:Type>NDC</tns:Type>
<tns:QueryString>00006-0464-05</tns:QueryString>
<tns:Token>YourTokenHere</tns:Token>
</tns:Query>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
</cfsavecontent>
<cfhttp url="http://www.YourWDSLHere.com/wspHVLookup.asmx" method="post" proxyserver="indiaproxy.india.cypress.com" proxyport="8080">
	 <cfhttpparam type="header" name="content-type" value="text/xml">
<cfhttpparam type="header" name="SOAPAction" value="http://YourWDSLHere.com/webservice/2008/Query">
<cfhttpparam type="header" name="content-length" value="#len(soap)#">
<cfhttpparam type="header" name="charset" value="utf-8">
<cfhttpparam type="xml" name="message" value="#trim(soap)#">
</cfhttp>
<cfset response = XMLParse(trim(cfhttp.FileContent)) >
<cfset responseNodes = xmlSearch(
response,
"//*[ local-name() = 'WebServiceResult' ]"
) />
<cfloop from="1" to="#ArrayLen(responseNodes)#" index="i">
<cfset responseNodesArr = responseNodes[i].XmlChildren >
<cfset responseNodesArrTemp = responseNodesArr[3].XmlChildren >
<cfset responseNodesArrTempNew = responseNodesArrTemp[1].XmlChildren >
<cfset name = responseNodesArrTempNew[1].XmlText>
<cfset value = responseNodesArrTempNew[2].XmlText >
<cfdump var="#name#">
<cfdump var="#value#">
<br/>
</cfloop>
</cfprocessingdirective>ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
specifically the name/value pairs?
Extracting name/value is even simpler than that using local-name
Extracting name/value is even simpler than that using local-name
<cfset doc = XmlParse(trim(cfhttp.FileContent)))>
<cfset data = XMLSearch(doc, "//*[ local-name() = 'Pair' ]")>
<cfloop array="#data#" index="pair">
<cfoutput>
Name: #pair.name.xmlText# Value: #pair.value.xmlText#<br>
</cfoutput>
</cfloop>ASKER
@brijeshchauhan: Sorry for the delay in getting back to you. Your solution worked great!! Thanks so much.
@aqx: Very cool code snippet but it only received two of the three name/value pairs
@aqx: Very cool code snippet but it only received two of the three name/value pairs
@blue44 - Nope, using the SOAP sample in your first post gives the full results below (CF8&CF9).
Are you sure you implemented it correctly?
Results
Name: NDCCode Value: 0006-0464-01
Name: TradeName Value: EMEND CAPSULES
Name: FirmName Value: MERCK AND CO INC
Name: NDCCode Value: 0006-0464-05
Name: TradeName Value: EMEND CAPSULES
Name: FirmName Value: MERCK AND CO INC
Name: NDCCode Value: 0006-0464-10
Name: TradeName Value: EMEND CAPSULES
Name: FirmName Value: MERCK AND CO INC
Name: NDCCode Value: 49288-0464-5
Name: TradeName Value: SPONDYLOCLADIUM INJECTION SOLUTION
Name: FirmName Value: ANTIGEN LABORATORIES INC
Name: NDCCode Value: 53746-464-01
Name: TradeName Value: IBUPROFEN TABLETS
Name: FirmName Value: AMNEAL PHARMACEUTICALS NY LLC
Name: NDCCode Value: 53746-464-05
Name: TradeName Value: IBUPROFEN TABLETS
Name: FirmName Value: AMNEAL PHARMACEUTICALS NY LLC
Name: NDCCode Value: 53746-464-30
Name: TradeName Value: IBUPROFEN TABLETS
Name: FirmName Value: AMNEAL PHARMACEUTICALS NY LLC
Name: NDCCode Value: 53746-464-60
Name: TradeName Value: IBUPROFEN TABLETS
Name: FirmName Value: AMNEAL PHARMACEUTICALS NY LLC
Name: NDCCode Value: 53746-464-90
Name: TradeName Value: IBUPROFEN TABLETS
Name: FirmName Value: AMNEAL PHARMACEUTICALS NY LLC
Name: NDCCode Value: 62794-464-01
Name: TradeName Value: MAXZIDE .25 MG TABLETS
Name: FirmName Value: MYLAN BERTEK PHARMACEUTICALS INC
Name: NDCCode Value: 62794-464-05
Name: TradeName Value: MAXZIDE .25 MG TABLETS
Name: FirmName Value: MYLAN BERTEK PHARMACEUTICALS INC
Name: NDCCode Value: 62794-464-88
Name: TradeName Value: MAXZIDE .25 MG TABLETS
Name: FirmName Value: MYLAN BERTEK PHARMACEUTICALS INC
Name: NDCCode Value: 63739-464-05
Name: TradeName Value: FUROSEMIDE INJECTION
Name: FirmName Value: MCKESSON PACKAGING SERVICES BUSINESS UNIT MCKESSON CORP
Name: NDCCode Value: 0078-0464-61
Name: TradeName Value: AREDIA FOR INJECTION
Name: FirmName Value: NOVARTIS PHARMACEUTICALS CORP
Name: NDCCode Value: 0378-0464-01
Name: TradeName Value: MAXZIDE TABLETS
Name: FirmName Value: MYLAN PHARMACEUTICALS INC
Name: NDCCode Value: 0456-0464-01
Name: TradeName Value: ARMOUR THYROID TABLETS
Name: FirmName Value: FOREST PHARMACEUTICALS INC
Name: NDCCode Value: 0472-0464-01
Name: TradeName Value: BENZOYL PEROXIDE PADS
Name: FirmName Value: ACTAVIS MID ATLANTIC LLC
Name: NDCCode Value: 0472-0464-30
Name: TradeName Value: BENZOYL PEROXIDE PADS
Name: FirmName Value: ACTAVIS MID ATLANTIC LLC
Name: NDCCode Value: 0472-0464-60
Name: TradeName Value: BENZOYL PEROXIDE PADS
Name: FirmName Value: ACTAVIS MID ATLANTIC LLC
Name: NDCCode Value: 10267-0464-0
Name: TradeName Value: FEROTRINSIC CAPSULES
Name: FirmName Value: CONTRACT PHARMACAL CORP
Name: NDCCode Value: 10267-0464-1
Name: TradeName Value: FEROTRINSIC CAPSULES
Name: FirmName Value: CONTRACT PHARMACAL CORP
Name: NDCCode Value: 10267-0464-4
Name: TradeName Value: FEROTRINSIC CAPSULES
Name: FirmName Value: CONTRACT PHARMACAL CORP
Name: NDCCode Value: 13411-464-04
Name: TradeName Value: ERYTHROCIN STEARATE TABLETS
Name: FirmName Value: ADVANCED PHARMACEUTICAL SERVICES INC
Name: NDCCode Value: 14049-464-34
Name: TradeName Value: NEOMYCIN AND POLYMYXIN B SULFATES AND BACITRACIN OPH OINTMENT
Name: FirmName Value: RX VETERINARY PRODUCTS
Name: NDCCode Value: 21695-464-07
Name: TradeName Value: LEVAQUIN TABLETS
Name: FirmName Value: REBEL DISTRIBUTORS CORP
Name: NDCCode Value: 33261-464-01
Name: TradeName Value: AMOXICILLIN CLAVULANATE POTASSIUM SUSPENSION
Name: FirmName Value: AIDAREX PHARMACUTICALS LLC
Name: NDCCode Value: 33358-464-30
Name: TradeName Value: BENAZEPRIL HYDROCHLORIDE AND HYDROCHLOROTHIAZIDE TABLETS
Name: FirmName Value: CORE PHARMACEUTICALS INC
Name: NDCCode Value: 43353-464-32
Name: TradeName Value: RISPERIDONE TABLETS
Name: FirmName Value: DBA PREPAK SYSTEMS INC
Name: NDCCode Value: 49288-0464-1
Name: TradeName Value: SPONDYLOCLADIUM INJECTION SOLUTION
Name: FirmName Value: ANTIGEN LABORATORIES INC
Name: NDCCode Value: 49288-0464-2
Name: TradeName Value: SPONDYLOCLADIUM INJECTION SOLUTION
Name: FirmName Value: ANTIGEN LABORATORIES INC
Are you sure you implemented it correctly?
Results
Name: NDCCode Value: 0006-0464-01
Name: TradeName Value: EMEND CAPSULES
Name: FirmName Value: MERCK AND CO INC
Name: NDCCode Value: 0006-0464-05
Name: TradeName Value: EMEND CAPSULES
Name: FirmName Value: MERCK AND CO INC
Name: NDCCode Value: 0006-0464-10
Name: TradeName Value: EMEND CAPSULES
Name: FirmName Value: MERCK AND CO INC
Name: NDCCode Value: 49288-0464-5
Name: TradeName Value: SPONDYLOCLADIUM INJECTION SOLUTION
Name: FirmName Value: ANTIGEN LABORATORIES INC
Name: NDCCode Value: 53746-464-01
Name: TradeName Value: IBUPROFEN TABLETS
Name: FirmName Value: AMNEAL PHARMACEUTICALS NY LLC
Name: NDCCode Value: 53746-464-05
Name: TradeName Value: IBUPROFEN TABLETS
Name: FirmName Value: AMNEAL PHARMACEUTICALS NY LLC
Name: NDCCode Value: 53746-464-30
Name: TradeName Value: IBUPROFEN TABLETS
Name: FirmName Value: AMNEAL PHARMACEUTICALS NY LLC
Name: NDCCode Value: 53746-464-60
Name: TradeName Value: IBUPROFEN TABLETS
Name: FirmName Value: AMNEAL PHARMACEUTICALS NY LLC
Name: NDCCode Value: 53746-464-90
Name: TradeName Value: IBUPROFEN TABLETS
Name: FirmName Value: AMNEAL PHARMACEUTICALS NY LLC
Name: NDCCode Value: 62794-464-01
Name: TradeName Value: MAXZIDE .25 MG TABLETS
Name: FirmName Value: MYLAN BERTEK PHARMACEUTICALS INC
Name: NDCCode Value: 62794-464-05
Name: TradeName Value: MAXZIDE .25 MG TABLETS
Name: FirmName Value: MYLAN BERTEK PHARMACEUTICALS INC
Name: NDCCode Value: 62794-464-88
Name: TradeName Value: MAXZIDE .25 MG TABLETS
Name: FirmName Value: MYLAN BERTEK PHARMACEUTICALS INC
Name: NDCCode Value: 63739-464-05
Name: TradeName Value: FUROSEMIDE INJECTION
Name: FirmName Value: MCKESSON PACKAGING SERVICES BUSINESS UNIT MCKESSON CORP
Name: NDCCode Value: 0078-0464-61
Name: TradeName Value: AREDIA FOR INJECTION
Name: FirmName Value: NOVARTIS PHARMACEUTICALS CORP
Name: NDCCode Value: 0378-0464-01
Name: TradeName Value: MAXZIDE TABLETS
Name: FirmName Value: MYLAN PHARMACEUTICALS INC
Name: NDCCode Value: 0456-0464-01
Name: TradeName Value: ARMOUR THYROID TABLETS
Name: FirmName Value: FOREST PHARMACEUTICALS INC
Name: NDCCode Value: 0472-0464-01
Name: TradeName Value: BENZOYL PEROXIDE PADS
Name: FirmName Value: ACTAVIS MID ATLANTIC LLC
Name: NDCCode Value: 0472-0464-30
Name: TradeName Value: BENZOYL PEROXIDE PADS
Name: FirmName Value: ACTAVIS MID ATLANTIC LLC
Name: NDCCode Value: 0472-0464-60
Name: TradeName Value: BENZOYL PEROXIDE PADS
Name: FirmName Value: ACTAVIS MID ATLANTIC LLC
Name: NDCCode Value: 10267-0464-0
Name: TradeName Value: FEROTRINSIC CAPSULES
Name: FirmName Value: CONTRACT PHARMACAL CORP
Name: NDCCode Value: 10267-0464-1
Name: TradeName Value: FEROTRINSIC CAPSULES
Name: FirmName Value: CONTRACT PHARMACAL CORP
Name: NDCCode Value: 10267-0464-4
Name: TradeName Value: FEROTRINSIC CAPSULES
Name: FirmName Value: CONTRACT PHARMACAL CORP
Name: NDCCode Value: 13411-464-04
Name: TradeName Value: ERYTHROCIN STEARATE TABLETS
Name: FirmName Value: ADVANCED PHARMACEUTICAL SERVICES INC
Name: NDCCode Value: 14049-464-34
Name: TradeName Value: NEOMYCIN AND POLYMYXIN B SULFATES AND BACITRACIN OPH OINTMENT
Name: FirmName Value: RX VETERINARY PRODUCTS
Name: NDCCode Value: 21695-464-07
Name: TradeName Value: LEVAQUIN TABLETS
Name: FirmName Value: REBEL DISTRIBUTORS CORP
Name: NDCCode Value: 33261-464-01
Name: TradeName Value: AMOXICILLIN CLAVULANATE POTASSIUM SUSPENSION
Name: FirmName Value: AIDAREX PHARMACUTICALS LLC
Name: NDCCode Value: 33358-464-30
Name: TradeName Value: BENAZEPRIL HYDROCHLORIDE AND HYDROCHLOROTHIAZIDE TABLETS
Name: FirmName Value: CORE PHARMACEUTICALS INC
Name: NDCCode Value: 43353-464-32
Name: TradeName Value: RISPERIDONE TABLETS
Name: FirmName Value: DBA PREPAK SYSTEMS INC
Name: NDCCode Value: 49288-0464-1
Name: TradeName Value: SPONDYLOCLADIUM INJECTION SOLUTION
Name: FirmName Value: ANTIGEN LABORATORIES INC
Name: NDCCode Value: 49288-0464-2
Name: TradeName Value: SPONDYLOCLADIUM INJECTION SOLUTION
Name: FirmName Value: ANTIGEN LABORATORIES INC
<cfset response = cfhttp.FileContent >
<cfset response = response.ReplaceAll("(</?)
<cfset response = response.ReplaceAll("xmlns
For more information, the source of that code is:
http://www.bennadel.com/blog/494-Stripping-XML-Name-Spaces-And-Node-Prefixes-From-ColdFusion-XML-Data-To-Simplify-XPath-.htm
<cfset response = response.ReplaceAll("(</?)
<cfset response = response.ReplaceAll("xmlns
For more information, the source of that code is:
http://www.bennadel.com/blog/494-Stripping-XML-Name-Spaces-And-Node-Prefixes-From-ColdFusion-XML-Data-To-Simplify-XPath-.htm
Another unanswered question for the archives ...
ASKER
@aqx: Thanks...you might be right and I was coding late that night. Bottom line, I appreciate everyone's continued assistance on EE -- what a great service...especially for developers like myself who don't work in large development teams where you can bounce issues off each other.
@blue44 - I hear ya'. I just wanted to point out the extra code shouldn't be needed. The point of using local-name() is to ignore the namespace. So removing the namespace and *also* use local-name() doesn't really make sense. You normally use one or the other - not both. But glad you got it solved .. and thanks for following up :)
Open in new window