topic Re: How to pass the context variable from command line in Talend Studio

How to pass the context variable from command line

SJeshwani1618330394 — Sun, 31 Oct 2021 09:36:50 GMT

Hi,

I am scheduling a flow every month using the following URL:

https://services5.arcgis.com/sjP4Ugu5s0dZWLjd/arcgis/rest/services/Bands_Public/FeatureServer/0/query?where=STARTDATE%20%3E=

'"+ 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

Re: How to pass the context variable from command line

Anonymous — Tue, 02 Nov 2021 07:21:01 GMT

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

Re: How to pass the context variable from command line

SJeshwani1618330394 — Tue, 02 Nov 2021 08:25:48 GMT

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

Re: How to pass the context variable from command line

joeg627 — Tue, 16 Jan 2024 18:15:08 GMT

Thank you @Shicong Hong , this is very helpful!

Re: How to pass the context variable from command line

joeg627 — Tue, 16 Jan 2024 23:11:36 GMT

@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/query?where=STARTDATE%20%3E='"+ 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