How to append JSON Object in another File

Help Studio
, ,
1

Hi Team,

I have two Json File , One for DEV and One for PROD,

Basically i am trying to append “XYZ” from DEV JSON file to PROD file,
Could you please help me here , Attached is the JSON files

When ever new App code added i want to perform the same, so both file must be same

FileProd.txt (90 Bytes)
FileDev.txt (171 Bytes)

2

@shivkumar,

  1. Deserialize both the JSON to Dictionary(Of String, Object)
  2. Iterate through both file in separate for each to check if dictionary content the keys
  3. If any key missing from another dictionary, use assign activity to add that key and value

Thanks,
Ashok :slight_smile:

3

can u give me a small solution
I tired diff ways, but now i am doing this way also

4

Hi @shivkumar

image
image879×1221 46.4 KB

Hope it helps!!

5

What is json object argument type ?
image

6

@shivkumar

image

7

Maybe append can be understood as a merge:

1 Like
8

Its updating whole file in need to append that key only “XYZ”

Prod can have more, Dev can be less

9

Firstly Thanks for the help

1 Like
10

@shivkumar

Instead of Write text use Append line text activity to append
Check the below once

image
image608×662 19 KB

11

No this is not working , It will just append and break the JSON schema

ProdJsonObj.Merge(devJsonObj(“XYZ”)) is working but one problem is here
It is not merging in similar way
image

12

Illustrating above

grafik
with Details:

grafik
grafik801×543 57.9 KB

Before:
grafik

After:
grafik

And we can also fine tune the merging by adapting the MergeSettings

14

When it is about a Level1 merge and we want only add missing L1 Properties

In the mind that we can construct JOBjects from JProperty Collections:
grafik

We can do:

grafik
grafik794×361 52.8 KB

And get the merged JSON by:

grafik
grafik732×242 45.5 KB

So the origin ABC Appcode from Prod is kept and not overwritten by Dev

If it is needed different let us know and we can check for adaptions

1 Like
15

its updating the whole code,
FileProd.txt (182 Bytes)
FileDev.txt (372 Bytes)

I want to update only the XYZ updating file are attached for more clarification

16

share expected output from the above inputs

as we mentioned:

17

Using code i will check for the key “XYZ” that will be update only

SO no matter how many key on DEV file what i am looking that is going to be update

image
image1173×637 25.2 KB

18

Did you motioned the solution ?

19

@shivkumar

Newtonsoft.Json.JsonConvert.SerializeObject(ProdJsonObj, Newtonsoft.Json.Formatting.Indented)

image
image879×1724 65.8 KB

Hope it helps!!

20

assign activity code please

21

Just open them in Notepad and make the edits. They’re just text files.