Extracting delimited value from json

Anonymous — Wed, 07 Oct 2015 16:16:09 GMT

Hello,
I'm trying to pull some data from json with extractDelimitedFields , not sure how to proceed , or if it's the right course , like in this image:

onedrive.live.com/redir?resid=77E8039C68438481!431&authkey=!AKeUhI1Ktct4Wlc&v=3&ithint=photo%2cpng

Getting json data from a webservice like :
"prod": {
"maj": "2015-08-17 14:51:30",
"code": "109410",
"nom": "name test",
"type_code": "3",
"destination_code": "1,2,3,",
"jours": "8",
"nuits": "7",
"description": " ~ description here",
"prix": "1075",
"thematique_code": "4,14,7,21,"
}

I need to extract the thematic codes delimted from the JSON , look up in another table for example
dp_themes -> which contains the id of the theme, id of the product and the thematic code . I need to get the id of the theme and insert it into a field in dp_produits , any idea how to go about this?

Re: Extracting delimited value from json

Anonymous — Fri, 09 Oct 2015 10:28:41 GMT

You can use tExtracJSONField component to get value from jSON file , output of tExtractJSONField is value of key (or call element) in json file. After that, use tMap to process.
Ex:
json -> tExtrackJsonFiled --> tMap ... (look up table in here).

I am not clear what you want, just give you a component to extract value from jSON file .

Regards,
Luan Huynh

topic Extracting delimited value from json in Talend Studio

Extracting delimited value from json

Re: Extracting delimited value from json