I'm querying Google Sheets and am not quite sure h...

# serialization

[crummy]

I'm querying Google Sheets and am not quite sure how to build an object to deserialize this:

{
  "values": [
    [
      "Plums",
      5
    ],
    [
      "Apples"
      4
    ]
  ]
}

If the quantities were strings I'd do values: List<List<String>> but this fails with Expected string literal. Can I do this?

[turansky]

List<List<Any>> - as is contract

[turansky]

Alternative - custom serializer

[crummy]

With Any I get Serializer has not been found for type "Any"

[turansky]

Is it fixed tuple?

[turansky]

[String, Int] ?

[crummy]

Yeah - there are actually four fields in there, but they are always the same like that

[turansky]

Custom serializer looks like best solution if you want data class like this:

data class Row(
    val name: String,
    val count: Int 
)

[turansky]

values: List<Row>

[crummy]

hmm, then I get:

kotlinx.serialization.json.JsonDecodingException: Unexpected JSON token at offset 78: Expected '{, kind: CLASS'.

[turansky]

Do you write custom serializer?

[crummy]

ah - I missed that bit. Thought it might be automatic. OK, I'll look into that, thanks.

[Paul Woitaschek]

Off topic, but that's a * json format

[turansky]

@Paul Woitaschek What does it mean?

[Paul Woitaschek]

That having an array of sth random is hard to parse, so that's a bad api

[crummy]

I thought the same. But it is coming from google sheets so an array of arrays kind of makes sense.

[Paul Woitaschek]

Ah that is a sheet, that makes sense

[sandwwraith]

You can try to set isLenient = true in json configuration. It makes parser more flexible and allows to parse non-quoted literals as strings