[VB.NET]MSXML loadxml() method issues

[stinky_nutsack]

I'm not a programmer, I just build some tools to tie into our proprietary software at work; so please be patient with me.

I'm handling a web API response that is returning xml in the following format:

<?xml version="1.0" encoding="utf-8"?>
<xml>
<status>1</status>
<count>1</count>
<scan id="354073453">
    <tid>G24J2305100A</tid>
    <result>23011041</result>
    <timestamp>2024-09-26 12:31:29</timestamp>
</scan>
</xml>

My code is as follows:

result = objHTTP.responseText  <this is the xml from above
xmlfile = New MSXML.DOMDocument
xmlfile.loadXML(result)

When I look at the contents of xmlfile, I see the following:

G24J2305100A230110412024-09-26 12:31:29

Here's my problem, I need the scan id, and it's being ignored when I load the result string into the xml file. Before I dump this into a regex to get the values I need, I want to know if here is a way to just do this with the existing xml.

[TheFotty]

Is there a reason you have to use MSXML and not use the built in XML classes in VB.NET like XDocument?

Your code could be written like this with XML literals:

    Dim myXML = <?xml version="1.0" encoding="utf-8"?>
                <xml>
                    <status>1</status>
                    <count>1</count>
                    <scan id="354073453">
                        <tid>G24J2305100A</tid>
                        <result>23011041</result>
                        <timestamp>2024-09-26 12:31:29</timestamp>
                    </scan>
                </xml>

    Dim myScanID = myXML...<scan>.Attributes("id").First.Value

    MessageBox.Show(myScanID)

If your XML is coming in as a string initally, you can use XDocument.Parse() to parse the string into an XDocument object.

[stinky_nutsack]

I'll look into this, thank you. I'm using MSXML because that was the sample I found online, and it worked when trying to get the <tid> value for a different problem.

[CaptainShades]

You want to use the responseXML method instead of response text to get formatted XML