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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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]