Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?