Ingest sharepoint list using NiFi !!

[#1]

Is there any way to consume sharepoint List data using Nifi? I am using owssvr.dll to fetch data in XML format and want to ingest data into hive.

http://sharepointsiteURL/_vti_bin/owssvr.dll?Cmd=Display&List={LIST ID}&View={VIEW ID}&Query=*&XMLDATA=TRUE

Please suggest.

[#2 · Accepted solution]

I would prefer to use the native web service or REST interface provided by Sharepoint. https://msdn.microsoft.com/en-us/library/office/bb862916(v=office.12).aspx or https://msdn.microsoft.com/en-us/library/office/fp142380.aspx. You can then ConvertJSONToAvro and use PutHiveStreaming to insert the data into Hive table.