How to assign json file as key and value to dictionary varible?

Help Studio
, ,
1

Hi , Guys,!!

I want to assign json file data as key and value to dictionary variable to config file.

variable out_Config type dictionary

this is my json file

{
“OrchestratorQueueName”: “Swivel_Chair_Queue”,
“OrchestratorQueueFolder”: “”,
“logF_BusinessProcessName”: “Framework”,
“InputFilePath”: “InputFile\Sample_Data.xlsx”,
“InputFileSheetName”: “Sheet1”,
“LoginCredential”: “LegacyAppCredentail”,
“OrchestratorFolderPath”: “IT Dept”,
“OrchestratorAssetName”: “GmailCredential”,
“SuccessMailBody”: “Data migrated successfully”,
“SuccessMailSubject”: “Data migrated successfully…”,
“MailPort”: “587”,
“MailServer”: “smtp.gmail.com”,
“SuccessMailTo”: “autm7@gmail.com”,
“FailMailTo”: “autm7@gmail.com”,
“FailMailBody”: “This currebt transaction has failed”,
“FailMailSubject”: “Data migration failed…”,
“SystemExceptionMailTo”: “a@gmail.com”,
“SystemExceptionMailSubject”: “Application Exception occurred…”,
“SystemExceptionMailBody”: “Hi, Team System/Application exception has occurred.”,
“MaxRetryNumber”: “0”,
“MaxConsecutiveSystemExceptions”: “0”,
“ExScreenshotsFolderPath”: “Exceptions_Screenshots”,
“LogMessage_GetTransactionData”: “Processing Transaction Number:”,
“LogMessage_GetTransactionDataError”: "Error getting transaction data for Transaction Number: ",
“LogMessage_Success”: “Transaction Successful.”,
“LogMessage_BusinessRuleException”: “Business rule exception.”,
“LogMessage_ApplicationException”: “System exception.”,
“ExceptionMessage_ConsecutiveErrors”: "The maximum number of consecutive system exceptions was reached. ",
“RetryNumberGetTransactionItem”: “2”,
“RetryNumberSetTransactionStatus”: “2”,
“ShouldMarkJobAsFaulted”: “FALSE”,
“urlDataScraping”: “Legacy Application Portal”,
“LoginLegacyAppURL”: “Modern Portal Login”,
“InputFileName”: “C:\Users\sanket.shinde\Documents\UiPath\RE_Swivel Chair Inc\InputFile\Sample_Data.xlsx”
}

2

Hello @Sanket_Shinde1 Welcome to the UiPath Community Forum.

Please find video tutorial of JSON to Dictionary & please check your JSON is valid or not.

JSON to Dictionary

1 Like
3

@Sanket_Shinde1 Please mark the response as solution if it has resolved your query, so that if anyone is searching for the same scenario they can use the response.

Thanks.

1 Like
4

Thank you,
Now I have assign those keys and values to out_Config variable,
Then How I can access specific key value using the out_Config variable

5

@Sanket_Shinde1 Please assign the out_Config variable to local variable defined in main activity or a global variable so that it holds the value throughout the process.

Accessing Dictionary will be like: For example -
Config(“logF_BusinessProcessName”).ToString

1 Like
6

Thank you so much Shantanu Sir, finally I have got the solution.

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.