Creating a CSV table from nested array values

[F_Quint]

Hi all, 

I'm trying to create a flow that will extract the evaluations of some agents completed by an evaluator and send this as a CSV table.

what I'm trying to extract from these nested arrays is agent id, questionid & score.  This is what the JSON looks like in tree view. 

here's what I've done so far. 

but I'm stumped on how to remove the \ for  agents and questionid output.

also agents come out as an array and I'm only interested in getting the id.

"agent": {
          "id": "2375389f-987f-4e06-82c1-c6878fd8dce8",
          "selfUri": "/api/v2/users/2375389f-987f-4e06-82c1-c6878fd8dce8"
        }

here's the sample JSON. any help will be greatly appreciated!!

{
  "entities": [
    {
      "id": "5fbc0cdf-b19c-4b52-b870-8d4426683ca4",
      "conversation": {
        "id": "4e82d021-64c9-4aee-8d8a-f496e09d2508",
        "selfUri": "/api/v2/conversations/4e82d021-64c9-4aee-8d8a-f496e09d2508"
      },
      "evaluationForm": {
        "id": "c3f388c3-49b5-4862-8f0c-c0f37756a34b",
        "name": "SSC Standard Evaluation Form",
        "published": true,
        "selfUri": "/api/v2/quality/publishedforms/evaluations/c3f388c3-49b5-4862-8f0c-c0f37756a34b"
      },
      "evaluator": {
        "id": "4cdc2d34-9945-4a9a-90eb-15b07959c677",
        "selfUri": "/api/v2/users/4cdc2d34-9945-4a9a-90eb-15b07959c677"
      },
      "agent": {
        "id": "2375389f-987f-4e06-82c1-c6878fd8dce8",
        "selfUri": "/api/v2/users/2375389f-987f-4e06-82c1-c6878fd8dce8"
      },
      "status": "FINISHED",
      "answers": {
        "totalScore": 94.230774,
        "totalCriticalScore": 0,
        "totalNonCriticalScore": 94.230774,
        "questionGroupScores": [
          {
            "questionGroupId": "df4ffd43-df77-40d4-8a0e-ed48140cd03a",
            "totalScore": 32,
            "maxTotalScore": 32,
            "markedNA": false,
            "totalCriticalScore": 0,
            "maxTotalCriticalScore": 0,
            "totalNonCriticalScore": 32,
            "maxTotalNonCriticalScore": 32,
            "totalScoreUnweighted": 8,
            "maxTotalScoreUnweighted": 8,
            "totalCriticalScoreUnweighted": 0,
            "maxTotalCriticalScoreUnweighted": 0,
            "totalNonCriticalScoreUnweighted": 8,
            "maxTotalNonCriticalScoreUnweighted": 8,
            "questionScores": [
              {
                "questionId": "ac8fe92f-8f82-48c8-997e-cec2545c86db",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "82bc4c8a-3b4e-4bbb-b606-9ac423036349",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "d1b294ce-02f7-4bd6-8a54-12184c6cb7f7",
                "answerId": "ee58a96d-7bef-41ca-90e1-b73cf3d7a6c1",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "ae7b6608-cc80-41d0-aa43-c36d084911c5",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "adb2d8eb-17b6-4419-80ba-0dea55aec578",
                "answerId": "6d91daba-2dd6-406f-817c-a75e17bd750b",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Caller had errors checking in a EP companion, you were able to process for them."
              }
            ]
          },
          {
            "questionGroupId": "68f9eaba-0e66-4d4e-b4dd-92e1fb4ad1dd",
            "totalScore": 17,
            "maxTotalScore": 20,
            "markedNA": false,
            "totalCriticalScore": 0,
            "maxTotalCriticalScore": 0,
            "totalNonCriticalScore": 17,
            "maxTotalNonCriticalScore": 20,
            "totalScoreUnweighted": 17,
            "maxTotalScoreUnweighted": 20,
            "totalCriticalScoreUnweighted": 0,
            "maxTotalCriticalScoreUnweighted": 0,
            "totalNonCriticalScoreUnweighted": 17,
            "maxTotalNonCriticalScoreUnweighted": 20,
            "questionScores": [
              {
                "questionId": "305c72c7-1117-49d9-9531-630e40c3544d",
                "answerId": "c7ac1930-f396-4713-a402-c912df94f603",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Great job using the callers name"
              },
              {
                "questionId": "74ffd71b-14f4-4f82-b6f6-5df87372254e",
                "answerId": "cbfecb3f-9c6b-45ba-bf03-18b172e2c3bb",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "The background noise was distracting but you did a great job staying focused on the callers needs."
              },
              {
                "questionId": "591be936-d3ce-44d7-97da-793ccca29ce1",
                "answerId": "a663b038-4396-4f0c-9f22-07d8e9c6c75a",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Caller was distracted and you had some short answers at the end of the call."
              },
              {
                "questionId": "a136ffd4-c06b-45b6-9609-8103dbe19de7",
                "answerId": "7d2bcc5c-6a90-41f1-bd8e-3b7472558095",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Good job providing essential information"
              },
              {
                "questionId": "359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5",
                "answerId": "7e415064-8e24-4879-8304-65de477264e9",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "No options with this call."
              }
            ]
          }
        ],
        "anyFailedKillQuestions": false,
        "comments": "Good call overall. Nice job using the callers name.  The caller was creating the issue by not having the EP checked in before checking in the companion.  You avoided confrontation and kept the call moving. Good job!"
      },
      "agentHasRead": false,
      "assignedDate": "2021-05-11T02:19:15.198Z",
      "changedDate": "2021-05-14T23:53:57.795Z",
      "mediaType": [
        "CALL"
      ],
      "conversationDate": "2021-05-08T16:39:32.704Z",
      "conversationEndDate": "2021-05-08T16:45:22.637Z",
      "neverRelease": true,
      "selfUri": "/api/v2/quality/conversations/4e82d021-64c9-4aee-8d8a-f496e09d2508/evaluations/5fbc0cdf-b19c-4b52-b870-8d4426683ca4"
    },
    {
      "id": "6459e07f-1d73-43d6-a814-cb8c82b68cb4",
      "conversation": {
        "id": "0331d4ce-58c9-40d0-8656-aba4a4695d25",
        "selfUri": "/api/v2/conversations/0331d4ce-58c9-40d0-8656-aba4a4695d25"
      },
      "evaluationForm": {
        "id": "c3f388c3-49b5-4862-8f0c-c0f37756a34b",
        "name": "SSC Standard Evaluation Form",
        "published": true,
        "selfUri": "/api/v2/quality/publishedforms/evaluations/c3f388c3-49b5-4862-8f0c-c0f37756a34b"
      },
      "evaluator": {
        "id": "4cdc2d34-9945-4a9a-90eb-15b07959c677",
        "selfUri": "/api/v2/users/4cdc2d34-9945-4a9a-90eb-15b07959c677"
      },
      "agent": {
        "id": "9fc0032a-08c8-419e-9421-3392fe438ab9",
        "selfUri": "/api/v2/users/9fc0032a-08c8-419e-9421-3392fe438ab9"
      },
      "status": "FINISHED",
      "answers": {
        "totalScore": 98.07692,
        "totalCriticalScore": 0,
        "totalNonCriticalScore": 98.07692,
        "questionGroupScores": [
          {
            "questionGroupId": "df4ffd43-df77-40d4-8a0e-ed48140cd03a",
            "totalScore": 32,
            "maxTotalScore": 32,
            "markedNA": false,
            "totalCriticalScore": 0,
            "maxTotalCriticalScore": 0,
            "totalNonCriticalScore": 32,
            "maxTotalNonCriticalScore": 32,
            "totalScoreUnweighted": 8,
            "maxTotalScoreUnweighted": 8,
            "totalCriticalScoreUnweighted": 0,
            "maxTotalCriticalScoreUnweighted": 0,
            "totalNonCriticalScoreUnweighted": 8,
            "maxTotalNonCriticalScoreUnweighted": 8,
            "questionScores": [
              {
                "questionId": "ac8fe92f-8f82-48c8-997e-cec2545c86db",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "82bc4c8a-3b4e-4bbb-b606-9ac423036349",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "d1b294ce-02f7-4bd6-8a54-12184c6cb7f7",
                "answerId": "ee58a96d-7bef-41ca-90e1-b73cf3d7a6c1",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "ae7b6608-cc80-41d0-aa43-c36d084911c5",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "adb2d8eb-17b6-4419-80ba-0dea55aec578",
                "answerId": "6d91daba-2dd6-406f-817c-a75e17bd750b",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Issue with check-in resolved by correcting multiple  issues."
              }
            ]
          },
          {
            "questionGroupId": "68f9eaba-0e66-4d4e-b4dd-92e1fb4ad1dd",
            "totalScore": 19,
            "maxTotalScore": 20,
            "markedNA": false,
            "totalCriticalScore": 0,
            "maxTotalCriticalScore": 0,
            "totalNonCriticalScore": 19,
            "maxTotalNonCriticalScore": 20,
            "totalScoreUnweighted": 19,
            "maxTotalScoreUnweighted": 20,
            "totalCriticalScoreUnweighted": 0,
            "maxTotalCriticalScoreUnweighted": 0,
            "totalNonCriticalScoreUnweighted": 19,
            "maxTotalNonCriticalScoreUnweighted": 20,
            "questionScores": [
              {
                "questionId": "305c72c7-1117-49d9-9531-630e40c3544d",
                "answerId": "247cd8b0-6b54-4f74-b319-b2adc1f27f42",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "No caller name given or asked for."
              },
              {
                "questionId": "74ffd71b-14f4-4f82-b6f6-5df87372254e",
                "answerId": "cbfecb3f-9c6b-45ba-bf03-18b172e2c3bb",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Identified needs very quickly and moved along the steps to resolve."
              },
              {
                "questionId": "591be936-d3ce-44d7-97da-793ccca29ce1",
                "answerId": "d4056225-19ff-4327-95d0-6113375c91d7",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "great conversation and interaction with the caller"
              },
              {
                "questionId": "a136ffd4-c06b-45b6-9609-8103dbe19de7",
                "answerId": "f0ced4e9-4d8a-49b7-875a-adf6ac8adcc0",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Great explanations for various steps "
              },
              {
                "questionId": "359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5",
                "answerId": "38a6cf3a-98f9-42de-9d58-2b6f5d0e61d4",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Took charge of the call and ownership for resolving the issue, plus shared steps for self resolution."
              }
            ]
          }
        ],
        "anyFailedKillQuestions": false,
        "comments": "Really great call overall, super supportive and sincere interaction with the caller.  Only improvement would have been to ack for their name at the start of the call."
      },
      "agentHasRead": false,
      "assignedDate": "2021-05-11T01:40:38.268Z",
      "changedDate": "2021-05-14T23:54:22.404Z",
      "mediaType": [
        "CALL"
      ],
      "conversationDate": "2021-05-05T03:07:09.459Z",
      "conversationEndDate": "2021-05-05T03:13:11.432Z",
      "neverRelease": true,
      "selfUri": "/api/v2/quality/conversations/0331d4ce-58c9-40d0-8656-aba4a4695d25/evaluations/6459e07f-1d73-43d6-a814-cb8c82b68cb4"
    },
    {
      "id": "31028a01-30ad-42cc-b19b-22bfc6278178",
      "conversation": {
        "id": "feb91e99-61ef-4350-81ad-961e91e03a27",
        "selfUri": "/api/v2/conversations/feb91e99-61ef-4350-81ad-961e91e03a27"
      },
      "evaluationForm": {
        "id": "c3f388c3-49b5-4862-8f0c-c0f37756a34b",
        "name": "SSC Standard Evaluation Form",
        "published": true,
        "selfUri": "/api/v2/quality/publishedforms/evaluations/c3f388c3-49b5-4862-8f0c-c0f37756a34b"
      },
      "evaluator": {
        "id": "4cdc2d34-9945-4a9a-90eb-15b07959c677",
        "selfUri": "/api/v2/users/4cdc2d34-9945-4a9a-90eb-15b07959c677"
      },
      "agent": {
        "id": "a8a5cae6-ef00-41fd-acfb-291731366e2b",
        "selfUri": "/api/v2/users/a8a5cae6-ef00-41fd-acfb-291731366e2b"
      },
      "status": "FINISHED",
      "answers": {
        "totalScore": 96.15385,
        "totalCriticalScore": 0,
        "totalNonCriticalScore": 96.15385,
        "questionGroupScores": [
          {
            "questionGroupId": "df4ffd43-df77-40d4-8a0e-ed48140cd03a",
            "totalScore": 32,
            "maxTotalScore": 32,
            "markedNA": false,
            "totalCriticalScore": 0,
            "maxTotalCriticalScore": 0,
            "totalNonCriticalScore": 32,
            "maxTotalNonCriticalScore": 32,
            "totalScoreUnweighted": 8,
            "maxTotalScoreUnweighted": 8,
            "totalCriticalScoreUnweighted": 0,
            "maxTotalCriticalScoreUnweighted": 0,
            "totalNonCriticalScoreUnweighted": 8,
            "maxTotalNonCriticalScoreUnweighted": 8,
            "questionScores": [
              {
                "questionId": "ac8fe92f-8f82-48c8-997e-cec2545c86db",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "82bc4c8a-3b4e-4bbb-b606-9ac423036349",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "d1b294ce-02f7-4bd6-8a54-12184c6cb7f7",
                "answerId": "ee58a96d-7bef-41ca-90e1-b73cf3d7a6c1",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "ae7b6608-cc80-41d0-aa43-c36d084911c5",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "adb2d8eb-17b6-4419-80ba-0dea55aec578",
                "answerId": "6d91daba-2dd6-406f-817c-a75e17bd750b",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Vol change FD was calculated but passenger declined the change."
              }
            ]
          },
          {
            "questionGroupId": "68f9eaba-0e66-4d4e-b4dd-92e1fb4ad1dd",
            "totalScore": 18,
            "maxTotalScore": 20,
            "markedNA": false,
            "totalCriticalScore": 0,
            "maxTotalCriticalScore": 0,
            "totalNonCriticalScore": 18,
            "maxTotalNonCriticalScore": 20,
            "totalScoreUnweighted": 18,
            "maxTotalScoreUnweighted": 20,
            "totalCriticalScoreUnweighted": 0,
            "maxTotalCriticalScoreUnweighted": 0,
            "totalNonCriticalScoreUnweighted": 18,
            "maxTotalNonCriticalScoreUnweighted": 20,
            "questionScores": [
              {
                "questionId": "305c72c7-1117-49d9-9531-630e40c3544d",
                "answerId": "247cd8b0-6b54-4f74-b319-b2adc1f27f42",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Caller gave name but not used"
              },
              {
                "questionId": "74ffd71b-14f4-4f82-b6f6-5df87372254e",
                "answerId": "7bb343f7-1258-4bb2-ae6d-8a683e7bed14",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Understood the callers needs and anticipated the FD"
              },
              {
                "questionId": "591be936-d3ce-44d7-97da-793ccca29ce1",
                "answerId": "d4056225-19ff-4327-95d0-6113375c91d7",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Patient with the caller, who seemed a bit flustered"
              },
              {
                "questionId": "a136ffd4-c06b-45b6-9609-8103dbe19de7",
                "answerId": "f0ced4e9-4d8a-49b7-875a-adf6ac8adcc0",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Very clear with quote and details"
              },
              {
                "questionId": "359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5",
                "answerId": "38a6cf3a-98f9-42de-9d58-2b6f5d0e61d4",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Asked to check with passenger before storing the fare."
              }
            ]
          }
        ],
        "anyFailedKillQuestions": false,
        "comments": "Very good call with agent needing help with a FD for a VOL change.  Very patient with caller while they explained the FD and the ability to re-use the ticket later.  Nice job!"
      },
      "agentHasRead": false,
      "assignedDate": "2021-05-10T23:41:37.266Z",
      "changedDate": "2021-05-14T23:54:51.667Z",
      "mediaType": [
        "CALL"
      ],
      "conversationDate": "2021-05-05T02:23:05.380Z",
      "conversationEndDate": "2021-05-05T02:28:21.708Z",
      "neverRelease": true,
      "selfUri": "/api/v2/quality/conversations/feb91e99-61ef-4350-81ad-961e91e03a27/evaluations/31028a01-30ad-42cc-b19b-22bfc6278178"
    },
    {
      "id": "b5110e8c-efa6-490f-bfc1-6a3b7fb36b52",
      "conversation": {
        "id": "f04dbbe5-9dd2-4a20-b769-98c06fe195ce",
        "selfUri": "/api/v2/conversations/f04dbbe5-9dd2-4a20-b769-98c06fe195ce"
      },
      "evaluationForm": {
        "id": "c3f388c3-49b5-4862-8f0c-c0f37756a34b",
        "name": "SSC Standard Evaluation Form",
        "published": true,
        "selfUri": "/api/v2/quality/publishedforms/evaluations/c3f388c3-49b5-4862-8f0c-c0f37756a34b"
      },
      "evaluator": {
        "id": "4cdc2d34-9945-4a9a-90eb-15b07959c677",
        "selfUri": "/api/v2/users/4cdc2d34-9945-4a9a-90eb-15b07959c677"
      },
      "agent": {
        "id": "349b65bc-8918-4c37-ae3a-894eb430e067",
        "selfUri": "/api/v2/users/349b65bc-8918-4c37-ae3a-894eb430e067"
      },
      "status": "FINISHED",
      "answers": {
        "totalScore": 94.230774,
        "totalCriticalScore": 0,
        "totalNonCriticalScore": 94.230774,
        "questionGroupScores": [
          {
            "questionGroupId": "df4ffd43-df77-40d4-8a0e-ed48140cd03a",
            "totalScore": 32,
            "maxTotalScore": 32,
            "markedNA": false,
            "totalCriticalScore": 0,
            "maxTotalCriticalScore": 0,
            "totalNonCriticalScore": 32,
            "maxTotalNonCriticalScore": 32,
            "totalScoreUnweighted": 8,
            "maxTotalScoreUnweighted": 8,
            "totalCriticalScoreUnweighted": 0,
            "maxTotalCriticalScoreUnweighted": 0,
            "totalNonCriticalScoreUnweighted": 8,
            "maxTotalNonCriticalScoreUnweighted": 8,
            "questionScores": [
              {
                "questionId": "ac8fe92f-8f82-48c8-997e-cec2545c86db",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "82bc4c8a-3b4e-4bbb-b606-9ac423036349",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "d1b294ce-02f7-4bd6-8a54-12184c6cb7f7",
                "answerId": "ee58a96d-7bef-41ca-90e1-b73cf3d7a6c1",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "ae7b6608-cc80-41d0-aa43-c36d084911c5",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "adb2d8eb-17b6-4419-80ba-0dea55aec578",
                "answerId": "6d91daba-2dd6-406f-817c-a75e17bd750b",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Caller needed assistance with checking in PAXs on diverted flight remaining overnight.  With flight departing the following day, agent did not know how to process the check-in."
              }
            ]
          },
          {
            "questionGroupId": "68f9eaba-0e66-4d4e-b4dd-92e1fb4ad1dd",
            "totalScore": 17,
            "maxTotalScore": 20,
            "markedNA": false,
            "totalCriticalScore": 0,
            "maxTotalCriticalScore": 0,
            "totalNonCriticalScore": 17,
            "maxTotalNonCriticalScore": 20,
            "totalScoreUnweighted": 17,
            "maxTotalScoreUnweighted": 20,
            "totalCriticalScoreUnweighted": 0,
            "maxTotalCriticalScoreUnweighted": 0,
            "totalNonCriticalScoreUnweighted": 17,
            "maxTotalNonCriticalScoreUnweighted": 20,
            "questionScores": [
              {
                "questionId": "305c72c7-1117-49d9-9531-630e40c3544d",
                "answerId": "247cd8b0-6b54-4f74-b319-b2adc1f27f42",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Name given but not used."
              },
              {
                "questionId": "74ffd71b-14f4-4f82-b6f6-5df87372254e",
                "answerId": "7bb343f7-1258-4bb2-ae6d-8a683e7bed14",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Understood the situation and listened to callers situation carefully"
              },
              {
                "questionId": "591be936-d3ce-44d7-97da-793ccca29ce1",
                "answerId": "d4056225-19ff-4327-95d0-6113375c91d7",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Provided great supporting comments through-out"
              },
              {
                "questionId": "a136ffd4-c06b-45b6-9609-8103dbe19de7",
                "answerId": "f0ced4e9-4d8a-49b7-875a-adf6ac8adcc0",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Very positive and clear on explaining where the [processing error was, checking in for the incorrect date."
              },
              {
                "questionId": "359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5",
                "answerId": "7e415064-8e24-4879-8304-65de477264e9",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Resolved the situation for the agent, no other options required"
              }
            ]
          }
        ],
        "anyFailedKillQuestions": false,
        "comments": "Great call overall!  Agent was confused and had a line down the terminal due to a diverted flight with 100+ passengers.  Super supportive and calm in understanding the situation and explaining the steps to properly check-in the diverted passengers with the departure the following day."
      },
      "agentHasRead": false,
      "assignedDate": "2021-05-10T22:47:43.156Z",
      "changedDate": "2021-05-14T23:55:09.412Z",
      "mediaType": [
        "CALL"
      ],
      "conversationDate": "2021-05-05T01:40:29.956Z",
      "conversationEndDate": "2021-05-05T01:46:15.397Z",
      "neverRelease": true,
      "selfUri": "/api/v2/quality/conversations/f04dbbe5-9dd2-4a20-b769-98c06fe195ce/evaluations/b5110e8c-efa6-490f-bfc1-6a3b7fb36b52"
    },
    {
      "id": "c6a0c174-0f8c-4355-829e-6de79a0bbc4e",
      "conversation": {
        "id": "ea5c9cff-f680-4d11-a5e0-3f22dc954531",
        "selfUri": "/api/v2/conversations/ea5c9cff-f680-4d11-a5e0-3f22dc954531"
      },
      "evaluationForm": {
        "id": "c3f388c3-49b5-4862-8f0c-c0f37756a34b",
        "name": "SSC Standard Evaluation Form",
        "published": true,
        "selfUri": "/api/v2/quality/publishedforms/evaluations/c3f388c3-49b5-4862-8f0c-c0f37756a34b"
      },
      "evaluator": {
        "id": "4cdc2d34-9945-4a9a-90eb-15b07959c677",
        "selfUri": "/api/v2/users/4cdc2d34-9945-4a9a-90eb-15b07959c677"
      },
      "agent": {
        "id": "94a11166-9477-46f3-840e-858bf3da6691",
        "selfUri": "/api/v2/users/94a11166-9477-46f3-840e-858bf3da6691"
      },
      "status": "FINISHED",
      "answers": {
        "totalScore": 94.230774,
        "totalCriticalScore": 0,
        "totalNonCriticalScore": 94.230774,
        "questionGroupScores": [
          {
            "questionGroupId": "df4ffd43-df77-40d4-8a0e-ed48140cd03a",
            "totalScore": 32,
            "maxTotalScore": 32,
            "markedNA": false,
            "totalCriticalScore": 0,
            "maxTotalCriticalScore": 0,
            "totalNonCriticalScore": 32,
            "maxTotalNonCriticalScore": 32,
            "totalScoreUnweighted": 8,
            "maxTotalScoreUnweighted": 8,
            "totalCriticalScoreUnweighted": 0,
            "maxTotalCriticalScoreUnweighted": 0,
            "totalNonCriticalScoreUnweighted": 8,
            "maxTotalNonCriticalScoreUnweighted": 8,
            "questionScores": [
              {
                "questionId": "ac8fe92f-8f82-48c8-997e-cec2545c86db",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "82bc4c8a-3b4e-4bbb-b606-9ac423036349",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "d1b294ce-02f7-4bd6-8a54-12184c6cb7f7",
                "answerId": "ee58a96d-7bef-41ca-90e1-b73cf3d7a6c1",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "ae7b6608-cc80-41d0-aa43-c36d084911c5",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "adb2d8eb-17b6-4419-80ba-0dea55aec578",
                "answerId": "6d91daba-2dd6-406f-817c-a75e17bd750b",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Reviewed PNR and no errors found, checked in all paxs"
              }
            ]
          },
          {
            "questionGroupId": "68f9eaba-0e66-4d4e-b4dd-92e1fb4ad1dd",
            "totalScore": 17,
            "maxTotalScore": 20,
            "markedNA": false,
            "totalCriticalScore": 0,
            "maxTotalCriticalScore": 0,
            "totalNonCriticalScore": 17,
            "maxTotalNonCriticalScore": 20,
            "totalScoreUnweighted": 17,
            "maxTotalScoreUnweighted": 20,
            "totalCriticalScoreUnweighted": 0,
            "maxTotalCriticalScoreUnweighted": 0,
            "totalNonCriticalScoreUnweighted": 17,
            "maxTotalNonCriticalScoreUnweighted": 20,
            "questionScores": [
              {
                "questionId": "305c72c7-1117-49d9-9531-630e40c3544d",
                "answerId": "247cd8b0-6b54-4f74-b319-b2adc1f27f42",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Caller gave name but not used on call"
              },
              {
                "questionId": "74ffd71b-14f4-4f82-b6f6-5df87372254e",
                "answerId": "7bb343f7-1258-4bb2-ae6d-8a683e7bed14",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Understood the caller needs"
              },
              {
                "questionId": "591be936-d3ce-44d7-97da-793ccca29ce1",
                "answerId": "d4056225-19ff-4327-95d0-6113375c91d7",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Very supportive and encouraging with the caller"
              },
              {
                "questionId": "a136ffd4-c06b-45b6-9609-8103dbe19de7",
                "answerId": "f0ced4e9-4d8a-49b7-875a-adf6ac8adcc0",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Explained what you were doing and asked clarifying questions"
              },
              {
                "questionId": "359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5",
                "answerId": "7e415064-8e24-4879-8304-65de477264e9",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "No options to offer but good job just checking in the PAXs to assist."
              }
            ]
          }
        ],
        "anyFailedKillQuestions": false,
        "comments": "Good call overall with great support and positive attitude  towards the caller.  Caller thought there were errors on their part but in reviewing the record everything looked good and you were able to successfully check everyone in.  Good job supporting  the caller!"
      },
      "agentHasRead": false,
      "assignedDate": "2021-05-10T00:11:36.716Z",
      "changedDate": "2021-05-10T00:18:10.848Z",
      "mediaType": [
        "CALL"
      ],
      "conversationDate": "2021-05-06T02:21:49.157Z",
      "conversationEndDate": "2021-05-06T02:27:28.207Z",
      "neverRelease": true,
      "selfUri": "/api/v2/quality/conversations/ea5c9cff-f680-4d11-a5e0-3f22dc954531/evaluations/c6a0c174-0f8c-4355-829e-6de79a0bbc4e"
    },
    {
      "id": "81da732a-5486-41ff-af52-a9d0c57376be",
      "conversation": {
        "id": "903a1255-984b-463b-903a-fe26e3d80423",
        "selfUri": "/api/v2/conversations/903a1255-984b-463b-903a-fe26e3d80423"
      },
      "evaluationForm": {
        "id": "c3f388c3-49b5-4862-8f0c-c0f37756a34b",
        "name": "SSC Standard Evaluation Form",
        "published": true,
        "selfUri": "/api/v2/quality/publishedforms/evaluations/c3f388c3-49b5-4862-8f0c-c0f37756a34b"
      },
      "evaluator": {
        "id": "4cdc2d34-9945-4a9a-90eb-15b07959c677",
        "selfUri": "/api/v2/users/4cdc2d34-9945-4a9a-90eb-15b07959c677"
      },
      "agent": {
        "id": "d9114c12-8a7d-44f2-8f9d-ea79ff80f96f",
        "selfUri": "/api/v2/users/d9114c12-8a7d-44f2-8f9d-ea79ff80f96f"
      },
      "status": "FINISHED",
      "answers": {
        "totalScore": 88.88889,
        "totalCriticalScore": 0,
        "totalNonCriticalScore": 88.88889,
        "questionGroupScores": [
          {
            "questionGroupId": "df4ffd43-df77-40d4-8a0e-ed48140cd03a",
            "totalScore": 16,
            "maxTotalScore": 16,
            "markedNA": false,
            "totalCriticalScore": 0,
            "maxTotalCriticalScore": 0,
            "totalNonCriticalScore": 16,
            "maxTotalNonCriticalScore": 16,
            "totalScoreUnweighted": 4,
            "maxTotalScoreUnweighted": 4,
            "totalCriticalScoreUnweighted": 0,
            "maxTotalCriticalScoreUnweighted": 0,
            "totalNonCriticalScoreUnweighted": 4,
            "maxTotalNonCriticalScoreUnweighted": 4,
            "questionScores": [
              {
                "questionId": "ac8fe92f-8f82-48c8-997e-cec2545c86db",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "82bc4c8a-3b4e-4bbb-b606-9ac423036349",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "d1b294ce-02f7-4bd6-8a54-12184c6cb7f7",
                "answerId": "ee58a96d-7bef-41ca-90e1-b73cf3d7a6c1",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "ae7b6608-cc80-41d0-aa43-c36d084911c5",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": ""
              },
              {
                "questionId": "adb2d8eb-17b6-4419-80ba-0dea55aec578",
                "answerId": "",
                "score": 0,
                "markedNA": true,
                "failedKillQuestion": false,
                "comments": "Call was for information regarding changing a  PAX ticket by Supervisor"
              }
            ]
          },
          {
            "questionGroupId": "68f9eaba-0e66-4d4e-b4dd-92e1fb4ad1dd",
            "totalScore": 16,
            "maxTotalScore": 20,
            "markedNA": false,
            "totalCriticalScore": 0,
            "maxTotalCriticalScore": 0,
            "totalNonCriticalScore": 16,
            "maxTotalNonCriticalScore": 20,
            "totalScoreUnweighted": 16,
            "maxTotalScoreUnweighted": 20,
            "totalCriticalScoreUnweighted": 0,
            "maxTotalCriticalScoreUnweighted": 0,
            "totalNonCriticalScoreUnweighted": 16,
            "maxTotalNonCriticalScoreUnweighted": 20,
            "questionScores": [
              {
                "questionId": "305c72c7-1117-49d9-9531-630e40c3544d",
                "answerId": "247cd8b0-6b54-4f74-b319-b2adc1f27f42",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Caller gave name but not used."
              },
              {
                "questionId": "74ffd71b-14f4-4f82-b6f6-5df87372254e",
                "answerId": "7bb343f7-1258-4bb2-ae6d-8a683e7bed14",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Understood the callers need after a long explaination"
              },
              {
                "questionId": "591be936-d3ce-44d7-97da-793ccca29ce1",
                "answerId": "d4056225-19ff-4327-95d0-6113375c91d7",
                "score": 4,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Good empathy with the passengers situation"
              },
              {
                "questionId": "a136ffd4-c06b-45b6-9609-8103dbe19de7",
                "answerId": "7d2bcc5c-6a90-41f1-bd8e-3b7472558095",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Expressed appropriate understanding and clear on limit of authorizing changes."
              },
              {
                "questionId": "359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5",
                "answerId": "7e415064-8e24-4879-8304-65de477264e9",
                "score": 3,
                "markedNA": false,
                "failedKillQuestion": false,
                "comments": "Good Option to have a CRO authorize in MIA"
              }
            ]
          }
        ],
        "anyFailedKillQuestions": false,
        "comments": "Good call overall.  Caller was a off-duty AA supervisor involved with a passenger in a family emergency situation, needing to change return flight.  Unusual situation with passenger having supervisors personal phone number.  Appropriate empathy for situation and adherence to company policy throughout the call."
      },
      "agentHasRead": false,
      "assignedDate": "2021-05-09T23:44:54.827Z",
      "changedDate": "2021-05-09T23:54:09.734Z",
      "mediaType": [
        "CALL"
      ],
      "conversationDate": "2021-05-02T19:35:22.847Z",
      "conversationEndDate": "2021-05-02T19:40:45.687Z",
      "neverRelease": true,
      "selfUri": "/api/v2/quality/conversations/903a1255-984b-463b-903a-fe26e3d80423/evaluations/81da732a-5486-41ff-af52-a9d0c57376be"
    }
  ],
  "pageSize": 25,
  "pageNumber": 1,
  "total": 6,
  "firstUri": "/api/v2/quality/evaluations/query?pageSize=25&pageNumber=1",
  "selfUri": "/api/v2/quality/evaluations/query?pageSize=25&pageNumber=1",
  "lastUri": "/api/v2/quality/evaluations/query?pageSize=25&pageNumber=1",
  "pageCount": 1
}

[DamoBird365]

Hi @F_Quint 

Are you looking for something like:

questionid ,score,agent id
ac8fe92f-8f82-48c8-997e-cec2545c86db,0,2375389f-987f-4e06-82c1-c6878fd8dce8
82bc4c8a-3b4e-4bbb-b606-9ac423036349,0,2375389f-987f-4e06-82c1-c6878fd8dce8
d1b294ce-02f7-4bd6-8a54-12184c6cb7f7,4,2375389f-987f-4e06-82c1-c6878fd8dce8
ae7b6608-cc80-41d0-aa43-c36d084911c5,0,2375389f-987f-4e06-82c1-c6878fd8dce8
adb2d8eb-17b6-4419-80ba-0dea55aec578,4,2375389f-987f-4e06-82c1-c6878fd8dce8
305c72c7-1117-49d9-9531-630e40c3544d,4,2375389f-987f-4e06-82c1-c6878fd8dce8
74ffd71b-14f4-4f82-b6f6-5df87372254e,4,2375389f-987f-4e06-82c1-c6878fd8dce8
591be936-d3ce-44d7-97da-793ccca29ce1,3,2375389f-987f-4e06-82c1-c6878fd8dce8
a136ffd4-c06b-45b6-9609-8103dbe19de7,3,2375389f-987f-4e06-82c1-c6878fd8dce8
359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5,3,2375389f-987f-4e06-82c1-c6878fd8dce8
ac8fe92f-8f82-48c8-997e-cec2545c86db,0,9fc0032a-08c8-419e-9421-3392fe438ab9
82bc4c8a-3b4e-4bbb-b606-9ac423036349,0,9fc0032a-08c8-419e-9421-3392fe438ab9
d1b294ce-02f7-4bd6-8a54-12184c6cb7f7,4,9fc0032a-08c8-419e-9421-3392fe438ab9
ae7b6608-cc80-41d0-aa43-c36d084911c5,0,9fc0032a-08c8-419e-9421-3392fe438ab9
adb2d8eb-17b6-4419-80ba-0dea55aec578,4,9fc0032a-08c8-419e-9421-3392fe438ab9
305c72c7-1117-49d9-9531-630e40c3544d,3,9fc0032a-08c8-419e-9421-3392fe438ab9
74ffd71b-14f4-4f82-b6f6-5df87372254e,4,9fc0032a-08c8-419e-9421-3392fe438ab9
591be936-d3ce-44d7-97da-793ccca29ce1,4,9fc0032a-08c8-419e-9421-3392fe438ab9
a136ffd4-c06b-45b6-9609-8103dbe19de7,4,9fc0032a-08c8-419e-9421-3392fe438ab9
359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5,4,9fc0032a-08c8-419e-9421-3392fe438ab9
ac8fe92f-8f82-48c8-997e-cec2545c86db,0,a8a5cae6-ef00-41fd-acfb-291731366e2b
82bc4c8a-3b4e-4bbb-b606-9ac423036349,0,a8a5cae6-ef00-41fd-acfb-291731366e2b
d1b294ce-02f7-4bd6-8a54-12184c6cb7f7,4,a8a5cae6-ef00-41fd-acfb-291731366e2b
ae7b6608-cc80-41d0-aa43-c36d084911c5,0,a8a5cae6-ef00-41fd-acfb-291731366e2b
adb2d8eb-17b6-4419-80ba-0dea55aec578,4,a8a5cae6-ef00-41fd-acfb-291731366e2b
305c72c7-1117-49d9-9531-630e40c3544d,3,a8a5cae6-ef00-41fd-acfb-291731366e2b
74ffd71b-14f4-4f82-b6f6-5df87372254e,3,a8a5cae6-ef00-41fd-acfb-291731366e2b
591be936-d3ce-44d7-97da-793ccca29ce1,4,a8a5cae6-ef00-41fd-acfb-291731366e2b
a136ffd4-c06b-45b6-9609-8103dbe19de7,4,a8a5cae6-ef00-41fd-acfb-291731366e2b
359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5,4,a8a5cae6-ef00-41fd-acfb-291731366e2b
ac8fe92f-8f82-48c8-997e-cec2545c86db,0,349b65bc-8918-4c37-ae3a-894eb430e067
82bc4c8a-3b4e-4bbb-b606-9ac423036349,0,349b65bc-8918-4c37-ae3a-894eb430e067
d1b294ce-02f7-4bd6-8a54-12184c6cb7f7,4,349b65bc-8918-4c37-ae3a-894eb430e067
ae7b6608-cc80-41d0-aa43-c36d084911c5,0,349b65bc-8918-4c37-ae3a-894eb430e067
adb2d8eb-17b6-4419-80ba-0dea55aec578,4,349b65bc-8918-4c37-ae3a-894eb430e067
305c72c7-1117-49d9-9531-630e40c3544d,3,349b65bc-8918-4c37-ae3a-894eb430e067
74ffd71b-14f4-4f82-b6f6-5df87372254e,3,349b65bc-8918-4c37-ae3a-894eb430e067
591be936-d3ce-44d7-97da-793ccca29ce1,4,349b65bc-8918-4c37-ae3a-894eb430e067
a136ffd4-c06b-45b6-9609-8103dbe19de7,4,349b65bc-8918-4c37-ae3a-894eb430e067
359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5,3,349b65bc-8918-4c37-ae3a-894eb430e067
ac8fe92f-8f82-48c8-997e-cec2545c86db,0,94a11166-9477-46f3-840e-858bf3da6691
82bc4c8a-3b4e-4bbb-b606-9ac423036349,0,94a11166-9477-46f3-840e-858bf3da6691
d1b294ce-02f7-4bd6-8a54-12184c6cb7f7,4,94a11166-9477-46f3-840e-858bf3da6691
ae7b6608-cc80-41d0-aa43-c36d084911c5,0,94a11166-9477-46f3-840e-858bf3da6691
adb2d8eb-17b6-4419-80ba-0dea55aec578,4,94a11166-9477-46f3-840e-858bf3da6691
305c72c7-1117-49d9-9531-630e40c3544d,3,94a11166-9477-46f3-840e-858bf3da6691
74ffd71b-14f4-4f82-b6f6-5df87372254e,3,94a11166-9477-46f3-840e-858bf3da6691
591be936-d3ce-44d7-97da-793ccca29ce1,4,94a11166-9477-46f3-840e-858bf3da6691
a136ffd4-c06b-45b6-9609-8103dbe19de7,4,94a11166-9477-46f3-840e-858bf3da6691
359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5,3,94a11166-9477-46f3-840e-858bf3da6691
ac8fe92f-8f82-48c8-997e-cec2545c86db,0,d9114c12-8a7d-44f2-8f9d-ea79ff80f96f
82bc4c8a-3b4e-4bbb-b606-9ac423036349,0,d9114c12-8a7d-44f2-8f9d-ea79ff80f96f
d1b294ce-02f7-4bd6-8a54-12184c6cb7f7,4,d9114c12-8a7d-44f2-8f9d-ea79ff80f96f
ae7b6608-cc80-41d0-aa43-c36d084911c5,0,d9114c12-8a7d-44f2-8f9d-ea79ff80f96f
adb2d8eb-17b6-4419-80ba-0dea55aec578,0,d9114c12-8a7d-44f2-8f9d-ea79ff80f96f
305c72c7-1117-49d9-9531-630e40c3544d,3,d9114c12-8a7d-44f2-8f9d-ea79ff80f96f
74ffd71b-14f4-4f82-b6f6-5df87372254e,3,d9114c12-8a7d-44f2-8f9d-ea79ff80f96f
591be936-d3ce-44d7-97da-793ccca29ce1,4,d9114c12-8a7d-44f2-8f9d-ea79ff80f96f
a136ffd4-c06b-45b6-9609-8103dbe19de7,3,d9114c12-8a7d-44f2-8f9d-ea79ff80f96f
359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5,3,d9114c12-8a7d-44f2-8f9d-ea79ff80f96f

Damien

[DamoBird365 · Accepted solution]

Hi @F_Quint 

Create a variable called Array with initial value [

and then copy and paste the following into your "new step" -> "my clipboard".

{"id":"ec342aa2-afb3-43aa-b8a9-05d4-b172be27","brandColor":"#8C3900","connectionReferences":{},"connectorDisplayName":"Control","icon":"data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iMCAwIDMyIDMyIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPg0KIDxwYXRoIGQ9Im0wIDBoMzJ2MzJoLTMyeiIgZmlsbD0iIzhDMzkwMCIvPg0KIDxwYXRoIGQ9Im04IDEwaDE2djEyaC0xNnptMTUgMTF2LTEwaC0xNHYxMHptLTItOHY2aC0xMHYtNnptLTEgNXYtNGgtOHY0eiIgZmlsbD0iI2ZmZiIvPg0KPC9zdmc+DQo=","isTrigger":false,"operationName":"DamoBird365_Nested_Array_to_CSV","operationDefinition":{"type":"Scope","actions":{"Compose":{"type":"Compose","inputs":{"entities":[{"id":"5fbc0cdf-b19c-4b52-b870-8d4426683ca4","conversation":{"id":"4e82d021-64c9-4aee-8d8a-f496e09d2508","selfUri":"/api/v2/conversations/4e82d021-64c9-4aee-8d8a-f496e09d2508"},"evaluationForm":{"id":"c3f388c3-49b5-4862-8f0c-c0f37756a34b","name":"SSC Standard Evaluation Form","published":true,"selfUri":"/api/v2/quality/publishedforms/evaluations/c3f388c3-49b5-4862-8f0c-c0f37756a34b"},"evaluator":{"id":"4cdc2d34-9945-4a9a-90eb-15b07959c677","selfUri":"/api/v2/users/4cdc2d34-9945-4a9a-90eb-15b07959c677"},"agent":{"id":"2375389f-987f-4e06-82c1-c6878fd8dce8","selfUri":"/api/v2/users/2375389f-987f-4e06-82c1-c6878fd8dce8"},"status":"FINISHED","answers":{"totalScore":94.230774,"totalCriticalScore":0,"totalNonCriticalScore":94.230774,"questionGroupScores":[{"questionGroupId":"df4ffd43-df77-40d4-8a0e-ed48140cd03a","totalScore":32,"maxTotalScore":32,"markedNA":false,"totalCriticalScore":0,"maxTotalCriticalScore":0,"totalNonCriticalScore":32,"maxTotalNonCriticalScore":32,"totalScoreUnweighted":8,"maxTotalScoreUnweighted":8,"totalCriticalScoreUnweighted":0,"maxTotalCriticalScoreUnweighted":0,"totalNonCriticalScoreUnweighted":8,"maxTotalNonCriticalScoreUnweighted":8,"questionScores":[{"questionId":"ac8fe92f-8f82-48c8-997e-cec2545c86db","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"82bc4c8a-3b4e-4bbb-b606-9ac423036349","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"d1b294ce-02f7-4bd6-8a54-12184c6cb7f7","answerId":"ee58a96d-7bef-41ca-90e1-b73cf3d7a6c1","score":4,"markedNA":false,"failedKillQuestion":false,"comments":""},{"questionId":"ae7b6608-cc80-41d0-aa43-c36d084911c5","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"adb2d8eb-17b6-4419-80ba-0dea55aec578","answerId":"6d91daba-2dd6-406f-817c-a75e17bd750b","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Caller had errors checking in a EP companion, you were able to process for them."}]},{"questionGroupId":"68f9eaba-0e66-4d4e-b4dd-92e1fb4ad1dd","totalScore":17,"maxTotalScore":20,"markedNA":false,"totalCriticalScore":0,"maxTotalCriticalScore":0,"totalNonCriticalScore":17,"maxTotalNonCriticalScore":20,"totalScoreUnweighted":17,"maxTotalScoreUnweighted":20,"totalCriticalScoreUnweighted":0,"maxTotalCriticalScoreUnweighted":0,"totalNonCriticalScoreUnweighted":17,"maxTotalNonCriticalScoreUnweighted":20,"questionScores":[{"questionId":"305c72c7-1117-49d9-9531-630e40c3544d","answerId":"c7ac1930-f396-4713-a402-c912df94f603","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Great job using the callers name"},{"questionId":"74ffd71b-14f4-4f82-b6f6-5df87372254e","answerId":"cbfecb3f-9c6b-45ba-bf03-18b172e2c3bb","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"The background noise was distracting but you did a great job staying focused on the callers needs."},{"questionId":"591be936-d3ce-44d7-97da-793ccca29ce1","answerId":"a663b038-4396-4f0c-9f22-07d8e9c6c75a","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"Caller was distracted and you had some short answers at the end of the call."},{"questionId":"a136ffd4-c06b-45b6-9609-8103dbe19de7","answerId":"7d2bcc5c-6a90-41f1-bd8e-3b7472558095","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"Good job providing essential information"},{"questionId":"359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5","answerId":"7e415064-8e24-4879-8304-65de477264e9","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"No options with this call."}]}],"anyFailedKillQuestions":false,"comments":"Good call overall. Nice job using the callers name.  The caller was creating the issue by not having the EP checked in before checking in the companion.  You avoided confrontation and kept the call moving. Good job!"},"agentHasRead":false,"assignedDate":"2021-05-11T02:19:15.198Z","changedDate":"2021-05-14T23:53:57.795Z","mediaType":["CALL"],"conversationDate":"2021-05-08T16:39:32.704Z","conversationEndDate":"2021-05-08T16:45:22.637Z","neverRelease":true,"selfUri":"/api/v2/quality/conversations/4e82d021-64c9-4aee-8d8a-f496e09d2508/evaluations/5fbc0cdf-b19c-4b52-b870-8d4426683ca4"},{"id":"6459e07f-1d73-43d6-a814-cb8c82b68cb4","conversation":{"id":"0331d4ce-58c9-40d0-8656-aba4a4695d25","selfUri":"/api/v2/conversations/0331d4ce-58c9-40d0-8656-aba4a4695d25"},"evaluationForm":{"id":"c3f388c3-49b5-4862-8f0c-c0f37756a34b","name":"SSC Standard Evaluation Form","published":true,"selfUri":"/api/v2/quality/publishedforms/evaluations/c3f388c3-49b5-4862-8f0c-c0f37756a34b"},"evaluator":{"id":"4cdc2d34-9945-4a9a-90eb-15b07959c677","selfUri":"/api/v2/users/4cdc2d34-9945-4a9a-90eb-15b07959c677"},"agent":{"id":"9fc0032a-08c8-419e-9421-3392fe438ab9","selfUri":"/api/v2/users/9fc0032a-08c8-419e-9421-3392fe438ab9"},"status":"FINISHED","answers":{"totalScore":98.07692,"totalCriticalScore":0,"totalNonCriticalScore":98.07692,"questionGroupScores":[{"questionGroupId":"df4ffd43-df77-40d4-8a0e-ed48140cd03a","totalScore":32,"maxTotalScore":32,"markedNA":false,"totalCriticalScore":0,"maxTotalCriticalScore":0,"totalNonCriticalScore":32,"maxTotalNonCriticalScore":32,"totalScoreUnweighted":8,"maxTotalScoreUnweighted":8,"totalCriticalScoreUnweighted":0,"maxTotalCriticalScoreUnweighted":0,"totalNonCriticalScoreUnweighted":8,"maxTotalNonCriticalScoreUnweighted":8,"questionScores":[{"questionId":"ac8fe92f-8f82-48c8-997e-cec2545c86db","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"82bc4c8a-3b4e-4bbb-b606-9ac423036349","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"d1b294ce-02f7-4bd6-8a54-12184c6cb7f7","answerId":"ee58a96d-7bef-41ca-90e1-b73cf3d7a6c1","score":4,"markedNA":false,"failedKillQuestion":false,"comments":""},{"questionId":"ae7b6608-cc80-41d0-aa43-c36d084911c5","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"adb2d8eb-17b6-4419-80ba-0dea55aec578","answerId":"6d91daba-2dd6-406f-817c-a75e17bd750b","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Issue with check-in resolved by correcting multiple  issues."}]},{"questionGroupId":"68f9eaba-0e66-4d4e-b4dd-92e1fb4ad1dd","totalScore":19,"maxTotalScore":20,"markedNA":false,"totalCriticalScore":0,"maxTotalCriticalScore":0,"totalNonCriticalScore":19,"maxTotalNonCriticalScore":20,"totalScoreUnweighted":19,"maxTotalScoreUnweighted":20,"totalCriticalScoreUnweighted":0,"maxTotalCriticalScoreUnweighted":0,"totalNonCriticalScoreUnweighted":19,"maxTotalNonCriticalScoreUnweighted":20,"questionScores":[{"questionId":"305c72c7-1117-49d9-9531-630e40c3544d","answerId":"247cd8b0-6b54-4f74-b319-b2adc1f27f42","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"No caller name given or asked for."},{"questionId":"74ffd71b-14f4-4f82-b6f6-5df87372254e","answerId":"cbfecb3f-9c6b-45ba-bf03-18b172e2c3bb","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Identified needs very quickly and moved along the steps to resolve."},{"questionId":"591be936-d3ce-44d7-97da-793ccca29ce1","answerId":"d4056225-19ff-4327-95d0-6113375c91d7","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"great conversation and interaction with the caller"},{"questionId":"a136ffd4-c06b-45b6-9609-8103dbe19de7","answerId":"f0ced4e9-4d8a-49b7-875a-adf6ac8adcc0","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Great explanations for various steps "},{"questionId":"359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5","answerId":"38a6cf3a-98f9-42de-9d58-2b6f5d0e61d4","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Took charge of the call and ownership for resolving the issue, plus shared steps for self resolution."}]}],"anyFailedKillQuestions":false,"comments":"Really great call overall, super supportive and sincere interaction with the caller.  Only improvement would have been to ack for their name at the start of the call."},"agentHasRead":false,"assignedDate":"2021-05-11T01:40:38.268Z","changedDate":"2021-05-14T23:54:22.404Z","mediaType":["CALL"],"conversationDate":"2021-05-05T03:07:09.459Z","conversationEndDate":"2021-05-05T03:13:11.432Z","neverRelease":true,"selfUri":"/api/v2/quality/conversations/0331d4ce-58c9-40d0-8656-aba4a4695d25/evaluations/6459e07f-1d73-43d6-a814-cb8c82b68cb4"},{"id":"31028a01-30ad-42cc-b19b-22bfc6278178","conversation":{"id":"feb91e99-61ef-4350-81ad-961e91e03a27","selfUri":"/api/v2/conversations/feb91e99-61ef-4350-81ad-961e91e03a27"},"evaluationForm":{"id":"c3f388c3-49b5-4862-8f0c-c0f37756a34b","name":"SSC Standard Evaluation Form","published":true,"selfUri":"/api/v2/quality/publishedforms/evaluations/c3f388c3-49b5-4862-8f0c-c0f37756a34b"},"evaluator":{"id":"4cdc2d34-9945-4a9a-90eb-15b07959c677","selfUri":"/api/v2/users/4cdc2d34-9945-4a9a-90eb-15b07959c677"},"agent":{"id":"a8a5cae6-ef00-41fd-acfb-291731366e2b","selfUri":"/api/v2/users/a8a5cae6-ef00-41fd-acfb-291731366e2b"},"status":"FINISHED","answers":{"totalScore":96.15385,"totalCriticalScore":0,"totalNonCriticalScore":96.15385,"questionGroupScores":[{"questionGroupId":"df4ffd43-df77-40d4-8a0e-ed48140cd03a","totalScore":32,"maxTotalScore":32,"markedNA":false,"totalCriticalScore":0,"maxTotalCriticalScore":0,"totalNonCriticalScore":32,"maxTotalNonCriticalScore":32,"totalScoreUnweighted":8,"maxTotalScoreUnweighted":8,"totalCriticalScoreUnweighted":0,"maxTotalCriticalScoreUnweighted":0,"totalNonCriticalScoreUnweighted":8,"maxTotalNonCriticalScoreUnweighted":8,"questionScores":[{"questionId":"ac8fe92f-8f82-48c8-997e-cec2545c86db","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"82bc4c8a-3b4e-4bbb-b606-9ac423036349","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"d1b294ce-02f7-4bd6-8a54-12184c6cb7f7","answerId":"ee58a96d-7bef-41ca-90e1-b73cf3d7a6c1","score":4,"markedNA":false,"failedKillQuestion":false,"comments":""},{"questionId":"ae7b6608-cc80-41d0-aa43-c36d084911c5","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"adb2d8eb-17b6-4419-80ba-0dea55aec578","answerId":"6d91daba-2dd6-406f-817c-a75e17bd750b","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Vol change FD was calculated but passenger declined the change."}]},{"questionGroupId":"68f9eaba-0e66-4d4e-b4dd-92e1fb4ad1dd","totalScore":18,"maxTotalScore":20,"markedNA":false,"totalCriticalScore":0,"maxTotalCriticalScore":0,"totalNonCriticalScore":18,"maxTotalNonCriticalScore":20,"totalScoreUnweighted":18,"maxTotalScoreUnweighted":20,"totalCriticalScoreUnweighted":0,"maxTotalCriticalScoreUnweighted":0,"totalNonCriticalScoreUnweighted":18,"maxTotalNonCriticalScoreUnweighted":20,"questionScores":[{"questionId":"305c72c7-1117-49d9-9531-630e40c3544d","answerId":"247cd8b0-6b54-4f74-b319-b2adc1f27f42","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"Caller gave name but not used"},{"questionId":"74ffd71b-14f4-4f82-b6f6-5df87372254e","answerId":"7bb343f7-1258-4bb2-ae6d-8a683e7bed14","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"Understood the callers needs and anticipated the FD"},{"questionId":"591be936-d3ce-44d7-97da-793ccca29ce1","answerId":"d4056225-19ff-4327-95d0-6113375c91d7","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Patient with the caller, who seemed a bit flustered"},{"questionId":"a136ffd4-c06b-45b6-9609-8103dbe19de7","answerId":"f0ced4e9-4d8a-49b7-875a-adf6ac8adcc0","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Very clear with quote and details"},{"questionId":"359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5","answerId":"38a6cf3a-98f9-42de-9d58-2b6f5d0e61d4","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Asked to check with passenger before storing the fare."}]}],"anyFailedKillQuestions":false,"comments":"Very good call with agent needing help with a FD for a VOL change.  Very patient with caller while they explained the FD and the ability to re-use the ticket later.  Nice job!"},"agentHasRead":false,"assignedDate":"2021-05-10T23:41:37.266Z","changedDate":"2021-05-14T23:54:51.667Z","mediaType":["CALL"],"conversationDate":"2021-05-05T02:23:05.380Z","conversationEndDate":"2021-05-05T02:28:21.708Z","neverRelease":true,"selfUri":"/api/v2/quality/conversations/feb91e99-61ef-4350-81ad-961e91e03a27/evaluations/31028a01-30ad-42cc-b19b-22bfc6278178"},{"id":"b5110e8c-efa6-490f-bfc1-6a3b7fb36b52","conversation":{"id":"f04dbbe5-9dd2-4a20-b769-98c06fe195ce","selfUri":"/api/v2/conversations/f04dbbe5-9dd2-4a20-b769-98c06fe195ce"},"evaluationForm":{"id":"c3f388c3-49b5-4862-8f0c-c0f37756a34b","name":"SSC Standard Evaluation Form","published":true,"selfUri":"/api/v2/quality/publishedforms/evaluations/c3f388c3-49b5-4862-8f0c-c0f37756a34b"},"evaluator":{"id":"4cdc2d34-9945-4a9a-90eb-15b07959c677","selfUri":"/api/v2/users/4cdc2d34-9945-4a9a-90eb-15b07959c677"},"agent":{"id":"349b65bc-8918-4c37-ae3a-894eb430e067","selfUri":"/api/v2/users/349b65bc-8918-4c37-ae3a-894eb430e067"},"status":"FINISHED","answers":{"totalScore":94.230774,"totalCriticalScore":0,"totalNonCriticalScore":94.230774,"questionGroupScores":[{"questionGroupId":"df4ffd43-df77-40d4-8a0e-ed48140cd03a","totalScore":32,"maxTotalScore":32,"markedNA":false,"totalCriticalScore":0,"maxTotalCriticalScore":0,"totalNonCriticalScore":32,"maxTotalNonCriticalScore":32,"totalScoreUnweighted":8,"maxTotalScoreUnweighted":8,"totalCriticalScoreUnweighted":0,"maxTotalCriticalScoreUnweighted":0,"totalNonCriticalScoreUnweighted":8,"maxTotalNonCriticalScoreUnweighted":8,"questionScores":[{"questionId":"ac8fe92f-8f82-48c8-997e-cec2545c86db","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"82bc4c8a-3b4e-4bbb-b606-9ac423036349","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"d1b294ce-02f7-4bd6-8a54-12184c6cb7f7","answerId":"ee58a96d-7bef-41ca-90e1-b73cf3d7a6c1","score":4,"markedNA":false,"failedKillQuestion":false,"comments":""},{"questionId":"ae7b6608-cc80-41d0-aa43-c36d084911c5","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"adb2d8eb-17b6-4419-80ba-0dea55aec578","answerId":"6d91daba-2dd6-406f-817c-a75e17bd750b","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Caller needed assistance with checking in PAXs on diverted flight remaining overnight.  With flight departing the following day, agent did not know how to process the check-in."}]},{"questionGroupId":"68f9eaba-0e66-4d4e-b4dd-92e1fb4ad1dd","totalScore":17,"maxTotalScore":20,"markedNA":false,"totalCriticalScore":0,"maxTotalCriticalScore":0,"totalNonCriticalScore":17,"maxTotalNonCriticalScore":20,"totalScoreUnweighted":17,"maxTotalScoreUnweighted":20,"totalCriticalScoreUnweighted":0,"maxTotalCriticalScoreUnweighted":0,"totalNonCriticalScoreUnweighted":17,"maxTotalNonCriticalScoreUnweighted":20,"questionScores":[{"questionId":"305c72c7-1117-49d9-9531-630e40c3544d","answerId":"247cd8b0-6b54-4f74-b319-b2adc1f27f42","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"Name given but not used."},{"questionId":"74ffd71b-14f4-4f82-b6f6-5df87372254e","answerId":"7bb343f7-1258-4bb2-ae6d-8a683e7bed14","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"Understood the situation and listened to callers situation carefully"},{"questionId":"591be936-d3ce-44d7-97da-793ccca29ce1","answerId":"d4056225-19ff-4327-95d0-6113375c91d7","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Provided great supporting comments through-out"},{"questionId":"a136ffd4-c06b-45b6-9609-8103dbe19de7","answerId":"f0ced4e9-4d8a-49b7-875a-adf6ac8adcc0","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Very positive and clear on explaining where the [processing error was, checking in for the incorrect date."},{"questionId":"359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5","answerId":"7e415064-8e24-4879-8304-65de477264e9","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"Resolved the situation for the agent, no other options required"}]}],"anyFailedKillQuestions":false,"comments":"Great call overall!  Agent was confused and had a line down the terminal due to a diverted flight with 100+ passengers.  Super supportive and calm in understanding the situation and explaining the steps to properly check-in the diverted passengers with the departure the following day."},"agentHasRead":false,"assignedDate":"2021-05-10T22:47:43.156Z","changedDate":"2021-05-14T23:55:09.412Z","mediaType":["CALL"],"conversationDate":"2021-05-05T01:40:29.956Z","conversationEndDate":"2021-05-05T01:46:15.397Z","neverRelease":true,"selfUri":"/api/v2/quality/conversations/f04dbbe5-9dd2-4a20-b769-98c06fe195ce/evaluations/b5110e8c-efa6-490f-bfc1-6a3b7fb36b52"},{"id":"c6a0c174-0f8c-4355-829e-6de79a0bbc4e","conversation":{"id":"ea5c9cff-f680-4d11-a5e0-3f22dc954531","selfUri":"/api/v2/conversations/ea5c9cff-f680-4d11-a5e0-3f22dc954531"},"evaluationForm":{"id":"c3f388c3-49b5-4862-8f0c-c0f37756a34b","name":"SSC Standard Evaluation Form","published":true,"selfUri":"/api/v2/quality/publishedforms/evaluations/c3f388c3-49b5-4862-8f0c-c0f37756a34b"},"evaluator":{"id":"4cdc2d34-9945-4a9a-90eb-15b07959c677","selfUri":"/api/v2/users/4cdc2d34-9945-4a9a-90eb-15b07959c677"},"agent":{"id":"94a11166-9477-46f3-840e-858bf3da6691","selfUri":"/api/v2/users/94a11166-9477-46f3-840e-858bf3da6691"},"status":"FINISHED","answers":{"totalScore":94.230774,"totalCriticalScore":0,"totalNonCriticalScore":94.230774,"questionGroupScores":[{"questionGroupId":"df4ffd43-df77-40d4-8a0e-ed48140cd03a","totalScore":32,"maxTotalScore":32,"markedNA":false,"totalCriticalScore":0,"maxTotalCriticalScore":0,"totalNonCriticalScore":32,"maxTotalNonCriticalScore":32,"totalScoreUnweighted":8,"maxTotalScoreUnweighted":8,"totalCriticalScoreUnweighted":0,"maxTotalCriticalScoreUnweighted":0,"totalNonCriticalScoreUnweighted":8,"maxTotalNonCriticalScoreUnweighted":8,"questionScores":[{"questionId":"ac8fe92f-8f82-48c8-997e-cec2545c86db","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"82bc4c8a-3b4e-4bbb-b606-9ac423036349","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"d1b294ce-02f7-4bd6-8a54-12184c6cb7f7","answerId":"ee58a96d-7bef-41ca-90e1-b73cf3d7a6c1","score":4,"markedNA":false,"failedKillQuestion":false,"comments":""},{"questionId":"ae7b6608-cc80-41d0-aa43-c36d084911c5","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"adb2d8eb-17b6-4419-80ba-0dea55aec578","answerId":"6d91daba-2dd6-406f-817c-a75e17bd750b","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Reviewed PNR and no errors found, checked in all paxs"}]},{"questionGroupId":"68f9eaba-0e66-4d4e-b4dd-92e1fb4ad1dd","totalScore":17,"maxTotalScore":20,"markedNA":false,"totalCriticalScore":0,"maxTotalCriticalScore":0,"totalNonCriticalScore":17,"maxTotalNonCriticalScore":20,"totalScoreUnweighted":17,"maxTotalScoreUnweighted":20,"totalCriticalScoreUnweighted":0,"maxTotalCriticalScoreUnweighted":0,"totalNonCriticalScoreUnweighted":17,"maxTotalNonCriticalScoreUnweighted":20,"questionScores":[{"questionId":"305c72c7-1117-49d9-9531-630e40c3544d","answerId":"247cd8b0-6b54-4f74-b319-b2adc1f27f42","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"Caller gave name but not used on call"},{"questionId":"74ffd71b-14f4-4f82-b6f6-5df87372254e","answerId":"7bb343f7-1258-4bb2-ae6d-8a683e7bed14","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"Understood the caller needs"},{"questionId":"591be936-d3ce-44d7-97da-793ccca29ce1","answerId":"d4056225-19ff-4327-95d0-6113375c91d7","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Very supportive and encouraging with the caller"},{"questionId":"a136ffd4-c06b-45b6-9609-8103dbe19de7","answerId":"f0ced4e9-4d8a-49b7-875a-adf6ac8adcc0","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Explained what you were doing and asked clarifying questions"},{"questionId":"359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5","answerId":"7e415064-8e24-4879-8304-65de477264e9","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"No options to offer but good job just checking in the PAXs to assist."}]}],"anyFailedKillQuestions":false,"comments":"Good call overall with great support and positive attitude  towards the caller.  Caller thought there were errors on their part but in reviewing the record everything looked good and you were able to successfully check everyone in.  Good job supporting  the caller!"},"agentHasRead":false,"assignedDate":"2021-05-10T00:11:36.716Z","changedDate":"2021-05-10T00:18:10.848Z","mediaType":["CALL"],"conversationDate":"2021-05-06T02:21:49.157Z","conversationEndDate":"2021-05-06T02:27:28.207Z","neverRelease":true,"selfUri":"/api/v2/quality/conversations/ea5c9cff-f680-4d11-a5e0-3f22dc954531/evaluations/c6a0c174-0f8c-4355-829e-6de79a0bbc4e"},{"id":"81da732a-5486-41ff-af52-a9d0c57376be","conversation":{"id":"903a1255-984b-463b-903a-fe26e3d80423","selfUri":"/api/v2/conversations/903a1255-984b-463b-903a-fe26e3d80423"},"evaluationForm":{"id":"c3f388c3-49b5-4862-8f0c-c0f37756a34b","name":"SSC Standard Evaluation Form","published":true,"selfUri":"/api/v2/quality/publishedforms/evaluations/c3f388c3-49b5-4862-8f0c-c0f37756a34b"},"evaluator":{"id":"4cdc2d34-9945-4a9a-90eb-15b07959c677","selfUri":"/api/v2/users/4cdc2d34-9945-4a9a-90eb-15b07959c677"},"agent":{"id":"d9114c12-8a7d-44f2-8f9d-ea79ff80f96f","selfUri":"/api/v2/users/d9114c12-8a7d-44f2-8f9d-ea79ff80f96f"},"status":"FINISHED","answers":{"totalScore":88.88889,"totalCriticalScore":0,"totalNonCriticalScore":88.88889,"questionGroupScores":[{"questionGroupId":"df4ffd43-df77-40d4-8a0e-ed48140cd03a","totalScore":16,"maxTotalScore":16,"markedNA":false,"totalCriticalScore":0,"maxTotalCriticalScore":0,"totalNonCriticalScore":16,"maxTotalNonCriticalScore":16,"totalScoreUnweighted":4,"maxTotalScoreUnweighted":4,"totalCriticalScoreUnweighted":0,"maxTotalCriticalScoreUnweighted":0,"totalNonCriticalScoreUnweighted":4,"maxTotalNonCriticalScoreUnweighted":4,"questionScores":[{"questionId":"ac8fe92f-8f82-48c8-997e-cec2545c86db","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"82bc4c8a-3b4e-4bbb-b606-9ac423036349","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"d1b294ce-02f7-4bd6-8a54-12184c6cb7f7","answerId":"ee58a96d-7bef-41ca-90e1-b73cf3d7a6c1","score":4,"markedNA":false,"failedKillQuestion":false,"comments":""},{"questionId":"ae7b6608-cc80-41d0-aa43-c36d084911c5","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":""},{"questionId":"adb2d8eb-17b6-4419-80ba-0dea55aec578","answerId":"","score":0,"markedNA":true,"failedKillQuestion":false,"comments":"Call was for information regarding changing a  PAX ticket by Supervisor"}]},{"questionGroupId":"68f9eaba-0e66-4d4e-b4dd-92e1fb4ad1dd","totalScore":16,"maxTotalScore":20,"markedNA":false,"totalCriticalScore":0,"maxTotalCriticalScore":0,"totalNonCriticalScore":16,"maxTotalNonCriticalScore":20,"totalScoreUnweighted":16,"maxTotalScoreUnweighted":20,"totalCriticalScoreUnweighted":0,"maxTotalCriticalScoreUnweighted":0,"totalNonCriticalScoreUnweighted":16,"maxTotalNonCriticalScoreUnweighted":20,"questionScores":[{"questionId":"305c72c7-1117-49d9-9531-630e40c3544d","answerId":"247cd8b0-6b54-4f74-b319-b2adc1f27f42","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"Caller gave name but not used."},{"questionId":"74ffd71b-14f4-4f82-b6f6-5df87372254e","answerId":"7bb343f7-1258-4bb2-ae6d-8a683e7bed14","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"Understood the callers need after a long explaination"},{"questionId":"591be936-d3ce-44d7-97da-793ccca29ce1","answerId":"d4056225-19ff-4327-95d0-6113375c91d7","score":4,"markedNA":false,"failedKillQuestion":false,"comments":"Good empathy with the passengers situation"},{"questionId":"a136ffd4-c06b-45b6-9609-8103dbe19de7","answerId":"7d2bcc5c-6a90-41f1-bd8e-3b7472558095","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"Expressed appropriate understanding and clear on limit of authorizing changes."},{"questionId":"359c1ec5-1d9c-4baf-80f4-ca9cc6ce30b5","answerId":"7e415064-8e24-4879-8304-65de477264e9","score":3,"markedNA":false,"failedKillQuestion":false,"comments":"Good Option to have a CRO authorize in MIA"}]}],"anyFailedKillQuestions":false,"comments":"Good call overall.  Caller was a off-duty AA supervisor involved with a passenger in a family emergency situation, needing to change return flight.  Unusual situation with passenger having supervisors personal phone number.  Appropriate empathy for situation and adherence to company policy throughout the call."},"agentHasRead":false,"assignedDate":"2021-05-09T23:44:54.827Z","changedDate":"2021-05-09T23:54:09.734Z","mediaType":["CALL"],"conversationDate":"2021-05-02T19:35:22.847Z","conversationEndDate":"2021-05-02T19:40:45.687Z","neverRelease":true,"selfUri":"/api/v2/quality/conversations/903a1255-984b-463b-903a-fe26e3d80423/evaluations/81da732a-5486-41ff-af52-a9d0c57376be"}],"pageSize":25,"pageNumber":1,"total":6,"firstUri":"/api/v2/quality/evaluations/query?pageSize=25&pageNumber=1","selfUri":"/api/v2/quality/evaluations/query?pageSize=25&pageNumber=1","lastUri":"/api/v2/quality/evaluations/query?pageSize=25&pageNumber=1","pageCount":1},"runAfter":{}},"AgentID":{"type":"Select","inputs":{"from":"@outputs('Compose')?['entities']","select":"@item()?['agent']?['id']"},"runAfter":{"Compose":["Succeeded"]}},"QuestionGroupScores":{"type":"Select","inputs":{"from":"@outputs('Compose')?['entities']","select":"@item()?['answers']?['questionGroupScores']"},"runAfter":{"AgentID":["Succeeded"]}},"Apply_to_each":{"type":"Foreach","foreach":"@range(0,length(body('AgentID')))","actions":{"SelectQuestionScores":{"type":"Select","inputs":{"from":"@body('QuestionGroupScores')?[item()]","select":"@item()?['questionScores']"},"runAfter":{}},"SelectQuestionScoreObjects":{"type":"Select","inputs":{"from":"@outputs('Union')","select":{"questionid ":"@item()?['questionid']","score":"@item()?['score']","agent id":"@body('AgentID')?[items('Apply_to_each')]"}},"runAfter":{"Union":["Succeeded"]}},"Union":{"type":"Compose","inputs":"@union(body('SelectQuestionScores')?[0],body('SelectQuestionScores')?[1])","runAfter":{"SelectQuestionScores":["Succeeded"]}},"Replace":{"type":"Compose","inputs":"@replace(replace(string(body('SelectQuestionScoreObjects')),']',''),'[','')","runAfter":{"SelectQuestionScoreObjects":["Succeeded"]}},"Append_to_string_variable":{"type":"AppendToStringVariable","inputs":{"name":"Array","value":"@{outputs('Replace')},"},"runAfter":{"Replace":["Succeeded"]}}},"runAfter":{"QuestionGroupScores":["Succeeded"]}},"Jsonify":{"type":"Compose","inputs":"@json(concat(variables('Array'),']'))","runAfter":{"Apply_to_each":["Succeeded"]}},"Create_CSV_table":{"type":"Table","inputs":{"from":"@outputs('Jsonify')","format":"CSV"},"runAfter":{"Jsonify":["Succeeded"]}},"Create_HTML_table":{"type":"Table","inputs":{"from":"@outputs('Jsonify')","format":"HTML"},"runAfter":{"Create_CSV_table":["Succeeded"]}}},"runAfter":{"Initialize_variable":["Succeeded"]}}}

I've done this with one apply to each, and have built up the final array using a string and then converting to an array.

I've retrieved the agent id and question group score (using select).

Then using a range based on the length of the agent ID array, used an apply to each to bring the question id and score (of which there are two objects - using union on oject 0 & 1) together.  I then use select to build an array but convert to string, remove the closing brackets of the array and append to the string variable.

Finally, outside of the apply to each, I concat the string with a closing ] and apply the json expression before passing to either the create CSV or Table action.

Runs in a couple of seconds, hope it is what you are looking for but please test as this one was quite complex.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

[F_Quint]

hi @DamoBird365 the output that you're getting is exactly what I'm after, however, I'm lost at how you are copying and pasting into "new step" -> "my clipboard".

Never mind I got it. 

you're awsome! Thank you so much

[F_Quint]

@DamoBird365 
Once again thank you very much for your help here.

I have some follow up questions if you don't mind and I can open a new thread if you prefer it that way. . 

1. What part of the flow do I need to edit to add the Conversation id
2. also if I wanted to combine with the above conversationid with something like  http://mycall.com to end up with  http://mycall.com/conversationid
3. Lastly, how I can replace something like this agent id (example: 2375389f-987f-4e06-82c1-c6878fd8dce8​) for an actual name like John Doe and present that as the Agend ID in the CSV column. There are about 20 people so building some sort of table to do a look up might be way to go I'm thinking

Thank you again, you were great help. 

much appreciated!