Question

Update value in the nested json

Forum|Forum|3 years ago
September 27, 2022
11 replies
0 views

a!localVariables(
  local!metadataJSON: if(
    a!isNotNullOrEmpty(ri!metadataJSON),
    a!fromJson(ri!metadataJSON),
    null
  ),
  local!result: a!forEach(
    items: local!metadataJSON,
    expression: a!localVariables(
      local!section: fv!item,
      a!forEach(
        items: local!section.questions,
        expression: a!localVariables(
          local!questionrow: fv!item.questionrow,
          a!forEach(
            items: local!questionrow,
            expression: 
              if(
                fv!item.questiontitle = ri!targetField,
                updatedictionary(fv!item,
                {
                  "responsetext": ri!value
                }),
                null
              )
          )
        )
      )
    )
  ),
  local!metadataJSON
)

I have a nested json. I need to update its field "responestext" if its questiontitle is equal to the parameter. Then return the new json. But the original variable metadataJSON is not updated. Is there any function to update the origin value?

durgeshk0003

Check your result variable value.

K

kevins1191Author

In result variable it misses some fields. And the data struct is different.

The origin json

The result variable

harshitb6843

Can you paste the JSON here as code for better debugging?

K

kevins1191Author

[
    {
        "customkey": "",
        "sectioninstructions": "",
        "sectionparent": "root",
        "questions": [
            {
                "customkey": "",
                "rowlabelstyle": "",
                "rowlabel": "CV Submission",
                "questionrow": [
                    {
                        "customkey": "",
                        "ismandatory": "",
                        "questiontooltip": "",
                        "questionid": 1,
                        "readonly": "",
                        "questioninstructions": "",
                        "questiontitle": "CV Upload",
                        "responsetype": "recordaction",
                        "responsevalue": "",
                        "responsetext": "",
                        "parentid": 1
                    }
                ]
            }
        ],
        "sectionlevel": 1,
        "nestedjson": "",
        "sectionstyle": "bold",
        "sectiontype": "card",
        "collapsible": true,
        "sectionname": "Questionnaire",
        "objectid": 1,
        "parentid": 0
    }
]

This is the json. I need to update the "responsevalue" for the item in the "questionrow"

harshitb6843

What are the values of targetField and value Rule Inputs?

stefanhelzle0001

You cannot "change" a value in an expression in Appian. instead, you create a modified copy as the returned value.

K

kevins1191Author

Thanks for your suggestion. But How can I do it? Currently I do it in the expression rule. The json, targetField and value are the parameter. I parse the json as a new object in the rule and I do the change on this new object.

stefanhelzle0001

Sure. You create the modified copy in local!result but then define the unmodified value as the output.

In case you need a JSON string as the output, call toJson() to do so.

Sign up

Login with SSO

Login to the community

Login with SSO