How to Update the property value of the json object file e.g:("status"="success")

Help Something Else
, ,
1

{

"customer": {
  "name": "XXXX",
  "code:": "XXyy",
  "beat": "HHHHH"
},
"Status": "",
2

@Anji_Eswar
Welcome to the Forum

May we ask you to Share the entire json

In General WE do

  • Deserialize the json
  • Access the Token
  • Update the value
3

[

{

"customer": {

  "name": "I D B I Bank",

  "code:": "I D B I Bank",

  "beat": "COUNTER(S.P)"

},

"Status": "Success",

"Orders": "",

"salesperson": {

  "name": "HARISH",

  "qwiponame": "HARISH"

},

"items": [

  {

    "itemshortcode": "AFIKS",

    "itemname": "Allout Baygon FIK-250ml",

    "quantity": 5

  },

  {

    "itemshortcode": "ATPN",

    "itemname": "Allout.liq.twinpack-45ml",

    "quantity": 3

  },

  {

    "itemshortcode": "AGLN",

    "itemname": "Glad Aerosol Lavender-320ml",

    "quantity": 7

  }

]

},

{

"customer": {

  "name": "DEVI MED",

  "code:": "DEVI MED",

  "beat": "DOULTHABAD"

},

"Status": "",

"Orders": "",

"salesperson": {

  "name": "HARISH",

  "qwiponame": "HARISH"

},

"items": [

  {

    "itemshortcode": "NVG",

    "itemname": "NOVA Hair styling Gel050gm",

    "quantity": 3

  },

  {

    "itemshortcode": "5S",

    "itemname": "FIVE.STAR-10.1GM",

    "quantity": 4

  },

  {

    "itemshortcode": "CDMM",

    "itemname": "CAT.DIARYMILK-13.2GM",

    "quantity": 3

  }

]

}

]

4

I am not able to update the status in json file @ppr by using assign activity item(“status”)=“Success”
please help me.

5

start like below:

grafik
grafik533Ă—626 14.1 KB

grafik

it will update all looped status property values
grafik

6

Thank You So much @ppr
Only the status value is present/updated in the output after followed your steps but how the status value will update in the json file.
if possible please
Once again Thank you so much

7

it is updating the json
Before:

grafik
grafik274Ă—854 15.1 KB

after update
grafik
grafik321Ă—852 17.7 KB

in case the updated json is to persist just use the write text file activity and pass myJArray.toString to it

8

Thank you so much @ppr :heart_eyes:
I am not able to update in json file may be I am in wrong way.
Could you please give me the steps you followed to update value in the json file.

9

Have a look here:
grafik

  • read JSON
  • deserialize
  • loop & update
  • write updated JSON

Find starter help here:
ppr_JSONBox_AnjiEswar.xaml (8.2 KB)
data_AnjiEswar.json (1.3 KB)

1 Like
10

Thank you so much @ppr all are working fine from my end. :heart_eyes: