san-salvador-api-request Normal / ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE 0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 - 2019/01/29 13:57:17.971 - 2019/01/29 13:57:17.971 N JSON Input Modified Java Script Value Y JSON Input 2 JSON Input Y Modified Java Script Value Select values Y Select values Filter rows Y REST Client JSON Input 2 Y JSON Input JsonInput Y 1 none N N N N Y N Y Y Y N N time $.data[*].time Number -1 -1 none N precipIntensity $.data[*].precipIntensity Number -1 -1 none N precipProbability $.data[*].precipProbability Number -1 -1 none N precipType $.data[*].precipType String -1 -1 none N temperature $.data[*].temperature Number -1 -1 none N apparentTemperature $.data[*].apparentTemperature Number -1 -1 none N humidity $.data[*].humidity Number -1 -1 none N pressure $.data[*].pressure Number -1 -1 none N windSpeed $.data[*].windSpeed Number -1 -1 none N windGust $.data[*].windGust Number -1 -1 none N windBearing $.data[*].windBearing Number -1 -1 none N cloudCover $.data[*].cloudCover Number -1 -1 none N summary $.data[*].summary String -1 -1 none N icon $.data[*].icon String -1 -1 none N 0 Y N hourly

464 112 Y Modified Java Script Value ScriptValueMod Y 1 none Y 9 0 Script 1 //Script here var time_hmi = new Date(time*1000); var fecha = new Date(); var fecha_mañana = truncDate(dateAdd(fecha, "d", 1),3); var fecha_pasado = truncDate(dateAdd(fecha, "d", 2),3); var ciudad = "San Salvador"; var pais = "El Salvador"; -1 dateAdd_Sample // Add's the given number to the given date Value. // // Usage: // dateAdd(var,var,var); // 1: Date - The Variable with the Date. // 2: String - The Type which represents the value // to add. // y - Years // m - Months // d - Days // w - Weeks // wd - Workingdays // hh - Hours // mi - Minutes // ss - Seconds // 3: Numeric - The Value to add. // // 2006-11-15 // var d1 = new Date(); Alert(dateAdd(d1, "y", 1)); Alert(dateAdd(d1, "m", 4)); Alert(dateAdd(d1, "d", 5)); Alert(dateAdd(d1, "wd", 5)); -1 truncDate_Sample // // Usage: // truncDate(var1, var2); // // 1: a date - the date-time to be truncated // 2: the requested precision: // - 5 : truncate MONTHS (set to 1) // - 4 : truncate DAYS (set to 1) // - 3 : truncate HOURS (set to 0) // - 2 : truncate MINUTES (set to 0) // - 1 : truncate SECONDS (set to 0) // - 0 : truncate MILLISECONDS (set to 0) // // 2008-02-29 // var dateTime = new Date(); var date0 = truncDate(dateTime, 0); // gives back today at yyyy/MM/dd HH:mm:ss.000 var date1 = truncDate(dateTime, 1); // gives back today at yyyy/MM/dd HH:mm:00.000 var date2 = truncDate(dateTime, 2); // gives back today at yyyy/MM/dd HH:00:00.000 var date3 = truncDate(dateTime, 3); // gives back today at yyyy/MM/dd 00:00:00.000 var date4 = truncDate(dateTime, 4); // gives back today at yyyy/MM/01 00:00:00.000 var date5 = truncDate(dateTime, 5); // gives back today at yyyy/01/01 00:00:00.000 time_hmi time_hmi Date -1 -1 N fecha_mañana fecha_mañana Date -1 -1 N fecha_pasado fecha_pasado Date -1 -1 N ciudad ciudad String -1 -1 N pais pais String -1 -1 N

592 112 Y JSON Input 2 JsonInput Y 1 none N N N N N N Y Y Y C:\Users\BI4\Documents\Development\PDI - Kettle\weather-darksky\san-salvador-forecast.json N N latitude $.latitude Number -1 -1 none N longitude $.longitude Number -1 -1 none N hourly $.hourly String -1 -1 none N 0 N N

352 112 Y Select values SelectValues Y 1 none N time

736 112 Y Filter rows FilterRows Y 1 none N N time_hmi >= fecha_mañana N AND time_hmi < fecha_pasado

848 112 Y REST Client Rest Y 1 none TEXT PLAIN GET N N Encrypted N Encrypted result

240 112 Y N