Note: I also just tried sending the results back in several smaller chunks using 3 different json blocks, but it still threw a -14 after trying to return about 6 or 7 thousand records.  It is starting to look like multiple requests might be the only way to get back a large number of records, unless there is something sneaky causing this "code conversion failed" error, and not just the number of records or size of the data.

       public IDataPacker MyRetrieve(String newDwSql)
        {
            var packer = new DataPacker();
            var dataStore = new DataStore<PropertyReviewGrid>(_dataContext);
            var dataStore2 = new DataStore<PropertyReviewGrid>(_dataContext);
            var dataStore3 = new DataStore<PropertyReviewGrid>(_dataContext);
            long totalRows;
            long dwRows;
            
            //05/25/22 GOES - I've started base64 encoding the sql string to get past the Azure WAF sql-injection rules and make the API's more secure.
            byte[] data = Convert.FromBase64String(newDwSql);
            string decodedSql = Encoding.UTF8.GetString(data);
            
            dataStore.SetSqlSelect(decodedSql);
            // dataStore2.SetSqlSelect(decodedSql);
            
            dataStore.Retrieve(new object[] { });
            
            totalRows = dataStore.RowCount;
            packer.AddValue("Total Count", totalRows);
            
            if (totalRows <= 2500)
            {
                packer.AddDataStore("First 2500 Batch", dataStore);
            }
            
            if (totalRows > 2500)
            {
                var myBool = dataStore.RowsMove(2500, 4999, DwBuffer.Primary, dataStore2, 999, DwBuffer.Primary);
                dwRows = dataStore2.RowCount;
                packer.AddDataStore("First 2500 Batch", dataStore);
                packer.AddDataStore("Second 2500 Batch", dataStore2);
            }
            
            if (totalRows > 5000)
            {
                var myBool = dataStore.RowsMove(5000, 7499, DwBuffer.Primary, dataStore3, 999, DwBuffer.Primary);
                dwRows = dataStore3.RowCount;
                packer.AddDataStore("Third 2500 Batch", dataStore3);
            }
            
            packer.AddValue("Error Message", "Ok");
            
            return packer;
        }

Hi Glenn,

Your issue may be caused by the limitation of HttpClient/RestClient when processing large JSON data. So the key issue is how to reduce the size of the JSON.

I suggest that you can consider calling more times page by page.

E.g.: use RetrieveByPage in the server side. IDataStoreBases.RetrieveByPageAsync Method (appeon.com)

Extend your custom Retrieve method in RestClient to get all data into a temporary DataStore page by page, and import data from the temporary DataStore to the real DataWindow.

Regards, Logan