I want to retrieve json object into a listview. But i can't reach any of them

Hello,
I have a json file. i want to get every inner_title and title_name of json file but i can't reach it. I tried many ways and i still got nothing. Here is the program


{
  "industry": {
    "language": [
      {
        "lan": "TR",
        "title": [
          {
            "title_name": "Starting",
            "inner_title": [
              {
                "name": "Introduction",
                "description": ""
              },
              {
                "name": "Hardware",
                "description": ""
              }
            ]
          },
          {
            "title_name": "Stations",
            "inner_title": {
              "name": "AR/RS for Palettes",
              "description": ""
            }
          },
          {
            "inner_title": [
              {
                "name": "Robot Assembly",
                "description": ""
              },
              {
                "name": "Basic Module Branch and Linear",
                "description": ""
              }
            ],
            "title_name": "Base Modules"
          },
          {
            "title_name": "Application Modules",
            "inner_title": [
              {
                "name": "Camera",
                "description": ""
              },
              {
                "name": "Heat Tunnel",
                "description": ""
              },
              {
                "name": "Magazine",
                "description": ""
              },
              {
                "name": "Press",
                "description": ""
              }
            ]
          },
          {
            "title_name": "Robotino",
            "inner_title": {
              "name": "Robotino CP-Factory",
              "description": ""
            }
          }
        ]
      },{
        "lan": "EN",
        "title": [
          {
            "title_name": "Starting",
            "inner_title": [
              {
                "name": "Introduction",
                "description": ""
              },
              {
                "name": "Hardware",
                "description": ""
              }
            ]
          },
          {
            "title_name": "Stations",
            "inner_title": {
              "name": "AR/RS for Palettes",
              "description": ""
            }
          },
          {
            "inner_title": [
              {
                "name": "Robot Assembly",
                "description": ""
              },
              {
                "name": "Basic Module Branch and Linear",
                "description": ""
              }
            ],
            "title_name": "Base Modules"
          },
          {
            "title_name": "Application Modules",
            "inner_title": [
              {
                "name": "Camera",
                "description": ""
              },
              {
                "name": "Heat Tunnel",
                "description": ""
              },
              {
                "name": "Magazine",
                "description": ""
              },
              {
                "name": "Press",
                "description": ""
              }
            ]
          },
          {
            "title_name": "Robotino",
            "inner_title": {
              "name": "Robotino CP-Factory",
              "description": ""
            }
          }
        ]
      }
]
  }
}

How's this?



Titles Capture
table_extractor.aia (9.2 KB)


But I want to categorize them. For example i want to get for only pages TR-Titles after i click on the item of titles i want to go inner titles of them. In the main page i want to choose which language do you want to choose something like that. How can i solve them?

Your json has an irregular pattern to it, which makes it difficult to parse as json (with the tools we have). Therefore parsing as text may be the most direct option.

Once you have the desired columns in a table, you can use row selection filters from this project: