I'm using a couple of scripts to automate a workflow we are using. The workflow is as follows :

A user requests access to a certain system, He or she has to fill in 2 fields, 1 dropdown and 1 multiline. Both are custom fields. Upon submitting the request, SDP asks for an approval to the user's manager. Depending on getting an approval or not, SDP sends an email to the department that grants the access or sends a mail to the user that the approval is denied and in both cases it adds a note with the taken action to the request. We use Powershell for this.

However, when the user uses linebreaks in the multilined field, the script breaks because somehow the API does not accept the JSON, because of the linebreaks. So the script is executed, but nothing happens because of the linebreaks. If we manually remove the linebreaks and run the script again, everything is fine. Due to the amount of tickets that we get, we really like to automate this. Is there a way to use a multilined field with the API. The JSON we are generating is below

1. 
   
2. #=======================================================================
3. # Add Request fields values
   
4. #=======================================================================
   
5. $workorderid = $obj.request.WORKORDERID
   
6. $requester = $obj.request.REQUESTER
   
7. $Systemtyperequest = $obj.request."Tot welk systeem vraag je toegang"
   
8. $Queuename = $obj.request."Welke Queues in Blue heb je nodig?"
   
9. 
   
10. #=======================================================================
11. # Setting Reply settings
    
12. #=======================================================================
13. $replyurl = $sdphost + "sdpapi/request/" + $workorderid
    
14. $replymethod = "POST"
    
15. $replyoperation = "REPLY_REQUEST"
    
16. $Replyreciever = "reciever email"
    
17. #=======================================================================
18. # Configure the textinput for the reply
    
19. #=======================================================================
20. $replydescription = "$requester heeft toegang gevraagd tot het systeem $Systemtyperequest. Hij wil graag toegang tot de volgende queues: $Queuename."
    
21. 
    
22. #=======================================================================
23. #Configure input data for adding a reply
    
24. #=======================================================================
25. $replyinputdata = @"
    
26. {
    
27.     "operation": {
    
28.         "details": {
    
29.             "to": "$Replyreciever",
    
30.             "cc": "",
    
31.             "subject": "[Request ID:##$workorderid##] Aanvraag Toegang Blue/Parley/Obi4wan/Bas",
    
32.             "description": "$replydescription"
    
33.         }
    
34.     }
    
35. }
    
36. "@
    
37. 
    
38. #=======================================================================
39. # Sending Reply
    
40. #=======================================================================
41. $replyparams = @{INPUT_DATA=$replyinputdata;OPERATION_NAME=$replyoperation;TECHNICIAN_KEY=$techkey;format='json'}
    
42. Invoke-WebRequest -Uri $replyurl -Method $replymethod -Body $replyparams
    
43. 
    
44. #=======================================================================
45. # Setting Notes settings
    
46. #=======================================================================
47. $notesurl = $sdphost + "sdpapi/request/" + $workorderid + "/notes"
    
48. $notesmethod = "POST"
    
49. $notesoperation = "ADD_NOTE"
    
50. 
    
51. #=======================================================================
52. # Configure the textinput for the note
    
53. #=======================================================================
54. $notescontent = "$requester wil in het systeem $Systemtyperequest toegang tot de queue $Queuename. De aanvraag is doorgestuurd naar het volgende adres: $Replyreciever"
    
55. 
    
56. #=======================================================================
57. # Configure input data for adding note to request
    
58. #=======================================================================
59. $notesinputdata = @"
    
60. {
    
61.     "operation": {
    
62.         "details": {
    
63.             "notes": {
    
64.                 "note": {
    
65.                     "ispublic": "false",
    
66.                     "notestext": "$notescontent"
    
67.                 }
    
68.             }
    
69.         }
    
70.     }
    
71. }
    
72. "@
    
73. 
    
74. #=======================================================================
75. # Sending Notes
    
76. #=======================================================================
77. $noteparams = @{INPUT_DATA=$notesinputdata;OPERATION_NAME=$notesoperation;TECHNICIAN_KEY=$techkey;format='json'}
    
78. Invoke-WebRequest -Uri $notesurl -Method $notesmethod -Body $noteparams
    
79. 
    

Edit : We are using SDP version 10.0 Build 100200 on Postgres