Registre de vacunacions COVID_jdt2_MARTA
Normal
0
/
p_provincia
08
p_url
https://analisi.transparenciacatalunya.cat/resource/irki-p3c7.json?provincia_codi=08&$limit=500000
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
-
2020/04/02 20:43:34.121
-
2021/11/05 09:56:26.330
H4sIAAAAAAAAAAMAAAAAAAAAAAA=
N
REST client
JSON input
Y
Generate rows
REST client
Y
JSON input
Text file output
Y
Generate rows
RowGenerator
Y
1
none
filename
String
${Internal.Entry.Current.Directory}/../05.Fitxers_sortida/covid_vacunacio_Municipi_${p_provincia}
-1
-1
N
1
N
5000
now
FiveSecondsAgo
320
128
Y
JSON input
JsonInput
Y
1
none
N
N
N
N
N
N
Y
Y
Y
Rownum2
E:\QV_CCLIMATIC\Coronavirus\05.Fitxers_sortida\irki-p3c7.json
N
N
no_vacunat
$..no_vacunat
String
-1
-1
none
N
districte_codi
$..districte_codi
String
-1
-1
none
N
recompte
$..recompte
String
-1
-1
none
N
fabricant
$..fabricant
String
-1
-1
none
N
data
$..data
String
-1
-1
none
N
dosi
$..dosi
String
-1
-1
none
N
districte
$..districte
String
-1
-1
none
N
municipi
$..municipi
String
-1
-1
none
N
municipi_codi
$..municipi_codi
String
-1
-1
none
N
comarca
$..comarca
String
-1
-1
none
N
comarca_codi
$..comarca_codi
String
-1
-1
none
N
provincia
$..provincia
String
-1
-1
none
N
provincia_codi
$..provincia_codi
String
-1
-1
none
N
sexe
$..sexe
String
-1
-1
none
N
sexe_codi
$..sexe_codi
String
-1
-1
none
N
0
Y
N
resultat_json
704
128
Y
REST client
Rest
Y
1
none
JSON
GET
${p_url}
N
N
URL
933aer11dv174rytpb9l3xj9j
Encrypted 36627839377666646b6d64706861617330657179336976696170737a6e67617a3631d4f797b812c39cd5b80abb79d0c7a6dd
N
Encrypted
resultat_json
vStatus
vResponseTime
vResponseHeader
512
128
Y
Text file output
TextFileOutput
Y
1
none
;
"
N
N
DOS
None
N
Y
E:\QV_CCLIMATIC\Coronavirus\05.Fitxers_sortida
N
N
csv
N
N
N
N
N
N
Y
N
N
filename
String
none
-1
-1
resultat_json
String
none
-1
-1
vStatus
Integer
####0;-####0
.
,
none
-1
0
vResponseTime
Integer
####0;-####0
.
,
none
-1
0
vResponseHeader
String
none
-1
-1
no_vacunat
String
none
-1
-1
districte_codi
String
none
-1
-1
recompte
String
none
-1
-1
fabricant
String
none
-1
-1
data
String
none
-1
-1
dosi
String
none
-1
-1
districte
String
none
-1
-1
municipi
String
none
-1
-1
municipi_codi
String
none
-1
-1
comarca
String
none
-1
-1
comarca_codi
String
none
-1
-1
provincia
String
none
-1
-1
provincia_codi
String
none
-1
-1
sexe
String
none
-1
-1
sexe_codi
String
none
-1
-1
896
128
Y
N