Method Community

Understandable. Knowing that it is SQL Server helps because now I am able to say "TOP 1000" in the fieldQuery and choose a column to order by I can now range the requests by something other than date - which I don't like. I suppose since you didn't offer any alternatives that there is no way to get an entire table in one shot. ...

I am trying to retrieve a very large dataset from the system using the MethodAPISelect_DataSetV2. All of the tables I have tried work fine except for one. The query fails after about 60 seconds with an error from the far end web service about web.config needing additional parameter. The table in question is called "Activities." ...