https://community.blueprism.com/t5/Product-Forum/API-response-in-Collection-Out-of-memory/m-p/72396#M25001 May or may not be helpful to you in this situation but... I have found that even in newer versions of BP it does not typically enjoy nested collections when they are nested to the extreme that the default BP JSON to Collection action nests them, eg. JArrays become a collection of rows with each row being a collection and possible further nesting beyond that. Solutions that I typically use are to create custom JSON actions with .NET Code stages to either flatten the JSON structure and pull out a collection from the flattened structure ; create custom JSON actions with .NET code stages to utilize JsonPath and pull exactly what I need out of the JSON directly if I don't need everything ; create custom JSON actions with .NET code stages to pull a collection out of the JSON at a specified depth / JSON path while also flattening the remaining depths.<BR /><BR />------------------------------<BR />Erin Connerley<BR />Automation Consultant<BR />Agilify Automation<BR />America/Indiana/Indianapolis<BR />------------------------------<BR /> Mon, 06 Dec 2021 13:48:00 GMT ErinConnerley 2021-12-06T13:48:00Z https://community.blueprism.com/t5/Product-Forum/API-response-in-Collection-Out-of-memory/m-p/72394#M24999 Hello,<BR /><BR />I am trying to get an api response in collection through (JSON to collection BO).<BR />Now JSON has more than 30k records and collection is failing to store all the data.<BR /><BR />can someone help me on this.<BR /><BR />additional point- my response is something looking like below screenshot(collection in nested collection)<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="27737.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/27870iE8926F43380559C3/image-size/large?v=v2&amp;px=999" role="button" title="27737.png" alt="27737.png" /></span><BR /><BR />------------------------------<BR />Bhawana Daultani<BR />------------------------------<BR /> Mon, 29 Nov 2021 18:09:00 GMT https://community.blueprism.com/t5/Product-Forum/API-response-in-Collection-Out-of-memory/m-p/72394#M24999 daultani 2021-11-29T18:09:00Z https://community.blueprism.com/t5/Product-Forum/API-response-in-Collection-Out-of-memory/m-p/72395#M25000 How many records are being stored? Are you getting an exception or some other error indication?<BR /><BR />Cheers,<BR /><BR />------------------------------<BR />Eric Wilson<BR />Director, Integrations and Enablement<BR />Blue Prism Digital Exchange<BR />------------------------------<BR /> Fri, 03 Dec 2021 19:14:00 GMT https://community.blueprism.com/t5/Product-Forum/API-response-in-Collection-Out-of-memory/m-p/72395#M25000 ewilson 2021-12-03T19:14:00Z https://community.blueprism.com/t5/Product-Forum/API-response-in-Collection-Out-of-memory/m-p/72396#M25001 May or may not be helpful to you in this situation but... I have found that even in newer versions of BP it does not typically enjoy nested collections when they are nested to the extreme that the default BP JSON to Collection action nests them, eg. JArrays become a collection of rows with each row being a collection and possible further nesting beyond that. Solutions that I typically use are to create custom JSON actions with .NET Code stages to either flatten the JSON structure and pull out a collection from the flattened structure ; create custom JSON actions with .NET code stages to utilize JsonPath and pull exactly what I need out of the JSON directly if I don't need everything ; create custom JSON actions with .NET code stages to pull a collection out of the JSON at a specified depth / JSON path while also flattening the remaining depths.<BR /><BR />------------------------------<BR />Erin Connerley<BR />Automation Consultant<BR />Agilify Automation<BR />America/Indiana/Indianapolis<BR />------------------------------<BR /> Mon, 06 Dec 2021 13:48:00 GMT https://community.blueprism.com/t5/Product-Forum/API-response-in-Collection-Out-of-memory/m-p/72396#M25001 ErinConnerley 2021-12-06T13:48:00Z