> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.athenaintel.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.athenaintel.com/_mcp/server.

# Get Tabular Data from Object

GET https://api.athenaintel.com/api/v0/tools/file/data-frame

Read a tabular asset as a JSON data frame.

Returns `columns`, an optional `index`, and `data` rows (pandas "split"
orientation) for an asset the caller can read: an Athena spreadsheet, a
file-backed live spreadsheet (SharePoint, OneDrive, Drive, iManage), or an
uploaded CSV, Excel or Parquet file. `row_limit` caps the rows returned,
`columns` selects columns by name or position, `sheet_name` picks the sheet
of an Excel file (the first by default), and `separator` sets the delimiter
of a CSV file. Any other asset type is a 415; a file the parser cannot read
is a 500 carrying the parser's message.

Reference: https://docs.athenaintel.com/api-reference/tools/data-frame

## Authentication

- `X-API-KEY` header (required) — API Key authentication via header

## Request

### Query parameters

- `asset_id` (string, required)
- `row_limit` (integer, optional, nullable)
- `index_column` (integer, optional, nullable)
- `columns` (list of ApiV0ToolsFileDataFrameGetParametersColumnsSchemaItems, optional, nullable) — should be a list of strings or a list of integers
- `sheet_name` (ApiV0ToolsFileDataFrameGetParametersSheetNameSchema, optional, nullable, default: 0) — only for excel files
- `separator` (string, optional, nullable, default: ,) — only for csv files

## Response

### 200

Successful Response

- `columns` (list of DataFrameRequestOutColumnsItems, required)
- `data` (list of list of DataFrameRequestOutDataItemsItems, required)
- `index` (list of DataFrameRequestOutIndexItems, required, nullable)

## Errors

### 401 Unauthorized Error

Unauthorized

- `message` (string, required)

### 404 Not Found Error

Not Found

- `message` (string, required)

### 415 Unsupported Media Type Error

Unsupported Media Type

- `asset_id` (string, required)
- `media_type` (string, required)
- `message` (string, required)

### 422 Unprocessable Entity Error

Validation Error

- `detail` (list of ValidationError, optional)

### 500 Internal Server Error

Internal Server Error

- `asset_id` (string, required)
- `message` (string, required)

## Types

### ApiV0ToolsFileDataFrameGetParametersColumnsSchemaItems

- integer
- string

### ApiV0ToolsFileDataFrameGetParametersSheetNameSchema

only for excel files

- string
- integer

### DataFrameRequestOutColumnsItems

- string
- integer
- double

### DataFrameRequestOutDataItemsItems

- string
- integer
- double

### DataFrameRequestOutIndexItems

- string
- integer
- double

### ValidationError

- `loc` (list of ValidationErrorLocItems, required)
- `msg` (string, required)
- `type` (string, required)
- `ctx` (ValidationErrorCtx, optional)
- `input` (any, optional)

### ValidationErrorLocItems

- string
- integer

### ValidationErrorCtx

## Examples

**Response**

```json
{
  "columns": [
    "header1",
    "header2"
  ],
  "data": [
    [
      "a",
      1
    ],
    [
      "b",
      2
    ]
  ],
  "index": [
    0,
    1
  ]
}
```

**SDK Code**

```python
import requests

url = "https://api.athenaintel.com/api/v0/tools/file/data-frame"

querystring = {"asset_id":"asset_id"}

headers = {"X-API-KEY": "<apiKey>"}

response = requests.get(url, headers=headers, params=querystring)

print(response.json())
```

```javascript
const url = 'https://api.athenaintel.com/api/v0/tools/file/data-frame?asset_id=asset_id';
const options = {method: 'GET', headers: {'X-API-KEY': '<apiKey>'}};

try {
  const response = await fetch(url, options);
  const data = await response.json();
  console.log(data);
} catch (error) {
  console.error(error);
}
```

```go
package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://api.athenaintel.com/api/v0/tools/file/data-frame?asset_id=asset_id"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("X-API-KEY", "<apiKey>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(res)
	fmt.Println(string(body))

}
```

```ruby
require 'uri'
require 'net/http'

url = URI("https://api.athenaintel.com/api/v0/tools/file/data-frame?asset_id=asset_id")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["X-API-KEY"] = '<apiKey>'

response = http.request(request)
puts response.read_body
```

```java
import com.mashape.unirest.http.HttpResponse;
import com.mashape.unirest.http.Unirest;

HttpResponse<String> response = Unirest.get("https://api.athenaintel.com/api/v0/tools/file/data-frame?asset_id=asset_id")
  .header("X-API-KEY", "<apiKey>")
  .asString();
```

```php
<?php
require_once('vendor/autoload.php');

$client = new \GuzzleHttp\Client();

$response = $client->request('GET', 'https://api.athenaintel.com/api/v0/tools/file/data-frame?asset_id=asset_id', [
  'headers' => [
    'X-API-KEY' => '<apiKey>',
  ],
]);

echo $response->getBody();
```

```csharp
using RestSharp;

var client = new RestClient("https://api.athenaintel.com/api/v0/tools/file/data-frame?asset_id=asset_id");
var request = new RestRequest(Method.GET);
request.AddHeader("X-API-KEY", "<apiKey>");
IRestResponse response = client.Execute(request);
```

```swift
import Foundation

let headers = ["X-API-KEY": "<apiKey>"]

let request = NSMutableURLRequest(url: NSURL(string: "https://api.athenaintel.com/api/v0/tools/file/data-frame?asset_id=asset_id")! as URL,
                                        cachePolicy: .useProtocolCachePolicy,
                                    timeoutInterval: 10.0)
request.httpMethod = "GET"
request.allHTTPHeaderFields = headers

let session = URLSession.shared
let dataTask = session.dataTask(with: request as URLRequest, completionHandler: { (data, response, error) -> Void in
  if (error != nil) {
    print(error as Any)
  } else {
    let httpResponse = response as? HTTPURLResponse
    print(httpResponse)
  }
})

dataTask.resume()
```