Update import source
curl --request PATCH \
--url https://api.prequel.co/import/sources/{id} \
--header 'Content-Type: application/json' \
--header 'X-API-KEY: <api-key>' \
--data '
{
"source": {
"name": "<string>",
"postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
},
"redshift": {
"host": "<string>",
"port": 123,
"database": "<string>",
"cluster": "<string>",
"region": "<string>",
"workgroup": "<string>",
"username": "<string>",
"use_ssh_tunnel": true,
"disable_ssl": true,
"connection_timeout_in_seconds": 1
},
"redshift_serverless": {
"host": "<string>",
"port": 123,
"database": "<string>",
"workgroup": "<string>",
"region": "<string>",
"use_ssh_tunnel": true,
"disable_ssl": true,
"connection_timeout_in_seconds": 1
},
"bigquery": {
"project_id": "<string>",
"region": "<string>",
"gcp_service_account_role": {
"service_account_email": "jsmith@example.com"
},
"gcp_service_account_key": {
"service_account_email": "jsmith@example.com",
"service_account_key": "<unknown>"
}
},
"s3": {
"bucket_name": "<string>",
"region": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"bucket_host": "<string>",
"use_ssh_tunnel": true
},
"abs": {
"bucket_name": "<string>",
"storage_account_name": "<string>",
"auth_method": "azure_service_shared_access_signature",
"azure_service_shared_access_signature": {
"shared_access_signature_token": "<string>"
}
},
"sftp": {
"username": "<string>",
"host": "<string>",
"port": 123,
"auth_method": "public_key_auth",
"public_key_auth": {
"public_key": "<string>"
}
},
"gcs": {
"bucket_name": "<string>",
"region": "<string>",
"gcp_service_account_role": {
"service_account_email": "jsmith@example.com"
},
"gcs_hmac_keys": {
"access_key": "<string>",
"secret": "<string>"
},
"gcp_service_account_key": {
"service_account_email": "jsmith@example.com",
"service_account_key": "<unknown>"
}
},
"s3_compatible": {
"host": "<string>",
"port": 123,
"bucket_name": "<string>",
"auth_method": "access_keys",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"disable_ssl": true,
"use_ssh_tunnel": true
},
"snowflake": {
"host": "<string>",
"port": 123,
"database": "<string>",
"username": "<string>",
"auth_method": "public_key_auth",
"public_key_auth": {
"public_key": "<string>"
}
},
"delta_sharing": {
"host": "<string>",
"port": 123
}
}
}
'import requests
url = "https://api.prequel.co/import/sources/{id}"
payload = { "source": {
"name": "<string>",
"postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
},
"redshift": {
"host": "<string>",
"port": 123,
"database": "<string>",
"cluster": "<string>",
"region": "<string>",
"workgroup": "<string>",
"username": "<string>",
"use_ssh_tunnel": True,
"disable_ssl": True,
"connection_timeout_in_seconds": 1
},
"redshift_serverless": {
"host": "<string>",
"port": 123,
"database": "<string>",
"workgroup": "<string>",
"region": "<string>",
"use_ssh_tunnel": True,
"disable_ssl": True,
"connection_timeout_in_seconds": 1
},
"bigquery": {
"project_id": "<string>",
"region": "<string>",
"gcp_service_account_role": { "service_account_email": "jsmith@example.com" },
"gcp_service_account_key": {
"service_account_email": "jsmith@example.com",
"service_account_key": "<unknown>"
}
},
"s3": {
"bucket_name": "<string>",
"region": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"bucket_host": "<string>",
"use_ssh_tunnel": True
},
"abs": {
"bucket_name": "<string>",
"storage_account_name": "<string>",
"auth_method": "azure_service_shared_access_signature",
"azure_service_shared_access_signature": { "shared_access_signature_token": "<string>" }
},
"sftp": {
"username": "<string>",
"host": "<string>",
"port": 123,
"auth_method": "public_key_auth",
"public_key_auth": { "public_key": "<string>" }
},
"gcs": {
"bucket_name": "<string>",
"region": "<string>",
"gcp_service_account_role": { "service_account_email": "jsmith@example.com" },
"gcs_hmac_keys": {
"access_key": "<string>",
"secret": "<string>"
},
"gcp_service_account_key": {
"service_account_email": "jsmith@example.com",
"service_account_key": "<unknown>"
}
},
"s3_compatible": {
"host": "<string>",
"port": 123,
"bucket_name": "<string>",
"auth_method": "access_keys",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"disable_ssl": True,
"use_ssh_tunnel": True
},
"snowflake": {
"host": "<string>",
"port": 123,
"database": "<string>",
"username": "<string>",
"auth_method": "public_key_auth",
"public_key_auth": { "public_key": "<string>" }
},
"delta_sharing": {
"host": "<string>",
"port": 123
}
} }
headers = {
"X-API-KEY": "<api-key>",
"Content-Type": "application/json"
}
response = requests.patch(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PATCH',
headers: {'X-API-KEY': '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
source: {
name: '<string>',
postgres: {
host: '<string>',
port: 123,
database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
},
redshift: {
host: '<string>',
port: 123,
database: '<string>',
cluster: '<string>',
region: '<string>',
workgroup: '<string>',
username: '<string>',
use_ssh_tunnel: true,
disable_ssl: true,
connection_timeout_in_seconds: 1
},
redshift_serverless: {
host: '<string>',
port: 123,
database: '<string>',
workgroup: '<string>',
region: '<string>',
use_ssh_tunnel: true,
disable_ssl: true,
connection_timeout_in_seconds: 1
},
bigquery: {
project_id: '<string>',
region: '<string>',
gcp_service_account_role: {service_account_email: 'jsmith@example.com'},
gcp_service_account_key: {service_account_email: 'jsmith@example.com', service_account_key: '<unknown>'}
},
s3: {
bucket_name: '<string>',
region: '<string>',
aws_access_keys: {access_id: '<string>', secret_key: '<string>'},
bucket_host: '<string>',
use_ssh_tunnel: true
},
abs: {
bucket_name: '<string>',
storage_account_name: '<string>',
auth_method: 'azure_service_shared_access_signature',
azure_service_shared_access_signature: {shared_access_signature_token: '<string>'}
},
sftp: {
username: '<string>',
host: '<string>',
port: 123,
auth_method: 'public_key_auth',
public_key_auth: {public_key: '<string>'}
},
gcs: {
bucket_name: '<string>',
region: '<string>',
gcp_service_account_role: {service_account_email: 'jsmith@example.com'},
gcs_hmac_keys: {access_key: '<string>', secret: '<string>'},
gcp_service_account_key: {service_account_email: 'jsmith@example.com', service_account_key: '<unknown>'}
},
s3_compatible: {
host: '<string>',
port: 123,
bucket_name: '<string>',
auth_method: 'access_keys',
aws_access_keys: {access_id: '<string>', secret_key: '<string>'},
disable_ssl: true,
use_ssh_tunnel: true
},
snowflake: {
host: '<string>',
port: 123,
database: '<string>',
username: '<string>',
auth_method: 'public_key_auth',
public_key_auth: {public_key: '<string>'}
},
delta_sharing: {host: '<string>', port: 123}
}
})
};
fetch('https://api.prequel.co/import/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.prequel.co/import/sources/{id}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PATCH",
CURLOPT_POSTFIELDS => json_encode([
'source' => [
'name' => '<string>',
'postgres' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
],
'redshift' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'cluster' => '<string>',
'region' => '<string>',
'workgroup' => '<string>',
'username' => '<string>',
'use_ssh_tunnel' => true,
'disable_ssl' => true,
'connection_timeout_in_seconds' => 1
],
'redshift_serverless' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'workgroup' => '<string>',
'region' => '<string>',
'use_ssh_tunnel' => true,
'disable_ssl' => true,
'connection_timeout_in_seconds' => 1
],
'bigquery' => [
'project_id' => '<string>',
'region' => '<string>',
'gcp_service_account_role' => [
'service_account_email' => 'jsmith@example.com'
],
'gcp_service_account_key' => [
'service_account_email' => 'jsmith@example.com',
'service_account_key' => '<unknown>'
]
],
's3' => [
'bucket_name' => '<string>',
'region' => '<string>',
'aws_access_keys' => [
'access_id' => '<string>',
'secret_key' => '<string>'
],
'bucket_host' => '<string>',
'use_ssh_tunnel' => true
],
'abs' => [
'bucket_name' => '<string>',
'storage_account_name' => '<string>',
'auth_method' => 'azure_service_shared_access_signature',
'azure_service_shared_access_signature' => [
'shared_access_signature_token' => '<string>'
]
],
'sftp' => [
'username' => '<string>',
'host' => '<string>',
'port' => 123,
'auth_method' => 'public_key_auth',
'public_key_auth' => [
'public_key' => '<string>'
]
],
'gcs' => [
'bucket_name' => '<string>',
'region' => '<string>',
'gcp_service_account_role' => [
'service_account_email' => 'jsmith@example.com'
],
'gcs_hmac_keys' => [
'access_key' => '<string>',
'secret' => '<string>'
],
'gcp_service_account_key' => [
'service_account_email' => 'jsmith@example.com',
'service_account_key' => '<unknown>'
]
],
's3_compatible' => [
'host' => '<string>',
'port' => 123,
'bucket_name' => '<string>',
'auth_method' => 'access_keys',
'aws_access_keys' => [
'access_id' => '<string>',
'secret_key' => '<string>'
],
'disable_ssl' => true,
'use_ssh_tunnel' => true
],
'snowflake' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'username' => '<string>',
'auth_method' => 'public_key_auth',
'public_key_auth' => [
'public_key' => '<string>'
]
],
'delta_sharing' => [
'host' => '<string>',
'port' => 123
]
]
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"X-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://api.prequel.co/import/sources/{id}"
payload := strings.NewReader("{\n \"source\": {\n \"name\": \"<string>\",\n \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"redshift\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"cluster\": \"<string>\",\n \"region\": \"<string>\",\n \"workgroup\": \"<string>\",\n \"username\": \"<string>\",\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"redshift_serverless\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"workgroup\": \"<string>\",\n \"region\": \"<string>\",\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"bigquery\": {\n \"project_id\": \"<string>\",\n \"region\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"jsmith@example.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"s3\": {\n \"bucket_name\": \"<string>\",\n \"region\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_host\": \"<string>\",\n \"use_ssh_tunnel\": true\n },\n \"abs\": {\n \"bucket_name\": \"<string>\",\n \"storage_account_name\": \"<string>\",\n \"auth_method\": \"azure_service_shared_access_signature\",\n \"azure_service_shared_access_signature\": {\n \"shared_access_signature_token\": \"<string>\"\n }\n },\n \"sftp\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"gcs\": {\n \"bucket_name\": \"<string>\",\n \"region\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"jsmith@example.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"s3_compatible\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"bucket_name\": \"<string>\",\n \"auth_method\": \"access_keys\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"disable_ssl\": true,\n \"use_ssh_tunnel\": true\n },\n \"snowflake\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"username\": \"<string>\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"delta_sharing\": {\n \"host\": \"<string>\",\n \"port\": 123\n }\n }\n}")
req, _ := http.NewRequest("PATCH", url, payload)
req.Header.Add("X-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.patch("https://api.prequel.co/import/sources/{id}")
.header("X-API-KEY", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"source\": {\n \"name\": \"<string>\",\n \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"redshift\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"cluster\": \"<string>\",\n \"region\": \"<string>\",\n \"workgroup\": \"<string>\",\n \"username\": \"<string>\",\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"redshift_serverless\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"workgroup\": \"<string>\",\n \"region\": \"<string>\",\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"bigquery\": {\n \"project_id\": \"<string>\",\n \"region\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"jsmith@example.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"s3\": {\n \"bucket_name\": \"<string>\",\n \"region\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_host\": \"<string>\",\n \"use_ssh_tunnel\": true\n },\n \"abs\": {\n \"bucket_name\": \"<string>\",\n \"storage_account_name\": \"<string>\",\n \"auth_method\": \"azure_service_shared_access_signature\",\n \"azure_service_shared_access_signature\": {\n \"shared_access_signature_token\": \"<string>\"\n }\n },\n \"sftp\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"gcs\": {\n \"bucket_name\": \"<string>\",\n \"region\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"jsmith@example.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"s3_compatible\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"bucket_name\": \"<string>\",\n \"auth_method\": \"access_keys\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"disable_ssl\": true,\n \"use_ssh_tunnel\": true\n },\n \"snowflake\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"username\": \"<string>\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"delta_sharing\": {\n \"host\": \"<string>\",\n \"port\": 123\n }\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.prequel.co/import/sources/{id}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
request["X-API-KEY"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"source\": {\n \"name\": \"<string>\",\n \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"redshift\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"cluster\": \"<string>\",\n \"region\": \"<string>\",\n \"workgroup\": \"<string>\",\n \"username\": \"<string>\",\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"redshift_serverless\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"workgroup\": \"<string>\",\n \"region\": \"<string>\",\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"bigquery\": {\n \"project_id\": \"<string>\",\n \"region\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"jsmith@example.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"s3\": {\n \"bucket_name\": \"<string>\",\n \"region\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_host\": \"<string>\",\n \"use_ssh_tunnel\": true\n },\n \"abs\": {\n \"bucket_name\": \"<string>\",\n \"storage_account_name\": \"<string>\",\n \"auth_method\": \"azure_service_shared_access_signature\",\n \"azure_service_shared_access_signature\": {\n \"shared_access_signature_token\": \"<string>\"\n }\n },\n \"sftp\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"gcs\": {\n \"bucket_name\": \"<string>\",\n \"region\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"jsmith@example.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"s3_compatible\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"bucket_name\": \"<string>\",\n \"auth_method\": \"access_keys\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"disable_ssl\": true,\n \"use_ssh_tunnel\": true\n },\n \"snowflake\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"username\": \"<string>\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"delta_sharing\": {\n \"host\": \"<string>\",\n \"port\": 123\n }\n }\n}"
response = http.request(request)
puts response.read_body{
"status": "<string>",
"data": {
"source": {
"vendor": "<unknown>",
"postgres": {
"is_valid": true,
"host": "<string>",
"port": 123,
"database": "<string>",
"username": "<string>",
"auth_method": "<string>",
"use_ssh_tunnel": true,
"disable_ssl": true,
"connection_timeout_in_seconds": 123,
"ssh_tunnel": {
"ssh_tunnel_host": "<string>",
"ssh_tunnel_port": 123,
"ssh_tunnel_username": "<string>",
"ssh_public_key": "<string>"
}
},
"id": "<string>",
"provider_id": "<string>",
"name": "<string>",
"created_at": "<string>",
"updated_at": "<string>"
}
},
"message": "<string>"
}{
"status": "<string>",
"message": "<string>",
"data": null
}{
"status": "<string>",
"message": "<string>",
"data": null
}{
"status": "<string>",
"message": "<string>",
"data": null
}{
"status": "<string>",
"message": "<string>",
"data": null
}Import Sources
Update import source
Update an existing import source.
PATCH
/
import
/
sources
/
{id}
Update import source
curl --request PATCH \
--url https://api.prequel.co/import/sources/{id} \
--header 'Content-Type: application/json' \
--header 'X-API-KEY: <api-key>' \
--data '
{
"source": {
"name": "<string>",
"postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
},
"redshift": {
"host": "<string>",
"port": 123,
"database": "<string>",
"cluster": "<string>",
"region": "<string>",
"workgroup": "<string>",
"username": "<string>",
"use_ssh_tunnel": true,
"disable_ssl": true,
"connection_timeout_in_seconds": 1
},
"redshift_serverless": {
"host": "<string>",
"port": 123,
"database": "<string>",
"workgroup": "<string>",
"region": "<string>",
"use_ssh_tunnel": true,
"disable_ssl": true,
"connection_timeout_in_seconds": 1
},
"bigquery": {
"project_id": "<string>",
"region": "<string>",
"gcp_service_account_role": {
"service_account_email": "jsmith@example.com"
},
"gcp_service_account_key": {
"service_account_email": "jsmith@example.com",
"service_account_key": "<unknown>"
}
},
"s3": {
"bucket_name": "<string>",
"region": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"bucket_host": "<string>",
"use_ssh_tunnel": true
},
"abs": {
"bucket_name": "<string>",
"storage_account_name": "<string>",
"auth_method": "azure_service_shared_access_signature",
"azure_service_shared_access_signature": {
"shared_access_signature_token": "<string>"
}
},
"sftp": {
"username": "<string>",
"host": "<string>",
"port": 123,
"auth_method": "public_key_auth",
"public_key_auth": {
"public_key": "<string>"
}
},
"gcs": {
"bucket_name": "<string>",
"region": "<string>",
"gcp_service_account_role": {
"service_account_email": "jsmith@example.com"
},
"gcs_hmac_keys": {
"access_key": "<string>",
"secret": "<string>"
},
"gcp_service_account_key": {
"service_account_email": "jsmith@example.com",
"service_account_key": "<unknown>"
}
},
"s3_compatible": {
"host": "<string>",
"port": 123,
"bucket_name": "<string>",
"auth_method": "access_keys",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"disable_ssl": true,
"use_ssh_tunnel": true
},
"snowflake": {
"host": "<string>",
"port": 123,
"database": "<string>",
"username": "<string>",
"auth_method": "public_key_auth",
"public_key_auth": {
"public_key": "<string>"
}
},
"delta_sharing": {
"host": "<string>",
"port": 123
}
}
}
'import requests
url = "https://api.prequel.co/import/sources/{id}"
payload = { "source": {
"name": "<string>",
"postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
},
"redshift": {
"host": "<string>",
"port": 123,
"database": "<string>",
"cluster": "<string>",
"region": "<string>",
"workgroup": "<string>",
"username": "<string>",
"use_ssh_tunnel": True,
"disable_ssl": True,
"connection_timeout_in_seconds": 1
},
"redshift_serverless": {
"host": "<string>",
"port": 123,
"database": "<string>",
"workgroup": "<string>",
"region": "<string>",
"use_ssh_tunnel": True,
"disable_ssl": True,
"connection_timeout_in_seconds": 1
},
"bigquery": {
"project_id": "<string>",
"region": "<string>",
"gcp_service_account_role": { "service_account_email": "jsmith@example.com" },
"gcp_service_account_key": {
"service_account_email": "jsmith@example.com",
"service_account_key": "<unknown>"
}
},
"s3": {
"bucket_name": "<string>",
"region": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"bucket_host": "<string>",
"use_ssh_tunnel": True
},
"abs": {
"bucket_name": "<string>",
"storage_account_name": "<string>",
"auth_method": "azure_service_shared_access_signature",
"azure_service_shared_access_signature": { "shared_access_signature_token": "<string>" }
},
"sftp": {
"username": "<string>",
"host": "<string>",
"port": 123,
"auth_method": "public_key_auth",
"public_key_auth": { "public_key": "<string>" }
},
"gcs": {
"bucket_name": "<string>",
"region": "<string>",
"gcp_service_account_role": { "service_account_email": "jsmith@example.com" },
"gcs_hmac_keys": {
"access_key": "<string>",
"secret": "<string>"
},
"gcp_service_account_key": {
"service_account_email": "jsmith@example.com",
"service_account_key": "<unknown>"
}
},
"s3_compatible": {
"host": "<string>",
"port": 123,
"bucket_name": "<string>",
"auth_method": "access_keys",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"disable_ssl": True,
"use_ssh_tunnel": True
},
"snowflake": {
"host": "<string>",
"port": 123,
"database": "<string>",
"username": "<string>",
"auth_method": "public_key_auth",
"public_key_auth": { "public_key": "<string>" }
},
"delta_sharing": {
"host": "<string>",
"port": 123
}
} }
headers = {
"X-API-KEY": "<api-key>",
"Content-Type": "application/json"
}
response = requests.patch(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PATCH',
headers: {'X-API-KEY': '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
source: {
name: '<string>',
postgres: {
host: '<string>',
port: 123,
database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
},
redshift: {
host: '<string>',
port: 123,
database: '<string>',
cluster: '<string>',
region: '<string>',
workgroup: '<string>',
username: '<string>',
use_ssh_tunnel: true,
disable_ssl: true,
connection_timeout_in_seconds: 1
},
redshift_serverless: {
host: '<string>',
port: 123,
database: '<string>',
workgroup: '<string>',
region: '<string>',
use_ssh_tunnel: true,
disable_ssl: true,
connection_timeout_in_seconds: 1
},
bigquery: {
project_id: '<string>',
region: '<string>',
gcp_service_account_role: {service_account_email: 'jsmith@example.com'},
gcp_service_account_key: {service_account_email: 'jsmith@example.com', service_account_key: '<unknown>'}
},
s3: {
bucket_name: '<string>',
region: '<string>',
aws_access_keys: {access_id: '<string>', secret_key: '<string>'},
bucket_host: '<string>',
use_ssh_tunnel: true
},
abs: {
bucket_name: '<string>',
storage_account_name: '<string>',
auth_method: 'azure_service_shared_access_signature',
azure_service_shared_access_signature: {shared_access_signature_token: '<string>'}
},
sftp: {
username: '<string>',
host: '<string>',
port: 123,
auth_method: 'public_key_auth',
public_key_auth: {public_key: '<string>'}
},
gcs: {
bucket_name: '<string>',
region: '<string>',
gcp_service_account_role: {service_account_email: 'jsmith@example.com'},
gcs_hmac_keys: {access_key: '<string>', secret: '<string>'},
gcp_service_account_key: {service_account_email: 'jsmith@example.com', service_account_key: '<unknown>'}
},
s3_compatible: {
host: '<string>',
port: 123,
bucket_name: '<string>',
auth_method: 'access_keys',
aws_access_keys: {access_id: '<string>', secret_key: '<string>'},
disable_ssl: true,
use_ssh_tunnel: true
},
snowflake: {
host: '<string>',
port: 123,
database: '<string>',
username: '<string>',
auth_method: 'public_key_auth',
public_key_auth: {public_key: '<string>'}
},
delta_sharing: {host: '<string>', port: 123}
}
})
};
fetch('https://api.prequel.co/import/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.prequel.co/import/sources/{id}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PATCH",
CURLOPT_POSTFIELDS => json_encode([
'source' => [
'name' => '<string>',
'postgres' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
],
'redshift' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'cluster' => '<string>',
'region' => '<string>',
'workgroup' => '<string>',
'username' => '<string>',
'use_ssh_tunnel' => true,
'disable_ssl' => true,
'connection_timeout_in_seconds' => 1
],
'redshift_serverless' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'workgroup' => '<string>',
'region' => '<string>',
'use_ssh_tunnel' => true,
'disable_ssl' => true,
'connection_timeout_in_seconds' => 1
],
'bigquery' => [
'project_id' => '<string>',
'region' => '<string>',
'gcp_service_account_role' => [
'service_account_email' => 'jsmith@example.com'
],
'gcp_service_account_key' => [
'service_account_email' => 'jsmith@example.com',
'service_account_key' => '<unknown>'
]
],
's3' => [
'bucket_name' => '<string>',
'region' => '<string>',
'aws_access_keys' => [
'access_id' => '<string>',
'secret_key' => '<string>'
],
'bucket_host' => '<string>',
'use_ssh_tunnel' => true
],
'abs' => [
'bucket_name' => '<string>',
'storage_account_name' => '<string>',
'auth_method' => 'azure_service_shared_access_signature',
'azure_service_shared_access_signature' => [
'shared_access_signature_token' => '<string>'
]
],
'sftp' => [
'username' => '<string>',
'host' => '<string>',
'port' => 123,
'auth_method' => 'public_key_auth',
'public_key_auth' => [
'public_key' => '<string>'
]
],
'gcs' => [
'bucket_name' => '<string>',
'region' => '<string>',
'gcp_service_account_role' => [
'service_account_email' => 'jsmith@example.com'
],
'gcs_hmac_keys' => [
'access_key' => '<string>',
'secret' => '<string>'
],
'gcp_service_account_key' => [
'service_account_email' => 'jsmith@example.com',
'service_account_key' => '<unknown>'
]
],
's3_compatible' => [
'host' => '<string>',
'port' => 123,
'bucket_name' => '<string>',
'auth_method' => 'access_keys',
'aws_access_keys' => [
'access_id' => '<string>',
'secret_key' => '<string>'
],
'disable_ssl' => true,
'use_ssh_tunnel' => true
],
'snowflake' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'username' => '<string>',
'auth_method' => 'public_key_auth',
'public_key_auth' => [
'public_key' => '<string>'
]
],
'delta_sharing' => [
'host' => '<string>',
'port' => 123
]
]
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"X-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://api.prequel.co/import/sources/{id}"
payload := strings.NewReader("{\n \"source\": {\n \"name\": \"<string>\",\n \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"redshift\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"cluster\": \"<string>\",\n \"region\": \"<string>\",\n \"workgroup\": \"<string>\",\n \"username\": \"<string>\",\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"redshift_serverless\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"workgroup\": \"<string>\",\n \"region\": \"<string>\",\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"bigquery\": {\n \"project_id\": \"<string>\",\n \"region\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"jsmith@example.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"s3\": {\n \"bucket_name\": \"<string>\",\n \"region\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_host\": \"<string>\",\n \"use_ssh_tunnel\": true\n },\n \"abs\": {\n \"bucket_name\": \"<string>\",\n \"storage_account_name\": \"<string>\",\n \"auth_method\": \"azure_service_shared_access_signature\",\n \"azure_service_shared_access_signature\": {\n \"shared_access_signature_token\": \"<string>\"\n }\n },\n \"sftp\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"gcs\": {\n \"bucket_name\": \"<string>\",\n \"region\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"jsmith@example.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"s3_compatible\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"bucket_name\": \"<string>\",\n \"auth_method\": \"access_keys\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"disable_ssl\": true,\n \"use_ssh_tunnel\": true\n },\n \"snowflake\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"username\": \"<string>\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"delta_sharing\": {\n \"host\": \"<string>\",\n \"port\": 123\n }\n }\n}")
req, _ := http.NewRequest("PATCH", url, payload)
req.Header.Add("X-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.patch("https://api.prequel.co/import/sources/{id}")
.header("X-API-KEY", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"source\": {\n \"name\": \"<string>\",\n \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"redshift\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"cluster\": \"<string>\",\n \"region\": \"<string>\",\n \"workgroup\": \"<string>\",\n \"username\": \"<string>\",\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"redshift_serverless\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"workgroup\": \"<string>\",\n \"region\": \"<string>\",\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"bigquery\": {\n \"project_id\": \"<string>\",\n \"region\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"jsmith@example.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"s3\": {\n \"bucket_name\": \"<string>\",\n \"region\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_host\": \"<string>\",\n \"use_ssh_tunnel\": true\n },\n \"abs\": {\n \"bucket_name\": \"<string>\",\n \"storage_account_name\": \"<string>\",\n \"auth_method\": \"azure_service_shared_access_signature\",\n \"azure_service_shared_access_signature\": {\n \"shared_access_signature_token\": \"<string>\"\n }\n },\n \"sftp\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"gcs\": {\n \"bucket_name\": \"<string>\",\n \"region\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"jsmith@example.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"s3_compatible\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"bucket_name\": \"<string>\",\n \"auth_method\": \"access_keys\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"disable_ssl\": true,\n \"use_ssh_tunnel\": true\n },\n \"snowflake\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"username\": \"<string>\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"delta_sharing\": {\n \"host\": \"<string>\",\n \"port\": 123\n }\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.prequel.co/import/sources/{id}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
request["X-API-KEY"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"source\": {\n \"name\": \"<string>\",\n \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"redshift\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"cluster\": \"<string>\",\n \"region\": \"<string>\",\n \"workgroup\": \"<string>\",\n \"username\": \"<string>\",\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"redshift_serverless\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"workgroup\": \"<string>\",\n \"region\": \"<string>\",\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"bigquery\": {\n \"project_id\": \"<string>\",\n \"region\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"jsmith@example.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"s3\": {\n \"bucket_name\": \"<string>\",\n \"region\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_host\": \"<string>\",\n \"use_ssh_tunnel\": true\n },\n \"abs\": {\n \"bucket_name\": \"<string>\",\n \"storage_account_name\": \"<string>\",\n \"auth_method\": \"azure_service_shared_access_signature\",\n \"azure_service_shared_access_signature\": {\n \"shared_access_signature_token\": \"<string>\"\n }\n },\n \"sftp\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"gcs\": {\n \"bucket_name\": \"<string>\",\n \"region\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"jsmith@example.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"s3_compatible\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"bucket_name\": \"<string>\",\n \"auth_method\": \"access_keys\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"disable_ssl\": true,\n \"use_ssh_tunnel\": true\n },\n \"snowflake\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"username\": \"<string>\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"delta_sharing\": {\n \"host\": \"<string>\",\n \"port\": 123\n }\n }\n}"
response = http.request(request)
puts response.read_body{
"status": "<string>",
"data": {
"source": {
"vendor": "<unknown>",
"postgres": {
"is_valid": true,
"host": "<string>",
"port": 123,
"database": "<string>",
"username": "<string>",
"auth_method": "<string>",
"use_ssh_tunnel": true,
"disable_ssl": true,
"connection_timeout_in_seconds": 123,
"ssh_tunnel": {
"ssh_tunnel_host": "<string>",
"ssh_tunnel_port": 123,
"ssh_tunnel_username": "<string>",
"ssh_public_key": "<string>"
}
},
"id": "<string>",
"provider_id": "<string>",
"name": "<string>",
"created_at": "<string>",
"updated_at": "<string>"
}
},
"message": "<string>"
}{
"status": "<string>",
"message": "<string>",
"data": null
}{
"status": "<string>",
"message": "<string>",
"data": null
}{
"status": "<string>",
"message": "<string>",
"data": null
}{
"status": "<string>",
"message": "<string>",
"data": null
}⌘I