execute-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 16:02:42.790 - 2019/01/29 16:02:42.790 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N PRD_ORION_AZURE 192.168.100.4 MSSQLNATIVE Native PRD_ORION 1433 MERELEC_PDI Encrypted 2bec8eb8127c28081a71cad348cc2fe82 EXTRA_OPTION_MSSQLNATIVE.instance azureme.wmercadosme.local FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N MSSQLUseIntegratedSecurity false MSSQL_DOUBLE_DECIMAL_SEPARATOR N PORT_NUMBER 1433 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N JSON Input Modified Java Script Value Y Modified Java Script Value Select values Y JSON Input 2 JSON Input Y REST Client JSON Input 2 Y Get rows from result REST Client Y Select values Table output Y Get rows from result RowsFromResult Y 1 none pais String -1 -1 ciudad String -1 -1 url String -1 -1

208 128 Y JSON Input JsonInput Y 1 none N N N N Y N Y Y Y N N time $.time Number -1 -1 none N precipIntensity $.precipIntensity Number -1 -1 none N precipProbability $.precipProbability Number -1 -1 none N precipType $.precipType String -1 -1 none N temperature $.temperature Number -1 -1 none N apparentTemperature $.apparentTemperature Number -1 -1 none N humidity $.humidity Number -1 -1 none N pressure $.pressure Number -1 -1 none N windSpeed $.windSpeed Number -1 -1 none N windGust $.windGust Number -1 -1 none N windBearing $.windBearing Number -1 -1 none N cloudCover $.cloudCover Number -1 -1 none N summary $.summary String -1 -1 none N icon $.icon String -1 -1 none N 0 Y N currently

608 128 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 currently $.currently String -1 -1 none N 0 Y N result_json

496 128 Y Modified Java Script Value ScriptValueMod Y 1 none Y 9 0 Script 1 //Script here var time_hmi = new Date(time*1000); time_hmi = truncDate(time_hmi,2); -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

736 128 Y REST Client Rest Y 1 none JSON GET https://api.darksky.net/forecast/8da2488ae697993621bb7e4d11077fb3/13.699,-89.1914?lang=es&units=ca&exclude=hourly,daily,alerts,flags Y N url Encrypted N Encrypted result_json

368 128 Y Select values SelectValues Y 1 none N time

880 128 Y Table output TableOutput Y 1 none PRD_ORION_AZURE CLIMA CLIMA_HORARIO 1000 N N Y Y N N Y N Y N PAIS pais CIUDAD ciudad LATITUD latitude LONGITUD longitude PRECIP_INTENSITY precipIntensity PRECIP_PROBABILITY precipProbability PRECIP_TYPE precipType TEMPERATURE temperature APPARENT_TEMPERATURE apparentTemperature HUMIDITY humidity PRESSURE pressure WIND_SPEED windSpeed WIND_GUST windGust WIND_BEARING windBearing CLOUD_COVER cloudCover SUMMARY summary ICON icon FECHA time_hmi

1120 128 Y N