Within our SW Web Help Desk, I have a JSON file (below) to import code into the helpdesk and everything is populating as expected into WHD, except for 1 field.
{
"reportDateUtc": "date here from variable",
"emailClient": false,
"emailTech": false,
"emailTechGroupLevel": false,
"emailGroupManager": false,
"emailCc": false,
"imsservicedesk@stjames.ie": "",
"emailBcc": false,
"imsservicedesk@stjames.ie": "",
"subject": "",
"detail": "Details go Here from Variable,
"assignToCreatingTech": false,
"problemtype": {
"type": "Passwords / Access / Folders",
"id": 525
},
"sendEmail": false,
"location": {
"type": "Location",
"id": "Location ID from variable"
},
"clientReporter": {
"type": "Client",
"id": "client ID from variable"
},
"customField_14": "custom field from variable",
"customField_18": "custom field from variable",
"room": "MID8 IMS Technical Support (Hospital 1)",
"notes": "notes field from variable",
"ClientNotes": "notes field from variable",
"customField_49": "No",
"statustype": {
"type": "StatusType",
"id": 1
},
"prioritytype": {
"type": "PriorityType",
"id": 3
}
}
The VB code I'm using that builds the above JSON.
Dim objXmlHttpMain , URL
strJSONToSend = "{""reportDateUtc"": """&varWHDDATETIME&""", ""emailClient"": false, ""emailTech"": false, ""emailTechGroupLevel"": false, ""emailGroupManager"": false, ""emailCc"": false, ""imsservicedesk@stjames.ie"": """", ""emailBcc"": false, ""imsservicedesk@stjames.ie"": """", ""subject"": """", ""detail"": """&varREQUESTDETAILS&""" , ""assignToCreatingTech"": false, ""problemtype"": { ""type"": ""Passwords / Access / Folders"", ""id"": 525 }, ""sendEmail"": false, ""location"": {""type"": ""Location"", ""id"": """&varWHD_Location_ID&""" }, ""clientReporter"": { ""type"": ""Client"", ""id"": """&varCLIENT_ID&""" }, ""customField_14"": """&varREQEXT&""", ""customField_18"": """&varLOGONS&""", ""room"": ""MID8 IMS Technical Support (Hospital 1)"", ""notes"": """&varREQEXT&""", ""ClientNotes"": """&varREQEXT&""", ""customField_49"": ""No"", ""statustype"": { ""type"": ""StatusType"", ""id"": 1 }, ""prioritytype"": { ""type"": ""PriorityType"", ""id"": 3 }}"
apiKey = "You don't get to see my API key"
URL="http://imsservicedesk/helpdesk/WebObjects/Helpdesk.woa/ra/Tickets?apiKey=" & apiKey
Set objXmlHttpMain = CreateObject("Msxml2.ServerXMLHTTP")
on error resume next
objXmlHttpMain.open "POST",URL, False
objXmlHttpMain.setRequestHeader "Authorization", "Bearer " & apiKey
objXmlHttpMain.setRequestHeader "Content-Type", "application/json"
objXmlHttpMain.send strJSONToSend
set objJSONDoc = nothing
set objResult = nothing
I am trying to populate the "Notes" Box, but no matter what option I use: notes
, TechNotes
, shortDetail
, latestNote
, TicketNotes
, ClientNotes
- nothing appears to populate.
I have been on to support team who have advised to try THWACK to see if anyone can help.