Create Datasource with REST API from PHP

leshgancomp — Wed, 08 Jan 2020 09:53:49 GMT

Good afternoon. I'm trying to create a new Datasource using PHP. When sending a request, an error is returned to me.

Error:

( [error] => Array (
[code] => DM_GWPipeline_UnknownError
[pbi.error] => Array(
[code] => DM_GWPipeline_UnknownError
[parameters] => Array()

[details] => Array(
[0] => Array(
[code] => DM_ErrorDetailNameCode_UnderlyingErrorMessage
[detail] => Array(
[type] => 1
[value] => Неправильный параметр.

)

[1] => Array(
[code] => DM_ErrorDetailNameCode_UnderlyingHResult
[detail] => Array(
[type] => 1
[value] => -2146893785
)

)

[exceptionCulprit] => 1
)

)

PHP:

$gateway = $this->get($gateway_id);
$exponent = $gateway['publicKey']['exponent'];
$modulus = $gateway['publicKey']['modulus'];
$credentialsData = json_encode([
"credentialData" => [
[
"name" => "username",
"value" => $db_username
],
[
"name" => "password",
"value" => $db_password
]
]
]);
$rsa = new RSA();
$rsa->loadKey([
'e' => new BigInteger(base64_decode($exponent), 256),
'n' => new BigInteger(base64_decode($modulus), 256)
]);
echo $rsa->getPublicKey(); // returns -----BEGIN PUBLIC KEY----- ...................... -----END PUBLIC KEY-----
$rsa->setEncryptionMode(RSA::ENCRYPTION_OAEP);
$ciphertext = $rsa->encrypt($credentialsData);

$params = [
"dataSourceType" => $db_type,
"connectionDetails" => json_encode([
"server" => $db_server,
"database" => $db_name
]),
"dataSourceName" => $db_name,
"onPremGatewayRequired" => true,
"credentialDetails" => [
"credentials" => base64_encode($ciphertext),
"credentialType" => "Basic",
"encryptedConnection" => "NotEncrypted",
"privacyLevel" => "None",
"encryptionAlgorithm" => "RSA-OAEP"
]
];
$this->request->execute('gateways/'.$gateway_id.'/datasources', $params, PowerBiRequest::METHOD_POST_JSON);

topic Create Datasource with REST API from PHP in Developer

Create Datasource with REST API from PHP