Update a data source

curl -X POST 'https://api.growthbook.io/api/v1/data-sources/{id}' \
  -H 'Authorization: Bearer YOUR_API_KEY'

import requests

url = "https://api.growthbook.io/api/v1/data-sources/{id}"

payload = {
    "name": "<string>",
    "description": "<string>",
    "projectIds": ["<string>"],
    "identifierTypes": [
        {
            "id": "<string>",
            "description": "<string>"
        }
    ],
    "assignmentQueries": [
        {
            "name": "<string>",
            "sql": "<string>",
            "id": "<string>",
            "description": "<string>",
            "identifierTypes": ["<string>"],
            "identifierType": "<string>",
            "includesNameColumns": True,
            "dimensionColumns": ["<string>"],
            "projects": ["<string>"],
            "columnMapping": {
                "experimentIdColumn": "<string>",
                "variationIdColumn": "<string>",
                "timestampColumn": "<string>",
                "userIdColumns": {},
                "experimentNameColumn": "<string>",
                "variationNameColumn": "<string>"
            }
        }
    ],
    "identifierJoinQueries": [
        {
            "identifierTypes": ["<string>"],
            "sql": "<string>"
        }
    ],
    "mixpanelSettings": {
        "viewedExperimentEventName": "<string>",
        "experimentIdProperty": "<string>",
        "variationIdProperty": "<string>",
        "extraUserIdProperty": "<string>"
    },
    "pipelineSettings": {
        "allowWriting": True,
        "writeDatabase": "<string>",
        "writeDataset": "<string>",
        "unitsTableRetentionHours": 123,
        "unitsTableDeletion": True,
        "includedExperimentIds": ["<string>"],
        "excludedExperimentIds": ["<string>"],
        "incrementalOptInExperimentIds": ["<string>"]
    },
    "maxConcurrentQueries": 1,
    "queryCacheTTLMins": 1
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

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

print(response.text)

const options = {
  method: 'POST',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    name: '<string>',
    description: '<string>',
    projectIds: ['<string>'],
    identifierTypes: [{id: '<string>', description: '<string>'}],
    assignmentQueries: [
      {
        name: '<string>',
        sql: '<string>',
        id: '<string>',
        description: '<string>',
        identifierTypes: ['<string>'],
        identifierType: '<string>',
        includesNameColumns: true,
        dimensionColumns: ['<string>'],
        projects: ['<string>'],
        columnMapping: {
          experimentIdColumn: '<string>',
          variationIdColumn: '<string>',
          timestampColumn: '<string>',
          userIdColumns: {},
          experimentNameColumn: '<string>',
          variationNameColumn: '<string>'
        }
      }
    ],
    identifierJoinQueries: [{identifierTypes: ['<string>'], sql: '<string>'}],
    mixpanelSettings: {
      viewedExperimentEventName: '<string>',
      experimentIdProperty: '<string>',
      variationIdProperty: '<string>',
      extraUserIdProperty: '<string>'
    },
    pipelineSettings: {
      allowWriting: true,
      writeDatabase: '<string>',
      writeDataset: '<string>',
      unitsTableRetentionHours: 123,
      unitsTableDeletion: true,
      includedExperimentIds: ['<string>'],
      excludedExperimentIds: ['<string>'],
      incrementalOptInExperimentIds: ['<string>']
    },
    maxConcurrentQueries: 1,
    queryCacheTTLMins: 1
  })
};

fetch('https://api.growthbook.io/api/v1/data-sources/{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://api.growthbook.io/api/v1/data-sources/{id}",
  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([
    'name' => '<string>',
    'description' => '<string>',
    'projectIds' => [
        '<string>'
    ],
    'identifierTypes' => [
        [
                'id' => '<string>',
                'description' => '<string>'
        ]
    ],
    'assignmentQueries' => [
        [
                'name' => '<string>',
                'sql' => '<string>',
                'id' => '<string>',
                'description' => '<string>',
                'identifierTypes' => [
                                '<string>'
                ],
                'identifierType' => '<string>',
                'includesNameColumns' => true,
                'dimensionColumns' => [
                                '<string>'
                ],
                'projects' => [
                                '<string>'
                ],
                'columnMapping' => [
                                'experimentIdColumn' => '<string>',
                                'variationIdColumn' => '<string>',
                                'timestampColumn' => '<string>',
                                'userIdColumns' => [
                                                                
                                ],
                                'experimentNameColumn' => '<string>',
                                'variationNameColumn' => '<string>'
                ]
        ]
    ],
    'identifierJoinQueries' => [
        [
                'identifierTypes' => [
                                '<string>'
                ],
                'sql' => '<string>'
        ]
    ],
    'mixpanelSettings' => [
        'viewedExperimentEventName' => '<string>',
        'experimentIdProperty' => '<string>',
        'variationIdProperty' => '<string>',
        'extraUserIdProperty' => '<string>'
    ],
    'pipelineSettings' => [
        'allowWriting' => true,
        'writeDatabase' => '<string>',
        'writeDataset' => '<string>',
        'unitsTableRetentionHours' => 123,
        'unitsTableDeletion' => true,
        'includedExperimentIds' => [
                '<string>'
        ],
        'excludedExperimentIds' => [
                '<string>'
        ],
        'incrementalOptInExperimentIds' => [
                '<string>'
        ]
    ],
    'maxConcurrentQueries' => 1,
    'queryCacheTTLMins' => 1
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>",
    "Content-Type: application/json"
  ],
]);

$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://api.growthbook.io/api/v1/data-sources/{id}"

	payload := strings.NewReader("{\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"projectIds\": [\n    \"<string>\"\n  ],\n  \"identifierTypes\": [\n    {\n      \"id\": \"<string>\",\n      \"description\": \"<string>\"\n    }\n  ],\n  \"assignmentQueries\": [\n    {\n      \"name\": \"<string>\",\n      \"sql\": \"<string>\",\n      \"id\": \"<string>\",\n      \"description\": \"<string>\",\n      \"identifierTypes\": [\n        \"<string>\"\n      ],\n      \"identifierType\": \"<string>\",\n      \"includesNameColumns\": true,\n      \"dimensionColumns\": [\n        \"<string>\"\n      ],\n      \"projects\": [\n        \"<string>\"\n      ],\n      \"columnMapping\": {\n        \"experimentIdColumn\": \"<string>\",\n        \"variationIdColumn\": \"<string>\",\n        \"timestampColumn\": \"<string>\",\n        \"userIdColumns\": {},\n        \"experimentNameColumn\": \"<string>\",\n        \"variationNameColumn\": \"<string>\"\n      }\n    }\n  ],\n  \"identifierJoinQueries\": [\n    {\n      \"identifierTypes\": [\n        \"<string>\"\n      ],\n      \"sql\": \"<string>\"\n    }\n  ],\n  \"mixpanelSettings\": {\n    \"viewedExperimentEventName\": \"<string>\",\n    \"experimentIdProperty\": \"<string>\",\n    \"variationIdProperty\": \"<string>\",\n    \"extraUserIdProperty\": \"<string>\"\n  },\n  \"pipelineSettings\": {\n    \"allowWriting\": true,\n    \"writeDatabase\": \"<string>\",\n    \"writeDataset\": \"<string>\",\n    \"unitsTableRetentionHours\": 123,\n    \"unitsTableDeletion\": true,\n    \"includedExperimentIds\": [\n      \"<string>\"\n    ],\n    \"excludedExperimentIds\": [\n      \"<string>\"\n    ],\n    \"incrementalOptInExperimentIds\": [\n      \"<string>\"\n    ]\n  },\n  \"maxConcurrentQueries\": 1,\n  \"queryCacheTTLMins\": 1\n}")

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

	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(string(body))

}

HttpResponse<String> response = Unirest.post("https://api.growthbook.io/api/v1/data-sources/{id}")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"projectIds\": [\n    \"<string>\"\n  ],\n  \"identifierTypes\": [\n    {\n      \"id\": \"<string>\",\n      \"description\": \"<string>\"\n    }\n  ],\n  \"assignmentQueries\": [\n    {\n      \"name\": \"<string>\",\n      \"sql\": \"<string>\",\n      \"id\": \"<string>\",\n      \"description\": \"<string>\",\n      \"identifierTypes\": [\n        \"<string>\"\n      ],\n      \"identifierType\": \"<string>\",\n      \"includesNameColumns\": true,\n      \"dimensionColumns\": [\n        \"<string>\"\n      ],\n      \"projects\": [\n        \"<string>\"\n      ],\n      \"columnMapping\": {\n        \"experimentIdColumn\": \"<string>\",\n        \"variationIdColumn\": \"<string>\",\n        \"timestampColumn\": \"<string>\",\n        \"userIdColumns\": {},\n        \"experimentNameColumn\": \"<string>\",\n        \"variationNameColumn\": \"<string>\"\n      }\n    }\n  ],\n  \"identifierJoinQueries\": [\n    {\n      \"identifierTypes\": [\n        \"<string>\"\n      ],\n      \"sql\": \"<string>\"\n    }\n  ],\n  \"mixpanelSettings\": {\n    \"viewedExperimentEventName\": \"<string>\",\n    \"experimentIdProperty\": \"<string>\",\n    \"variationIdProperty\": \"<string>\",\n    \"extraUserIdProperty\": \"<string>\"\n  },\n  \"pipelineSettings\": {\n    \"allowWriting\": true,\n    \"writeDatabase\": \"<string>\",\n    \"writeDataset\": \"<string>\",\n    \"unitsTableRetentionHours\": 123,\n    \"unitsTableDeletion\": true,\n    \"includedExperimentIds\": [\n      \"<string>\"\n    ],\n    \"excludedExperimentIds\": [\n      \"<string>\"\n    ],\n    \"incrementalOptInExperimentIds\": [\n      \"<string>\"\n    ]\n  },\n  \"maxConcurrentQueries\": 1,\n  \"queryCacheTTLMins\": 1\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.growthbook.io/api/v1/data-sources/{id}")

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

request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"projectIds\": [\n    \"<string>\"\n  ],\n  \"identifierTypes\": [\n    {\n      \"id\": \"<string>\",\n      \"description\": \"<string>\"\n    }\n  ],\n  \"assignmentQueries\": [\n    {\n      \"name\": \"<string>\",\n      \"sql\": \"<string>\",\n      \"id\": \"<string>\",\n      \"description\": \"<string>\",\n      \"identifierTypes\": [\n        \"<string>\"\n      ],\n      \"identifierType\": \"<string>\",\n      \"includesNameColumns\": true,\n      \"dimensionColumns\": [\n        \"<string>\"\n      ],\n      \"projects\": [\n        \"<string>\"\n      ],\n      \"columnMapping\": {\n        \"experimentIdColumn\": \"<string>\",\n        \"variationIdColumn\": \"<string>\",\n        \"timestampColumn\": \"<string>\",\n        \"userIdColumns\": {},\n        \"experimentNameColumn\": \"<string>\",\n        \"variationNameColumn\": \"<string>\"\n      }\n    }\n  ],\n  \"identifierJoinQueries\": [\n    {\n      \"identifierTypes\": [\n        \"<string>\"\n      ],\n      \"sql\": \"<string>\"\n    }\n  ],\n  \"mixpanelSettings\": {\n    \"viewedExperimentEventName\": \"<string>\",\n    \"experimentIdProperty\": \"<string>\",\n    \"variationIdProperty\": \"<string>\",\n    \"extraUserIdProperty\": \"<string>\"\n  },\n  \"pipelineSettings\": {\n    \"allowWriting\": true,\n    \"writeDatabase\": \"<string>\",\n    \"writeDataset\": \"<string>\",\n    \"unitsTableRetentionHours\": 123,\n    \"unitsTableDeletion\": true,\n    \"includedExperimentIds\": [\n      \"<string>\"\n    ],\n    \"excludedExperimentIds\": [\n      \"<string>\"\n    ],\n    \"incrementalOptInExperimentIds\": [\n      \"<string>\"\n    ]\n  },\n  \"maxConcurrentQueries\": 1,\n  \"queryCacheTTLMins\": 1\n}"

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

{
  "dataSource": {
    "id": "<string>",
    "dateCreated": "2023-11-07T05:31:56Z",
    "dateUpdated": "2023-11-07T05:31:56Z",
    "type": "<string>",
    "name": "<string>",
    "description": "<string>",
    "projectIds": [
      "<string>"
    ],
    "eventTracker": "<string>",
    "identifierTypes": [
      {
        "id": "<string>",
        "description": "<string>"
      }
    ],
    "assignmentQueries": [
      {
        "id": "<string>",
        "name": "<string>",
        "description": "<string>",
        "identifierTypes": [
          "<string>"
        ],
        "identifierType": "<string>",
        "sql": "<string>",
        "includesNameColumns": true,
        "dimensionColumns": [
          "<string>"
        ],
        "projects": [
          "<string>"
        ],
        "columnMapping": {
          "experimentIdColumn": "<string>",
          "variationIdColumn": "<string>",
          "timestampColumn": "<string>",
          "userIdColumns": {},
          "experimentNameColumn": "<string>",
          "variationNameColumn": "<string>"
        },
        "error": "<string>"
      }
    ],
    "identifierJoinQueries": [
      {
        "identifierTypes": [
          "<string>"
        ],
        "sql": "<string>"
      }
    ],
    "mixpanelSettings": {
      "viewedExperimentEventName": "<string>",
      "experimentIdProperty": "<string>",
      "variationIdProperty": "<string>",
      "extraUserIdProperty": "<string>"
    },
    "pipelineSettings": {
      "allowWriting": true,
      "mode": "ephemeral",
      "writeDataset": "<string>",
      "unitsTableRetentionHours": 123,
      "writeDatabase": "<string>",
      "unitsTableDeletion": true,
      "includedExperimentIds": [
        "<string>"
      ],
      "excludedExperimentIds": [
        "<string>"
      ],
      "incrementalOptInExperimentIds": [
        "<string>"
      ]
    },
    "maxConcurrentQueries": 1,
    "queryCacheTTLMins": 1
  },
  "eventForwarderWarning": "<string>"
}

{
  "confirmation": {
    "id": "<string>",
    "status": "pending",
    "actions": [
      {
        "action": "feature.create",
        "environments": [
          "<string>"
        ]
      }
    ],
    "summary": "<string>",
    "url": "<string>",
    "expiresAt": "<string>",
    "response": {
      "status": 123,
      "body": "<unknown>"
    },
    "note": "<string>"
  },
  "message": "<string>"
}