Need help in Json extract on dynamic array name

madhav_talend — Sat, 16 Nov 2024 07:37:03 GMT

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

Re: Need help in Json extract on dynamic array name

Anonymous — Thu, 20 Sep 2018 17:39:26 GMT

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 🙂

topic Re: Need help in Json extract on dynamic array name in Talend Studio

Need help in Json extract on dynamic array name

Re: Need help in Json extract on dynamic array name