SS&C Blue Prism Community

nicolailykke · 22-08-24

Hi all,When receiving the response from a BigQuery.jobs query using Skills, I would like to have the data structured in a collection. However, I'm having trouble achieving this and always end up with rows that require looping to unnest.The entire res...

nicolailykke · 23-08-24

Hi Nandhakumar,Thank you very much  I got the time reduced to a few seconds with the regex solution, så it's perfect Have a great day!Best regards,Nicolai

nicolailykke · 23-08-24

Hi Nandhakumar,Thank you very much for taking the time to post a solution.Your solution does work, but it takes over 6 hours to loop through the rows on my test machine when running with our production data. I was hoping to find an alternative approa...

nicolailykke · 23-08-24

Hi Michael,Thank you for your solution  However, I am seeking a solution where I can avoid the looping part.I'm not sure if such a solution exists, but I end up having to loop through upwards of 100,000 rows, and that would take many hours each time...

nicolailykke · 22-08-24

Hi Nandhakumar,Thank you for the answer.I have used the action from the utillity but I still have to loop in order to unnest.I have provided an example of the response in my original post. Can you make that to work with the JSON to Collection (skippi...

nicolailykke · 22-08-24

Hi Parthiban,Thank you for the answer. Do you have a example of doing this without having to loop through the initial collection?I can't get that to work without looping which is the issue.Best regards,Nicolai

SS&C Blue Prism Community

User Statistics

User Activity

Response Content to Collection

Re: Response Content to Collection

Re: Response Content to Collection

Re: Response Content to Collection

Re: Response Content to Collection

Re: Response Content to Collection