How to get data after ( " : " )?

[170290064 (Eyüp Hasan Akbaba)]

Result = {“sfiyat_fiyati”:222}

The type of result is string but it comes like Json

Can i use split ? If i can how come ??

I only need numbers after (" : ")

[pikorpa (Piotr Kołakowski)]

hey @170290064
you can use:

1. Assign: splitResult = Result.Split(":"c)
2. Assign: numberAsString = splitResult(1).Trim(New Char() { "}"c, " "c })
3. Assign: finalNumber = Convert.ToInt32(numberAsString)

or

1. Deserialize JSON Activity:

• JsonString: Your JSON string variable (e.g., Result).
• Result: A new variable of type JObject (e.g., jsonObject).

2. Assign Activity (to extract the value):

• To: extractedValue (an integer variable to store the extracted number).
• Value: CInt(jsonObject("sfiyat_fiyati").ToString)

[ashokkarale]

@170290064

Here you go

Here’s how you can do it step by step:

1. Use the Deserialize JSON activity:

• Drag and drop the “Deserialize JSON” activity onto your workflow.
• In the properties panel, set the Input property to your JSON string ({"sfiyat_fiyati":222}).
• Create a variable to store the deserialized output, let’s call it jsonObject.

2. Access the value:

• Use an Assign activity or any appropriate activity to extract the value associated with the key sfiyat_fiyati.
• For example, you can use jsonObject("sfiyat_fiyati").ToString to get the value 222 as a string.

Thanks,
Ashok

[170290064 (Eyüp Hasan Akbaba)]

The RPA product that i am using doesn’t have Deserialize JSON activity. So that why i am looking for a way to solve it.

But it has code editor. How can i do it i do not know.

[ptrobot]

You can deserialize the JSON string to a JObject.

[170290064 (Eyüp Hasan Akbaba)]

The RPA product that i am using doesn’t have Deserialize JSON activity. So that why i am looking for a way to solve it.

But it has code editor. How can i do it i do not know.

[ptrobot]

Are you allowed to install packages? If yes, you can install it from Manage Packages. Search for the package UiPath.WebAPI.Activities.

[170290064 (Eyüp Hasan Akbaba)]

That’s the problem. I am not using UiPath RPA. I am using local RPA.

Thats why i need help

[ptrobot]

If you are not using UiPath Studio, it would be helpful for us to know what tool and what programming language you are using.

[ppr (Peter Preuss)]

@170290064

{“sfiyat_fiyati”:222}

As it is JSON we can do directly like:

[ashokkarale]

In that case here you go. It’s lengthy but you are open to optimize it.

JsonSplit.xaml (10.4 KB)

Thanks,
Ashok

[170290064 (Eyüp Hasan Akbaba)]

I used code editor in the RPA Program but i am getting some kinda error

[loginerror (Maciej Kuźmicz)]

Shameless plug of the new Deserialize JSON feature that produces an object out of a sample JSON to make this easier

It works like this, during design time: