> This page is for Developer.

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

# Retrieves the transformed data for a database/export

GET https://meta.feedonomics.com/api.php/dbs/{db_id}/transformed_data/{export_id}

Reference: https://docs.feedonomics.com/developer/api-reference/rest/content-api/data/retrieves-the-transformed-data-for-a-database-export

## Authentication

- `Authorization` header (bearer token, required) — Bearer authentication of the form `Bearer <token>`, where token is your auth token.

## Request

### Path parameters

- `db_id` (integer, required) — ID of the database to get transformed data from
- `export_id` (integer, required) — The export ID to get transformed data from. Default to 0 for all

### Query parameters

- `direction` (string, optional) — Order direction, can be &gt; or &lt;
- `limit` (double, optional) — How many results should be returned
- `offset` (double, optional) — Offset used for paging
- `selector` (string, optional) — The query selector to filter data by
- `override_logs` (boolean, optional) — Returns override_logs with each row of data to get the original values pre-transformed data overrides

### Headers

- `x-api-key` (string, required)

## Response

### 200

successful operation

- `list of DbsDbIdTransformedDataExportIdGetResponsesContentApplicationJsonSchemaItems`

## Types

### DbsDbIdTransformedDataExportIdGetResponsesContentApplicationJsonSchemaItems

- `statud` (string, optional)
- `correlation_id` (string, optional)
- `total_run_time` (string, optional)
- `total_count` (string, optional)
- `data` (list of any, optional)
- `total_chunks` (string, optional)
- `queue_chunk_metrics` (list of DbsDbIdTransformedDataExportIdGetResponsesContentApplicationJsonSchemaItemsQueueChunkMetricsItems, optional)

### DbsDbIdTransformedDataExportIdGetResponsesContentApplicationJsonSchemaItemsQueueChunkMetricsItems

- `queue_time_chunk_0_0` (list of DbsDbIdTransformedDataExportIdGetResponsesContentApplicationJsonSchemaItemsQueueChunkMetricsItemsQueueTimeChunk00Items, optional)

### DbsDbIdTransformedDataExportIdGetResponsesContentApplicationJsonSchemaItemsQueueChunkMetricsItemsQueueTimeChunk00Items

- `local_host` (string, optional)
- `remote_host` (string, optional)
- `db_id` (string, optional)
- `resource_type` (string, optional)
- `resource_id` (string, optional)
- `correlation_id` (string, optional)
- `event` (string, optional)
- `value1` (string, optional)
- `value2` (string, optional)
- `value3` (string, optional)
- `value4` (string, optional)
- `value5` (string, optional)
- `value6` (string, optional)
- `value7` (string, optional)
- `value8` (string, optional)
- `value9` (string, optional)
- `value10` (string, optional)
- `memory_usage` (string, optional)
- `memory_peak` (string, optional)
- `tag1` (string, optional)
- `tag2` (string, optional)
- `tag3` (string, optional)
- `tag4` (string, optional)
- `tag5` (string, optional)
- `timestamp` (string, optional)
- `scheduled` (string, optional)
- `query_worker_group` (string, optional)

## Examples

**Response**

```json
[
  {
    "correlation_id": "185191d4bae6ed2a",
    "total_run_time": "13.243301868439",
    "total_count": "462",
    "data": [
      [
        "Pencil",
        "High",
        "Tap"
      ],
      [
        "Pen",
        "Low",
        "Ballet"
      ]
    ],
    "total_chunks": "1",
    "queue_chunk_metrics": [
      {
        "queue_time_chunk_0_0": [
          {
            "local_host": "chunk-worker6.feedonomics.com",
            "db_id": "1",
            "resource_type": "",
            "resource_id": "0",
            "correlation_id": "abcdef",
            "event": "queue_time_chunk_0_0",
            "value1": "147473.81210327",
            "memory_usage": "6843656",
            "memory_peak": "24133736",
            "timestamp": "2024-11-20 01:47:41",
            "scheduled": "0"
          }
        ]
      }
    ],
    "status": "success"
  }
]
```

**SDK Code**

```python Data_retrievesTheTransformedDataForADatabaseExport_example
import requests

url = "https://meta.feedonomics.com/api.php/dbs/1/transformed_data/1"

headers = {
    "x-api-key": "x-api-key",
    "Authorization": "Bearer <token>"
}

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

print(response.json())
```

```javascript Data_retrievesTheTransformedDataForADatabaseExport_example
const url = 'https://meta.feedonomics.com/api.php/dbs/1/transformed_data/1';
const options = {
  method: 'GET',
  headers: {'x-api-key': 'x-api-key', Authorization: 'Bearer <token>'}
};

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

```go Data_retrievesTheTransformedDataForADatabaseExport_example
package main

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

func main() {

	url := "https://meta.feedonomics.com/api.php/dbs/1/transformed_data/1"

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

	req.Header.Add("x-api-key", "x-api-key")
	req.Header.Add("Authorization", "Bearer <token>")

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

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

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

}
```

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

url = URI("https://meta.feedonomics.com/api.php/dbs/1/transformed_data/1")

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

request = Net::HTTP::Get.new(url)
request["x-api-key"] = 'x-api-key'
request["Authorization"] = 'Bearer <token>'

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

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

HttpResponse<String> response = Unirest.get("https://meta.feedonomics.com/api.php/dbs/1/transformed_data/1")
  .header("x-api-key", "x-api-key")
  .header("Authorization", "Bearer <token>")
  .asString();
```

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

$client = new \GuzzleHttp\Client();

$response = $client->request('GET', 'https://meta.feedonomics.com/api.php/dbs/1/transformed_data/1', [
  'headers' => [
    'Authorization' => 'Bearer <token>',
    'x-api-key' => 'x-api-key',
  ],
]);

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

```csharp Data_retrievesTheTransformedDataForADatabaseExport_example
using RestSharp;

var client = new RestClient("https://meta.feedonomics.com/api.php/dbs/1/transformed_data/1");
var request = new RestRequest(Method.GET);
request.AddHeader("x-api-key", "x-api-key");
request.AddHeader("Authorization", "Bearer <token>");
IRestResponse response = client.Execute(request);
```

```swift Data_retrievesTheTransformedDataForADatabaseExport_example
import Foundation

let headers = [
  "x-api-key": "x-api-key",
  "Authorization": "Bearer <token>"
]

let request = NSMutableURLRequest(url: NSURL(string: "https://meta.feedonomics.com/api.php/dbs/1/transformed_data/1")! 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()
```