Support Questions

Find answers, ask questions, and share your expertise

Ingest sharepoint list using NiFi !!

New Contributor

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.

1 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.

View solution in original post

1 REPLY 1

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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.