Skip to main content

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?

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.


Reply