Parsing curl output command line

Question

In response to a curl command curl -ik -u max:pass -X GET -i -H "Content-Type: application/xml" https://1.2.3.4:943/cloud/rest/projects I get a huge xml with many entires similar to the following

<project xlink:href="https://1.2.3.4:943/cloud/projects/13389/" >
            <approvedservers xlink:href="https://1.2.3.4:943/cloud/projects/13389/approvedservers/" ></approvedservers>
            <requestUser>maxadmin</requestUser>
            <removed xlink:href="https://1.2.3.4:943/cloud/projects/13389/removed/" ></removed>
            <rejected>false</rejected>
            <pending xlink:href="https://1.2.3.4:943/cloud/rest/projects/13389/pending/" ></pending>
            <name>4BSm3ZQ1T6q7xBR2xT2PdQ</name>
            <servers xlink:href="https://1.2.3.4:943/cloud/rest/projects/13389/servers/" ></servers>
            <ticketId>ticketId</ticketId>
            <approved>true</approved>
            <history xlink:href="https://1.2.3.4:943/cloud/rest/projects/13389/history/" ></history>
            <startTime>1502214154651</startTime>
            <requestedServerCount>1</requestedServerCount>
            <applicationid>4336525</applicationid>
            <provision>provision</provision>
            <customer>None</customer>
            <endTime>253402300740000</endTime>
        </project>

How can I parse this output to fetch project ID which is same in all the urls https://1.2.3.4:943/cloud/rest/projects/13389/pending/ based on the <name>4BSm3ZQ1T6q7xBR2xT2PdQ</name>. Basically I want to find the project id for a user name.

Is it possible to get with content type as json, that way it can be easily parsed using jq? Can you try with "Content-Type: application/json"? using this answer stackoverflow.com/questions/21326397/… — Inian
– Inian, Commented Aug 23, 2017 at 10:02

Arminius · Accepted Answer · 2017-08-23 10:49:50Z

1

You could use xmlstarlet and search for all name elements that have the desired text as value, then output the sibling element pending (using ../pending/@href:xlink which means "up one level, then element pending, then attribute xlink:href):

xmlstarlet sel -t  --match '//name[text() = "4BSm3ZQ1T6q7xBR2xT2PdQ"]' -v "../pending/@xlink:href"   file.xml

answered Aug 23, 2017 at 10:49

Arminius

1,1797 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

glenn jackman Over a year ago

You can specify the condition in the xpath: -v "//project[name='$name']/@xlink:href"

Arminius Over a year ago

@glennjackman yes, that's better. If I don't use xmlstarlet on a daily basis, I forget everything :-)

glenn jackman Over a year ago

Too true. I have to do xmlstarlet sel --help | less every single time. Wait until you start using jq though...

Arminius Over a year ago

@glennjackman oh, jq the tool that makes xmlstarlet and exiting vim look easy :-) -- that's where the gray hair on the left side of my head is from ...

Collectives™ on Stack Overflow

Parsing curl output command line

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related