Skip to main content
Question

String operation taking lot of time

  • August 28, 2023
  • 1 reply
  • 50 views

Forum|alt.badge.img+1

Hi, 

 

I have json response with 21 lakh data, I am doing some before after string manipulation to extract the appropriate data for me but the manipulation is taking lots of time.

Can anyone please help with this? whether the A360 is taking lots of time or is there any way to do json manipulation?

1 reply

LoganPrice
Most Valuable Pathfinder
Forum|alt.badge.img+12
  • Most Valuable Pathfinder
  • 77 replies
  • September 6, 2023

Can you explain which actions your are using? Are you using the JSON actions? Are you using loops? Screenshots would be ideal to see your current work.

One alternative to string ops is to use a JavaScript or Python function to parse the JSON. JavaScript is probably safer as I don’t think you have to manage software versions across your bot runner devices.

Your flow could be something like this:

  1. run JavaScript
    1. it will parse your json and return the value you want based on the script
  2. Assign the JavaScript output variable to whatever variables you are using
  3. loop over the script for each value you want to search

I have never tried this before, but I believe it can be done. I am not sure how much faster it would be compared to string ops.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings