none
Parsing JSON Object inside Object

    Question

  • I'm trying to parse JSON. Once in the Array I can read the top level properties, but not sub object-properties. In the below example I can read expand, id, self, key. What I’m looking to do is read within the fields object.

    Most of the examples I’ve found so far lead me to JsonTuples, but in this case fields is not an array. Any suggestions?

    Thanks

    {…},
    {
        "expand": …expand…",
        "id": "40432",
        "self": "...url....",
        "key": "...key...",
        "fields": {
            "issuetype": {
            "self": "...url...",
            "id": "111111",
            "description": "....desc....",
            "iconUrl": "...url....",
            "name": "Bug",
            "subtask": false,
            "avatarId": 11111
            }
      }


    @issues=

    EXTRACT

    expand string,

    id string,

    key string

    FROM @LandingZone_File

    USING new Microsoft.Analytics.Samples.Formats.Json.JsonExtractor("$.issues[*]");

    Thursday, November 15, 2018 10:14 PM

Answers

All replies