Chilkat Online Tools

DescribeEndpoints delphiDll Example

AWS Database Migration Service

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);