Using API_DoQuery, how do I grab all fields in a Quickbase table?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
  • (Edited)
Original post:
  • Asked by Sally  in previous community
  • 21 days ago
I am wanting to use the API_DoQuery to transfer all of the fields in a
Quickbase table to another database.  I see an example of how to query a
field (one field) of a quickbase table but I need to query the whole table.
Photo of Dan G. (QB Support)

Dan G. (QB Support), Official Rep

  • 490 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Dan G. (QB Support)

Dan G. (QB Support), Official Rep

  • 490 Points 250 badge 2x thumb
Answer

You can specify the clist parameter with a value of "a" for all. 

For example using JavaScript from this applicaiton:

Formula Functions Reference
https://login.quickbase.com/db/6ewwzuuj?a=td

You can paste this code into the console (no apptoken required):

var dbidFormulaFunctionsReference = "6ewwzuuj";
$.get(dbidFormulaFunctionsReference, {
  act: "API_DoQuery",
  qid: "1",
  clist: "a"
}).then(function(xml) {
  console.dirxml(xml);
});


Was this answer helpful?
Answered by:

Original
dandiebolt_QB_Pirate , Pres. of Service Worker Union
QuickBase Pro 21 days ago



2 comments

Thank you for taking the time to respond to my question


It was a pleasure to respond to your question.