Reading value from JSON string Scala using ScalaJson

Question

I have a JSON response as follow

{
  ......,

  "phoneNumbers":[
   {
    "info":[

  ],
  "phoneNumber":"1234567890",
  "phoneNumberType":"HOME_NUMBER"
 },
 {
  "info":[

  ],
  "phoneNumber":"9876543210",
  "phoneNumberType":"WORK_NUMBER"
 },
 {
  "info":[

  ],
  "phoneNumber":"7418529630",
  "phoneNumberType":"MOBILE_NUMBER"
 }
],

.......

}

I need to extract mobile number and I try like this

  val jsonBody = Json.parse(phoneListResponse.body)
  val phoneList: Seq[JsValue] = (jsonBody \\ "phoneNumbers")
  val mobileNodes: Seq[JsValue] = phoneList.filter(number => {
   (number \\ "phoneNumberType").head.asInstanceOf[JsString].value == "MOBILE_NUMBER"
  })
  (mobileNodes.head \\ "phoneNumber").head.asInstanceOf[JsString].value

But my mobileNodes is empty. Any suggestion?

What json lib are you using? That could be a number of them (I've lost count of how many json libs Scala+Java has.) — wheaties
– wheaties, Commented Sep 12, 2016 at 18:42

Nagarjuna Pamu · Accepted Answer · 2016-09-12 19:05:51Z

1

If you are using Play-json

val phoneList: Seq[String] = 
 ((jsonBody \\ "phoneNumbers")(0).as[List[JsValue]])
 .filter(x => (x \ "phoneNumberType").as[String] == "MOBILE_NUMBER")
 .map(x => (x \ "phoneNumber").as[String])

REPL output

scala>  ((json \\ "phoneNumbers")(0).as[List[JsValue]]).foreach(println)
{"info":[],"phoneNumber":"1234567890","phoneNumberType":"HOME_NUMBER"}
{"info":[],"phoneNumber":"9876543210","phoneNumberType":"WORK_NUMBER"}
{"info":[],"phoneNumber":"7418529630","phoneNumberType":"MOBILE_NUMBER"}

scala>  ((json \\ "phoneNumbers")(0).as[List[JsValue]]).filter(x => (x \ "phoneNumberType").as[String] == "MOBILE_NUMBER")
res31: List[play.api.libs.json.JsValue] = List({"info":[],"phoneNumber":"7418529630","phoneNumberType":"MOBILE_NUMBER"})

scala>  ((json \\ "phoneNumbers")(0).as[List[JsValue]]).filter(x => (x \ "phoneNumberType").as[String] == "MOBILE_NUMBER").map(x => (x \ "phoneNumber").as[String])
res32: List[String] = List(7418529630)

edited Sep 12, 2016 at 19:05

answered Sep 12, 2016 at 18:46

Nagarjuna Pamu

14.8k3 gold badges24 silver badges41 bronze badges

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

3 Comments

αƞjiβ Over a year ago

Still phoneList is empty.

Nagarjuna Pamu Over a year ago

@αƞjiβ here is the repl output for step wise execution

Nagarjuna Pamu Over a year ago

@αƞjiβ I have edited the answer Please notice the (0)

Collectives™ on Stack Overflow

Reading value from JSON string Scala using ScalaJson

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related