Jon,

To answer the points you brought up:

1. The toInsert option references the output of a function in my code. I have attached an updated code that generate some dummy data instead. (please see the attached file)

2. The script intends to process the data from a custom query and show the results in multiple tables for the users to view. Is there a better way of doing this? I am very new to Labkey and would appreciate any suggestions.

3. I think I have figured out the source of the problem. It appears that the API calls fail when the number of rows in the data pass some threshold. In the file I have attached, you can change the number of rows of the dummy data table using the rownumber variable. For example, the code works fine for rownumber = 100, but fails for rownumber = 5000. Do you know what causes this and how we can solve the issue?

Thanks,
Shadi