Skip to main content
Question

Pull all fields from a table using query for data api

  • June 13, 2022
  • 0 replies
  • 214 views
hi,

I am trying to write a API query to pull all data for a given Quickbase table.  Is there a way to pull the fields without having to list each field individually?
I saw there a 'clist' parameter that can be used but I'm not sure how to use that one.

thanks,
Sangeeta

------------------------------
Sangeeta Ram
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+12
    • LauraThacker
    • Registered
    • June 14, 2022
    If you're trying to get all the data out of a table (data, not schema) then you can use the ?a=ImportExport screen to export an entire table of data to CSV format.

    If you're trying to get all the schema out of a table, I recommend using the Application Documentor in the Exchange published by Ryan Pflederer; which is a great tool and does the work in minutes.

    If you're trying to backup your entire Application Data content, I recommend using the QuNect.com QuNect Backup tool which will download ALL your data form ALL your tables into CSV format.

    ------------------------------
    Laura Thacker (IDS)
    laura@intelligentdbs.com
    (626) 771 0454
    ------------------------------
    Laura Thacker (IDS) laura@intelligentdbs.com (626) 771 0454
    Terms & ConditionsAccessibility statement