topic Re: Expresion json in tmap in Talend Studio

Expresion json in tmap

Anonymous — Thu, 22 Mar 2018 18:54:28 GMT

Hello,
I would like to send a json expression (in tMap) to a tRest for a PUT message but I have an error:

My expression JSON:

"{\"EntityList\": \"[\""+"

"{\"EntityName\": \"lead\","+"\"Id": \""+Var.var1+"\","+"\"Attributes\":\"[\""+"

"{\"Name\" : \"crmvi_opt\","+"\"Type\" : \"integer\","+"\"Value\" : \"0\""+"}""+"

\"]\""+"}""\"]\""+"}"

Re: Expresion json in tmap

Anonymous — Thu, 22 Mar 2018 22:14:15 GMT

You are putting quotes around the wrong sections. For example, arrays ([...]) do not need quotes around them. I believe your code should look more like this....

"{\"EntityList\": [{\"EntityName\": \"lead\","+"\"Id\": \""+Var.var1+"\","+"\"Attributes\":[{\"Name\" : \"crmvi_opt\",\"Type\" : \"integer\",\"Value\" : \"0\"}]}]}"