topic [resolved] tREST with variable in body in Talend Studio

[resolved] tREST with variable in body

Anonymous — Thu, 04 Feb 2016 00:32:07 GMT

Hello,

I am trying to dump my payload into Marketo using Rest so I can specify the partition. I keep getting errors when I do this despite the payload having a valid json schema. Is there any way to use variables from the tWriteJSONField to tflowtoiterate to get it in there. I keep getting an
{"requestId":"","success":false,"errors":[{"code":"609","message":"Unexpected character ('(' (code 40)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')"}]}|
[statistics] disconnected
"{
\"action\":\"createOnly\",
\"lookupField\":\"email\",
\"partitionName\":\"blah\",
\"input\":
((String)globalMap.get('myKey'))
}"

Any ideas on how to do this?

Re: [resolved] tREST with variable in body

Anonymous — Thu, 04 Feb 2016 16:13:29 GMT

Got it figured out! Here is how you do it. This is a good solution for people who find that XML map or JSON schema are not generating per API standard.
[font=Verdana, Helvetica, Arial, sans-serif]"{[/font]
[font=Verdana, Helvetica, Arial, sans-serif] \"action\":\"createOnly\",[/font]
[font=Verdana, Helvetica, Arial, sans-serif] \"lookupField\":\"email\",[/font]
[font=Verdana, Helvetica, Arial, sans-serif] \"partitionName\":\"Swyft\",[/font]
[font=Verdana, Helvetica, Arial, sans-serif] \"input\":"[/font]
[font=Verdana, Helvetica, Arial, sans-serif] +((String)globalMap.get("row3.Payload"))+"[/font]
[font=Verdana, Helvetica, Arial, sans-serif]}"[/font]