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:
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?
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 .
