Skip to main content
M
mohdjaveda0001
September 8, 2022
Solved

Unable to return a JSON from Expression rule

  • September 8, 2022
  • 3 replies
  • 0 views

Hi team,

I am trying to return a hardcoded json value from an expression rule but I am not able to do so. I have tried even with escape sequences i.e, /" but still I am not getting the proper output. Could u pls help ?

original JSON:

{
     "uuid" : "6722c859-76b4-4aa8-ac82-3b3f93d903ba",
     "name" : "ContainerisedApp",
     "description" : "",
     "jiraId" : "REP-4783",
     "mappedCases" : [ {
        "caseUuid" : "8fcfc7a7-d989-4592-b321-d456460c7f0d",
        "casePath" : "ContainerisedApp",
        "runMode" : false,
        "reportable" : true,
        "caseExecutionSequence" : 1,
        "datasheetType" : "Default",
        "dataStore" : {
           "type" : "Excel",
           "path" : "ScriptsContainerisedApp.xlsx",
           "sheetName" : "ValidateAppRej"
        }
     }, {
        "caseUuid" : "2e010c2e-6b4e-42c5-bea7-5cfe03f242e6",
        "casePath" : "ContainerisedApp",
        "runMode" : false,
        "reportable" : true,
        "caseExecutionSequence" : 2,
        "datasheetType" : "Default",
        "dataStore" : {
           "type" : "Excel",
           "path" : "ScriptsContainerisedApp.xlsx",
           "sheetName" : "ValidateAppRej_GE"
        }
     }, {
        "caseUuid" : "0c604570-a5cb-4af1-afc4-65b6a65a951c",
        "casePath" : "ContainerisedApp",
        "runMode" : true,
        "reportable" : true,
        "caseExecutionSequence" : 3,
        "datasheetType" : "Default",
        "dataStore" : {
           "type" : "Excel",
           "path" : "ScriptsContainerisedApp.xlsx",
           "sheetName" : "ValidateSearchUI_658"
        }
     }, {
        "caseUuid" : "3d2a6d90-99d7-4b29-a76b-540a62e4a18e",
        "casePath" : "ContainerisedApp",
        "runMode" : false,
        "reportable" : true,
        "caseExecutionSequence" : 4,
        "datasheetType" : "Default",
        "dataStore" : {
           "type" : "Excel",
           "path" : "ScriptsContainerisedApp.xlsx",
           "sheetName" : "ValidateAmountError"
        }
     }, {
        "caseUuid" : "1e9d2603-7dcd-459e-93cf-cdc43a6a5480",
        "casePath" : "saveBtnValidate_367",
        "runMode" : false,
        "reportable" : true,
        "caseExecutionSequence" : 5,
        "datasheetType" : "NoDatasheet",
        "dataStore" : {
           "type" : ""
        }
     }, {
        "caseUuid" : "a25092c2-d22e-48e0-a2e2-1c8ce5da98b6",
        "casePath" : "ContainerisedApp",
        "runMode" : false,
        "reportable" : true,
        "caseExecutionSequence" : 6,
        "datasheetType" : "Default",
        "dataStore" : {
           "type" : "Excel",
           "path" : "ScriptsContainerisedApp.xlsx",
           "sheetName" : "ValidateDDOptions_1147"
        }
     }, {
        "caseUuid" : "5d4151e8-6c3c-49d7-a17f-7b5945d86dba",
        "casePath" : "ContainerisedApp",
        "runMode" : false,
        "reportable" : true,
        "caseExecutionSequence" : 7,
        "datasheetType" : "Default",
        "dataStore" : {
           "type" : "Excel",
           "path" : "ScriptsContainerisedApp.xlsx",
           "sheetName" : "ValidateErrorMsg"
        }
     }, {
        "caseUuid" : "c8a2bdba-4215-46c5-b21b-af516ce9ed25",
        "casePath" : "ContainerisedApp",
        "runMode" : false,
        "reportable" : true,
        "caseExecutionSequence" : 8,
        "datasheetType" : "NoDatasheet",
        "dataStore" : {
           "type" : ""
        }
     }, {
        "caseUuid" : "ace5e793-7df1-457b-b765-506229d34f40",
        "casePath" : "ContainerisedApp",
        "runMode" : false,
        "reportable" : true,
        "caseExecutionSequence" : 9,
        "datasheetType" : "NoDatasheet",
        "dataStore" : {
           "type" : ""
        }
     }, {
        "caseUuid" : "31e62811-d849-4bb6-8492-cf19b8b4de1e",
        "casePath" : "validateREPInfraPermissions",
        "runMode" : false,
        "reportable" : true,
        "caseExecutionSequence" : 10,
        "datasheetType" : "Default",
        "dataStore" : {
           "type" : "Excel",
           "path" : "ScriptsContainerisedApp.xlsx",
           "sheetName" : "validateREPInfraPermissions"
        }
     }, {
        "caseUuid" : "61169fbb-8181-42e5-8d45-052b58fc7c6c",
        "casePath" : "ValidateAmountHighlighted",
        "runMode" : false,
        "reportable" : true,
        "caseExecutionSequence" : 11,
        "datasheetType" : "Default",
        "dataStore" : {
           "type" : "Excel",
           "path" : "ScriptsContainerisedApp.xlsx",
           "sheetName" : "ValidateAmountHighlighted"
        }
     }, {
        "caseUuid" : "b4b3c482-6e97-4330-b576-53d21b21f62a",
        "casePath" : "AmountFunctionality_1148",
        "runMode" : false,
        "reportable" : true,
        "caseExecutionSequence" : 12,
        "datasheetType" : "Default",
        "dataStore" : {
           "type" : "Excel",
           "path" : "ScriptsContainerisedApp.xlsx",
           "sheetName" : "AmountFunctionality_1148"
        }
     } ],
     "userI" : "abc@bc.cc"
  }

JSON with escape sequences:

{
     /"uuid/" : /"6722c859-76b4-4aa8-ac82-3b3f93d903ba/",
     /"name/" : /"ContainerisedApp/",
     /"description/" : /"/",
     /"jiraId/" : /"REP-4783/",
     /"mappedCases/" : [ {
        /"caseUuid/" : /"8fcfc7a7-d989-4592-b321-d456460c7f0d/",
        /"casePath/" : /"\\\\ContainerisedApp/",
        /"runMode/" : false,
        /"reportable/" : true,
        /"caseExecutionSequence/" : 1,
        /"datasheetType/" : /"Default/",
        /"dataStore/" : {
           /"type/" : /"Excel/",
           /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/",
           /"sheetName/" : /"ValidateAppRej/"
        }
     }, {
        /"caseUuid/" : /"2e010c2e-6b4e-42c5-bea7-5cfe03f242e6/",
        /"casePath/" : /"\\\\ContainerisedApp/",
        /"runMode/" : false,
        /"reportable/" : true,
        /"caseExecutionSequence/" : 2,
        /"datasheetType/" : /"Default/",
        /"dataStore/" : {
           /"type/" : /"Excel/",
           /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/",
           /"sheetName/" : /"ValidateAppRej_GE/"
        }
     }, {
        /"caseUuid/" : /"0c604570-a5cb-4af1-afc4-65b6a65a951c/",
        /"casePath/" : /"\\\\ContainerisedApp/",
        /"runMode/" : true,
        /"reportable/" : true,
        /"caseExecutionSequence/" : 3,
        /"datasheetType/" : /"Default/",
        /"dataStore/" : {
           /"type/" : /"Excel/",
           /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/",
           /"sheetName/" : /"ValidateSearchUI_658/"
        }
     }, {
        /"caseUuid/" : /"3d2a6d90-99d7-4b29-a76b-540a62e4a18e/",
        /"casePath/" : /"\\\\ContainerisedApp/",
        /"runMode/" : false,
        /"reportable/" : true,
        /"caseExecutionSequence/" : 4,
        /"datasheetType/" : /"Default/",
        /"dataStore/" : {
           /"type/" : /"Excel/",
           /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/",
           /"sheetName/" : /"ValidateAmountError/"
        }
     }, {
        /"caseUuid/" : /"1e9d2603-7dcd-459e-93cf-cdc43a6a5480/",
        /"casePath/" : /"\\\\saveBtnValidate_367/",
        /"runMode/" : false,
        /"reportable/" : true,
        /"caseExecutionSequence/" : 5,
        /"datasheetType/" : /"NoDatasheet/",
        /"dataStore/" : {
           /"type/" : /"/"
        }
     }, {
        /"caseUuid/" : /"a25092c2-d22e-48e0-a2e2-1c8ce5da98b6/",
        /"casePath/" : /"\\\\ContainerisedApp/",
        /"runMode/" : false,
        /"reportable/" : true,
        /"caseExecutionSequence/" : 6,
        /"datasheetType/" : /"Default/",
        /"dataStore/" : {
           /"type/" : /"Excel/",
           /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/",
           /"sheetName/" : /"ValidateDDOptions_1147/"
        }
     }, {
        /"caseUuid/" : /"5d4151e8-6c3c-49d7-a17f-7b5945d86dba/",
        /"casePath/" : /"\\\\ContainerisedApp/",
        /"runMode/" : false,
        /"reportable/" : true,
        /"caseExecutionSequence/" : 7,
        /"datasheetType/" : /"Default/",
        /"dataStore/" : {
           /"type/" : /"Excel/",
           /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/",
           /"sheetName/" : /"ValidateErrorMsg/"
        }
     }, {
        /"caseUuid/" : /"c8a2bdba-4215-46c5-b21b-af516ce9ed25/",
        /"casePath/" : /"\\\\ContainerisedApp/",
        /"runMode/" : false,
        /"reportable/" : true,
        /"caseExecutionSequence/" : 8,
        /"datasheetType/" : /"NoDatasheet/",
        /"dataStore/" : {
           /"type/" : /"/"
        }
     }, {
        /"caseUuid/" : /"ace5e793-7df1-457b-b765-506229d34f40/",
        /"casePath/" : /"\\\\ContainerisedApp/",
        /"runMode/" : false,
        /"reportable/" : true,
        /"caseExecutionSequence/" : 9,
        /"datasheetType/" : /"NoDatasheet/",
        /"dataStore/" : {
           /"type/" : /"/"
        }
     }, {
        /"caseUuid/" : /"31e62811-d849-4bb6-8492-cf19b8b4de1e/",
        /"casePath/" : /"\\\\validateREPInfraPermissions/",
        /"runMode/" : false,
        /"reportable/" : true,
        /"caseExecutionSequence/" : 10,
        /"datasheetType/" : /"Default/",
        /"dataStore/" : {
           /"type/" : /"Excel/",
           /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/",
           /"sheetName/" : /"validateREPInfraPermissions/"
        }
     }, {
        /"caseUuid/" : /"61169fbb-8181-42e5-8d45-052b58fc7c6c/",
        /"casePath/" : /"\\\\ValidateAmountHighlighted/",
        /"runMode/" : false,
        /"reportable/" : true,
        /"caseExecutionSequence/" : 11,
        /"datasheetType/" : /"Default/",
        /"dataStore/" : {
           /"type/" : /"Excel/",
           /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/",
           /"sheetName/" : /"ValidateAmountHighlighted/"
        }
     }, {
        /"caseUuid/" : /"b4b3c482-6e97-4330-b576-53d21b21f62a/",
        /"casePath/" : /"\\\\AmountFunctionality_1148/",
        /"runMode/" : false,
        /"reportable/" : true,
        /"caseExecutionSequence/" : 12,
        /"datasheetType/" : /"Default/",
        /"dataStore/" : {
           /"type/" : /"Excel/",
           /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/",
           /"sheetName/" : /"AmountFunctionality_1148/"
        }
     } ],
     /"userI/" : /"abc@bc.cc/"
  }

Best answer by deepakg681722

a!toJson(
  {
    uuid : "6722c859-76b4-4aa8-ac82-3b3f93d903ba",
    name : "ContainerisedApp",
    description : "",
    jiraId : "REP-4783",
    mappedCases : {
      {
        caseUuid : "61169fbb-8181-42e5-8d45-052b58fc7c6c",
        casePath : "ValidateAmountHighlighted",
        runMode : false,
        reportable : true,
        caseExecutionSequence : 11,
        datasheetType : "Default",
        dataStore : {
          type : "Excel",
          path : "ScriptsContainerisedApp.xlsx",
          sheetName : "ValidateAmountHighlighted"
        }
      },
      {
        caseUuid : "b4b3c482-6e97-4330-b576-53d21b21f62a",
        casePath : "AmountFunctionality_1148",
        runMode : false,
        reportable : true,
        caseExecutionSequence : 12,
        datasheetType : "Default",
        dataStore : {
          type: "Excel",
          path : "ScriptsContainerisedApp.xlsx",
          sheetName : "AmountFunctionality_1148"
        }
      } 
    },
    userI : "abc@bc.cc"
  }
)

3 replies

D
deepakg681722Answer
September 8, 2022

a!toJson(
  {
    uuid : "6722c859-76b4-4aa8-ac82-3b3f93d903ba",
    name : "ContainerisedApp",
    description : "",
    jiraId : "REP-4783",
    mappedCases : {
      {
        caseUuid : "61169fbb-8181-42e5-8d45-052b58fc7c6c",
        casePath : "ValidateAmountHighlighted",
        runMode : false,
        reportable : true,
        caseExecutionSequence : 11,
        datasheetType : "Default",
        dataStore : {
          type : "Excel",
          path : "ScriptsContainerisedApp.xlsx",
          sheetName : "ValidateAmountHighlighted"
        }
      },
      {
        caseUuid : "b4b3c482-6e97-4330-b576-53d21b21f62a",
        casePath : "AmountFunctionality_1148",
        runMode : false,
        reportable : true,
        caseExecutionSequence : 12,
        datasheetType : "Default",
        dataStore : {
          type: "Excel",
          path : "ScriptsContainerisedApp.xlsx",
          sheetName : "AmountFunctionality_1148"
        }
      } 
    },
    userI : "abc@bc.cc"
  }
)

    M
    mohdjaveda0001Author
    September 8, 2022

    Thanks Deepak. It worked for me.

    D
    deepakg681722
    September 8, 2022

    YW

    Terms & ConditionsAccessibility statement