ConnectionsScript

pipeline {
    agent any
    parameters {
        choice(name: 'InstanceURL', choices: ['DEV', 'UAT', 'PROD'], description: 'Select the instance URL')
    }
    stages {
        stage('Read CSV') {
            steps {
                script {
				def instanceURL
					def Username
                    def Password
                    switch(params.InstanceURL) {
                        case 'DEV':
                            instanceURL = 'https://testinstance-idevjxz332qf-ia.integration.ocp.oraclecloud.com'
							Username = 'Devops_user'
                            Password = 'Oic_Jenkins#2023'
                            break
                        case 'UAT':
                            instanceURL = 'http://example.com/url2'
							Username = 'username1'
                            Password = 'password1'
                            break
                        case 'PROD':
                            instanceURL = 'http://example.com/url3'
							Username = 'username1'
                            Password = 'password1'
                            break
                        default:
                            echo 'Invalid instance URL'
                            return
                    }
                    def csvFile = readFile(params.CSVFileName).trim()
                    def records = csvFile.readLines().drop(1).collect { line -> line.tokenize(',') }
                    records.each { record ->
                        def field1 = record[0]
                        def field2 = record[1]
                        def field3 = record[2]
                        def field4 = record[3]
                        
                        def conProperties = """
                            { 
                                "connectionProperties": { 
                                    "propertyGroup": "CONNECTION_PROPS",
                                    "propertyName": "connectionUrl",
                                    "propertyType": "URL",
                                    "propertyValue": "${field1}"
                                },
                                "securityPolicy": "BASIC_AUTH",
                                "securityProperties": [
                                    {
                                        "propertyGroup": "CREDENTIALS",
                                        "propertyName": "username",
                                        "propertyValue": "${field2}"
                                    },
                                    {
                                        "propertyGroup": "CREDENTIALS",
                                        "propertyName": "password",
                                        "propertyValue": "${field3}"
                                    }
                                ]
                            }
                        """
                        def payload = conProperties.replace('\n', '').trim()
                        writeFile file: 'payload.json', text: payload
                        
                        //def integURL = "https://testinstance-idevjxz332qf-ia.integration.ocp.oraclecloud.com/ic/api/integration/v1/connections/${field4}"
                        
                        //bat"""
//curl -X POST --user "Devops_user:Oic_Jenkins#2023" --header "X-HTTP-Method-Override:PATCH" --header "Content-Type:application/json" -d @payload.json "https://testinstance-idevjxz332qf-ia.integration.ocp.oraclecloud.com/ic/api/integration/v1/connections/${field4}"                        """
                     

def selectedOption = "${params.Import_Method}".trim()
                    if (selectedOption == 'New') {
                        echo 'Adding new connection'
                        bat """
						curl -X POST --user ${Username}:${Password} --header "X-HTTP-Method-Override:PATCH" --header "Content-Type:application/json" -d @payload.json "${instanceURL}/ic/api/integration/v1/connections/${field4}"
						"""
                    } else if (selectedOption == 'Replace') {
                        echo 'Replacing a connection'
                        bat """
						curl -X POST --user ${Username}:${Password} --header "X-HTTP-Method-Override:PATCH" --header "Content-Type:application/json" -d @payload.json "${instanceURL}/ic/api/integration/v1/connections/${field4}"
						"""
                    } else {
                        echo 'No import method is selected'
                    }					 
                    }
                }
            }
        }
    }
}