About GCaixeta

VidyaSargur · ‎09-21-2021

English Translation: Question: How to transform a JSON into multiple flow files? Ex: how to generate through this Json below and generate 4 flow files? [ { "ID_WA_REcipient" : "5599999999999", "DES_MENS_NMO" : "You are receiving the 1st copy of your invoice.", "COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcv" }, { "ID_WA_REcipient" : "5599999999999", "DES_MENS_NMO" : "You are receiving the 1st copy of your invoice.", "COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcvb" }, { "ID_WA_REcipient" : "5599999999999", "DES_MENS_NMO" : "You are receiving the 1st copy of your invoice.", "COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcvc" }, { "ID_WA_REcipient" : "5599999999999", "DES_MENS_NMO" : "You are receiving the 1st copy of your invoice.", "COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcvd" }] Solution You will use the SplitJson processor and in the property "JsonPath Expression" you will put "$" (without quotes).

GCaixeta · ‎09-20-2021

After looks better to the process, I understood what is need to persist Spatial data from a Oracle Database into a PostgreSQL. First I can`t automate all the process due the fact the NIFI (could be a feature request!?) cannot handle GeoSpatial data, due this I had to use specific functions in my Oracle query to return the data in WKT format (which is a text format). Making possible the data serialization from NIFI, and after that I just apply some modifications over the data (to make the data complaint with the table) and everything works.

Online	Offline
Last Visited	‎10-28-2021 08:43 AM

Member Since	‎09-15-2021 06:54 AM
Last Visited	‎10-28-2021 08:43 AM
Posts	4
Kudos received	1

Cloudera Community

Re: Apache Nifi - Error on ExecuteSQL in a table ...

Re: Como tranformar um JSON em varios flow files?

Re: Como tranformar um JSON em varios flow files?

Re: Apache Nifi - Error on ExecuteSQL in a table ...