Avatar of GeneBe
GeneBe
Flag for United States of America asked on

convert the xml POST response to a text file without the tagnames?

this is a VBscript  How do I convert the xml response to a text file without the tagnames?

Dim xml : xml = PostURL(HRP_BaseDomain & path, values)

Dim oXMLDoc, oXMLHTTP, oXMLResults, oXMLFields
Function PostURL(path, values)
   LogItem "path: " & HRP_BaseDomain & "   " &  path : LogError : Err.Clear
   On Error Resume Next
   set oXMLHTTP = createobject ("MSXML2.XMLHTTP.6.0")
   oXMLHTTP.open "POST", path, false
   oXMLHTTP.setRequestHeader "Content-type","application/x-www-form-urlencoded"
  oXMLHTTP.send values
   LogError : Err.Clear
   PostURL = oXMLHTTP.responseText
End Function

Open in new window

XMLVB Script

Avatar of undefined
Last Comment
GeneBe

8/22/2022 - Mon
Zvonko

Show the response from this property:  oXMLHTTP.responseXML.xml

https://docs.microsoft.com/en-us/previous-versions/windows/desktop/ms757055(v%3Dvs.85) 
GeneBe

ASKER
this gives me an xml response. I need a text formatted response without the tags
ASKER CERTIFIED SOLUTION
Zvonko

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Bill Prew

A sample of the output XML would be helpful, an answer may be driven by the structure and content of the XML, since XML can look a lot different between a simple schema and a very complex one.  With the XML sample a sample of the desired text output would be helpful.

You may be able to do something with an XSLT transformation, although I'm not very well skilled on that.  Take a look at this earlier question for an idea of that approach, but notice that to make it most useful it needs to know what the specific data looked liked, etc.



»bp
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
GeneBe

ASKER
Please close this issue. your solution worked. thank you very much.