https://community.cloudera.com/t5/Archives-of-Support-Questions/Ingest-sharepoint-list-using-NiFi/m-p/129206#M39308 <P>I would prefer to use the native web service or REST interface provided by Sharepoint. <A href="https://msdn.microsoft.com/en-us/library/office/bb862916(v=office.12).aspx" target="_blank">https://msdn.microsoft.com/en-us/library/office/bb862916(v=office.12).aspx</A> or <A href="https://msdn.microsoft.com/en-us/library/office/fp142380.aspx" target="_blank">https://msdn.microsoft.com/en-us/library/office/fp142380.aspx</A>. You can then ConvertJSONToAvro and use PutHiveStreaming to insert the data into Hive table.</P> Tue, 06 Sep 2016 23:25:55 GMT mpandit 2016-09-06T23:25:55Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Ingest-sharepoint-list-using-NiFi/m-p/129205#M39307 <P>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.</P><P><A href="http://sharepointsiteURL/_vti_bin/owssvr.dll?Cmd=Display&amp;List={LIST" target="_blank">http://sharepointsiteURL/_vti_bin/owssvr.dll?Cmd=Display&amp;List={LIST</A> ID}&amp;View={VIEW ID}&amp;Query=*&amp;XMLDATA=TRUE</P><P>Please suggest.</P> Thu, 01 Sep 2016 01:35:12 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Ingest-sharepoint-list-using-NiFi/m-p/129205#M39307 goyal_goyal 2016-09-01T01:35:12Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Ingest-sharepoint-list-using-NiFi/m-p/129206#M39308 <P>I would prefer to use the native web service or REST interface provided by Sharepoint. <A href="https://msdn.microsoft.com/en-us/library/office/bb862916(v=office.12).aspx" target="_blank">https://msdn.microsoft.com/en-us/library/office/bb862916(v=office.12).aspx</A> or <A href="https://msdn.microsoft.com/en-us/library/office/fp142380.aspx" target="_blank">https://msdn.microsoft.com/en-us/library/office/fp142380.aspx</A>. You can then ConvertJSONToAvro and use PutHiveStreaming to insert the data into Hive table.</P> Tue, 06 Sep 2016 23:25:55 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Ingest-sharepoint-list-using-NiFi/m-p/129206#M39308 mpandit 2016-09-06T23:25:55Z