Question
Eclantiqx
AU
Last activity: 27 Apr 2023 4:25 EDT
How to get JsonPayload from queue
Hi, I have to retrive Json Data from queue (single) i mean count 1 in Queue, my json payload will be more than one row, ex: Number is having 2 times in list, i want extract Number1 and 2 one by one from queue. i saw there is no retieve exact payload from queue,
{
"caseTypeID": "ABCK-ABC-Work-RegisterUser",
"content": {
"UserDetails":[
{
"Number":"SSN0061",
"DOB":"19821119",
"LastName":"LastName1248",
"FirstName":"FirstName15777",
"ActivityDate":"20150321",
"MiddleName":"Middle145898"
},
{
"Number":"SSN0062",
"DOB":"19821120",
"LastName":"LastName123",
"FirstName":"FirstName157777",
"ActivityDate":"20150326",
"MiddleName":"Middle145899"
}
]
}
}
Evonsys
IN
@SarveswaraR If you convert this json to page, it will be in page.pagelist structure. Then you will be able to fetch the data from that pagelist. Will that work for you?
Eclantiqx
AU
@Anoop Krishna you mean to say before laod into queue, in pega side need to convert Page.pagelist structure then load into Queue? is this correct? then from queue to robot which proprty need use to get info?
Evonsys
IN
@Sarveswara Reddy Okay, this is about Pega RPA. I am not sure how data ingestion to RPA works, but if you want the payload data to be structured into pega page structure and you need to use that, then once you have converted to page.pagelist, you will need to send each of the pages in the pagelist seperately.
Evonsys
IN
@Sarveswara Reddy Good to know that, can you share the solution?
Eclantiqx
AU
@Anoop Krishna
{ "caseTypeID": "ABCK-ABC-Work-RegisterUser", "content": { "UserDetails":[ { "Number":"SSN0061", "DOB":"19821119", "LastName":"LastName1248", "FirstName":"FirstName15777", "ActivityDate":"20150321", "MiddleName":"Middle145898" }, { "Number":"SSN0062", "DOB":"19821120", "LastName":"LastName123", "FirstName":"FirstName157777", "ActivityDate":"20150326", "MiddleName":"Middle145899" } ] } }
@Anoop Krishna
{ "caseTypeID": "ABCK-ABC-Work-RegisterUser", "content": { "UserDetails":[ { "Number":"SSN0061", "DOB":"19821119", "LastName":"LastName1248", "FirstName":"FirstName15777", "ActivityDate":"20150321", "MiddleName":"Middle145898" }, { "Number":"SSN0062", "DOB":"19821120", "LastName":"LastName123", "FirstName":"FirstName157777", "ActivityDate":"20150326", "MiddleName":"Middle145899" } ] } }
Created Property in data model - UserDetails extracting data from queue as proprty name and so information will come [ { "Number":"SSN0061", "DOB":"19821119", "LastName":"LastName1248", "FirstName":"FirstName15777", "ActivityDate":"20150321", "MiddleName":"Middle145898" }, { "Number":"SSN0062", "DOB":"19821120", "LastName":"LastName123", "FirstName":"FirstName157777", "ActivityDate":"20150326", "MiddleName":"Middle145899" } ] then loop one by one, i mean row by row.