Process XML Data

[jamesng]

Hi

I'm trying to process some XML data and extract the parameter values. For example, the UserID 1234 in the xml below.

xml =[[<?xml version="1.0" encoding="utf-8"?>
<Response>
<Name>Login</Name>
<Parameters>
<Parameter name="Status" dataType="int">0</Parameter>
<Parameter name="StatusMessage" dataType="string">Successful</Parameter>
<Parameter name="UserID" dataType="int">1234</Parameter>
<Parameter name="Firstname" dataType="string">James</Parameter>
<Parameter name="AllowR1XTill" dataType="string">2023-06-30</Parameter>
</Parameters>
</Response>]]


I gather I should be using the following to parse the XML but haven't come across an example of how to implement it. Has anyone done something similar?


require('lxp').new({
StartElement = starttag,
EndElement = endtag,
CharacterData = text,
}):parse(xml)

Many thanks in advance

Kind Regards
James

[admin]

Try this:

Code:

xml =[[<?xml version="1.0" encoding="utf-8"?>
<Response>
<Name>Login</Name>
<Parameters>
<Parameter name="Status" dataType="int">0</Parameter>
<Parameter name="StatusMessage" dataType="string">Successful</Parameter>
<Parameter name="UserID" dataType="int">1234</Parameter>
<Parameter name="Firstname" dataType="string">James</Parameter>
<Parameter name="AllowR1XTill" dataType="string">2023-06-30</Parameter>
</Parameters>
</Response>]]

parameters = {}

function starttag(parser, tag, attrs)
  if tag == 'Parameter' then
    name = attrs.name
  end
end

function text(parser, text)
  if name then
    parameters[ name ] = text:trim()
    name = nil
  end
end

require('lxp').new({
  StartElement = starttag,
  CharacterData = text,
}):parse(xml)

log(parameters)
log(parameters.UserID)

[jamesng]

Works perfectly .. many thanks!