Forum Discussion

CharmaineColeta's avatar
CharmaineColeta
Qrew Member
3 years ago

RETURN ALL COLUMNS WHEN QUERYING (REST API)

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
------------------------------
No RepliesBe the first to reply