Post Assignment Source

curl --request POST \
  --url https://statsigapi.net/console/v1/experiments/assignment_source/{name} \
  --header 'Content-Type: application/json' \
  --header 'STATSIG-API-KEY: <api-key>' \
  --data '
{
  "sql": "<string>",
  "timestampColumn": "<string>",
  "experimentIDColumn": "<string>",
  "groupIDColumn": "<string>",
  "idTypeMapping": [
    {
      "statsigUnitID": "<string>",
      "column": "<string>"
    }
  ],
  "name": "<string>",
  "description": "<string>",
  "isVerified": true,
  "tags": [
    "<string>"
  ],
  "isReadOnly": true,
  "owner": {
    "ownerID": "user123",
    "ownerType": "USER",
    "ownerName": "John Doe",
    "ownerEmail": "owner123@test.com"
  }
}
'

import requests

url = "https://statsigapi.net/console/v1/experiments/assignment_source/{name}"

payload = {
    "sql": "<string>",
    "timestampColumn": "<string>",
    "experimentIDColumn": "<string>",
    "groupIDColumn": "<string>",
    "idTypeMapping": [
        {
            "statsigUnitID": "<string>",
            "column": "<string>"
        }
    ],
    "name": "<string>",
    "description": "<string>",
    "isVerified": True,
    "tags": ["<string>"],
    "isReadOnly": True,
    "owner": {
        "ownerID": "user123",
        "ownerType": "USER",
        "ownerName": "John Doe",
        "ownerEmail": "owner123@test.com"
    }
}
headers = {
    "STATSIG-API-KEY": "<api-key>",
    "Content-Type": "application/json"
}

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

print(response.text)

const options = {
  method: 'POST',
  headers: {'STATSIG-API-KEY': '<api-key>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    sql: '<string>',
    timestampColumn: '<string>',
    experimentIDColumn: '<string>',
    groupIDColumn: '<string>',
    idTypeMapping: [{statsigUnitID: '<string>', column: '<string>'}],
    name: '<string>',
    description: '<string>',
    isVerified: true,
    tags: ['<string>'],
    isReadOnly: true,
    owner: {
      ownerID: 'user123',
      ownerType: 'USER',
      ownerName: 'John Doe',
      ownerEmail: 'owner123@test.com'
    }
  })
};

fetch('https://statsigapi.net/console/v1/experiments/assignment_source/{name}', 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://statsigapi.net/console/v1/experiments/assignment_source/{name}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    'sql' => '<string>',
    'timestampColumn' => '<string>',
    'experimentIDColumn' => '<string>',
    'groupIDColumn' => '<string>',
    'idTypeMapping' => [
        [
                'statsigUnitID' => '<string>',
                'column' => '<string>'
        ]
    ],
    'name' => '<string>',
    'description' => '<string>',
    'isVerified' => true,
    'tags' => [
        '<string>'
    ],
    'isReadOnly' => true,
    'owner' => [
        'ownerID' => 'user123',
        'ownerType' => 'USER',
        'ownerName' => 'John Doe',
        'ownerEmail' => 'owner123@test.com'
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Content-Type: application/json",
    "STATSIG-API-KEY: <api-key>"
  ],
]);

$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://statsigapi.net/console/v1/experiments/assignment_source/{name}"

	payload := strings.NewReader("{\n  \"sql\": \"<string>\",\n  \"timestampColumn\": \"<string>\",\n  \"experimentIDColumn\": \"<string>\",\n  \"groupIDColumn\": \"<string>\",\n  \"idTypeMapping\": [\n    {\n      \"statsigUnitID\": \"<string>\",\n      \"column\": \"<string>\"\n    }\n  ],\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"isVerified\": true,\n  \"tags\": [\n    \"<string>\"\n  ],\n  \"isReadOnly\": true,\n  \"owner\": {\n    \"ownerID\": \"user123\",\n    \"ownerType\": \"USER\",\n    \"ownerName\": \"John Doe\",\n    \"ownerEmail\": \"owner123@test.com\"\n  }\n}")

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

	req.Header.Add("STATSIG-API-KEY", "<api-key>")
	req.Header.Add("Content-Type", "application/json")

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

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

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.post("https://statsigapi.net/console/v1/experiments/assignment_source/{name}")
  .header("STATSIG-API-KEY", "<api-key>")
  .header("Content-Type", "application/json")
  .body("{\n  \"sql\": \"<string>\",\n  \"timestampColumn\": \"<string>\",\n  \"experimentIDColumn\": \"<string>\",\n  \"groupIDColumn\": \"<string>\",\n  \"idTypeMapping\": [\n    {\n      \"statsigUnitID\": \"<string>\",\n      \"column\": \"<string>\"\n    }\n  ],\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"isVerified\": true,\n  \"tags\": [\n    \"<string>\"\n  ],\n  \"isReadOnly\": true,\n  \"owner\": {\n    \"ownerID\": \"user123\",\n    \"ownerType\": \"USER\",\n    \"ownerName\": \"John Doe\",\n    \"ownerEmail\": \"owner123@test.com\"\n  }\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://statsigapi.net/console/v1/experiments/assignment_source/{name}")

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

request = Net::HTTP::Post.new(url)
request["STATSIG-API-KEY"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"sql\": \"<string>\",\n  \"timestampColumn\": \"<string>\",\n  \"experimentIDColumn\": \"<string>\",\n  \"groupIDColumn\": \"<string>\",\n  \"idTypeMapping\": [\n    {\n      \"statsigUnitID\": \"<string>\",\n      \"column\": \"<string>\"\n    }\n  ],\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"isVerified\": true,\n  \"tags\": [\n    \"<string>\"\n  ],\n  \"isReadOnly\": true,\n  \"owner\": {\n    \"ownerID\": \"user123\",\n    \"ownerType\": \"USER\",\n    \"ownerName\": \"John Doe\",\n    \"ownerEmail\": \"owner123@test.com\"\n  }\n}"

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

{
  "message": "Assignment Source updated successfully",
  "data": {
    "name": "exposures3",
    "description": "qweqwe",
    "tags": [],
    "sql": "SELECT * FROM shoppy-sales.experiment_data.exposures",
    "timestampColumn": "ts",
    "groupIDColumn": "group_id",
    "experimentIDColumn": "experiment_name",
    "idTypeMapping": [
      {
        "statsigUnitID": "stableID",
        "column": "user_id"
      }
    ]
  }
}

{
  "status": 400,
  "message": "Invalid request. Please check the request input and try again."
}

{
  "status": 401,
  "message": "This endpoint only accepts an active CONSOLE key, but an invalid key was sent. Key: console-xxxXXXxxxXXXxxx"
}

{
  "status": 404,
  "message": "Not Found. The requested resource could not be found."
}

POST

console

experiments

assignment_source

{name}

Post Assignment Source

curl --request POST \
  --url https://statsigapi.net/console/v1/experiments/assignment_source/{name} \
  --header 'Content-Type: application/json' \
  --header 'STATSIG-API-KEY: <api-key>' \
  --data '
{
  "sql": "<string>",
  "timestampColumn": "<string>",
  "experimentIDColumn": "<string>",
  "groupIDColumn": "<string>",
  "idTypeMapping": [
    {
      "statsigUnitID": "<string>",
      "column": "<string>"
    }
  ],
  "name": "<string>",
  "description": "<string>",
  "isVerified": true,
  "tags": [
    "<string>"
  ],
  "isReadOnly": true,
  "owner": {
    "ownerID": "user123",
    "ownerType": "USER",
    "ownerName": "John Doe",
    "ownerEmail": "owner123@test.com"
  }
}
'

import requests

url = "https://statsigapi.net/console/v1/experiments/assignment_source/{name}"

payload = {
    "sql": "<string>",
    "timestampColumn": "<string>",
    "experimentIDColumn": "<string>",
    "groupIDColumn": "<string>",
    "idTypeMapping": [
        {
            "statsigUnitID": "<string>",
            "column": "<string>"
        }
    ],
    "name": "<string>",
    "description": "<string>",
    "isVerified": True,
    "tags": ["<string>"],
    "isReadOnly": True,
    "owner": {
        "ownerID": "user123",
        "ownerType": "USER",
        "ownerName": "John Doe",
        "ownerEmail": "owner123@test.com"
    }
}
headers = {
    "STATSIG-API-KEY": "<api-key>",
    "Content-Type": "application/json"
}

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

print(response.text)

const options = {
  method: 'POST',
  headers: {'STATSIG-API-KEY': '<api-key>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    sql: '<string>',
    timestampColumn: '<string>',
    experimentIDColumn: '<string>',
    groupIDColumn: '<string>',
    idTypeMapping: [{statsigUnitID: '<string>', column: '<string>'}],
    name: '<string>',
    description: '<string>',
    isVerified: true,
    tags: ['<string>'],
    isReadOnly: true,
    owner: {
      ownerID: 'user123',
      ownerType: 'USER',
      ownerName: 'John Doe',
      ownerEmail: 'owner123@test.com'
    }
  })
};

fetch('https://statsigapi.net/console/v1/experiments/assignment_source/{name}', 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://statsigapi.net/console/v1/experiments/assignment_source/{name}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    'sql' => '<string>',
    'timestampColumn' => '<string>',
    'experimentIDColumn' => '<string>',
    'groupIDColumn' => '<string>',
    'idTypeMapping' => [
        [
                'statsigUnitID' => '<string>',
                'column' => '<string>'
        ]
    ],
    'name' => '<string>',
    'description' => '<string>',
    'isVerified' => true,
    'tags' => [
        '<string>'
    ],
    'isReadOnly' => true,
    'owner' => [
        'ownerID' => 'user123',
        'ownerType' => 'USER',
        'ownerName' => 'John Doe',
        'ownerEmail' => 'owner123@test.com'
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Content-Type: application/json",
    "STATSIG-API-KEY: <api-key>"
  ],
]);

$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://statsigapi.net/console/v1/experiments/assignment_source/{name}"

	payload := strings.NewReader("{\n  \"sql\": \"<string>\",\n  \"timestampColumn\": \"<string>\",\n  \"experimentIDColumn\": \"<string>\",\n  \"groupIDColumn\": \"<string>\",\n  \"idTypeMapping\": [\n    {\n      \"statsigUnitID\": \"<string>\",\n      \"column\": \"<string>\"\n    }\n  ],\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"isVerified\": true,\n  \"tags\": [\n    \"<string>\"\n  ],\n  \"isReadOnly\": true,\n  \"owner\": {\n    \"ownerID\": \"user123\",\n    \"ownerType\": \"USER\",\n    \"ownerName\": \"John Doe\",\n    \"ownerEmail\": \"owner123@test.com\"\n  }\n}")

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

	req.Header.Add("STATSIG-API-KEY", "<api-key>")
	req.Header.Add("Content-Type", "application/json")

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

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

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.post("https://statsigapi.net/console/v1/experiments/assignment_source/{name}")
  .header("STATSIG-API-KEY", "<api-key>")
  .header("Content-Type", "application/json")
  .body("{\n  \"sql\": \"<string>\",\n  \"timestampColumn\": \"<string>\",\n  \"experimentIDColumn\": \"<string>\",\n  \"groupIDColumn\": \"<string>\",\n  \"idTypeMapping\": [\n    {\n      \"statsigUnitID\": \"<string>\",\n      \"column\": \"<string>\"\n    }\n  ],\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"isVerified\": true,\n  \"tags\": [\n    \"<string>\"\n  ],\n  \"isReadOnly\": true,\n  \"owner\": {\n    \"ownerID\": \"user123\",\n    \"ownerType\": \"USER\",\n    \"ownerName\": \"John Doe\",\n    \"ownerEmail\": \"owner123@test.com\"\n  }\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://statsigapi.net/console/v1/experiments/assignment_source/{name}")

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

request = Net::HTTP::Post.new(url)
request["STATSIG-API-KEY"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"sql\": \"<string>\",\n  \"timestampColumn\": \"<string>\",\n  \"experimentIDColumn\": \"<string>\",\n  \"groupIDColumn\": \"<string>\",\n  \"idTypeMapping\": [\n    {\n      \"statsigUnitID\": \"<string>\",\n      \"column\": \"<string>\"\n    }\n  ],\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"isVerified\": true,\n  \"tags\": [\n    \"<string>\"\n  ],\n  \"isReadOnly\": true,\n  \"owner\": {\n    \"ownerID\": \"user123\",\n    \"ownerType\": \"USER\",\n    \"ownerName\": \"John Doe\",\n    \"ownerEmail\": \"owner123@test.com\"\n  }\n}"

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

{
  "message": "Assignment Source updated successfully",
  "data": {
    "name": "exposures3",
    "description": "qweqwe",
    "tags": [],
    "sql": "SELECT * FROM shoppy-sales.experiment_data.exposures",
    "timestampColumn": "ts",
    "groupIDColumn": "group_id",
    "experimentIDColumn": "experiment_name",
    "idTypeMapping": [
      {
        "statsigUnitID": "stableID",
        "column": "user_id"
      }
    ]
  }
}

{
  "status": 400,
  "message": "Invalid request. Please check the request input and try again."
}

{
  "status": 401,
  "message": "This endpoint only accepts an active CONSOLE key, but an invalid key was sent. Key: console-xxxXXXxxxXXXxxx"
}

{
  "status": 404,
  "message": "Not Found. The requested resource could not be found."
}

Authorizations

STATSIG-API-KEY

string

header

required

Headers

x-respect-review-settings

string

Optional header to respect review settings for mutation endpoints.

Path Parameters

name

string

required

Name of the assignment source

Body

application/json

sql

string

required

SQL query defining the data source for assignments.

timestampColumn

string

required

Column name representing the timestamp of assignments.

experimentIDColumn

string

required

Column name for the experiment ID associated with the assignments.

groupIDColumn

string

required

Column name for the group ID linked to the assignments.

idTypeMapping

object[]

required

Mappings of Statsig units to their respective columns.

Show child attributes

name

string

Optional new name for the assignment source.

description

string

Optional updated context for the assignment source.

isVerified

boolean

Marks the assignment source as verified for internal trustworthiness.

Response

Post Assignment Source response

message

string

required

A simple string explaining the result of the operation.

data

object

required

A single result.

Show child attributes

⌘I

HTTP API

Console API

Alerts

Audit Logs

Autotunes

Company

Dynamic Configs

Events

Experiments

Experiments (Warehouse Native)

Configs

Gates

Holdouts

Ingestions

Keys

Layers

Metrics

Metrics (Warehouse Native)

Project

Usage

Reports

Segments

Tags

Target App

Users

Post Assignment Source

Authorizations

Headers

Path Parameters

Body

Response