Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am scheduling a flow every month using the following URL:
'"+ TalendDate.addDate( TalendDate.getDate("YYYYMMDD"), "yyyyMMdd", -1, "MM" )+"'AND%20STARTDATE%20%3C='"+ TalendDate.addDate(TalendDate.getDate("YYYYMMDD"), "yyyyMMdd", -1, "dd")+"'&returnGeometry=true&resultType=standard&outFields=*&outSR=4326&f=json
I have passed the URL as a variable from context variable -> tJava -> tHttpRequest. It's working as expected.
But I want to change the URL by passing the context param from command line, however I am unable to override it.
Regards,
sheetal
Hi
Below is the syntax of passing new values to context variables from command line.
>jobName_0_1.bat --context=Default --context_param var1=value1 --context_param var2=value2
Please try and let me know if you have any issues.
Regards
Shong
Hi Shong,
Thank you for your reply.
I tried the syntax you provided but still, I am unable to override the value while running the job from command line.
job.bandsdatamonthlyflow_0_1.BandsDataMonthlyflow --context=Default --context_param BandsMonthlyURL=https://services5.arcgis.com/sjP4Ugu5s0dZWLjd/arcgis/rest/services/Bands_Public/FeatureServer/0/query?where=STARTDATE%20%3E='"+ TalendDate.addDate( TalendDate.getDate("YYYYMMDD"), "yyyyMMdd", -3, "MM" )+"'AND%20STARTDATE%20%3C='"+ TalendDate.addDate( TalendDate.getDate("YYYYMMDD"), "yyyyMMdd", -1, "dd" )+"'&returnGeometry=true&resultType=standard&outFields=*&outSR=4326&f=json"$@"
Regards,
Sheetal
Thank you @Shicong Hong , this is very helpful!
@Sheetal Jeshwani IMO you are passing in too much, and I doubt the TalendDate operations will work when passed in from command line. You might consider having 2 context variables for start date and end date that are used in another context variable for the URL. So in your context, you'd have a variable for BandsMonthlyURL with a value like
```https://services5.arcgis.com/sjP4Ugu5s0dZWLjd/arcgis/rest/services/Bands_Public/FeatureServer/0/quer...'"+ TalendDate.addDate( TalendDate.getDate("YYYYMMDD"), "yyyyMMdd", context.StartDate, "MM" )+"'AND%20STARTDATE%20%3C='"+ TalendDate.addDate( TalendDate.getDate("YYYYMMDD"), "yyyyMMdd", context.EndDate, "dd" )+"'&returnGeometry=true&resultType=standard&outFields=*&outSR=4326&f=json"$@" ```
Then from the command line you could pass in just --context=Default --context_param StartDate=-3 --context_param EndDate=-1