Question Re: BTP CPI. get Security Material in groovyscript problem in Technology Q&A

BTP CPI. get Security Material in groovyscript problem

wkpk — Sat, 18 Mar 2023 10:18:35 GMT

I would like to connect and use Google api of openconnector through CPI.

I used an http adapter on the sender, and I succeeded in hardcoding and deploying the authorization of header through groovyscript and calling it from POSTMAN.

Next, hard coding seems to have a management problem, so i tried to change it to Security Material... But it's not working.

To be exact, the API that gets security material information does not seem to work well.

this is my Security Material

*The User value is the User value of OPENCONNECTOR.
In Password, the organization and element of OPENCONNECTOR are concatenated as comma.

this is my GroovyScript :

import com.sap.gateway.ip.core.customdev.util.Message;
import java.util.HashMap;
import com.sap.it.api.ITApiFactory;
import com.sap.it.api.mapping.ValueMappingApi
import com.sap.it.api.securestore.SecureStoreService
import com.sap.it.api.securestore.UserCredential
import com.sap.it.api.securestore.exception.SecureStoreException

def Message processData(Message message) {
    def secureStorageService =  ITApiFactory.getService(SecureStoreService.class, null)
    def credentials  = secureStorageService.getUserCredential('GoogleDrive')
    
    def user = credentials.getUser()
    def password = credentials.getPassword()
    def (organization, element) = password.split(',')
    
    String authorization ="User ${user}, Organization ${organization}, Element ${element}"
    message.setHeader("Authorization", 'authorization ')
    return message;
}

this is error :

How can solve this problem?

Re: BTP CPI. get Security Material in groovyscript problem

wkpk — Sat, 18 Mar 2023 11:15:56 GMT

I solved the problem.

I changed it to a secure parameter and changed the Getusercrendental and getpassword strings, and it works well

Re: BTP CPI. get Security Material in groovyscript problem

Chris_XI — Wed, 26 Feb 2025 11:54:30 GMT

Hi,
I tried the same, but as I want to have user and password secured, I did not want to switch to Secure Parameter.
With this script I am able to read out also User Credentials.

I like to add Debug infos....not necessary, but nice to have.

import com.sap.gateway.ip.core.customdev.util.Message import com.sap.it.api.ITApiFactory import com.sap.it.api.securestore.SecureStoreService def Message processData(Message message) { def map = message.getProperties() def debugCounter = map.keySet().findAll { it.startsWith("Debug_") }.size() + 1 try { // Retrieve SecureStoreService instance (with null as the second argument) SecureStoreService secureStoreService = ITApiFactory.getService(SecureStoreService.class, null) if (secureStoreService == null) { message.setProperty("Debug_${debugCounter++}", "Error: SecureStoreService could not be instantiated.") return message } // Access stored user credentials def credential = secureStoreService.getUserCredential("Name_of_Credential") if (credential == null) { message.setProperty("Debug_${debugCounter++}", "Error: No credentials found for Credentials.") return message } // Extract username and password String username = credential.getUsername() String password = new String(credential.getPassword()) // Convert char array to String // Store debugging information message.setProperty("Debug_${debugCounter++}", "Successfully retrieved credentials from Secure Store.") message.setProperty("Username", username) message.setProperty("Password", password) } catch (Exception e) { message.setProperty("Debug_${debugCounter++}", "Exception while accessing Secure Store: " + e.getMessage()) } return message }