# Help with converting String to Integer in xml parsing

**URL:** <https://discuss.elastic.co/t/help-with-converting-string-to-integer-in-xml-parsing/239672>\
**Category:** Logstash\
**Created:** [July 2, 2020, 4:10pm UTC](https://discuss.elastic.co/t/help-with-converting-string-to-integer-in-xml-parsing/239672 "2020-07-02T16:10:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jyotsna.ganji](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jyotsna.ganji/32/71540_2.png) [@jyotsna.ganji](https://discuss.elastic.co/u/jyotsna.ganji)\
**Post date:** [July 2, 2020, 4:10pm UTC](https://discuss.elastic.co/t/help-with-converting-string-to-integer-in-xml-parsing/239672/1 "2020-07-02T16:10:33Z")

</div>

I am parsing a nested xml using the below conf file and it parses individual tag elements perfectly. But when I try to convert string elements to Integer using XPath, it forms arrays of values.

```auto
input{
http_poller{
        urls => {
                urlname => "urlxxxxxx"
        }
        request_timeout => 880
        socket_timeout => 180
        connect_timeout => 100
        schedule => {every => "60s"}
        type => "xml"
        codec => "plain"
    }
}
filter {
      xml {
        source => "message"
        target => "parsed"
        store_xml =>true
      }
        split {
        field => "[parsed][collectionInstance]"
        }
        split {
        field => "[parsed][collectionInstance][actions]"
        }
        split {
        field => "[parsed][collectionInstance][actions][rerun]"
        }
        split {
        field => "[parsed][collectionInstance][aha]"
        }
        split {
        field => "[parsed][collectionInstance][aha][regressionAnalysis]"
        }
        split {
        field => "[parsed][collectionInstance][aha][stabilityAnalysis]"
        }

mutate {
remove_field => ["message","@version"]
}

}

output{
elasticsearch{
        hosts => ["localhost:9200"]
		index => "summary_xml"
}
stdout { codec => rubydebug }
}

```

My indexed output in Kibana looks like this

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/d/edfa7c0f60bac6d3e8b3486627a4478516a49733.png)

When I add the XPath values, and convert block for changing data types, with the below conf:

```auto
input{
http_poller{ 
        urls => {
                urlname => "http://thirdeye.us.oracle.com/thirdeye-services/v1.0/views/runs/summary.xml?tql=user.dte.topology.id=%5B%5B%7B%7B98319%7D%7D%5D%5D%20time%20%3E%20$now%20-%201%20*%20$day"
        }
        request_timeout => 880
        socket_timeout => 180
        connect_timeout => 100
        schedule => {every => "60s"}
        type => "xml"
        codec => "plain"
    }
}
filter {
      xml {
        source => "message"
        target => "parsed"
        store_xml =>true
        xpath => [
                "//collectionInstance/actions/failure/text()", "ActionsFailurecount",
                "//collectionInstance/actions/rerun/failure/text()", "rerunfailurecount",
                "//collectionInstance/actions/rerun/success/text()", "rerunsuccesscount",
                "//collectionInstance/actions/rerun/total/text()", "actionreruntotalcount",
                "//collectionInstance/actions/total/text()", "actionstotalcount",
                "//collectionInstance/actions/success/text()", "actionssuccesscount",
                "//collectionInstance/aha/regressionAnalysis/regressionLikely/text()", "regressionLikely",
                "//collectionInstance/aha/stabilityAnalysis/alwaysPass/text()", "alwaysPass",
                "//collectionInstance/aha/stabilityAnalysis/failedWithoutProblem/text()", "failedWithoutProblem",
                "//collectionInstance/aha/stabilityAnalysis/healthy/text()", "stabilityanalysis_healthy",
                "//collectionInstance/aha/stabilityAnalysis/neverPass/text()", "neverPass",
                "//parsed/count/text()", "count",
                "//collectionInstance/actions/timeout/text()", "actionstimeoutcount",
                "//collectionInstance/actions/rerun/timeout/text()", "actionsreruntimeoutcount"
                ]
      }
        split {
        field => "[parsed][collectionInstance]"
        }
        split {
        field => "[parsed][collectionInstance][actions]"
        }
        split {
        field => "[parsed][collectionInstance][actions][rerun]"
        }
        split {
        field => "[parsed][collectionInstance][aha]"
        }
        
        split {
        field => "[parsed][collectionInstance][aha][regressionAnalysis]"
        }
        split {
        field => "[parsed][collectionInstance][aha][stabilityAnalysis]"
        }

mutate {
        convert => {"ActionsFailurecount" => "integer" }
        convert => { "actionsreruntimeoutcount" => "integer" }
        convert => {"actionstimeoutcount" => "integer"}
        convert => {"count" => "integer"}
        convert => {"neverPass" => "integer"}
        convert => {"stabilityanalysis_healthy" => "integer"}
        convert => {"failedWithoutProblem" => "integer"}
        convert => {"alwaysPass" => "integer"}
        convert => {"regressionLikely" => "integer"}
        convert => {"actionssuccesscount" => "integer"}
        convert => {"actionstotalcount" => "integer"}
        convert => {"actionreruntotalcount" => "integer"}
        convert => {"rerunsuccesscount" => "integer"}
        convert => {"rerunfailurecount" => "integer"}

}
mutate {
remove_field => ["message","@version"]
}

}

output{
elasticsearch{
        hosts => ["localhost:9200"]
        index => "xml_summary"
}
stdout { codec => rubydebug }
}

```

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/e/4e8ee48b12db394df6271c55ba1708fbbe493592.png)

How can I get data type conversion without having data clubbed in to arrays?

---

<div class="post-metadata">

**Author:** ![jyotsna.ganji](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jyotsna.ganji/32/71540_2.png) [@jyotsna.ganji](https://discuss.elastic.co/u/jyotsna.ganji)\
**Post date:** [July 3, 2020, 5:56am UTC](https://discuss.elastic.co/t/help-with-converting-string-to-integer-in-xml-parsing/239672/2 "2020-07-03T05:56:46Z")

</div>

Resolved this issue by adding individual mutate convert blocks in conf file.

```auto
 mutate{
        convert=>{"[parsed][collectionInstance][actions][failure]"=>"integer"}
        }
        mutate{
        convert=>{"[parsed][collectionInstance][actions][success]"=>"integer"}
        }
        mutate{
        convert=>{"[parsed][collectionInstance][actions][total]"=>"integer"}
        }
        mutate{
        convert=>{"[parsed][collectionInstance][aha][regressionAnalysis][regressionLikely]"=>"integer"}
        }
        mutate{
        convert=>{"[parsed][collectionInstance][aha][stabilityAnalysis][alwaysPass]"=>"integer"}
        }

```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 31, 2020, 5:56am UTC](https://discuss.elastic.co/t/help-with-converting-string-to-integer-in-xml-parsing/239672/3 "2020-07-31T05:56:47Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.