> 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.

# Create/Update OR Delete transformed data overrides for a specific export in a database. A primary key must be set for the database.

POST https://meta.feedonomics.com/api.php/dbs/{db_id}/transformed_data_overrides/{export_id}
Content-Type: application/json

Reference: https://docs.feedonomics.com/developer/api-reference/rest/platform-api/data-overrides/create-update-or-delete-transformed-data-overrides-for-a-specific-export-in-a-database-a-primary-key-must-be-set-for-the-database

## 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) — ID of the export to add transformed data to (0 if all)

### Headers

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

### Body (application/json)

This endpoint expects an object.

- `data_row_id` (string, required) — The id of the TDO
- `join_value` (string, required) — The value of the primary-key-column in the target data row
- `override_field` (string, required) — The target column to override
- `override_value` (string, required) — The value that column will be set to
- `delete` (boolean, optional) — Set to 'true' to specify deletion of given TDO. Note: deletes and creates/updates must be done in separate requests.

## Response

### 200

Success

- `row_added` (double, optional) — The count of TDOs successfully created and/or updated
- `tdos_ignored` (double, optional) — The count of TDOs ignored in this request due to the override_field being empty or not matching an export field

## Errors

### 400 Bad Request Error

Fail response

- `any`

## Examples

### create/update

**Request**

```json
{
  "data_row_id": "2",
  "join_value": "10001",
  "override_field": "description",
  "override_value": "Unisex / One size fits all"
}
```

**Response**

```json
{
  "data": {
    "row_added": 2,
    "tdos_ignored": 0,
    "transaction_id": 6
  },
  "status": "success"
}
```

**SDK Code**

```python create/update
import requests

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

payload = {
    "data_row_id": "2",
    "join_value": "10001",
    "override_field": "description",
    "override_value": "Unisex / One size fits all"
}
headers = {
    "x-api-key": "x-api-key",
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.json())
```

```javascript create/update
const url = 'https://meta.feedonomics.com/api.php/dbs/1/transformed_data_overrides/1';
const options = {
  method: 'POST',
  headers: {
    'x-api-key': 'x-api-key',
    Authorization: 'Bearer <token>',
    'Content-Type': 'application/json'
  },
  body: '{"data_row_id":"2","join_value":"10001","override_field":"description","override_value":"Unisex / One size fits all"}'
};

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

```go create/update
package main

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

func main() {

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

	payload := strings.NewReader("{\n  \"data_row_id\": \"2\",\n  \"join_value\": \"10001\",\n  \"override_field\": \"description\",\n  \"override_value\": \"Unisex / One size fits all\"\n}")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("x-api-key", "x-api-key")
	req.Header.Add("Authorization", "Bearer <token>")
	req.Header.Add("Content-Type", "application/json")

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

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

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

}
```

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

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

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

request = Net::HTTP::Post.new(url)
request["x-api-key"] = 'x-api-key'
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"data_row_id\": \"2\",\n  \"join_value\": \"10001\",\n  \"override_field\": \"description\",\n  \"override_value\": \"Unisex / One size fits all\"\n}"

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

```java create/update
import com.mashape.unirest.http.HttpResponse;
import com.mashape.unirest.http.Unirest;

HttpResponse<String> response = Unirest.post("https://meta.feedonomics.com/api.php/dbs/1/transformed_data_overrides/1")
  .header("x-api-key", "x-api-key")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"data_row_id\": \"2\",\n  \"join_value\": \"10001\",\n  \"override_field\": \"description\",\n  \"override_value\": \"Unisex / One size fits all\"\n}")
  .asString();
```

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

$client = new \GuzzleHttp\Client();

$response = $client->request('POST', 'https://meta.feedonomics.com/api.php/dbs/1/transformed_data_overrides/1', [
  'body' => '{
  "data_row_id": "2",
  "join_value": "10001",
  "override_field": "description",
  "override_value": "Unisex / One size fits all"
}',
  'headers' => [
    'Authorization' => 'Bearer <token>',
    'Content-Type' => 'application/json',
    'x-api-key' => 'x-api-key',
  ],
]);

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

```csharp create/update
using RestSharp;

var client = new RestClient("https://meta.feedonomics.com/api.php/dbs/1/transformed_data_overrides/1");
var request = new RestRequest(Method.POST);
request.AddHeader("x-api-key", "x-api-key");
request.AddHeader("Authorization", "Bearer <token>");
request.AddHeader("Content-Type", "application/json");
request.AddParameter("application/json", "{\n  \"data_row_id\": \"2\",\n  \"join_value\": \"10001\",\n  \"override_field\": \"description\",\n  \"override_value\": \"Unisex / One size fits all\"\n}", ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
```

```swift create/update
import Foundation

let headers = [
  "x-api-key": "x-api-key",
  "Authorization": "Bearer <token>",
  "Content-Type": "application/json"
]
let parameters = [
  "data_row_id": "2",
  "join_value": "10001",
  "override_field": "description",
  "override_value": "Unisex / One size fits all"
] as [String : Any]

let postData = JSONSerialization.data(withJSONObject: parameters, options: [])

let request = NSMutableURLRequest(url: NSURL(string: "https://meta.feedonomics.com/api.php/dbs/1/transformed_data_overrides/1")! as URL,
                                        cachePolicy: .useProtocolCachePolicy,
                                    timeoutInterval: 10.0)
request.httpMethod = "POST"
request.allHTTPHeaderFields = headers
request.httpBody = postData as Data

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()
```

### delete

**Request**

```json
{
  "data_row_id": "2",
  "join_value": "10001",
  "override_field": "description",
  "override_value": "Unisex / One size fits all",
  "delete": true
}
```

**Response**

```json
{
  "data": {
    "row_deleted": 1
  },
  "status": "success"
}
```

**SDK Code**

```python delete
import requests

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

payload = {
    "data_row_id": "2",
    "join_value": "10001",
    "override_field": "description",
    "override_value": "Unisex / One size fits all",
    "delete": True
}
headers = {
    "x-api-key": "x-api-key",
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.json())
```

```javascript delete
const url = 'https://meta.feedonomics.com/api.php/dbs/1/transformed_data_overrides/1';
const options = {
  method: 'POST',
  headers: {
    'x-api-key': 'x-api-key',
    Authorization: 'Bearer <token>',
    'Content-Type': 'application/json'
  },
  body: '{"data_row_id":"2","join_value":"10001","override_field":"description","override_value":"Unisex / One size fits all","delete":true}'
};

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

```go delete
package main

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

func main() {

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

	payload := strings.NewReader("{\n  \"data_row_id\": \"2\",\n  \"join_value\": \"10001\",\n  \"override_field\": \"description\",\n  \"override_value\": \"Unisex / One size fits all\",\n  \"delete\": true\n}")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("x-api-key", "x-api-key")
	req.Header.Add("Authorization", "Bearer <token>")
	req.Header.Add("Content-Type", "application/json")

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

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

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

}
```

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

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

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

request = Net::HTTP::Post.new(url)
request["x-api-key"] = 'x-api-key'
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"data_row_id\": \"2\",\n  \"join_value\": \"10001\",\n  \"override_field\": \"description\",\n  \"override_value\": \"Unisex / One size fits all\",\n  \"delete\": true\n}"

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

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

HttpResponse<String> response = Unirest.post("https://meta.feedonomics.com/api.php/dbs/1/transformed_data_overrides/1")
  .header("x-api-key", "x-api-key")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"data_row_id\": \"2\",\n  \"join_value\": \"10001\",\n  \"override_field\": \"description\",\n  \"override_value\": \"Unisex / One size fits all\",\n  \"delete\": true\n}")
  .asString();
```

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

$client = new \GuzzleHttp\Client();

$response = $client->request('POST', 'https://meta.feedonomics.com/api.php/dbs/1/transformed_data_overrides/1', [
  'body' => '{
  "data_row_id": "2",
  "join_value": "10001",
  "override_field": "description",
  "override_value": "Unisex / One size fits all",
  "delete": true
}',
  'headers' => [
    'Authorization' => 'Bearer <token>',
    'Content-Type' => 'application/json',
    'x-api-key' => 'x-api-key',
  ],
]);

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

```csharp delete
using RestSharp;

var client = new RestClient("https://meta.feedonomics.com/api.php/dbs/1/transformed_data_overrides/1");
var request = new RestRequest(Method.POST);
request.AddHeader("x-api-key", "x-api-key");
request.AddHeader("Authorization", "Bearer <token>");
request.AddHeader("Content-Type", "application/json");
request.AddParameter("application/json", "{\n  \"data_row_id\": \"2\",\n  \"join_value\": \"10001\",\n  \"override_field\": \"description\",\n  \"override_value\": \"Unisex / One size fits all\",\n  \"delete\": true\n}", ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
```

```swift delete
import Foundation

let headers = [
  "x-api-key": "x-api-key",
  "Authorization": "Bearer <token>",
  "Content-Type": "application/json"
]
let parameters = [
  "data_row_id": "2",
  "join_value": "10001",
  "override_field": "description",
  "override_value": "Unisex / One size fits all",
  "delete": true
] as [String : Any]

let postData = JSONSerialization.data(withJSONObject: parameters, options: [])

let request = NSMutableURLRequest(url: NSURL(string: "https://meta.feedonomics.com/api.php/dbs/1/transformed_data_overrides/1")! as URL,
                                        cachePolicy: .useProtocolCachePolicy,
                                    timeoutInterval: 10.0)
request.httpMethod = "POST"
request.allHTTPHeaderFields = headers
request.httpBody = postData as Data

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()
```

### empty payload/early return

**Response**

```json
{
  "message": "There are no records to process.",
  "status": "fail"
}
```

**SDK Code**

```python empty payload/early return
import requests

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

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

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

print(response.json())
```

```javascript empty payload/early return
const url = 'https://meta.feedonomics.com/api.php/dbs/1/transformed_data_overrides/1';
const options = {
  method: 'POST',
  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 empty payload/early return
package main

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

func main() {

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

	req, _ := http.NewRequest("POST", 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 empty payload/early return
require 'uri'
require 'net/http'

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

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

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

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

```java empty payload/early return
import com.mashape.unirest.http.HttpResponse;
import com.mashape.unirest.http.Unirest;

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

```php empty payload/early return
<?php
require_once('vendor/autoload.php');

$client = new \GuzzleHttp\Client();

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

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

```csharp empty payload/early return
using RestSharp;

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

```swift empty payload/early return
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_overrides/1")! as URL,
                                        cachePolicy: .useProtocolCachePolicy,
                                    timeoutInterval: 10.0)
request.httpMethod = "POST"
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()
```