Data Extraction API- Column Names not Returned
In the data extraction API, I am not sure how to receive the column names of the data table that is returned. Is this coming in the future? Will data be returned in JSON ever, or is it going to stick to CSV format for the foreseeable future?
Best Answer
-
I'm not sure I understand the question but I'll give it a shot. Here is what we have. To get the schema or the "column names" you call the API Get DataSet MetaData. To get the actual data you call the API Pull Data. Both of these only return CSV format for now. We can look at adding a JSON format in the future.
Perhaps you are just saying it would be nice to get the first row to include the schema on the Pull data download. I think that would be a nice option also.
We are currently working on exposing a lot more attributes on the datasets so you can do many very interesting things like dataset owner and when it was last updated.
0
Answers
-
I have the same problem. A little surprising, because the documentation makes it look as if you get the headers in the data result.
However, it seems you can get the information if you just fetch the metadata for the data set, so I'm doing that first, and use that to build my table headers before I populate the rest with data.
0 -
I'm not sure I understand the question but I'll give it a shot. Here is what we have. To get the schema or the "column names" you call the API Get DataSet MetaData. To get the actual data you call the API Pull Data. Both of these only return CSV format for now. We can look at adding a JSON format in the future.
Perhaps you are just saying it would be nice to get the first row to include the schema on the Pull data download. I think that would be a nice option also.
We are currently working on exposing a lot more attributes on the datasets so you can do many very interesting things like dataset owner and when it was last updated.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 620 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 742 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive