question Re: InvokeHTTP to return CSV in Support Questions

InvokeHTTP to return CSV

a_gulshani — Thu, 13 Jun 2019 16:05:03 GMT

Hi!

How can I configure InvokeHTTP to return comma separated flow file?

At the moment it is returning file in below format (tab separated):

RELM Satieva_microloans 6 3369 2019-06-12 11:42:00 772103971

RELM Satieva_microloans 6 3369 2019-06-12 11:42:00 772104117

RELM Satieva_microloans 6 3369 2019-06-12 11:42:00 772101000

Thanks in advance!

Re: InvokeHTTP to return CSV

jsensharma — Sat, 17 Aug 2019 21:59:13 GMT

@Gulshan Agivetova

May be you can use the "InvokeHTTP" --> "ReplaceText" --> "PutFile" processors like following:

Here in "ReplaceText" processor can be used something like following to replace Search Value = TAB with COMMA

ReplaceText Properties:

Search Value =     
Replacement Value = , 
Character Set = UTF-8
Maximum Buffer Size = 1 MB
Replacement Strategy = Regex Replace
Evaluation Mode =  Line-by-Line

And then it should be able to replace the TABs with Comma.

The output of the given inout should be something like:

RELM,Satieva_microloans,6,3369,2019-06-12,11:42:00,772103971
RELM,Satieva_microloans,6,3369,2019-06-12,11:42:00,772104117
RELM,Satieva_microloans,6,3369,2019-06-12,11:42:00,772101000

Re: InvokeHTTP to return CSV

a_gulshani — Fri, 14 Jun 2019 11:38:29 GMT

@Jay Kumar SenSharma Thank you very much! It helped