Need help in Json extract on dynamic array name

[madhav_talend]

Hi team ,

I have a json file like  below

{"profileSchema": {
    "fields": {
      "startYear": {
        "required": false,
        "type": "Int",
        "allowNull": true,
        "writeAccess": "server"
      },
      "Subject": {
        "required": false,
        "type": "Varchar",
        "allowNull": true,
        "writeAccess": "server"
      }      }      }      }

Need an output like

Column Name	required	type	allowNull	writeAccess
startYear	false	lnt	true	server
Subject	false	Varchar	true	server

   I tried using textractjson  , but getting issues on extracting the object name/array name for   column name field. Need some help here.

Thanks in Advance

[Anonymous]

Take a look at this post (https://community.talend.com/t5/Design-and-Development/Parse-hashmap-inside-a-json/m-p/133006). You will need to read all of the posts I  (and the person asking the question) posted and be able to work with a bit of Java. Unfortunately this is not possible just using Talend components. Example code can be found on this post and it shouldn't be difficult for you to work with if you know a bit of Java. Any questions, just ask 🙂