Replace a Lookup Table

curl --request PUT \
  --url https://{region}.mixpanel.com/lookup-tables/{id} \
  --header 'Authorization: Basic <encoded-value>' \
  --header 'Content-Type: text/csv' \
  --data 'id,field1,field2
key1,v1,z1
key2,z1,z2
'

import requests

url = "https://{region}.mixpanel.com/lookup-tables/{id}"

payload = "id,field1,field2\nkey1,v1,z1\nkey2,z1,z2\n"
headers = {
    "Authorization": "Basic <encoded-value>",
    "Content-Type": "text/csv"
}

response = requests.put(url, data=payload, headers=headers)

print(response.text)

const options = {
  method: 'PUT',
  headers: {Authorization: 'Basic <encoded-value>', 'Content-Type': 'text/csv'},
  body: 'id,field1,field2\nkey1,v1,z1\nkey2,z1,z2\n'
};

fetch('https://{region}.mixpanel.com/lookup-tables/{id}', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://{region}.mixpanel.com/lookup-tables/{id}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "PUT",
  CURLOPT_POSTFIELDS => "id,field1,field2\nkey1,v1,z1\nkey2,z1,z2\n",
  CURLOPT_HTTPHEADER => [
    "Authorization: Basic <encoded-value>",
    "Content-Type: text/csv"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

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

func main() {

	url := "https://{region}.mixpanel.com/lookup-tables/{id}"

	payload := strings.NewReader("id,field1,field2\nkey1,v1,z1\nkey2,z1,z2\n")

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

	req.Header.Add("Authorization", "Basic <encoded-value>")
	req.Header.Add("Content-Type", "text/csv")

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

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

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.put("https://{region}.mixpanel.com/lookup-tables/{id}")
  .header("Authorization", "Basic <encoded-value>")
  .header("Content-Type", "text/csv")
  .body("id,field1,field2\nkey1,v1,z1\nkey2,z1,z2\n")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://{region}.mixpanel.com/lookup-tables/{id}")

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

request = Net::HTTP::Put.new(url)
request["Authorization"] = 'Basic <encoded-value>'
request["Content-Type"] = 'text/csv'
request.body = "id,field1,field2\nkey1,v1,z1\nkey2,z1,z2\n"

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

{
  "code": 200,
  "status": "OK"
}

{
  "code": 400,
  "error": "Some data points in the request failed validation.",
  "status": "Bad Request",
  "failed_records": [
    {
      "index": 2,
      "message": "primary key is required and cannot be blank"
    },
    {
      "index": 3,
      "message": "invalid row: wrong number of fields"
    }
  ]
}

{
  "code": 401,
  "error": "Invalid credentials",
  "status": "Unauthorized"
}

{
  "code": 200,
  "error": "Lookup table with id 'f077cb07-008a-4955-8a4a-b4c163db3a87' was not found.",
  "status": "Not Found"
}

{
  "code": 413,
  "error": "request exceeds max limit of 10485760 bytes",
  "status": "Request Entity Too Large"
}

{
  "code": 429,
  "error": "Project exceeded rate limits. Please retry the request with exponential backoff.",
  "status": "Too Many Requests"
}