topic Re: Extract name of JSON fields in Talend Studio

Extract name of JSON fields

Anonymous — Thu, 22 Jun 2017 16:04:59 GMT

Hi all,

imagine the following JSON schema:

{
   ...
   
   "structure" : {
      "time_field" : {
         "date" : {
            "name" : "Date",
            "type" : "datetime"
         }
      },
      "dimensions" : {
         "campaign_id" : {
            "access" : true,
            "name" : "Campaign ID",
            "type" : "id",
         },
         "campaign_name" : {
            "name" : "Campaign Name",
            "maxLength" : 256,
            "type" : "string"
         },
         "strategy_id" : {
            "access" : true,
            "name" : "Strategy ID",
            "type" : "id"
         },
         "strategy_name" : {
            "name" : "Strategy Name",
            "maxLength" : 256,
            "type" : "string"
         }
      },
	  
      ...
}

Now I need to extract the name of each dimension (campaign_id, strategy_id etc.).

This is my try via tExtractJSONFields:

But I only get the name of the first dimension (campaign_id).

Could you please help?

Thanks

Simon

Re: Extract name of JSON fields

Anonymous — Fri, 23 Jun 2017 03:19:19 GMT

Hello
You should define 4 columns to map each name. I would suggest you to define a Json metadata following the wizard under Repository->Metadata.

Regards
Shong

Re: Extract name of JSON fields

Anonymous — Mon, 26 Jun 2017 19:50:40 GMT

Hi,

I solved this one on my own:

Thanks anyway!

Re: Extract name of JSON fields

Anonymous — Mon, 26 Jun 2017 19:56:33 GMT

Interesting.

Re: Extract name of JSON fields

Anonymous — Tue, 27 Jun 2017 08:25:34 GMT

Right! I can now iterate over each dimension name which is really helpful facing the fact that I've to process json files with about 50 dimension elements - no separate (static) columns needed.