topic Re: Extraction of Response values from XML in the desired way. in Dashboards & Visualizations

Extraction of Response values from XML in the desired way.

yamini_37 — Wed, 30 Sep 2020 05:23:02 GMT

Hi All,

I am trying to extract the multiple response values for a single request. After using "spath" command, the result is shown below.
Here, I didn't extract any values and just tabulated the needed information.

So, in the XML file, ALB city has 4 streets. Each street contains 4 members. This is single result . Now I want to break it as 16 results with all details as shown below.

My query looks like
index=ab host=xy source=*y.xml |spath |table _time host City_Name Street_name Person_code Person_role

The above query gave the results shown in the first pic. Now i want to get the results as shown in the second picture. Please help me in framing the query for the latter part to get the expected results.

Thank You.

Re: Extraction of Response values from XML in the desired way.

vnravikumar — Fri, 08 May 2020 04:40:51 GMT

Can you post sample XML?

Re: Extraction of Response values from XML in the desired way.

to4kawa — Fri, 08 May 2020 05:22:18 GMT

| makeresults
| eval City_name="ALB"
| eval Street_name=split("Street 1,Street 2,Street 3,Street 4",",")
| eval Person_code=split("1,2,3,4",",")
| eval Person_role=split("Father,Mother,Brother,Sister,Father,Mother,Brother,Sister,Father,Mother,Brother,Sister,Father,Mother,Brother,Sister",",")
| table City_name Street_name Person_code Person_role
| rename COMMENT as "this is your sample. please check this. from here, the logic"

| eval Person_role=mvdedup(Person_role)
| eval Person=mvzip(Person_code,Person_role)
| mvexpand Street_name
| stats values(City_name) as City_name list(Street_name) as Street_name by Person
| mvexpand Street_name
| eval Person_code=mvindex(split(Person,","),0), Person_role=mvindex(split(Person,","),1)
| fields - Person
| table City_name Street_name Person_code Person_role
| sort Street_name

Re: Extraction of Response values from XML in the desired way.

to4kawa — Fri, 08 May 2020 06:41:25 GMT

JSON:

| makeresults
| eval _raw="{\"City Name\":\"ALB\",\"Street name\":[\"street 1\",\"street 2\",\"street 3\",\"street 4\"],\"Person code\":[1,2,3,4],\"Person role\":[\"Father\",\"Mother\",\"Brother\",\"Sister\",\"Father\",\"Mother\",\"Brother\",\"Sister\",\"Father\",\"Mother\",\"Brother\",\"Sister\",\"Father\",\"Mother\",\"Brother\",\"Sister\"]}"
| spath

what's XML ?

Re: Extraction of Response values from XML in the desired way.

yamini_37 — Tue, 12 May 2020 10:38:54 GMT

HI Ravi,

Please find the sample xml. I want to map the data and display as shown in the second picture.

Re: Extraction of Response values from XML in the desired way.

yamini_37 — Tue, 12 May 2020 10:53:25 GMT

I couldn't able to share the xml here

Re: Extraction of Response values from XML in the desired way.

yamini_37 — Tue, 12 May 2020 10:54:20 GMT

please find below.

Re: Extraction of Response values from XML in the desired way.

vnravikumar — Tue, 12 May 2020 11:09:26 GMT

Still, it is missing

Re: Extraction of Response values from XML in the desired way.

yamini_37 — Wed, 13 May 2020 08:04:13 GMT

I have posted a new question and tagged you. Could you please check. The subject line of the question is "challenge!!! extraction of XML response values"

Re: Extraction of Response values from XML in the desired way.

vnravikumar — Wed, 13 May 2020 08:18:25 GMT

I not able to find, can you post the URL?