How to file type

[manoj_verma1 (manoj verma)]

how to read a .json file

[Gokul001 (Gokul Balaji)]

Hi @manoj_verma1

You can use Deserialize-json activity to read the file

Check out the XAML file

https://docs.uipath.com/activities/docs/deserialize-json

[Yoichi]

Hi,

First read json file using ReadTextFile activty.

Next deserialize json string to json object using Deserialize Json activity.

It’s necessary to install WebApi package to use DeserializeJson actiivty from MangePackage.

Regards,

[manoj_verma1 (manoj verma)]

@Yoichi @Gokul001
“{
‘fruit’: ‘Apple’,
‘size’: ‘Large’,
‘color’: ‘Red’
}”

how can i update size and color as large and red keeps changing

[Yoichi]

Hi,

Hope the following sample helps you.

Sequence.xaml (6.0 KB)

Regards,

[manoj_verma1 (manoj verma)]

@Yoichi if i am reading saving back in same .json file how to do that

[Yoichi]

Hi,

Can you try WriteTextFile activity as the following?

Sample20221215-6.zip (2.5 KB)

Regards,

[manoj_verma1 (manoj verma)]

@Yoichi

api is this

{
“store”: [
{
‘fruit’: ‘Apple’,
‘size’: ‘Large’,
‘color’: ‘Red’
QTY: [
]
{
}
}}

[Yoichi]

Hi,

The above seems invalid json format. Can you share whole the json string as txt file?

Regards,

[manoj_verma1 (manoj verma)]

removedd…
removed

[Yoichi]

Hi,

If you need update Id, the following will work.

Sample20221215-6v2.zip (4.3 KB)

Regards,

[manoj_verma1 (manoj verma)]

@Yoichi what i need to do to update endid , sku

[Yoichi]

Hi,

Give it a try

Jo("Store")(0)("enduser")(0)("endId")="999"
Jo("Store")(0)("enduser")(0)("Pro")(0)("sku")="Orange"

Sample20221215-6v3.zip (3.3 KB)

Regards,

[Yoichi]

Hi,

Can you clarify your expected output?

Regards,

[manoj_verma1 (manoj verma)]

@Yoichi is there any way that we can find out how many end user are there ?
Jo(“Store”)(0)(“enduser”)(4)(“endId”)=“999”

ex. (“enduser”)(4)