extracting data from json in scala

Question

{
    "findItemsByKeywordsResponse": [{
        "ack": ["Success"],
        "version": ["1.13.0"],
        "timestamp": ["2018-02-28T09:52:48.736Z"],
        "searchResult": [{
            "@count": "1",
            "item": [{
                "itemId": ["273088613147"],
                "title": ["MTG Air Elemental *ALPHA*"],
                "globalId": ["EBAY-ENCA"],
                "primaryCategory": [{
                    "categoryId": ["38292"],
                    "categoryName": ["MTG Individual Cards"]
                }],
                "galleryURL": ["http:\/\/thumbs4.ebaystatic.com\/m\/mrUjH7CtVxARfthfKH3wYAw\/140.jpg"],
                "viewItemURL": ["http:\/\/www.ebay.com\/itm\/MTG-Air-Elemental-ALPHA-\/273088613147"],
                "paymentMethod": ["PayPal"],
                "autoPay": ["false"],
                "postalCode": ["M4S2H7"],
                "location": ["Canada"],
                "country": ["CA"],
                "shippingInfo": [{
                    "shippingServiceCost": [{
                        "@currencyId": "USD",
                        "__value__": "0.0"
                    }],
                    "shippingType": ["Free"],
                    "shipToLocations": ["Worldwide"],
                    "expeditedShipping": ["false"],
                    "oneDayShippingAvailable": ["false"],
                    "handlingTime": ["1"]
                }],
                "sellingStatus": [{
                    "currentPrice": [{
                        "@currencyId": "CAD",
                        "__value__": "25.0"
                    }],
                    "convertedCurrentPrice": [{
                        "@currencyId": "USD",
                        "__value__": "19.6"
                    }],
                    "sellingState": ["Active"],
                    "timeLeft": ["P29DT19H50M26S"]
                }],
                "listingInfo": [{
                    "bestOfferEnabled": ["false"],
                    "buyItNowAvailable": ["false"],
                    "startTime": ["2018-02-28T05:43:14.000Z"],
                    "endTime": ["2018-03-30T05:43:14.000Z"],
                    "listingType": ["FixedPrice"],
                    "gift": ["false"]
                }],
                "returnsAccepted": ["false"],
                "condition": [{
                    "conditionId": ["3000"],
                    "conditionDisplayName": ["Used"]
                }],
                "isMultiVariationListing": ["false"],
                "topRatedListing": ["false"]
            }]
        }],
        "paginationOutput": [{
            "pageNumber": ["1"],
            "entriesPerPage": ["100"],
            "totalPages": ["1"],
            "totalEntries": ["1"]
        }],
        "itemSearchURL": ["http:\/\/www.ebay.com\/sch\/i.html?_nkw=mtg+air+elemental+alpha&_ddo=1&_ipg=100&_pgn=1"]
    }]
}

I want to extract, lets say, in the first line the value of 'SearchResult'. I looked on stackoverflow for the hints but I am getting confused and I am new to Scala. Can anyone suggest a simple and straight way to do it. Thanks

Possible duplicate of [How to parse JSON in Scala using standard Scala classes?](https://stackoverflow.com/questions/4170949/how-to-parse-json-in-scala-using-standard-scala-classes) — SCouto, Feb 28 '18 at 10:18

Nagarjuna Pamu · Accepted Answer · 2018-02-28T13:31:43.550

Using play-json Find here https://mvnrepository.com/artifact/com.typesafe.play/play-json_2.12/2.6.8

You can do the following to extract searchResult

Parse the json

val payload = Json.parse(str)

Use \\ operator to fetch required key value

val payload = Json.parse(str)
payload \\ "searchResult"

Scala REPL

scala> :paste
// Entering paste mode (ctrl-D to finish)

val str = """{"findItemsByKeywordsResponse":[{"ack":["Success"],"version":["1.13.0"],"timestamp":["2018-02-28T09:52:48.736Z"],"searchResult":[{"@count":"1","item":[{"itemId":["273088613147"],"title":["MTG Air Elemental *ALPHA*"],"globalId":["EBAY-ENCA"],"primaryCategory":[{"categoryId":["38292"],"categoryName":["MTG Individual Cards"]}],"galleryURL":["http:\/\/thumbs4.ebaystatic.com\/m\/mrUjH7CtVxARfthfKH3wYAw\/140.jpg"],"viewItemURL":["http:\/\/www.ebay.com\/itm\/MTG-Air-Elemental-ALPHA-\/273088613147"],"paymentMethod":["PayPal"],"autoPay":["false"],"postalCode":["M4S2H7"],"location":["Canada"],"country":["CA"],"shippingInfo":[{"shippingServiceCost":[{"@currencyId":"USD","__value__":"0.0"}],"shippingType":["Free"],"shipToLocations":["Worldwide"],"expeditedShipping":["false"],"oneDayShippingAvailable":["false"],"handlingTime":["1"]}],"sellingStatus":[{"currentPrice":[{"@currencyId":"CAD","__value__":"25.0"}],"convertedCurrentPrice":[{"@currencyId":"USD","__value__":"19.6"}],"sellingState":["Active"],"timeLeft":["P29DT19H50M26S"]}],"listingInfo":[{"bestOfferEnabled":["false"],"buyItNowAvailable":["false"],"startTime":["2018-02-28T05:43:14.000Z"],"endTime":["2018-03-30T05:43:14.000Z"],"listingType":["FixedPrice"],"gift":["false"]}],"returnsAccepted":["false"],"condition":[{"conditionId":["3000"],"conditionDisplayName":["Used"]}],"isMultiVariationListing":["false"],"topRatedListing":["false"]}]}],"paginationOutput":[{"pageNumber":["1"],"entriesPerPage":["100"],"totalPages":["1"],"totalEntries":["1"]}],"itemSearchURL":["http:\/\/www.ebay.com\/sch\/i.html?_nkw=mtg+air+elemental+alpha&_ddo=1&_ipg=100&_pgn=1"]}]}"""


// Exiting paste mode, now interpreting.

str: String = {"findItemsByKeywordsResponse":[{"ack":["Success"],"version":["1.13.0"],"timestamp":["2018-02-28T09:52:48.736Z"],"searchResult":[{"@count":"1","item":[{"itemId":["273088613147"],"title":["MTG Air Elemental *ALPHA*"],"globalId":["EBAY-ENCA"],"primaryCategory":[{"categoryId":["38292"],"categoryName":["MTG Individual Cards"]}],"galleryURL":["http:\/\/thumbs4.ebaystatic.com\/m\/mrUjH7CtVxARfthfKH3wYAw\/140.jpg"],"viewItemURL":["http:\/\/www.ebay.com\/itm\/MTG-Air-Elemental-ALPHA-\/273088613147"],"paymentMethod":["PayPal"],"autoPay":["false"],"postalCode":["M4S2H7"],"location":["Canada"],"country":["CA"],"shippingInfo":[{"shippingServiceCost":[{"@currencyId":"USD","__value__":"0.0"}],"shippingType":["Free"],"shipToLocations":["Worldwide"],"expeditedShi...

scala> val payload = Json.parse(str)
payload: play.api.libs.json.JsValue = {"findItemsByKeywordsResponse":[{"ack":["Success"],"version":["1.13.0"],"timestamp":["2018-02-28T09:52:48.736Z"],"searchResult":[{"@count":"1","item":[{"itemId":["273088613147"],"title":["MTG Air Elemental *ALPHA*"],"globalId":["EBAY-ENCA"],"primaryCategory":[{"categoryId":["38292"],"categoryName":["MTG Individual Cards"]}],"galleryURL":["http://thumbs4.ebaystatic.com/m/mrUjH7CtVxARfthfKH3wYAw/140.jpg"],"viewItemURL":["http://www.ebay.com/itm/MTG-Air-Elemental-ALPHA-/273088613147"],"paymentMethod":["PayPal"],"autoPay":["false"],"postalCode":["M4S2H7"],"location":["Canada"],"country":["CA"],"shippingInfo":[{"shippingServiceCost":[{"@currencyId":"USD","__value__":"0.0"}],"shippingType":["Free"],"shipToLocations":["Worldwide"]...

scala> payload \\ "searchResult"
res7: Seq[play.api.libs.json.JsValue] = List([{"@count":"1","item":[{"itemId":["273088613147"],"title":["MTG Air Elemental *ALPHA*"],"globalId":["EBAY-ENCA"],"primaryCategory":[{"categoryId":["38292"],"categoryName":["MTG Individual Cards"]}],"galleryURL":["http://thumbs4.ebaystatic.com/m/mrUjH7CtVxARfthfKH3wYAw/140.jpg"],"viewItemURL":["http://www.ebay.com/itm/MTG-Air-Elemental-ALPHA-/273088613147"],"paymentMethod":["PayPal"],"autoPay":["false"],"postalCode":["M4S2H7"],"location":["Canada"],"country":["CA"],"shippingInfo":[{"shippingServiceCost":[{"@currencyId":"USD","__value__":"0.0"}],"shippingType":["Free"],"shipToLocations":["Worldwide"],"expeditedShipping":["false"],"oneDayShippingAvailable":["false"],"handlingTime":["1"]}],"sellingStatus":[{"currentPrice...

scala> val searchResult = payload \\ "searchResult"
searchResult: Seq[play.api.libs.json.JsValue] = List([{"@count":"1","item":[{"itemId":["273088613147"],"title":["MTG Air Elemental *ALPHA*"],"globalId":["EBAY-ENCA"],"primaryCategory":[{"categoryId":["38292"],"categoryName":["MTG Individual Cards"]}],"galleryURL":["http://thumbs4.ebaystatic.com/m/mrUjH7CtVxARfthfKH3wYAw/140.jpg"],"viewItemURL":["http://www.ebay.com/itm/MTG-Air-Elemental-ALPHA-/273088613147"],"paymentMethod":["PayPal"],"autoPay":["false"],"postalCode":["M4S2H7"],"location":["Canada"],"country":["CA"],"shippingInfo":[{"shippingServiceCost":[{"@currencyId":"USD","__value__":"0.0"}],"shippingType":["Free"],"shipToLocations":["Worldwide"],"expeditedShipping":["false"],"oneDayShippingAvailable":["false"],"handlingTime":["1"]}],"sellingStatus":[{"curr...

scala> searchResult
res8: Seq[play.api.libs.json.JsValue] = List([{"@count":"1","item":[{"itemId":["273088613147"],"title":["MTG Air Elemental *ALPHA*"],"globalId":["EBAY-ENCA"],"primaryCategory":[{"categoryId":["38292"],"categoryName":["MTG Individual Cards"]}],"galleryURL":["http://thumbs4.ebaystatic.com/m/mrUjH7CtVxARfthfKH3wYAw/140.jpg"],"viewItemURL":["http://www.ebay.com/itm/MTG-Air-Elemental-ALPHA-/273088613147"],"paymentMethod":["PayPal"],"autoPay":["false"],"postalCode":["M4S2H7"],"location":["Canada"],"country":["CA"],"shippingInfo":[{"shippingServiceCost":[{"@currencyId":"USD","__value__":"0.0"}],"shippingType":["Free"],"shipToLocations":["Worldwide"],"expeditedShipping":["false"],"oneDayShippingAvailable":["false"],"handlingTime":["1"]}],"sellingStatus":[{"currentPrice...

thanks a lot for your help. It was really helpfull and simple to understand. :) — Abhinandan Singh, Feb 28 '18 at 11:28

score 0 · Answer 2 · answered Feb 28 '18 at 10:56

Using circe-parser (see also https://circe.github.io/circe/parsing.html how to use it / what to add to your build.sbt), the following snippet will print Right(273088613147), which is the itemId from within searchResult:

import io.circe._, io.circe.parser._

def myParse(jsonString: String) {
  val result = parse(jsonString) match {
    case Left(failure) => println("Invalid JSON :(")
    case Right(json) => {
      val cursor = json.hcursor
      println(cursor.downField("findItemsByKeywordsResponse").downArray.
              downField("searchResult").downArray.
              downField("item").downArray.
              downField("itemId").downArray.as[String])
    }
  }
}

Alternatively, you could have written a case-class for your JSON and then written decoders/encoders for it, but I figured, this is not what you were asking.

extracting data from json in scala

2 Answers2

Scala REPL