Fetch the value inside a text file

[tharaninatarajan1901 (RPALearner)]

I have below information in text file .There are multiple text file inside the folder

Input : {“WorkItem”:“51234557”,“ConversationID”:“10635790”}

Expected output : 10635790

I need to fetch the value for ConversationID and add into datatable .

Please guide me

[AutomationX_by_Kiran]

Hi @tharaninatarajan1901 ,

Use Json file has Dictionary and Get value

for you reference pls check below link…

Howto use JSON as config file

Hi @Enrico, Fine…! Kindly refer to the below xaml file. Hope this would help you to use JSON file json.xaml (5.3 KB) Before that kindly install UiPath.Web.Activities package in your studio to use this JSON file. Because you wont be having the activities related JSON files readily available in activity panel by default. Once you save this package to your studio from Manage package option in design tab, you can go ahead further…! I would like to give you few more suggestions for the issue tha…

[Jithesh_R (Jithesh Karkera)]

@tharaninatarajan1901 ,

1. Use Read text file activity to Read the data from the Text file
   2.Use deserialize Json Activity to Convert the Output From String to “Jobject” and Provide the TextfileOutput as input for this activity.
2. Set the Output of “Desrialize Json” activity as something like this .Lets say “JsonOutput”
   4.Now take an assign activity and give JsonOutput(“ConversationID”).ToString
   This will provide you with the required output for Conversation ID

Regards,

[Yoichi]

HI,
How about either of the following?

Regex

System.Text.RegularExpressions.Regex.Match(yourString,"(?<=ConversationID\W+)\d+").Value

DeserializeJson

jo("ConversationID").Value(Of String)

Sample20230613-7L.zip (4.5 KB)

Regards,