ConnectionUpdateScript

pipeline {
    agent any
    stages {
        stage('Read CSV') {
            steps {
                script {
                    def csvFile = readFile('ConnectionDetails.csv').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}"                        """
                        
                    }
                }
            }
        }
    }
}