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
}
}
}
'{
"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>"
}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
}
}
}
'{
"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>"
}⌘I