Skip to main content
Question

RETURN ALL COLUMNS WHEN QUERYING (REST API)

  • November 8, 2021
  • 0 replies
  • 171 views

Hi, 

I am trying to pull data from Quickbase table records from Azure Data Factory. I'm using Quickbase Rest APIs, specifically Get fields for a table and Query for Data.

I did a simple query for data and tested it, however it didn't return all the columns. It only returned default columns.

When I ran the Get fields for a table API, it was able to get all columns (even the hidden ones)

What to add in my query below so all columns will be returned?

{
  "from": "",
  "select": [],
  "sortBy": [false],
  "groupBy": [false],
  "options": {
  "skip": 0,
  "top": 0,
  "compareWithAppLocalTime": false
  }
}


------------------------------
Charmaine Coleta
------------------------------
This topic has been closed for replies.