WebService task returns all values in one field - How do I separate them?

Question

I am working on creating a workflow to pull data into Qualtrics using a WebService Task. This task pulls the information over successfully, but all the information is in one fieldExample of the input to the CodeTask:{ "payload": { "actionId": "OCAC_g2EK1VxwCCGSZ8I", "chain": { "OCAC_zRzvocU2ECXfhLX": { "$.issues": "[{"id":92516,"project":{"id":183,"name":"Service Requests"},"tracker":{"id":17,"name":"IT - Service Request"},"status":{"id":18,"name":"Closed","is_closed":true},"css_classes":"issue tracker-17 status-18 priority-12 priority-default closed multieditable-container","priority":{"id":12,"name":"Normal"},"author":{"id":255,"name":"Name Name"},"assigned_to":{"id":119,"name":"Name Name"},"subject":"FW: Vehicle 5487","description":"

From: PD Repairs
Sent: Wednesday, October 16, 2024 11:03 AM
To: Names of those on email
Subject: FW: Vehicle 5487

From: Name Name
Sent: Wednesday, October 16, 2024 11:03:21 AM (UTC-06:00) Central Time (US & Canada)
To: PD Repairs
Subject: Vehicle 5487
This morning I attempted to start vehicle 5487 and the computer would not turn on. I attempted multiple times with the vehicle running and received no response from the power button.

Hopefully it was just the cold weather. The keys are on the board.

Thank you,
Officer Name

Get Outlook for iOS

","start_date":"2024-10-16","due_date":null,"done_ratio":100,"is_private":false,"is_favorited":false,"estimated_hours":null,"easy_email_to":"someone@here.org","easy_email_cc":"department@here.org","custom_fields":[{"id":471,"name":"Name Name","internal_name":null,"field_format":"easy_lookup","value":2286,"url":"https://someurl.gov/users/2286/profile.json"},{"id":407,"name":"IT Category","internal_name":null,"field_format":"list","value":"Hardware"},{"id":408,"name":"IT Subcategory","internal_name":null,"field_format":"dependent_list","value":"Workstation"},{"id":396,"name":"Associated Workstation(s)","internal_name":null,"multiple":true,"field_format":"easy_lookup","value":[]},{"id":395,"name":"Associated Server(s)","internal_name":null,"multiple":true,"field_format":"easy_lookup","value":[]},{"id":397,"name":"Associated Network Equipment","internal_name":null,"multiple":true,"field_format":"easy_lookup","value":[]},{"id":398,"name":"Associated Storage System(s)","internal_name":null,"multiple":true,"field_format":"easy_lookup","value":[]},{"id":405,"name":"Associated Solution","internal_name":null,"multiple":true,"field_format":"easy_lookup","value":[]}],"created_on":"2024-10-16T18:00:16Z","updated_on":"2024-10-16T21:48:07Z","closed_on":"2024-10-16T21:48:07Z"},{"id":92513,"project":{"id":183,"name":"Service Requests"},"tracker":{"id":17,"name":"IT - Service Request"},"status":{"id":18,"name":"Closed","is_closed":true},"css_classes":"issue tracker-17 status-18 priority-12 priority-default closed multieditable-container","priority":{"id":12,"name":"Normal"},"author":{"id":807,"name":"Name Name"},"assigned_to":{"id":110,"name":"Name name"},"subject":"Rename holds = \"CONDITIONS OF APPROVAL\"","description":"

Hello Name,

Can you go in and rename all of our holds:

Example:
“Conditions of Approval – CODES” to “Conditions of Occupancy – CODES”
“Conditions of Approval – FIRE” to “Conditions of Occupancy – FIRE”
Etc. for all 7 departments plus Public Art as well.

Change the word Approval to Occupancy.

Thanks buddy.

Name Name CBO
Chief Building Official
(913) 971-9811 | OlatheKS.org
Building Codes Division - City of Olathe, Kansas
Setting the Standard for Excellence in Public Service

","start_date":"2024-10-16","due_date":null,"done_ratio":100,"is_private":false,"is_favorited":false,"estimated_hours":null,"easy_email_to":"someone@here.org","easy_email_cc":"someone@here.org, department@here.org","custom_fields":[{"id":471,"name":"Name Name","internal_name":null,"field_format":"easy_lookup","value":807,"url":"https://someurl.gov/users/807/profile.json"},{"id":407,"name":"IT Category","internal_name":null,"field_format":"list","value":"Solution"},{"id":408,"name":"IT Subcategory","internal_name":null,"field_format":"dependent_list","value":"Energov"},{"id":396,"name":"Associated Workstation(s)","internal_name":null,"multiple":true,"field_format":"easy_lookup","value":[]},{"id":395,"name":"Associated Server(s)","internal_name":null,"multiple":true,"field_format":"easy_lookup","value":[]},{"id":397,"name":"Associated Network Equipment","internal_name":null,"multiple":true,"field_format":"easy_lookup","value":[]},{"id":398,"name":"Associated Storage System(s)","internal_name":null,"multiple":true,"field_format":"easy_lookup","value":[]},{"id":405,"name":"Associated Solution","internal_name":null,"multiple":true,"field_format":"easy_lookup","value":[]}],"created_on":"2024-10-16T17:00:24Z","updated_on":"2024-10-16T20:59:01Z","closed_on":"2024-10-16T20:59:01Z"}]; issues = JSON.parse(issues); // Assuming the issues are returned as a string, parse them into an object // Ensure we have issues to process if (!Array.isArray(issues) || issues.length === 0) { return { result: "No issues to process" }; } // Retrieve the index from embedded data var indexStr = ~{e://Field/current_issue_index}; var index = parseInt(indexStr || 0); // Convert to number and ensure it's valid // Check the bounds of the index to avoid out-of-range errors if (index >= issues.length) { return { result: "No more issues to process" }; } // Extract the current issue from the list var currentIssue = issues[index]; // Handle missing properties with a fallback to empty strings or default values var projectName = currentIssue.project ? currentIssue.project.name : ""; var trackerName = currentIssue.tracker ? currentIssue.tracker.name : ""; var status = currentIssue.status ? currentIssue.status.name : ""; var priority = currentIssue.priority ? currentIssue.priority.name : ""; var author = currentIssue.author ? currentIssue.author.name : ""; var assignedTo = currentIssue.assigned_to ? currentIssue.assigned_to.name : ""; var subject = currentIssue.subject || ""; var description = currentIssue.description || ""; var startDate = currentIssue.start_date || ""; var dueDate = currentIssue.due_date || null; var doneRatio = currentIssue.done_ratio || 0; var isPrivate = currentIssue.is_private || false; var isFavorited = currentIssue.is_favorited || false; var estimatedHours = currentIssue.estimated_hours || null; var easyEmailTo = currentIssue.easy_email_to || ""; var createdOn = currentIssue.created_on || ""; var updatedOn = currentIssue.updated_on || ""; var closedOn = currentIssue.closed_on || ""; // Extract custom fields var internalName = ""; var itCategory = ""; var itSubcategory = ""; var associatedWorkstation = ""; var associatedServer = ""; var associatedNetworkEquipment = ""; var associatedStorageSystem = ""; var associatedSolution = ""; if (currentIssue.custom_fields) { for (var i = 0; i < currentIssue.custom_fields.length; i++) { var field = currentIssue.custom_fields; if (field.id === 471) { internalName = field.name; } else if (field.id === 407) { itCategory = field.value; } else if (field.id === 408) { itSubcategory = field.value; } else if (field.id === 396) { associatedWorkstation = field.value; } else if (field.id === 395) { associatedServer = field.value; } else if (field.id === 397) { associatedNetworkEquipment = field.value; } else if (field.id === 398) { associatedStorageSystem = field.value; } else if (field.id === 405) { associatedSolution = field.value; } } } // Return the extracted fields var result = { projectName: projectName, trackerName: trackerName, status: status, priority: priority, author: author, assignedTo: assignedTo, subject: subject, description: description, startDate: startDate, dueDate: dueDate, doneRatio: doneRatio, isPrivate: isPrivate, isFavorited: isFavorited, estimatedHours: estimatedHours, easyEmailTo: easyEmailTo, internalName: internalName, itCategory: itCategory, itSubcategory: itSubcategory, associatedWorkstation: associatedWorkstation, associatedServer: associatedServer, associatedNetworkEquipment: associatedNetworkEquipment, associatedStorageSystem: associatedStorageSystem, associatedSolution: associatedSolution, createdOn: createdOn, updatedOn: updatedOn, closedOn: closedOn }; // Increment the index for the next loop Qualtrics.SurveyEngine.setEmbeddedData('current_issue_index', index + 1); // Return the result to the Qualtrics Web Service Task return result; } ", "contextId": "SV_5nGzDiAvJg5xTLw", "createdAt": 1729192655853, "customSaveHandler": true, "dependencies": { "OCAC_zRzvocU2ECXfhLX": [ "$.issues" ] }, "dynamic": false, "elementConfigured": true, "exports": [ { "display_name": "result", "key": "result" }, { "display_name": "projectName", "key": "projectName" }, { "display_name": "trackerName", "key": "trackerName" }, { "display_name": "status", "key": "status" }, { "display_name": "priority", "key": "priority" }, { "display_name": "author", "key": "author" }, { "display_name": "assignedTo", "key": "assignedTo" }, { "display_name": "subject", "key": "subject" }, { "display_name": "description", "key": "description" }, { "display_name": "startDate", "key": "startDate" }, { "display_name": "dueDate", "key": "dueDate" }, { "display_name": "doneRatio", "key": "doneRatio" }, { "display_name": "isPrivate", "key": "isPrivate" }, { "display_name": "isFavorited", "key": "isFavorited" }, { "display_name": "estimatedHours", "key": "estimatedHours" }, { "display_name": "easyEmailTo", "key": "easyEmailTo" }, { "display_name": "internalName", "key": "internalName" }, { "display_name": "itCategory", "key": "itCategory" }, { "display_name": "itSubcategory", "key": "itSubcategory" }, { "display_name": "associatedWorkstation", "key": "associatedWorkstation" }, { "display_name": "associatedServer", "key": "associatedServer" }, { "display_name": "associatedNetworkEquipment", "key": "associatedNetworkEquipment" }, { "display_name": "associatedStorageSystem", "key": "associatedStorageSystem" }, { "display_name": "associatedSolution", "key": "associatedSolution" }, { "display_name": "createdOn", "key": "createdOn" }, { "display_name": "updatedOn", "key": "updatedOn" }, { "display_name": "closedOn", "key": "closedOn" } ], "icon": "https://www.xm-apps-static.com/assets/v1/APP_20aaddb5-1229-49f4-a0c2-25d1f72755ec/0.19.5/2ZlemZontaWGTTzN/images/logo.svg", "id": "PLUG_82724be1-02e7-44f9-a774-3f49a08b4a7a", "keyvalues": [], "metadata": { "lazyLoadPipedText": true, "tags": [ "wf-schematized", "survey" ], "worker": { "type": "runner" } }, "name": "Code", "outcomeId": "OC_W7mSij3gGEjUMfi", "ownerObject": { "brandId": "olathecx", "orgId": "olathecx", "userId": "UR_4MB9nKybyV0iwYZ" }, "replacementAppId": "", "summary": "Pull as an array", "surveyId": "SV_5nGzDiAvJg5xTLw", "taskNumber": 7, "taskRegistryId": "APP_20aaddb5-1229-49f4-a0c2-25d1f72755ec", "triggerAction": "CodeTask", "updatedAt": 1729194572352, "workspaceId": "SV_5nGzDiAvJg5xTLw", "workspaceType": "survey" }, "user": { "userId": "UR_4MB9nKybyV0iwYZ", "brandId": "olathecx" }, "executionData": { "workflowId": "MTW_3EhCGuTLAAOjTnJ-OC_W7mSij3gGEjUMfi", "runId": "", "actionId": "OCAC_g2EK1VxwCCGSZ8I", "contextId": "SV_5nGzDiAvJg5xTLw", "uniqueId": "MTW_3EhCGuTLAAOjTnJ", "outcomeId": "OC_W7mSij3gGEjUMfi", "taskToken": null, "attempt": 0, "orchestrator": "TEMPORAL" }, "policies": {} }This is the input into the Code Task when the workflow is run. I cannot figure out the correct javascript for the Code task to separate all the fields like below so they can be mapped into the feedback survey:THIS IS NOT FROM THE ABOVE DATA BUT A DIFFERENT DATE SO THE VALUES WILL NOT MATCH."projectName": "Service Requests","trackerName": "IT Service Requests","status": "Closed","priority": "Normal","author":"Name Name","assigned_to": "Name Name","subject": "Unblock Name Name Microsoft Office 365 Account","description": "

Plese Unblock Name Name Microsoft Office 365 Account

","start_date": ""2024-09-06","due_date": null,"done_ratio": 100,"is_private": false,"is_favorited": false,"estimated_hours": null,"easy_email_to": "someone@here.ORG","internal_name": "Someone","IT Category": "Solution","IT Subcategory": "Office 365","Associated Workstation(s)": "","Associated Server(s)": "","Associated Network Equipment": "","Associated Storage System(s)": "","Associated Solution": "","created_on":"2024-09-06T13:52:29Z","updated_on":"2024-09-23T14:24:22Z","closed_on":"2024-09-23T14:24:22Z"

Nam Nguyen · Answer

@SandraHIt’s a JSON object with multiple layer and the webservice task already offer an path to save the return message as pipe-text to use later. Just use the test function in the Webservice task and go down layer by layer, each seperated by a “.”For example, to pipe in userID in your: Code will be$.user.userIdAdd custom path to get a specific fieldYou should use some JSON formater i.e:jsoneditoronline.orgto get a better structured look at the objectAlso, the JSON you put up here missing a “}”. This task is coding/tech heavy, so ask your IT guys if you have one.

Leave a Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded