Set Output Variable in Azure CLI task on VSTS
Solution 1
Refer to this code below:
call {your command}>tmpFile1
set /p myvar= < tmpFile1
echo "##vso[task.setvariable variable=testvar;]%myvar%"
or
FOR /F "tokens=* USEBACKQ" %%F IN (`{your command}`) DO (
SET var=%%F
)
echo "##vso[task.setvariable variable=testvar;]%var%"
Mechaflash's answer in How to set commands output as a variable in a batch file
Solution 2
If using Azure CLI version 2.* , you can use a powershell command rather than batch script wizardry. Microsoft's documentation found here
For example if you needed access token to update azure database it would look like so:
$token= & az account get-access-token --resource=https://database.windows.net --query accessToken
Write-Output("##vso[task.setvariable variable=sqlToken;]$token")
Don't forget to login first if testing locally:
az login
Solution 3
Inspired from the answer above but with some variation.
Works in an Azure CLI task on a Hosted Ubuntu agent in Microsoft DevOps as of July 2019.
This example runs an az command to fetch the full resource name of a storage account and sets it in the variable _StorageAccountNameVar for use in another pipeline task.
myvar=`az storage account list -g MyResourceGroup --query "[?contains(name, 'config')].name" -o tsv`
echo $myvar
echo "##vso[task.setvariable variable=_StorageAccountNameVar;]$myvar"
user2297037
Updated on July 28, 2022Comments
-
user2297037 almost 2 years
I am getting crazy to achieve this very simple task. I need to set an Output Variable in an Azure CLI task on Visual Studio Team Services, because next task in the Release definition will be executed according to the value of this variable.
I wrote this simple codecall az extension add --name azure-cli-iot-ext call echo ##vso[task.setvariable variable=iotEdgeExists;]$(az iot hub query -n $(iotHub) -q "select * from devices.modules where devices.deviceId ='$(iotEdge)'")
which works, but not as exepected, in fact when I read the Ouput Variable in the next Azure CLI task and I try to print it on the screen I get the command string instead of the output...
call echo"$(az iot hub query -n <IOT_HUB> -q "select * from devices.modules where devices.deviceId ='<IOT_EDGE>'")"
What am I doing wrong?
-
Anish over 5 yearsExpect it to be very hard to make it xplat though.
-
Stef Heyenrath about 5 yearsWhen using the second command, it seems that (in my case) an extra double-quote is added at the end of the variable. So I just use
echo ##vso[task.setvariable variable=testvar;]%var%
-
CDerrig almost 5 yearsWith the second method I was able to use this to grab an accessToken to connect to Azure SQL for Dacpac deployment, which is exactly what I needed. I also had the issue described by @StefHeyenrath and had to remove the quotes. For those looking for Dacpac deployment with access token, just pass /at:$(testvar) of whatever in the arguments and use ConnectionString as the Authentication Type dropdown value. In your connection string don't have any user/password or authentication= specified.
-
Matt Sullivan over 4 yearsTo access azure sql you need
--resource=https://database.windows.net/
(i.e. with a slash on the end) -
dwp4ge almost 3 years@MattSullivan that is incorrect buddy. Tested with and without slash both get token successfully