Parsing XML from VBA

[newbie30]

Hello All,

Hi have this xml response through the SOAP UI
{"ResultCode":0,"ErrorText":"Registration entry details.","Details":"<Details><RegKey>3216788038</RegKey><ExpiryDate>2018-08-14T00:00:00.0000</ExpiryDate><OnStop>1</OnStop><AutoRenew>0</AutoRenew><Product>Touch 9</Product><SoftwareVersion></SoftwareVersion><EndUserName>Test Licence</EndUserName><LicenceKey>Key not used yet.</LicenceKey><TerminalNo>1</TerminalNo><BranchNo></BranchNo></Details>"}

How do I parse this to retrieve the individual fields?

I have tried the LOadxml but that doesnt work.

If xmlDoc.Load("https://regtest.cessoftware.co.uk/RegistrationsService/ThreeRDatabaseGetReg.asmx") Then
Dim doc2 As MSXML2.DOMDocument60
Set doc2 = New MSXML2.DOMDocument60
If doc2.LoadXML(xmlDoc.DocumentElement.Text) Then
Dim value
value = doc2.SelectSingleNode("//Details").Text


Else
'handle doc2.parseError here
End If

Am using VBA Access 2010.


Could some one please help.


Thanks
Newbie

[Micron]

If you have not solved this, see if this helps

https://www.accessforums.net/showthread.php?t=73932