How to read attributes and values in XML using Node Js

Question

I used a SOAP API to get the response. And now I have a long XML response. I tried to convert XML into JSON and then to read. But, it couldn't work. Then I tried xml2js , xmldom and filterxml to read the attributes. But, it didn't work.

XML Response.

<?xml version="1.0" encoding="UTF-8"?>
<soap-env:Envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/">
    <soap-env:Header>
        <eb:MessageHeader xmlns:eb="http://www.ebxml.org/namespaces/messageHeader" eb:version="1.0" soap-env:mustUnderstand="1">
            <eb:From>
                <eb:PartyId eb:type="URI" />
            </eb:From>
            <eb:To>
                <eb:PartyId eb:type="URI" />
            </eb:To>
            <eb:CPAId>36465</eb:CPAId>
            <eb:ConversationId>4767547547745757</eb:ConversationId>
            <eb:Service eb:type="sabreXML">Session</eb:Service>
            <eb:Action>SessionCreateRS</eb:Action>
            <eb:MessageData>
                <eb:MessageId>45757457547</eb:MessageId>
                <eb:Timestamp>2020-04-29T12:13:28</eb:Timestamp>
                <eb:RefToMessageId>63465653634ffghfghfghf</eb:RefToMessageId>
            </eb:MessageData>
        </eb:MessageHeader>
        <wsse:Security xmlns:wsse="http://schemas.xmlsoap.org/ws/2002/12/secext">
            <wsse:BinarySecurityToken valueType="String" EncodingType="wsse:Base64Binary">bmkfdkdgkdskmlskfsdfpskmfl</wsse:BinarySecurityToken>
        </wsse:Security>
    </soap-env:Header>
    <soap-env:Body>
        <SessionCreateRS xmlns="http://www.opentravel.org/OTA/2002/11" version="1" status="Approved">
            <ConversationId>4767547547745757</ConversationId>
        </SessionCreateRS>
    </soap-env:Body>
</soap-env:Envelope>

**Update

As I told I tried to convert XML into JSON using xml2jsn. And it gave me the complete json response. But, I can't go for a attribute that I want because of these symbols, -(dash) and :(colon).

I just want to get " wsse:BinarySecurityToken " value. Then how can go for the wsse:BinarySecurityToken ??

var parseString = parseStringReq.parseString;

parseString(SetSoapTokenRes, function (err, result) {
    let json_res = JSON.stringify(result, null, 4);
    // json_res = json_res.replace(':', '_') //output: 'A D C'
res.end(json_res.soap-env:Envelope);
});

are you trying to parse the response from client side or via terminal independently ? — TheoNeUpKID
– TheoNeUpKID, Commented Apr 29, 2020 at 12:21
@TheoNeUpKID - I created a API to get the result from web browser. Now I want to return only basekey with that API. — Amithash
– Amithash, Commented Apr 29, 2020 at 12:24
You need to select one of the approaches you tried. Show us exactly what you did, and tell us exactly how it failed, and then we can tell you what you did wrong. Telling us you tried everything, nothing worked, and can we suggest anything else is not a good way of approaching problem solving. (We need to see your mistakes. For example, perhaps you just haven't grokked namespaces.) — Michael Kay
– Michael Kay, Commented Apr 29, 2020 at 12:29
The conventional way would be to build an XML DOM and navigate the DOM. — Michael Kay
– Michael Kay, Commented Apr 30, 2020 at 6:24

Tuan Anh Tran · Accepted Answer · 2020-06-18 06:35:10Z

Alternatively, if you want to make it simpler by transforming XML to JSOn with only the data you are interested in, you can use camaro and do this:

const { ready, transform } = require('camaro')

const xml = `
<?xml version="1.0" encoding="UTF-8"?>
<soap-env:Envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/">
    <soap-env:Header>
        <eb:MessageHeader xmlns:eb="http://www.ebxml.org/namespaces/messageHeader" eb:version="1.0" soap-env:mustUnderstand="1">
            <eb:From>
                <eb:PartyId eb:type="URI" />
            </eb:From>
            <eb:To>
                <eb:PartyId eb:type="URI" />
            </eb:To>
            <eb:CPAId>36465</eb:CPAId>
            <eb:ConversationId>4767547547745757</eb:ConversationId>
            <eb:Service eb:type="sabreXML">Session</eb:Service>
            <eb:Action>SessionCreateRS</eb:Action>
            <eb:MessageData>
                <eb:MessageId>45757457547</eb:MessageId>
                <eb:Timestamp>2020-04-29T12:13:28</eb:Timestamp>
                <eb:RefToMessageId>63465653634ffghfghfghf</eb:RefToMessageId>
            </eb:MessageData>
        </eb:MessageHeader>
        <wsse:Security xmlns:wsse="http://schemas.xmlsoap.org/ws/2002/12/secext">
            <wsse:BinarySecurityToken valueType="String" EncodingType="wsse:Base64Binary">bmkfdkdgkdskmlskfsdfpskmfl</wsse:BinarySecurityToken>
        </wsse:Security>
    </soap-env:Header>
    <soap-env:Body>
        <SessionCreateRS xmlns="http://www.opentravel.org/OTA/2002/11" version="1" status="Approved">
            <ConversationId>4767547547745757</ConversationId>
        </SessionCreateRS>
    </soap-env:Body>
</soap-env:Envelope>
`
const template = {
    token: 'soap-env:Envelope/soap-env:Header/wsse:Security/wsse:BinarySecurityToken',
    conversationId: 'soap-env:Envelope/soap-env:Body/SessionCreateRS/ConversationId'
}

;(async function () {
    const result = await transform(xml, template)
    console.log(result)
})()

the template is just an example. you can add more fields if you want. Accessing token is simply result.token

example output

{
  token: 'bmkfdkdgkdskmlskfsdfpskmfl',
  conversationId: '4767547547745757'
}

TheoNeUpKID · Accepted Answer · 2020-04-29 12:57:04Z

1

looks like your trying to get the result incorrectly. Instead of json_res.soap-env:Envelope try json_res['soap-env:Envelope'] it maybe escaping because of the special character.

answered Apr 29, 2020 at 12:57

TheoNeUpKID

9918 silver badges13 bronze badges

4 Comments

Amithash Over a year ago

I tried with this res.end(json_res['soap-env:Envelope']);. But, nothing happened. No response or errors. Then I added another one like this res.end(json_res['soap-env:Envelope']['soap-env:Header']); And I got this error - TypeError: Cannot read property 'soap-env:Header' of undefined. What can I do ??

TheoNeUpKID Over a year ago

is var parseStringReq initialized

Amithash Over a year ago

yes, var parseStringReq = require('xml2js'); What is the problem ??

TheoNeUpKID Over a year ago

It’s wasn’t included in your code sample and wanted to make sure you initialized the variable.

Amithash · Accepted Answer · 2020-04-30 07:03:13Z

0

Finally, I converted XML into JSON using xml2js package. And used below code to read attributes as I want.

var xml2js = require('xml2js');
var parser = new xml2js.Parser();

parser.parseString(xml_response, function (err, result) {
    if (err) {
        console.error('here is the eror: ', err);
    } else {
        console.log(JSON.stringify(result, null, 2));
        console.log(["soap-env:Envelope"]["soap-env:Header"][0]["token"]); 
    }
});

answered Apr 30, 2020 at 7:03

Amithash

2772 gold badges5 silver badges26 bronze badges

Collectives™ on Stack Overflow

How to read attributes and values in XML using Node Js

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related