DescribeEndpoints delphiDll Example
var
rest: HCkRest;
success: Boolean;
authAws: HCkAuthAws;
json: HCkJsonObject;
sbRequestBody: HCkStringBuilder;
sbResponseBody: HCkStringBuilder;
respStatusCode: Integer;
jResp: HCkJsonObject;
CertificateArn: PWideChar;
DatabaseName: PWideChar;
BucketName: PWideChar;
ServiceAccessRoleArn: PWideChar;
DocDbSettingsDatabaseName: PWideChar;
DocsToInvestigate: Integer;
ExtractDocId: Integer;
KmsKeyId: PWideChar;
NestingLevel: PWideChar;
Password: PWideChar;
Port: Integer;
SecretsManagerAccessRoleArn: PWideChar;
SecretsManagerSecretId: PWideChar;
ServerName: PWideChar;
Username: PWideChar;
DynamoDbSettingsServiceAccessRoleArn: PWideChar;
EndpointUri: PWideChar;
ErrorRetryDuration: Integer;
FullLoadErrorPercentage: Integer;
ElasticsearchSettingsServiceAccessRoleArn: PWideChar;
EndpointArn: PWideChar;
EndpointIdentifier: PWideChar;
EndpointType: PWideChar;
EngineDisplayName: PWideChar;
EngineName: PWideChar;
ExternalId: PWideChar;
ExternalTableDefinition: PWideChar;
ExtraConnectionAttributes: PWideChar;
AfterConnectScript: PWideChar;
CleanSourceMetadataOnMismatch: Integer;
GcpMySQLSettingsDatabaseName: PWideChar;
EventsPollInterval: Integer;
MaxFileSize: Integer;
ParallelLoadThreads: Integer;
GcpMySQLSettingsPassword: PWideChar;
GcpMySQLSettingsPort: Integer;
GcpMySQLSettingsSecretsManagerAccessRoleArn: PWideChar;
GcpMySQLSettingsSecretsManagerSecretId: PWideChar;
GcpMySQLSettingsServerName: PWideChar;
ServerTimezone: PWideChar;
TargetDbType: PWideChar;
GcpMySQLSettingsUsername: PWideChar;
CurrentLsn: PWideChar;
IBMDb2SettingsDatabaseName: PWideChar;
MaxKBytesPerRead: Integer;
IBMDb2SettingsPassword: PWideChar;
IBMDb2SettingsPort: Integer;
IBMDb2SettingsSecretsManagerAccessRoleArn: PWideChar;
IBMDb2SettingsSecretsManagerSecretId: PWideChar;
IBMDb2SettingsServerName: PWideChar;
SetDataCaptureChanges: Integer;
IBMDb2SettingsUsername: PWideChar;
Broker: PWideChar;
IncludeControlDetails: Integer;
IncludeNullAndEmpty: Integer;
IncludePartitionValue: Integer;
IncludeTableAlterOperations: Integer;
IncludeTransactionDetails: Integer;
MessageFormat: PWideChar;
MessageMaxBytes: Integer;
NoHexPrefix: Integer;
PartitionIncludeSchemaTable: Integer;
SaslPassword: PWideChar;
SaslUsername: PWideChar;
SecurityProtocol: PWideChar;
SslCaCertificateArn: PWideChar;
SslClientCertificateArn: PWideChar;
SslClientKeyArn: PWideChar;
SslClientKeyPassword: PWideChar;
Topic: PWideChar;
KinesisSettingsIncludeControlDetails: Integer;
KinesisSettingsIncludeNullAndEmpty: Integer;
KinesisSettingsIncludePartitionValue: Integer;
KinesisSettingsIncludeTableAlterOperations: Integer;
KinesisSettingsIncludeTransactionDetails: Integer;
KinesisSettingsMessageFormat: PWideChar;
KinesisSettingsNoHexPrefix: Integer;
KinesisSettingsPartitionIncludeSchemaTable: Integer;
KinesisSettingsServiceAccessRoleArn: PWideChar;
StreamArn: PWideChar;
BcpPacketSize: Integer;
ControlTablesFileGroup: PWideChar;
MicrosoftSQLServerSettingsDatabaseName: PWideChar;
MicrosoftSQLServerSettingsPassword: PWideChar;
MicrosoftSQLServerSettingsPort: Integer;
QuerySingleAlwaysOnNode: Integer;
ReadBackupOnly: Integer;
SafeguardPolicy: PWideChar;
MicrosoftSQLServerSettingsSecretsManagerAccessRoleArn: PWideChar;
MicrosoftSQLServerSettingsSecretsManagerSecretId: PWideChar;
MicrosoftSQLServerSettingsServerName: PWideChar;
UseBcpFullLoad: Integer;
MicrosoftSQLServerSettingsUsername: PWideChar;
UseThirdPartyBackupDevice: Integer;
AuthMechanism: PWideChar;
AuthSource: PWideChar;
AuthType: PWideChar;
MongoDbSettingsDatabaseName: PWideChar;
MongoDbSettingsDocsToInvestigate: PWideChar;
MongoDbSettingsExtractDocId: PWideChar;
MongoDbSettingsKmsKeyId: PWideChar;
MongoDbSettingsNestingLevel: PWideChar;
MongoDbSettingsPassword: PWideChar;
MongoDbSettingsPort: Integer;
MongoDbSettingsSecretsManagerAccessRoleArn: PWideChar;
MongoDbSettingsSecretsManagerSecretId: PWideChar;
MongoDbSettingsServerName: PWideChar;
MongoDbSettingsUsername: PWideChar;
MySQLSettingsAfterConnectScript: PWideChar;
MySQLSettingsCleanSourceMetadataOnMismatch: Integer;
MySQLSettingsDatabaseName: PWideChar;
MySQLSettingsEventsPollInterval: Integer;
MySQLSettingsMaxFileSize: Integer;
MySQLSettingsParallelLoadThreads: Integer;
MySQLSettingsPassword: PWideChar;
MySQLSettingsPort: Integer;
MySQLSettingsSecretsManagerAccessRoleArn: PWideChar;
MySQLSettingsSecretsManagerSecretId: PWideChar;
MySQLSettingsServerName: PWideChar;
MySQLSettingsServerTimezone: PWideChar;
MySQLSettingsTargetDbType: PWideChar;
MySQLSettingsUsername: PWideChar;
NeptuneSettingsErrorRetryDuration: Integer;
IamAuthEnabled: Integer;
NeptuneSettingsMaxFileSize: Integer;
MaxRetryCount: Integer;
S3BucketFolder: PWideChar;
S3BucketName: PWideChar;
NeptuneSettingsServiceAccessRoleArn: PWideChar;
AccessAlternateDirectly: Integer;
AdditionalArchivedLogDestId: Integer;
AddSupplementalLogging: Integer;
AllowSelectNestedTables: Integer;
ArchivedLogDestId: Integer;
ArchivedLogsOnly: Integer;
AsmPassword: PWideChar;
AsmServer: PWideChar;
AsmUser: PWideChar;
CharLengthSemantics: PWideChar;
OracleSettingsDatabaseName: PWideChar;
DirectPathNoLog: Integer;
DirectPathParallelLoad: Integer;
EnableHomogenousTablespace: Integer;
FailTasksOnLobTruncation: Integer;
NumberDatatypeScale: Integer;
OraclePathPrefix: PWideChar;
ParallelAsmReadThreads: Integer;
OracleSettingsPassword: PWideChar;
OracleSettingsPort: Integer;
ReadAheadBlocks: Integer;
ReadTableSpaceName: Integer;
ReplacePathPrefix: Integer;
RetryInterval: Integer;
OracleSettingsSecretsManagerAccessRoleArn: PWideChar;
SecretsManagerOracleAsmAccessRoleArn: PWideChar;
SecretsManagerOracleAsmSecretId: PWideChar;
OracleSettingsSecretsManagerSecretId: PWideChar;
SecurityDbEncryption: PWideChar;
SecurityDbEncryptionName: PWideChar;
OracleSettingsServerName: PWideChar;
SpatialDataOptionToGeoJsonFunctionName: PWideChar;
StandbyDelayTime: Integer;
UseAlternateFolderForOnline: Integer;
UseBFile: Integer;
UseDirectPathFullLoad: Integer;
UseLogminerReader: Integer;
UsePathPrefix: PWideChar;
OracleSettingsUsername: PWideChar;
PostgreSQLSettingsAfterConnectScript: PWideChar;
CaptureDdls: Integer;
PostgreSQLSettingsDatabaseName: PWideChar;
DdlArtifactsSchema: PWideChar;
ExecuteTimeout: Integer;
PostgreSQLSettingsFailTasksOnLobTruncation: Integer;
HeartbeatEnable: Integer;
HeartbeatFrequency: Integer;
HeartbeatSchema: PWideChar;
PostgreSQLSettingsMaxFileSize: Integer;
PostgreSQLSettingsPassword: PWideChar;
PluginName: PWideChar;
PostgreSQLSettingsPort: Integer;
PostgreSQLSettingsSecretsManagerAccessRoleArn: PWideChar;
PostgreSQLSettingsSecretsManagerSecretId: PWideChar;
PostgreSQLSettingsServerName: PWideChar;
SlotName: PWideChar;
PostgreSQLSettingsUsername: PWideChar;
AuthPassword: PWideChar;
RedisSettingsAuthType: PWideChar;
AuthUserName: PWideChar;
RedisSettingsPort: Integer;
RedisSettingsServerName: PWideChar;
RedisSettingsSslCaCertificateArn: PWideChar;
SslSecurityProtocol: PWideChar;
AcceptAnyDate: Integer;
RedshiftSettingsAfterConnectScript: PWideChar;
BucketFolder: PWideChar;
RedshiftSettingsBucketName: PWideChar;
CaseSensitiveNames: Integer;
CompUpdate: Integer;
ConnectionTimeout: Integer;
RedshiftSettingsDatabaseName: PWideChar;
DateFormat: PWideChar;
EmptyAsNull: Integer;
EncryptionMode: PWideChar;
ExplicitIds: Integer;
FileTransferUploadStreams: Integer;
LoadTimeout: Integer;
RedshiftSettingsMaxFileSize: Integer;
RedshiftSettingsPassword: PWideChar;
RedshiftSettingsPort: Integer;
RemoveQuotes: Integer;
ReplaceChars: PWideChar;
ReplaceInvalidChars: PWideChar;
RedshiftSettingsSecretsManagerAccessRoleArn: PWideChar;
RedshiftSettingsSecretsManagerSecretId: PWideChar;
RedshiftSettingsServerName: PWideChar;
ServerSideEncryptionKmsKeyId: PWideChar;
RedshiftSettingsServiceAccessRoleArn: PWideChar;
TimeFormat: PWideChar;
TrimBlanks: Integer;
TruncateColumns: Integer;
RedshiftSettingsUsername: PWideChar;
WriteBufferSize: Integer;
AddColumnName: Integer;
S3SettingsBucketFolder: PWideChar;
S3SettingsBucketName: PWideChar;
CannedAclForObjects: PWideChar;
CdcInsertsAndUpdates: Integer;
CdcInsertsOnly: Integer;
CdcMaxBatchInterval: Integer;
CdcMinFileSize: Integer;
CdcPath: PWideChar;
CompressionType: PWideChar;
CsvDelimiter: PWideChar;
CsvNoSupValue: PWideChar;
CsvNullValue: PWideChar;
CsvRowDelimiter: PWideChar;
DataFormat: PWideChar;
DataPageSize: Integer;
DatePartitionDelimiter: PWideChar;
DatePartitionEnabled: Integer;
DatePartitionSequence: PWideChar;
DatePartitionTimezone: PWideChar;
DictPageSizeLimit: Integer;
EnableStatistics: Integer;
EncodingType: PWideChar;
S3SettingsEncryptionMode: PWideChar;
S3SettingsExternalTableDefinition: PWideChar;
IgnoreHeaderRows: Integer;
IncludeOpForFullLoad: Integer;
S3SettingsMaxFileSize: Integer;
ParquetTimestampInMillisecond: Integer;
ParquetVersion: PWideChar;
PreserveTransactions: Integer;
Rfc4180: Integer;
RowGroupLength: Integer;
S3SettingsServerSideEncryptionKmsKeyId: PWideChar;
S3SettingsServiceAccessRoleArn: PWideChar;
TimestampColumnName: PWideChar;
UseCsvNoSupValue: Integer;
UseTaskStartTimeForFullLoadTimestamp: Integer;
SslMode: PWideChar;
Status: PWideChar;
SybaseSettingsDatabaseName: PWideChar;
SybaseSettingsPassword: PWideChar;
SybaseSettingsPort: Integer;
SybaseSettingsSecretsManagerAccessRoleArn: PWideChar;
SybaseSettingsSecretsManagerSecretId: PWideChar;
SybaseSettingsServerName: PWideChar;
SybaseSettingsUsername: PWideChar;
j: Integer;
count_j: Integer;
intVal: Integer;
Marker: PWideChar;
i: Integer;
count_i: Integer;
begin
// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
rest := CkRest_Create();
authAws := CkAuthAws_Create();
CkAuthAws_putAccessKey(authAws,'AWS_ACCESS_KEY');
CkAuthAws_putSecretKey(authAws,'AWS_SECRET_KEY');
// Don't forget to change the region to your particular region. (Also make the same change in the call to Connect below.)
CkAuthAws_putRegion(authAws,'us-west-2');
CkAuthAws_putServiceName(authAws,'dms');
// SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
CkRest_SetAuthAws(rest,authAws);
// URL: https://dms.us-west-2.amazonaws.com/
// Use the same region as specified above.
success := CkRest_Connect(rest,'dms.us-west-2.amazonaws.com',443,True,True);
if (success <> True) then
begin
Memo1.Lines.Add('ConnectFailReason: ' + IntToStr(CkRest_getConnectFailReason(rest)));
Memo1.Lines.Add(CkRest__lastErrorText(rest));
Exit;
end;
// The following code creates the JSON request body.
// The JSON created by this code is shown below.
// Use this online tool to generate code from sample JSON:
// Generate Code to Create JSON
json := CkJsonObject_Create();
CkJsonObject_UpdateString(json,'Filters[0].Name','string');
CkJsonObject_UpdateString(json,'Filters[0].Values[0]','string');
CkJsonObject_UpdateString(json,'Marker','string');
CkJsonObject_UpdateInt(json,'MaxRecords',123);
// The JSON request body created by the above code:
// {
// "Filters": [
// {
// "Name": "string",
// "Values": [
// "string"
// ]
// }
// ],
// "Marker": "string",
// "MaxRecords": number
// }
CkRest_AddHeader(rest,'Content-Type','application/x-amz-json-1.1');
CkRest_AddHeader(rest,'X-Amz-Target','AmazonDMSv20160101.DescribeEndpoints');
sbRequestBody := CkStringBuilder_Create();
CkJsonObject_EmitSb(json,sbRequestBody);
sbResponseBody := CkStringBuilder_Create();
success := CkRest_FullRequestSb(rest,'POST','/',sbRequestBody,sbResponseBody);
if (success <> True) then
begin
Memo1.Lines.Add(CkRest__lastErrorText(rest));
Exit;
end;
respStatusCode := CkRest_getResponseStatusCode(rest);
Memo1.Lines.Add('response status code = ' + IntToStr(respStatusCode));
if (respStatusCode <> 200) then
begin
Memo1.Lines.Add('Response Header:');
Memo1.Lines.Add(CkRest__responseHeader(rest));
Memo1.Lines.Add('Response Body:');
Memo1.Lines.Add(CkStringBuilder__getAsString(sbResponseBody));
Exit;
end;
jResp := CkJsonObject_Create();
CkJsonObject_LoadSb(jResp,sbResponseBody);
// The following code parses the JSON response.
// A sample JSON response is shown below the sample code.
// Use this online tool to generate parsing code from sample JSON:
// Generate Parsing Code from JSON
Marker := CkJsonObject__stringOf(jResp,'Marker');
i := 0;
count_i := CkJsonObject_SizeOfArray(jResp,'Endpoints');
while i < count_i do
begin
CkJsonObject_putI(jResp,i);
CertificateArn := CkJsonObject__stringOf(jResp,'Endpoints[i].CertificateArn');
DatabaseName := CkJsonObject__stringOf(jResp,'Endpoints[i].DatabaseName');
BucketName := CkJsonObject__stringOf(jResp,'Endpoints[i].DmsTransferSettings.BucketName');
ServiceAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].DmsTransferSettings.ServiceAccessRoleArn');
DocDbSettingsDatabaseName := CkJsonObject__stringOf(jResp,'Endpoints[i].DocDbSettings.DatabaseName');
DocsToInvestigate := CkJsonObject_IntOf(jResp,'Endpoints[i].DocDbSettings.DocsToInvestigate');
ExtractDocId := CkJsonObject_IntOf(jResp,'Endpoints[i].DocDbSettings.ExtractDocId');
KmsKeyId := CkJsonObject__stringOf(jResp,'Endpoints[i].DocDbSettings.KmsKeyId');
NestingLevel := CkJsonObject__stringOf(jResp,'Endpoints[i].DocDbSettings.NestingLevel');
Password := CkJsonObject__stringOf(jResp,'Endpoints[i].DocDbSettings.Password');
Port := CkJsonObject_IntOf(jResp,'Endpoints[i].DocDbSettings.Port');
SecretsManagerAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].DocDbSettings.SecretsManagerAccessRoleArn');
SecretsManagerSecretId := CkJsonObject__stringOf(jResp,'Endpoints[i].DocDbSettings.SecretsManagerSecretId');
ServerName := CkJsonObject__stringOf(jResp,'Endpoints[i].DocDbSettings.ServerName');
Username := CkJsonObject__stringOf(jResp,'Endpoints[i].DocDbSettings.Username');
DynamoDbSettingsServiceAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].DynamoDbSettings.ServiceAccessRoleArn');
EndpointUri := CkJsonObject__stringOf(jResp,'Endpoints[i].ElasticsearchSettings.EndpointUri');
ErrorRetryDuration := CkJsonObject_IntOf(jResp,'Endpoints[i].ElasticsearchSettings.ErrorRetryDuration');
FullLoadErrorPercentage := CkJsonObject_IntOf(jResp,'Endpoints[i].ElasticsearchSettings.FullLoadErrorPercentage');
ElasticsearchSettingsServiceAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].ElasticsearchSettings.ServiceAccessRoleArn');
EndpointArn := CkJsonObject__stringOf(jResp,'Endpoints[i].EndpointArn');
EndpointIdentifier := CkJsonObject__stringOf(jResp,'Endpoints[i].EndpointIdentifier');
EndpointType := CkJsonObject__stringOf(jResp,'Endpoints[i].EndpointType');
EngineDisplayName := CkJsonObject__stringOf(jResp,'Endpoints[i].EngineDisplayName');
EngineName := CkJsonObject__stringOf(jResp,'Endpoints[i].EngineName');
ExternalId := CkJsonObject__stringOf(jResp,'Endpoints[i].ExternalId');
ExternalTableDefinition := CkJsonObject__stringOf(jResp,'Endpoints[i].ExternalTableDefinition');
ExtraConnectionAttributes := CkJsonObject__stringOf(jResp,'Endpoints[i].ExtraConnectionAttributes');
AfterConnectScript := CkJsonObject__stringOf(jResp,'Endpoints[i].GcpMySQLSettings.AfterConnectScript');
CleanSourceMetadataOnMismatch := CkJsonObject_IntOf(jResp,'Endpoints[i].GcpMySQLSettings.CleanSourceMetadataOnMismatch');
GcpMySQLSettingsDatabaseName := CkJsonObject__stringOf(jResp,'Endpoints[i].GcpMySQLSettings.DatabaseName');
EventsPollInterval := CkJsonObject_IntOf(jResp,'Endpoints[i].GcpMySQLSettings.EventsPollInterval');
MaxFileSize := CkJsonObject_IntOf(jResp,'Endpoints[i].GcpMySQLSettings.MaxFileSize');
ParallelLoadThreads := CkJsonObject_IntOf(jResp,'Endpoints[i].GcpMySQLSettings.ParallelLoadThreads');
GcpMySQLSettingsPassword := CkJsonObject__stringOf(jResp,'Endpoints[i].GcpMySQLSettings.Password');
GcpMySQLSettingsPort := CkJsonObject_IntOf(jResp,'Endpoints[i].GcpMySQLSettings.Port');
GcpMySQLSettingsSecretsManagerAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].GcpMySQLSettings.SecretsManagerAccessRoleArn');
GcpMySQLSettingsSecretsManagerSecretId := CkJsonObject__stringOf(jResp,'Endpoints[i].GcpMySQLSettings.SecretsManagerSecretId');
GcpMySQLSettingsServerName := CkJsonObject__stringOf(jResp,'Endpoints[i].GcpMySQLSettings.ServerName');
ServerTimezone := CkJsonObject__stringOf(jResp,'Endpoints[i].GcpMySQLSettings.ServerTimezone');
TargetDbType := CkJsonObject__stringOf(jResp,'Endpoints[i].GcpMySQLSettings.TargetDbType');
GcpMySQLSettingsUsername := CkJsonObject__stringOf(jResp,'Endpoints[i].GcpMySQLSettings.Username');
CurrentLsn := CkJsonObject__stringOf(jResp,'Endpoints[i].IBMDb2Settings.CurrentLsn');
IBMDb2SettingsDatabaseName := CkJsonObject__stringOf(jResp,'Endpoints[i].IBMDb2Settings.DatabaseName');
MaxKBytesPerRead := CkJsonObject_IntOf(jResp,'Endpoints[i].IBMDb2Settings.MaxKBytesPerRead');
IBMDb2SettingsPassword := CkJsonObject__stringOf(jResp,'Endpoints[i].IBMDb2Settings.Password');
IBMDb2SettingsPort := CkJsonObject_IntOf(jResp,'Endpoints[i].IBMDb2Settings.Port');
IBMDb2SettingsSecretsManagerAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].IBMDb2Settings.SecretsManagerAccessRoleArn');
IBMDb2SettingsSecretsManagerSecretId := CkJsonObject__stringOf(jResp,'Endpoints[i].IBMDb2Settings.SecretsManagerSecretId');
IBMDb2SettingsServerName := CkJsonObject__stringOf(jResp,'Endpoints[i].IBMDb2Settings.ServerName');
SetDataCaptureChanges := CkJsonObject_IntOf(jResp,'Endpoints[i].IBMDb2Settings.SetDataCaptureChanges');
IBMDb2SettingsUsername := CkJsonObject__stringOf(jResp,'Endpoints[i].IBMDb2Settings.Username');
Broker := CkJsonObject__stringOf(jResp,'Endpoints[i].KafkaSettings.Broker');
IncludeControlDetails := CkJsonObject_IntOf(jResp,'Endpoints[i].KafkaSettings.IncludeControlDetails');
IncludeNullAndEmpty := CkJsonObject_IntOf(jResp,'Endpoints[i].KafkaSettings.IncludeNullAndEmpty');
IncludePartitionValue := CkJsonObject_IntOf(jResp,'Endpoints[i].KafkaSettings.IncludePartitionValue');
IncludeTableAlterOperations := CkJsonObject_IntOf(jResp,'Endpoints[i].KafkaSettings.IncludeTableAlterOperations');
IncludeTransactionDetails := CkJsonObject_IntOf(jResp,'Endpoints[i].KafkaSettings.IncludeTransactionDetails');
MessageFormat := CkJsonObject__stringOf(jResp,'Endpoints[i].KafkaSettings.MessageFormat');
MessageMaxBytes := CkJsonObject_IntOf(jResp,'Endpoints[i].KafkaSettings.MessageMaxBytes');
NoHexPrefix := CkJsonObject_IntOf(jResp,'Endpoints[i].KafkaSettings.NoHexPrefix');
PartitionIncludeSchemaTable := CkJsonObject_IntOf(jResp,'Endpoints[i].KafkaSettings.PartitionIncludeSchemaTable');
SaslPassword := CkJsonObject__stringOf(jResp,'Endpoints[i].KafkaSettings.SaslPassword');
SaslUsername := CkJsonObject__stringOf(jResp,'Endpoints[i].KafkaSettings.SaslUsername');
SecurityProtocol := CkJsonObject__stringOf(jResp,'Endpoints[i].KafkaSettings.SecurityProtocol');
SslCaCertificateArn := CkJsonObject__stringOf(jResp,'Endpoints[i].KafkaSettings.SslCaCertificateArn');
SslClientCertificateArn := CkJsonObject__stringOf(jResp,'Endpoints[i].KafkaSettings.SslClientCertificateArn');
SslClientKeyArn := CkJsonObject__stringOf(jResp,'Endpoints[i].KafkaSettings.SslClientKeyArn');
SslClientKeyPassword := CkJsonObject__stringOf(jResp,'Endpoints[i].KafkaSettings.SslClientKeyPassword');
Topic := CkJsonObject__stringOf(jResp,'Endpoints[i].KafkaSettings.Topic');
KinesisSettingsIncludeControlDetails := CkJsonObject_IntOf(jResp,'Endpoints[i].KinesisSettings.IncludeControlDetails');
KinesisSettingsIncludeNullAndEmpty := CkJsonObject_IntOf(jResp,'Endpoints[i].KinesisSettings.IncludeNullAndEmpty');
KinesisSettingsIncludePartitionValue := CkJsonObject_IntOf(jResp,'Endpoints[i].KinesisSettings.IncludePartitionValue');
KinesisSettingsIncludeTableAlterOperations := CkJsonObject_IntOf(jResp,'Endpoints[i].KinesisSettings.IncludeTableAlterOperations');
KinesisSettingsIncludeTransactionDetails := CkJsonObject_IntOf(jResp,'Endpoints[i].KinesisSettings.IncludeTransactionDetails');
KinesisSettingsMessageFormat := CkJsonObject__stringOf(jResp,'Endpoints[i].KinesisSettings.MessageFormat');
KinesisSettingsNoHexPrefix := CkJsonObject_IntOf(jResp,'Endpoints[i].KinesisSettings.NoHexPrefix');
KinesisSettingsPartitionIncludeSchemaTable := CkJsonObject_IntOf(jResp,'Endpoints[i].KinesisSettings.PartitionIncludeSchemaTable');
KinesisSettingsServiceAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].KinesisSettings.ServiceAccessRoleArn');
StreamArn := CkJsonObject__stringOf(jResp,'Endpoints[i].KinesisSettings.StreamArn');
KmsKeyId := CkJsonObject__stringOf(jResp,'Endpoints[i].KmsKeyId');
BcpPacketSize := CkJsonObject_IntOf(jResp,'Endpoints[i].MicrosoftSQLServerSettings.BcpPacketSize');
ControlTablesFileGroup := CkJsonObject__stringOf(jResp,'Endpoints[i].MicrosoftSQLServerSettings.ControlTablesFileGroup');
MicrosoftSQLServerSettingsDatabaseName := CkJsonObject__stringOf(jResp,'Endpoints[i].MicrosoftSQLServerSettings.DatabaseName');
MicrosoftSQLServerSettingsPassword := CkJsonObject__stringOf(jResp,'Endpoints[i].MicrosoftSQLServerSettings.Password');
MicrosoftSQLServerSettingsPort := CkJsonObject_IntOf(jResp,'Endpoints[i].MicrosoftSQLServerSettings.Port');
QuerySingleAlwaysOnNode := CkJsonObject_IntOf(jResp,'Endpoints[i].MicrosoftSQLServerSettings.QuerySingleAlwaysOnNode');
ReadBackupOnly := CkJsonObject_IntOf(jResp,'Endpoints[i].MicrosoftSQLServerSettings.ReadBackupOnly');
SafeguardPolicy := CkJsonObject__stringOf(jResp,'Endpoints[i].MicrosoftSQLServerSettings.SafeguardPolicy');
MicrosoftSQLServerSettingsSecretsManagerAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].MicrosoftSQLServerSettings.SecretsManagerAccessRoleArn');
MicrosoftSQLServerSettingsSecretsManagerSecretId := CkJsonObject__stringOf(jResp,'Endpoints[i].MicrosoftSQLServerSettings.SecretsManagerSecretId');
MicrosoftSQLServerSettingsServerName := CkJsonObject__stringOf(jResp,'Endpoints[i].MicrosoftSQLServerSettings.ServerName');
UseBcpFullLoad := CkJsonObject_IntOf(jResp,'Endpoints[i].MicrosoftSQLServerSettings.UseBcpFullLoad');
MicrosoftSQLServerSettingsUsername := CkJsonObject__stringOf(jResp,'Endpoints[i].MicrosoftSQLServerSettings.Username');
UseThirdPartyBackupDevice := CkJsonObject_IntOf(jResp,'Endpoints[i].MicrosoftSQLServerSettings.UseThirdPartyBackupDevice');
AuthMechanism := CkJsonObject__stringOf(jResp,'Endpoints[i].MongoDbSettings.AuthMechanism');
AuthSource := CkJsonObject__stringOf(jResp,'Endpoints[i].MongoDbSettings.AuthSource');
AuthType := CkJsonObject__stringOf(jResp,'Endpoints[i].MongoDbSettings.AuthType');
MongoDbSettingsDatabaseName := CkJsonObject__stringOf(jResp,'Endpoints[i].MongoDbSettings.DatabaseName');
MongoDbSettingsDocsToInvestigate := CkJsonObject__stringOf(jResp,'Endpoints[i].MongoDbSettings.DocsToInvestigate');
MongoDbSettingsExtractDocId := CkJsonObject__stringOf(jResp,'Endpoints[i].MongoDbSettings.ExtractDocId');
MongoDbSettingsKmsKeyId := CkJsonObject__stringOf(jResp,'Endpoints[i].MongoDbSettings.KmsKeyId');
MongoDbSettingsNestingLevel := CkJsonObject__stringOf(jResp,'Endpoints[i].MongoDbSettings.NestingLevel');
MongoDbSettingsPassword := CkJsonObject__stringOf(jResp,'Endpoints[i].MongoDbSettings.Password');
MongoDbSettingsPort := CkJsonObject_IntOf(jResp,'Endpoints[i].MongoDbSettings.Port');
MongoDbSettingsSecretsManagerAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].MongoDbSettings.SecretsManagerAccessRoleArn');
MongoDbSettingsSecretsManagerSecretId := CkJsonObject__stringOf(jResp,'Endpoints[i].MongoDbSettings.SecretsManagerSecretId');
MongoDbSettingsServerName := CkJsonObject__stringOf(jResp,'Endpoints[i].MongoDbSettings.ServerName');
MongoDbSettingsUsername := CkJsonObject__stringOf(jResp,'Endpoints[i].MongoDbSettings.Username');
MySQLSettingsAfterConnectScript := CkJsonObject__stringOf(jResp,'Endpoints[i].MySQLSettings.AfterConnectScript');
MySQLSettingsCleanSourceMetadataOnMismatch := CkJsonObject_IntOf(jResp,'Endpoints[i].MySQLSettings.CleanSourceMetadataOnMismatch');
MySQLSettingsDatabaseName := CkJsonObject__stringOf(jResp,'Endpoints[i].MySQLSettings.DatabaseName');
MySQLSettingsEventsPollInterval := CkJsonObject_IntOf(jResp,'Endpoints[i].MySQLSettings.EventsPollInterval');
MySQLSettingsMaxFileSize := CkJsonObject_IntOf(jResp,'Endpoints[i].MySQLSettings.MaxFileSize');
MySQLSettingsParallelLoadThreads := CkJsonObject_IntOf(jResp,'Endpoints[i].MySQLSettings.ParallelLoadThreads');
MySQLSettingsPassword := CkJsonObject__stringOf(jResp,'Endpoints[i].MySQLSettings.Password');
MySQLSettingsPort := CkJsonObject_IntOf(jResp,'Endpoints[i].MySQLSettings.Port');
MySQLSettingsSecretsManagerAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].MySQLSettings.SecretsManagerAccessRoleArn');
MySQLSettingsSecretsManagerSecretId := CkJsonObject__stringOf(jResp,'Endpoints[i].MySQLSettings.SecretsManagerSecretId');
MySQLSettingsServerName := CkJsonObject__stringOf(jResp,'Endpoints[i].MySQLSettings.ServerName');
MySQLSettingsServerTimezone := CkJsonObject__stringOf(jResp,'Endpoints[i].MySQLSettings.ServerTimezone');
MySQLSettingsTargetDbType := CkJsonObject__stringOf(jResp,'Endpoints[i].MySQLSettings.TargetDbType');
MySQLSettingsUsername := CkJsonObject__stringOf(jResp,'Endpoints[i].MySQLSettings.Username');
NeptuneSettingsErrorRetryDuration := CkJsonObject_IntOf(jResp,'Endpoints[i].NeptuneSettings.ErrorRetryDuration');
IamAuthEnabled := CkJsonObject_IntOf(jResp,'Endpoints[i].NeptuneSettings.IamAuthEnabled');
NeptuneSettingsMaxFileSize := CkJsonObject_IntOf(jResp,'Endpoints[i].NeptuneSettings.MaxFileSize');
MaxRetryCount := CkJsonObject_IntOf(jResp,'Endpoints[i].NeptuneSettings.MaxRetryCount');
S3BucketFolder := CkJsonObject__stringOf(jResp,'Endpoints[i].NeptuneSettings.S3BucketFolder');
S3BucketName := CkJsonObject__stringOf(jResp,'Endpoints[i].NeptuneSettings.S3BucketName');
NeptuneSettingsServiceAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].NeptuneSettings.ServiceAccessRoleArn');
AccessAlternateDirectly := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.AccessAlternateDirectly');
AdditionalArchivedLogDestId := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.AdditionalArchivedLogDestId');
AddSupplementalLogging := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.AddSupplementalLogging');
AllowSelectNestedTables := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.AllowSelectNestedTables');
ArchivedLogDestId := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.ArchivedLogDestId');
ArchivedLogsOnly := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.ArchivedLogsOnly');
AsmPassword := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.AsmPassword');
AsmServer := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.AsmServer');
AsmUser := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.AsmUser');
CharLengthSemantics := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.CharLengthSemantics');
OracleSettingsDatabaseName := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.DatabaseName');
DirectPathNoLog := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.DirectPathNoLog');
DirectPathParallelLoad := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.DirectPathParallelLoad');
EnableHomogenousTablespace := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.EnableHomogenousTablespace');
FailTasksOnLobTruncation := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.FailTasksOnLobTruncation');
NumberDatatypeScale := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.NumberDatatypeScale');
OraclePathPrefix := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.OraclePathPrefix');
ParallelAsmReadThreads := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.ParallelAsmReadThreads');
OracleSettingsPassword := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.Password');
OracleSettingsPort := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.Port');
ReadAheadBlocks := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.ReadAheadBlocks');
ReadTableSpaceName := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.ReadTableSpaceName');
ReplacePathPrefix := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.ReplacePathPrefix');
RetryInterval := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.RetryInterval');
OracleSettingsSecretsManagerAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.SecretsManagerAccessRoleArn');
SecretsManagerOracleAsmAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.SecretsManagerOracleAsmAccessRoleArn');
SecretsManagerOracleAsmSecretId := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.SecretsManagerOracleAsmSecretId');
OracleSettingsSecretsManagerSecretId := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.SecretsManagerSecretId');
SecurityDbEncryption := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.SecurityDbEncryption');
SecurityDbEncryptionName := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.SecurityDbEncryptionName');
OracleSettingsServerName := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.ServerName');
SpatialDataOptionToGeoJsonFunctionName := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.SpatialDataOptionToGeoJsonFunctionName');
StandbyDelayTime := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.StandbyDelayTime');
UseAlternateFolderForOnline := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.UseAlternateFolderForOnline');
UseBFile := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.UseBFile');
UseDirectPathFullLoad := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.UseDirectPathFullLoad');
UseLogminerReader := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.UseLogminerReader');
UsePathPrefix := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.UsePathPrefix');
OracleSettingsUsername := CkJsonObject__stringOf(jResp,'Endpoints[i].OracleSettings.Username');
Port := CkJsonObject_IntOf(jResp,'Endpoints[i].Port');
PostgreSQLSettingsAfterConnectScript := CkJsonObject__stringOf(jResp,'Endpoints[i].PostgreSQLSettings.AfterConnectScript');
CaptureDdls := CkJsonObject_IntOf(jResp,'Endpoints[i].PostgreSQLSettings.CaptureDdls');
PostgreSQLSettingsDatabaseName := CkJsonObject__stringOf(jResp,'Endpoints[i].PostgreSQLSettings.DatabaseName');
DdlArtifactsSchema := CkJsonObject__stringOf(jResp,'Endpoints[i].PostgreSQLSettings.DdlArtifactsSchema');
ExecuteTimeout := CkJsonObject_IntOf(jResp,'Endpoints[i].PostgreSQLSettings.ExecuteTimeout');
PostgreSQLSettingsFailTasksOnLobTruncation := CkJsonObject_IntOf(jResp,'Endpoints[i].PostgreSQLSettings.FailTasksOnLobTruncation');
HeartbeatEnable := CkJsonObject_IntOf(jResp,'Endpoints[i].PostgreSQLSettings.HeartbeatEnable');
HeartbeatFrequency := CkJsonObject_IntOf(jResp,'Endpoints[i].PostgreSQLSettings.HeartbeatFrequency');
HeartbeatSchema := CkJsonObject__stringOf(jResp,'Endpoints[i].PostgreSQLSettings.HeartbeatSchema');
PostgreSQLSettingsMaxFileSize := CkJsonObject_IntOf(jResp,'Endpoints[i].PostgreSQLSettings.MaxFileSize');
PostgreSQLSettingsPassword := CkJsonObject__stringOf(jResp,'Endpoints[i].PostgreSQLSettings.Password');
PluginName := CkJsonObject__stringOf(jResp,'Endpoints[i].PostgreSQLSettings.PluginName');
PostgreSQLSettingsPort := CkJsonObject_IntOf(jResp,'Endpoints[i].PostgreSQLSettings.Port');
PostgreSQLSettingsSecretsManagerAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].PostgreSQLSettings.SecretsManagerAccessRoleArn');
PostgreSQLSettingsSecretsManagerSecretId := CkJsonObject__stringOf(jResp,'Endpoints[i].PostgreSQLSettings.SecretsManagerSecretId');
PostgreSQLSettingsServerName := CkJsonObject__stringOf(jResp,'Endpoints[i].PostgreSQLSettings.ServerName');
SlotName := CkJsonObject__stringOf(jResp,'Endpoints[i].PostgreSQLSettings.SlotName');
PostgreSQLSettingsUsername := CkJsonObject__stringOf(jResp,'Endpoints[i].PostgreSQLSettings.Username');
AuthPassword := CkJsonObject__stringOf(jResp,'Endpoints[i].RedisSettings.AuthPassword');
RedisSettingsAuthType := CkJsonObject__stringOf(jResp,'Endpoints[i].RedisSettings.AuthType');
AuthUserName := CkJsonObject__stringOf(jResp,'Endpoints[i].RedisSettings.AuthUserName');
RedisSettingsPort := CkJsonObject_IntOf(jResp,'Endpoints[i].RedisSettings.Port');
RedisSettingsServerName := CkJsonObject__stringOf(jResp,'Endpoints[i].RedisSettings.ServerName');
RedisSettingsSslCaCertificateArn := CkJsonObject__stringOf(jResp,'Endpoints[i].RedisSettings.SslCaCertificateArn');
SslSecurityProtocol := CkJsonObject__stringOf(jResp,'Endpoints[i].RedisSettings.SslSecurityProtocol');
AcceptAnyDate := CkJsonObject_IntOf(jResp,'Endpoints[i].RedshiftSettings.AcceptAnyDate');
RedshiftSettingsAfterConnectScript := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.AfterConnectScript');
BucketFolder := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.BucketFolder');
RedshiftSettingsBucketName := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.BucketName');
CaseSensitiveNames := CkJsonObject_IntOf(jResp,'Endpoints[i].RedshiftSettings.CaseSensitiveNames');
CompUpdate := CkJsonObject_IntOf(jResp,'Endpoints[i].RedshiftSettings.CompUpdate');
ConnectionTimeout := CkJsonObject_IntOf(jResp,'Endpoints[i].RedshiftSettings.ConnectionTimeout');
RedshiftSettingsDatabaseName := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.DatabaseName');
DateFormat := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.DateFormat');
EmptyAsNull := CkJsonObject_IntOf(jResp,'Endpoints[i].RedshiftSettings.EmptyAsNull');
EncryptionMode := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.EncryptionMode');
ExplicitIds := CkJsonObject_IntOf(jResp,'Endpoints[i].RedshiftSettings.ExplicitIds');
FileTransferUploadStreams := CkJsonObject_IntOf(jResp,'Endpoints[i].RedshiftSettings.FileTransferUploadStreams');
LoadTimeout := CkJsonObject_IntOf(jResp,'Endpoints[i].RedshiftSettings.LoadTimeout');
RedshiftSettingsMaxFileSize := CkJsonObject_IntOf(jResp,'Endpoints[i].RedshiftSettings.MaxFileSize');
RedshiftSettingsPassword := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.Password');
RedshiftSettingsPort := CkJsonObject_IntOf(jResp,'Endpoints[i].RedshiftSettings.Port');
RemoveQuotes := CkJsonObject_IntOf(jResp,'Endpoints[i].RedshiftSettings.RemoveQuotes');
ReplaceChars := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.ReplaceChars');
ReplaceInvalidChars := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.ReplaceInvalidChars');
RedshiftSettingsSecretsManagerAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.SecretsManagerAccessRoleArn');
RedshiftSettingsSecretsManagerSecretId := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.SecretsManagerSecretId');
RedshiftSettingsServerName := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.ServerName');
ServerSideEncryptionKmsKeyId := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.ServerSideEncryptionKmsKeyId');
RedshiftSettingsServiceAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.ServiceAccessRoleArn');
TimeFormat := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.TimeFormat');
TrimBlanks := CkJsonObject_IntOf(jResp,'Endpoints[i].RedshiftSettings.TrimBlanks');
TruncateColumns := CkJsonObject_IntOf(jResp,'Endpoints[i].RedshiftSettings.TruncateColumns');
RedshiftSettingsUsername := CkJsonObject__stringOf(jResp,'Endpoints[i].RedshiftSettings.Username');
WriteBufferSize := CkJsonObject_IntOf(jResp,'Endpoints[i].RedshiftSettings.WriteBufferSize');
AddColumnName := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.AddColumnName');
S3SettingsBucketFolder := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.BucketFolder');
S3SettingsBucketName := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.BucketName');
CannedAclForObjects := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.CannedAclForObjects');
CdcInsertsAndUpdates := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.CdcInsertsAndUpdates');
CdcInsertsOnly := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.CdcInsertsOnly');
CdcMaxBatchInterval := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.CdcMaxBatchInterval');
CdcMinFileSize := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.CdcMinFileSize');
CdcPath := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.CdcPath');
CompressionType := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.CompressionType');
CsvDelimiter := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.CsvDelimiter');
CsvNoSupValue := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.CsvNoSupValue');
CsvNullValue := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.CsvNullValue');
CsvRowDelimiter := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.CsvRowDelimiter');
DataFormat := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.DataFormat');
DataPageSize := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.DataPageSize');
DatePartitionDelimiter := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.DatePartitionDelimiter');
DatePartitionEnabled := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.DatePartitionEnabled');
DatePartitionSequence := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.DatePartitionSequence');
DatePartitionTimezone := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.DatePartitionTimezone');
DictPageSizeLimit := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.DictPageSizeLimit');
EnableStatistics := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.EnableStatistics');
EncodingType := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.EncodingType');
S3SettingsEncryptionMode := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.EncryptionMode');
S3SettingsExternalTableDefinition := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.ExternalTableDefinition');
IgnoreHeaderRows := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.IgnoreHeaderRows');
IncludeOpForFullLoad := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.IncludeOpForFullLoad');
S3SettingsMaxFileSize := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.MaxFileSize');
ParquetTimestampInMillisecond := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.ParquetTimestampInMillisecond');
ParquetVersion := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.ParquetVersion');
PreserveTransactions := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.PreserveTransactions');
Rfc4180 := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.Rfc4180');
RowGroupLength := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.RowGroupLength');
S3SettingsServerSideEncryptionKmsKeyId := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.ServerSideEncryptionKmsKeyId');
S3SettingsServiceAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.ServiceAccessRoleArn');
TimestampColumnName := CkJsonObject__stringOf(jResp,'Endpoints[i].S3Settings.TimestampColumnName');
UseCsvNoSupValue := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.UseCsvNoSupValue');
UseTaskStartTimeForFullLoadTimestamp := CkJsonObject_IntOf(jResp,'Endpoints[i].S3Settings.UseTaskStartTimeForFullLoadTimestamp');
ServerName := CkJsonObject__stringOf(jResp,'Endpoints[i].ServerName');
ServiceAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].ServiceAccessRoleArn');
SslMode := CkJsonObject__stringOf(jResp,'Endpoints[i].SslMode');
Status := CkJsonObject__stringOf(jResp,'Endpoints[i].Status');
SybaseSettingsDatabaseName := CkJsonObject__stringOf(jResp,'Endpoints[i].SybaseSettings.DatabaseName');
SybaseSettingsPassword := CkJsonObject__stringOf(jResp,'Endpoints[i].SybaseSettings.Password');
SybaseSettingsPort := CkJsonObject_IntOf(jResp,'Endpoints[i].SybaseSettings.Port');
SybaseSettingsSecretsManagerAccessRoleArn := CkJsonObject__stringOf(jResp,'Endpoints[i].SybaseSettings.SecretsManagerAccessRoleArn');
SybaseSettingsSecretsManagerSecretId := CkJsonObject__stringOf(jResp,'Endpoints[i].SybaseSettings.SecretsManagerSecretId');
SybaseSettingsServerName := CkJsonObject__stringOf(jResp,'Endpoints[i].SybaseSettings.ServerName');
SybaseSettingsUsername := CkJsonObject__stringOf(jResp,'Endpoints[i].SybaseSettings.Username');
Username := CkJsonObject__stringOf(jResp,'Endpoints[i].Username');
j := 0;
count_j := CkJsonObject_SizeOfArray(jResp,'Endpoints[i].OracleSettings.ExtraArchivedLogDestIds');
while j < count_j do
begin
CkJsonObject_putJ(jResp,j);
intVal := CkJsonObject_IntOf(jResp,'Endpoints[i].OracleSettings.ExtraArchivedLogDestIds[j]');
j := j + 1;
end;
i := i + 1;
end;
// A sample JSON response body parsed by the above code:
// {
// "Endpoints": [
// {
// "CertificateArn": "string",
// "DatabaseName": "string",
// "DmsTransferSettings": {
// "BucketName": "string",
// "ServiceAccessRoleArn": "string"
// },
// "DocDbSettings": {
// "DatabaseName": "string",
// "DocsToInvestigate": number,
// "ExtractDocId": boolean,
// "KmsKeyId": "string",
// "NestingLevel": "string",
// "Password": "string",
// "Port": number,
// "SecretsManagerAccessRoleArn": "string",
// "SecretsManagerSecretId": "string",
// "ServerName": "string",
// "Username": "string"
// },
// "DynamoDbSettings": {
// "ServiceAccessRoleArn": "string"
// },
// "ElasticsearchSettings": {
// "EndpointUri": "string",
// "ErrorRetryDuration": number,
// "FullLoadErrorPercentage": number,
// "ServiceAccessRoleArn": "string"
// },
// "EndpointArn": "string",
// "EndpointIdentifier": "string",
// "EndpointType": "string",
// "EngineDisplayName": "string",
// "EngineName": "string",
// "ExternalId": "string",
// "ExternalTableDefinition": "string",
// "ExtraConnectionAttributes": "string",
// "GcpMySQLSettings": {
// "AfterConnectScript": "string",
// "CleanSourceMetadataOnMismatch": boolean,
// "DatabaseName": "string",
// "EventsPollInterval": number,
// "MaxFileSize": number,
// "ParallelLoadThreads": number,
// "Password": "string",
// "Port": number,
// "SecretsManagerAccessRoleArn": "string",
// "SecretsManagerSecretId": "string",
// "ServerName": "string",
// "ServerTimezone": "string",
// "TargetDbType": "string",
// "Username": "string"
// },
// "IBMDb2Settings": {
// "CurrentLsn": "string",
// "DatabaseName": "string",
// "MaxKBytesPerRead": number,
// "Password": "string",
// "Port": number,
// "SecretsManagerAccessRoleArn": "string",
// "SecretsManagerSecretId": "string",
// "ServerName": "string",
// "SetDataCaptureChanges": boolean,
// "Username": "string"
// },
// "KafkaSettings": {
// "Broker": "string",
// "IncludeControlDetails": boolean,
// "IncludeNullAndEmpty": boolean,
// "IncludePartitionValue": boolean,
// "IncludeTableAlterOperations": boolean,
// "IncludeTransactionDetails": boolean,
// "MessageFormat": "string",
// "MessageMaxBytes": number,
// "NoHexPrefix": boolean,
// "PartitionIncludeSchemaTable": boolean,
// "SaslPassword": "string",
// "SaslUsername": "string",
// "SecurityProtocol": "string",
// "SslCaCertificateArn": "string",
// "SslClientCertificateArn": "string",
// "SslClientKeyArn": "string",
// "SslClientKeyPassword": "string",
// "Topic": "string"
// },
// "KinesisSettings": {
// "IncludeControlDetails": boolean,
// "IncludeNullAndEmpty": boolean,
// "IncludePartitionValue": boolean,
// "IncludeTableAlterOperations": boolean,
// "IncludeTransactionDetails": boolean,
// "MessageFormat": "string",
// "NoHexPrefix": boolean,
// "PartitionIncludeSchemaTable": boolean,
// "ServiceAccessRoleArn": "string",
// "StreamArn": "string"
// },
// "KmsKeyId": "string",
// "MicrosoftSQLServerSettings": {
// "BcpPacketSize": number,
// "ControlTablesFileGroup": "string",
// "DatabaseName": "string",
// "Password": "string",
// "Port": number,
// "QuerySingleAlwaysOnNode": boolean,
// "ReadBackupOnly": boolean,
// "SafeguardPolicy": "string",
// "SecretsManagerAccessRoleArn": "string",
// "SecretsManagerSecretId": "string",
// "ServerName": "string",
// "UseBcpFullLoad": boolean,
// "Username": "string",
// "UseThirdPartyBackupDevice": boolean
// },
// "MongoDbSettings": {
// "AuthMechanism": "string",
// "AuthSource": "string",
// "AuthType": "string",
// "DatabaseName": "string",
// "DocsToInvestigate": "string",
// "ExtractDocId": "string",
// "KmsKeyId": "string",
// "NestingLevel": "string",
// "Password": "string",
// "Port": number,
// "SecretsManagerAccessRoleArn": "string",
// "SecretsManagerSecretId": "string",
// "ServerName": "string",
// "Username": "string"
// },
// "MySQLSettings": {
// "AfterConnectScript": "string",
// "CleanSourceMetadataOnMismatch": boolean,
// "DatabaseName": "string",
// "EventsPollInterval": number,
// "MaxFileSize": number,
// "ParallelLoadThreads": number,
// "Password": "string",
// "Port": number,
// "SecretsManagerAccessRoleArn": "string",
// "SecretsManagerSecretId": "string",
// "ServerName": "string",
// "ServerTimezone": "string",
// "TargetDbType": "string",
// "Username": "string"
// },
// "NeptuneSettings": {
// "ErrorRetryDuration": number,
// "IamAuthEnabled": boolean,
// "MaxFileSize": number,
// "MaxRetryCount": number,
// "S3BucketFolder": "string",
// "S3BucketName": "string",
// "ServiceAccessRoleArn": "string"
// },
// "OracleSettings": {
// "AccessAlternateDirectly": boolean,
// "AdditionalArchivedLogDestId": number,
// "AddSupplementalLogging": boolean,
// "AllowSelectNestedTables": boolean,
// "ArchivedLogDestId": number,
// "ArchivedLogsOnly": boolean,
// "AsmPassword": "string",
// "AsmServer": "string",
// "AsmUser": "string",
// "CharLengthSemantics": "string",
// "DatabaseName": "string",
// "DirectPathNoLog": boolean,
// "DirectPathParallelLoad": boolean,
// "EnableHomogenousTablespace": boolean,
// "ExtraArchivedLogDestIds": [
// number
// ],
// "FailTasksOnLobTruncation": boolean,
// "NumberDatatypeScale": number,
// "OraclePathPrefix": "string",
// "ParallelAsmReadThreads": number,
// "Password": "string",
// "Port": number,
// "ReadAheadBlocks": number,
// "ReadTableSpaceName": boolean,
// "ReplacePathPrefix": boolean,
// "RetryInterval": number,
// "SecretsManagerAccessRoleArn": "string",
// "SecretsManagerOracleAsmAccessRoleArn": "string",
// "SecretsManagerOracleAsmSecretId": "string",
// "SecretsManagerSecretId": "string",
// "SecurityDbEncryption": "string",
// "SecurityDbEncryptionName": "string",
// "ServerName": "string",
// "SpatialDataOptionToGeoJsonFunctionName": "string",
// "StandbyDelayTime": number,
// "UseAlternateFolderForOnline": boolean,
// "UseBFile": boolean,
// "UseDirectPathFullLoad": boolean,
// "UseLogminerReader": boolean,
// "UsePathPrefix": "string",
// "Username": "string"
// },
// "Port": number,
// "PostgreSQLSettings": {
// "AfterConnectScript": "string",
// "CaptureDdls": boolean,
// "DatabaseName": "string",
// "DdlArtifactsSchema": "string",
// "ExecuteTimeout": number,
// "FailTasksOnLobTruncation": boolean,
// "HeartbeatEnable": boolean,
// "HeartbeatFrequency": number,
// "HeartbeatSchema": "string",
// "MaxFileSize": number,
// "Password": "string",
// "PluginName": "string",
// "Port": number,
// "SecretsManagerAccessRoleArn": "string",
// "SecretsManagerSecretId": "string",
// "ServerName": "string",
// "SlotName": "string",
// "Username": "string"
// },
// "RedisSettings": {
// "AuthPassword": "string",
// "AuthType": "string",
// "AuthUserName": "string",
// "Port": number,
// "ServerName": "string",
// "SslCaCertificateArn": "string",
// "SslSecurityProtocol": "string"
// },
// "RedshiftSettings": {
// "AcceptAnyDate": boolean,
// "AfterConnectScript": "string",
// "BucketFolder": "string",
// "BucketName": "string",
// "CaseSensitiveNames": boolean,
// "CompUpdate": boolean,
// "ConnectionTimeout": number,
// "DatabaseName": "string",
// "DateFormat": "string",
// "EmptyAsNull": boolean,
// "EncryptionMode": "string",
// "ExplicitIds": boolean,
// "FileTransferUploadStreams": number,
// "LoadTimeout": number,
// "MaxFileSize": number,
// "Password": "string",
// "Port": number,
// "RemoveQuotes": boolean,
// "ReplaceChars": "string",
// "ReplaceInvalidChars": "string",
// "SecretsManagerAccessRoleArn": "string",
// "SecretsManagerSecretId": "string",
// "ServerName": "string",
// "ServerSideEncryptionKmsKeyId": "string",
// "ServiceAccessRoleArn": "string",
// "TimeFormat": "string",
// "TrimBlanks": boolean,
// "TruncateColumns": boolean,
// "Username": "string",
// "WriteBufferSize": number
// },
// "S3Settings": {
// "AddColumnName": boolean,
// "BucketFolder": "string",
// "BucketName": "string",
// "CannedAclForObjects": "string",
// "CdcInsertsAndUpdates": boolean,
// "CdcInsertsOnly": boolean,
// "CdcMaxBatchInterval": number,
// "CdcMinFileSize": number,
// "CdcPath": "string",
// "CompressionType": "string",
// "CsvDelimiter": "string",
// "CsvNoSupValue": "string",
// "CsvNullValue": "string",
// "CsvRowDelimiter": "string",
// "DataFormat": "string",
// "DataPageSize": number,
// "DatePartitionDelimiter": "string",
// "DatePartitionEnabled": boolean,
// "DatePartitionSequence": "string",
// "DatePartitionTimezone": "string",
// "DictPageSizeLimit": number,
// "EnableStatistics": boolean,
// "EncodingType": "string",
// "EncryptionMode": "string",
// "ExternalTableDefinition": "string",
// "IgnoreHeaderRows": number,
// "IncludeOpForFullLoad": boolean,
// "MaxFileSize": number,
// "ParquetTimestampInMillisecond": boolean,
// "ParquetVersion": "string",
// "PreserveTransactions": boolean,
// "Rfc4180": boolean,
// "RowGroupLength": number,
// "ServerSideEncryptionKmsKeyId": "string",
// "ServiceAccessRoleArn": "string",
// "TimestampColumnName": "string",
// "UseCsvNoSupValue": boolean,
// "UseTaskStartTimeForFullLoadTimestamp": boolean
// },
// "ServerName": "string",
// "ServiceAccessRoleArn": "string",
// "SslMode": "string",
// "Status": "string",
// "SybaseSettings": {
// "DatabaseName": "string",
// "Password": "string",
// "Port": number,
// "SecretsManagerAccessRoleArn": "string",
// "SecretsManagerSecretId": "string",
// "ServerName": "string",
// "Username": "string"
// },
// "Username": "string"
// }
// ],
// "Marker": "string"
// }
CkRest_Dispose(rest);
CkAuthAws_Dispose(authAws);
CkJsonObject_Dispose(json);
CkStringBuilder_Dispose(sbRequestBody);
CkStringBuilder_Dispose(sbResponseBody);
CkJsonObject_Dispose(jResp);