Member since
03-07-2017
3
Posts
0
Kudos Received
0
Solutions
03-08-2017
09:00 AM
Thanks. Managed to do so with the Jolt Processor.
... View more
03-08-2017
08:59 AM
Perfect answer. Worked out perfectly. Thanks a lot.
... View more
03-07-2017
02:02 PM
Hi,
I want to put the following JSON-File into a DB-table:
{
"Time":"03/07/2017 11:45:46.365",
"Subscription":"1234567",
"ServiceCodes":[
"SERVICE_CODE1",
"SERVICE_CODE2",
"SERVICE_CODE3",
"SERVICE_CODE4"
]
}
The amount of servicecodes is variable, so there are JSONs, which consists 4 ServiceCodes but there are also some which just have 1 to 3 servicecodes.
It would be perfect to put it in the table having one row per Servicecode:
TIME
SUBSCRIPTION
SERVICECODE
03/07/2017 11:45:46.365
1234567
SERVICE_CODE1
03/07/2017 11:45:46.365
1234567
SERVICE_CODE2
But I don't know if this is possible with nifi.
If not, I would be ok with having it as a comma-seperated list:
TIME
SUBSCRIPTION
SERVICECODE
03/07/2017 11:45:46.365
1234567
SERVICE_CODE1,
SERVICE_CODE2,
SERVICE_CODE3,
SERVICE_CODE4
At the moment I am using a CONVERTJSONTOSQL-Processor in Combination with a PUTSQL-Processor. This is working for TIME and SUBSCRIPTION, but SERVICECODE is always empty. In the OracleDB ServiceCode is a varchar2(250), but this could be changed. Any suggestions how to do this? Thanks a lot for your help. Rgrds, Chris
... View more
Labels:
- Labels:
-
Apache NiFi