Member since
03-01-2018
6
Posts
0
Kudos Received
0
Solutions
03-29-2018
03:41 PM
@Shu Thank you sir i really appreciate your help, although i am having trouble loading your template, i am getting the following error!? templateerror.png
... View more
03-29-2018
12:48 PM
@Shu Thanks for your prompt response. I can see how that would work if i was making calls for the current day as each day progresses but i need to make the calls with historical dates i.e. start of at 2017/01/01 next call is 2017/01/02 all the way to 2017/12/31. Is this possible?
... View more
03-29-2018
12:11 PM
Hi i'm needing to make an api call for data pertaining to each day in a calendar year. I don't want to do this manually as it will be a laborious task and i will no doubt make a mistake at some stage. The api request is as follows: http://api.wunderground.com/api/dfe2f11fb7108c21/history_20170101/q/CA/EWR.json with the date parameter needing to change for each request. Is there a way to automate this process. Thanks in advance.
... View more
03-19-2018
10:54 PM
Thanks Shu, that worked perfect.
... View more
03-19-2018
10:22 PM
Hi Rahul, thanks for your prompt reply. Unfortunately the resulting CSV file is still being merged in the same manner. see following snippet. as you can see i don't have the heading and all csv files are being appended onto the one line.
... View more
03-19-2018
06:43 PM
Hi, i'm very new to NiFi and i was hoping for some advice. I'm taking in some JSON data which i'm assuming needs to be split before i can successfully convert it to CSV and then merge together again. json.png shows the JSON data before it has been converted, csv.png shows the data after its been converted and merged back together and desiredCSV.png shows what i want the csv file to look like. I'm currently using SplitJson -> EvaluateJsonPath -> ReplaceText -> MergeContent. Iv'e tried using the ConvertRecord processor but i can't seem to configure it properly. This is the flow for one record, i then need to do the same thing with over a hundred other records and merge them all together into one big CSV file!? Any help would be greatly appreciated.
... View more
Labels:
- Labels:
-
Apache NiFi