This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello,
I want to set the frequency of a property to more than one value. It is a Pipeline Trigger in Azure Data Factory.
If I do it via Azure Portal, I can retrieve the current value via CLI
az datafactory trigger show --factory-name poc-df-01 --resource-group poc-df-rg --name trigger_poc
To set the value to Tuesday and Friday, how can I do it?
az datafactory trigger update --factory-name poc-df-01 --resource-group poc-df-rg --name trigger_poc --set properties.recurrence.schedule.weekDays[0]="Tuesday Friday"
It doesn't work, nor other tests I have done:
.weekDays[0]="Tuesday" "Friday"
.weekDays[0]='{"Tuesday","Friday"}'
.weekDays[0]="\"Tuesday\",\"Friday\""
.weekDays[0]="'Tuesday','Friday'"
In all cases includes both days as a string, and In the Portal you can see that no day is selected:
Portal:
I have tried what it states in the Official Doc without success. And I know I am missing something. Probably the stupidest thing xD
How can I do it?
Hi @Martull ,
Thank you for posting query in Microsoft Q&A Platform.
WeekDays property taking array of values and in PowerShell arrays can be defined with comma separated values.
Could you please try passing values as "Tuesday","Friday" and see if that helps?
Please let me know how it goes. Thank you.
Hello Maheer @ShaikMaheer-MSFT ,
I am using AZ CLI and not PowerShell.
I did try that one as well. Actually, I tried all imaginable options with no success, that is why I asked here :-(
Other tests:
--set properties.recurrence.schedule.weekDays[0]='{"Tuesday","Friday"}'
--set properties.recurrence.schedule.weekDays[0]="\"Tuesday\",\"Friday\""
--set properties.recurrence.schedule.weekDays[0]="'Tuesday','Friday'"
--set properties.recurrence.schedule.weekDays[0]="Tuesday","Friday"
--set 'properties.recurrence.schedule.weekDays[0]="Tuesday","Friday"'
--set properties.recurrence.schedule.weekDays[0]="Tuesday\nSaturday"
--set properties.recurrence.schedule.weekDays[0]="Tuesday"\n"Saturday"
--set properties.recurrence.schedule.weekDays[0]="Tuesday"\n"Saturday"
--set properties.recurrence.schedule.weekDays[0]="Tuesday\nSaturday"
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 20%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Hi @Martull did you figure out any resolution on this? Actually I also stuck in updating the the weekDays to just set for couple of days like "sunday" and "monday" via azure CLI
Hello, no, I was not able to do it that way and I moved on.
But I had a similar problem with other command (az datafactory pipeline create-run), and using a parameters file I solved it. I think it is worth the try in your case.
az datafactory pipeline create-run --resource-group $resourcegroup --factory-name $datafactory --name $pipename --parameters @$my_parameters.json
In that case I used a file because the command accepts it:
--parameters
Parameters of the pipeline run. These parameters will be used only if the runId is not specified. Expected value: json-string/json-file/@json-file.
In your case with the trigger update we can't use a file, but maybe using a JSON string you can do it
Optional Parameters
--add
Add an object to a list of objects by specifying a path and key value pairs. Example: --add property.listProperty <key=value, string or JSON string>.
Good luck and keep us posted in case you make it :-)