nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Igor Kravzov <igork.ine...@gmail.com>
Subject Re: ReplaceText processor configuration help
Date Mon, 25 Apr 2016 14:33:41 GMT
Hi Aldrin,


Attached please find the template.  In this workflow I want to pull
"entities" and "user" entries for Twitter JSON as entire structure. I only
can do it if I set Return Type as JSON.
Subsequently I use AttributesToJSON to create a new JSON file. But
returning values for "entities" and "user" are escaped so I had to clean
these before converting to JSON.

Hope this helps.

On Mon, Apr 25, 2016 at 10:15 AM, Aldrin Piri <aldrinpiri@gmail.com> wrote:

> Hi Igor,
>
> That should certainly be possible.  Would you mind opening up a ticket (
> https://issues.apache.org/jira/browse/NIFI) and providing a template of
> your flow that is causing the issue?
>
> Thanks!
>
> On Mon, Apr 25, 2016 at 10:09 AM, Igor Kravzov <igork.inexso@gmail.com>
> wrote:
>
>> Thanks Pierre. It worked. Looks like I was doing something wrong inside
>> my workflow.
>> Would not be it feasible to have an option for EvaluateJsonPath processor
>> to have an option to return escaped or unescaped JSON result?
>>
>> On Mon, Apr 25, 2016 at 7:20 AM, Pierre Villard <
>> pierre.villard.fr@gmail.com> wrote:
>>
>>> Hi Igor,
>>>
>>> Please use ReplaceText processors.
>>>
>>> 1.
>>> Search value : \\
>>> Replace value : Empty string set
>>>
>>> 2.
>>> Search value : "\{
>>> Replace value : \{
>>>
>>> 3.
>>> Search value : \}"
>>> Replace value : \}
>>>
>>> Template example attached.
>>>
>>> HTH
>>> Pierre
>>>
>>>
>>> 2016-04-24 20:12 GMT+02:00 Igor Kravzov <igork.inexso@gmail.com>:
>>>
>>>> I am not that good in regex. What would be the proper configuration to
>>>> do the following;
>>>>
>>>>    1. Remove backslash from text.
>>>>    2. Replace "{ with {
>>>>    3. replace }" with }
>>>>
>>>> Basically I need to clean escaped JSON.
>>>>
>>>> Like before:
>>>>
>>>>  "{\"hashtags\":[{\"text\":\"Apple\",\"indices\":[45,51]}],\"urls\":[{\"url\":\"\",\"expanded_url\":\"\",\"display_url\":\"owler.us/abdLas\
<http://owler.us/abdLas%5C>",\"indices\":[64,87]}],\"user_mentions\":[],\"symbols\":[{\"text\":\"AAPL\",\"indices\":[88,93]}]}",
>>>>
>>>> after:
>>>>
>>>> {"hashtags":[{"text":"Apple","indices":[45,51]}],"urls":[{"url":"","expanded_url":"","display_url":"owler.us/abdLas","indices":[64,87]}],"user_mentions":[],"symbols":[{"text":"AAPL","indices":[88,93]}]},
>>>>
>>>> Thanks in advance.
>>>>
>>>
>>>
>>
>

Mime
View raw message