Webservice task JSON freetext no longer working

Hi Rod_Pestell,
I haven't encountered this issue myself, but have encountered similar issues when piping in values via Javascript. Sadly my solution won't work for JSON.
"It sounds like the parsing engine has changed behind the scenes and no longer likes a double quote being escaped by a backslash"
This gave me an iea - have you tried inserting without the escape characers? eg:
{"surveyId":"SV_********","resetRecordedDate":"false","embeddedData":"{"GE_T_Apology_Sent":" "Y", GE_T_Apology_Sent_Date:"${"tck://Field/updatedAt"}}}"
Seems ridiculous I know, but if the piped value now includes the double quotes it may work.
Good luck!

Hi Rod_Pestell,
I've just tried it on a dummy workflow and my suggestion did not work. Your initial text with the backslashes did work however. I literally copy pasted it and only changed the Survey ID / response ID.
No idea why yours is not working in this case :S

Hi Rod_Pestell,
I've just tried it after a normal trigger and I think I've found part of your issue.
Recreating your issue as described gave the error. The only things I changed were the survey ID, response ID and the embedded data fields so they matched ones that existed in my test survey.
Trying it with just one embedded data field however got a 200 OK response. It did not actually update the response for some reason, but maybe I have done something wrong.
eg:
// this errors
{"surveyId":"SV_********","resetRecordedDate":"false","embeddedData":"{\\"GE_T_Apology_Sent\\":\\"Y\\", \\"GE_T_Apology_Sent_Date\\":\\"${tck://Field/updatedAt}\\"}"}

// this gets an OK response
{"surveyId":"SV_********","resetRecordedDate":"false","embeddedData":"{\\"GE_T_Apology_Sent\\":\\"Y\\"}"}
Not sure why this happens or how you can solve it, but hopefully it's a piece of the puzzle.

https://community.qualtrics.com/XMcommunity/discussion/comment/49523#Comment_49523From a survey completion trigger. Screenshot below in case anybody else finds their way to this thread. (I am using an embedded field labelled "Result" because that already existed in my survey project).

https://community.qualtrics.com/XMcommunity/discussion/comment/49579#Comment_49579Radam Thanks so much for that pointer - that seems to have got it!! It's now working. I needed to remove he double quotes from the false as that is a boolean but other that that it worked!! :)

Thanks for much Radam and bgooldfed I've been taring my hair out on this one.
I'll come back shortly having done some extra tests and checking to see whether my original coding now works.
Thanks
Rod Pestell

HI aalokjain ,

The body needs to be set to free text and then you need to go back and change the Content-Type field back from plain text to application/json as it changes to plain text when you change the body field.

Then just make sure the JSON string is good and all the doubles quote etc. are paired up.

Hope that helps

Ok what we have discovered is, the carriage return is causing an issue, however other special character issues are resolved.
Original response as below :
-bullet one
second sentence
-second bullet
JSON output which Failed Response for the above entry in comments section :
\\n\\n-bullet one
So anything with \\n\\n is failing as its a carriage return which is not parsing.

Unsure how to overcome that.

Hi All,
I just wanted to update this thread as I'm still having problems (once editing an old task). I think I've discovered what the error message 'Expected param not found' was going on about. I discovered that in the input JSON log of each webservice call, it was injecting a dataTypes field. I discovered this by comparing a webservice that was working last week but as soon as I'd made a change, then this field started to appear in the log. When you use the key-value pairs mode, you are asked to enter the label and variable like you do in the free text mode but also it asks you for the data types. So I think what has happened is that Qualtrics (sometime last year) made a a change and for the free text mode in that you also need to inject the dataType into the free text part of the JSON string.

There doesn't seem to be any info from Qualtrics about how you do this. I've raised a ticket but not expecting much so reaching out here aswell. My question is how do you inject the dataTypes parameter into the free text version of the JSON string?

I'm able to get this dataType part populated via using the key-value pairs but am not sure how it gets populated by the normal free text approach


This is the webservice that I mnaged to get back working using the Key-value paris (I'd prefer to use the free text mode though)

and this is how the input JSON log is now

Thanks

Rod Pestell

// when using double quotes JS does not allow multi line text to be placed between them
// this can cause errors if you hand over a value with line breaks 
const myErrorProneValue = "${e://Field/myField}";

// when using single quotes JS does not allow multi line text to be placed between them
// this can cause errors if you hand over a value with line breaks 
const myErrorProneValue = '${e://Field/myField}';

// when using back ticks JS allows multi line text to be placed between them
// this will not cause errors for values containing line breaks
const myWorkingValue = `${e://Field/myField}`;

Also, if there are multiline text to be piped in the webservice then free-text format then we can also use code task to first JSON.stringify the text and then pipe this result without quotes in the Web service JSON body.