Forum Discussion
Powershell error with the below code
Replace the following existing line:
$secretName = $row.$secretNameWith:
$secretName = ConvertTo-SecureString -AsPlainText -String $row.$secretName -Force;The error's telling you that Set-AzKeyValutSecret wants a secure string, not a plain text string.
Cheers,
Lain
Thank you.
I ran below. I am using powershell ISE
PS C:\windows\System32> $keyVaultName = "marketing-test"
$data = Import-Csv "C:\Users\Ram.Muppaneni\Downloads\marketing.csv"
$data.value
PS C:\windows\System32>
Above was the output.
No data uploaded to the keyvault
Regards,
Rambo
If you do the same but instead of running $Data.value could you run just $Data and see what the output is like?
Cheers
Oliwer
The error is telling you that the values for Secretvalue in the XLSX may only contain:
- Numbers (0-9);
- Lowercase letters (a-z);
- Uppercase letters (A-Z);
- The minus/hyphen/dash symbol (-).
Cheers,
Lain
LainRobertson oliwer_sundgren
Hi Lain & OliwerI have edited and ran the below code and now i get the below error.
Please advise the workaround.
Looking forward to hear from you.
Regards,
RamboLainRobertson oliwer_sundgren
Hi Lain,
I ran the below as advised and received the below output.
Looking forward to hear from you. Thanks.
Regards,
RamboReplace the following existing line:
$secretName = $row.$secretNameWith:
$secretName = ConvertTo-SecureString -AsPlainText -String $row.$secretName -Force;The error's telling you that Set-AzKeyValutSecret wants a secure string, not a plain text string.
Cheers,
Lain
oliwer_sundgren LainRobertson
Hi Oliwer & Lain,
I ran below and got the below output.
Looking forward to hear from you.
Regards,
Rambo- LainRobertson
Yeah I noticed that I missed that it said SecretValue in the CSV 🙂 Thanks for clarifying
Cheers! It'd need to be $Data.Secretvalue rather than $Data.Value. Other than that, as you say, the data appears fine now, but wouldn't have at the start given the $null error.
Cheers,
Lain
- Hmm the data does look correct.
Could you try and run the script again and share a screenshot of error message again?.
After the script has ran, run $Row.Name in the terminal and see if it outputs something as well
Cheers
Oliwer oliwer_sundgren
Hi Oliwer,I got the below output.
But it did not upload the data to key vault.
Looking forward to hear from you. Thank you.
Regards,
Rambo