We have a requirement where we need to get data from DB and post this to a rest end point.
I will convert the DB data to JSON using the pub.json:documentToJSONString but when I post that huge data I am getting memory exception error. So do we have have any technique to handle this.
One thing i can think off is to use repeat step and put a threshold say 5k or 1k record to process and invoke the http and do this till the total records are completed.
Loop Over Data
Sequence: $iteration==%threshold%(Here threshold is 1k)
adjust the json like replacing the end string } with ](as my requirement is sent it as an array)