Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] tREST with variable in body

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?  

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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]

View solution in original post

1 Reply
Anonymous
Not applicable
Author

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]