What is the API call to use to retrieve about approximately 30,000 records from a table in a script task in SSIS. Please help. Thanks.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

After authenticated, here's the sample of codebase used to retrieve records from quickbase.


--------------------------------------------------------------------------------------------

var request3 = (HttpWebRequest)WebRequest.Create(@"https://xxxxx/db/tid?a=API_GenResultsTable&ticket=" + ticket + "&apptoken=" + appToken + "&options=csv" + ""); //&options=num-10000 //&options=csv (10665 records)

WebResponse webResponse3 = request3.GetResponse();

Stream responseStream3 = webResponse3.GetResponseStream();

text = new StreamReader(responseStream3).ReadToEnd();

---------------------------------------------------------------------------------------

Is there an API call which can retrieve all records from table.

Photo of QuickbaseUser

QuickbaseUser

  • 494 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Rama

Rama

  • 0 Points
your number of returned records ("options=num-10000") is set to 10,000. change it to 30,000 or something higher to make sure you get everything in the table.
Photo of QuickbaseUser

QuickbaseUser

  • 494 Points 250 badge 2x thumb
Thanks for the reply. Tried setting it to 30,000 but able to retrieve only about 10665. Is there any upper limit for retrieval. Has anyone faced problems with large data retrieval.