LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  Read Write SharePoint List Data via API

    Employee
    Posted 07-13-2015 10:40

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: jmorrissette

    As this thread indicates in 2010, SharePoint is indeed based on a SQL server database:
    http://community.lavastorm.com/threa...arepoint-Lists
    However working directly with SQL is not the correct way to work with SharePoint list data, especially considering that hosted versions like Office 365 wont give you access to the DB. There is an API for this purpose in fact, one that I would imagine LAE's HTTP node would be excellent at working with. Has anyone by chance created a library of API based nodes for the task?


  • 2.  RE: Read Write SharePoint List Data via API

    Employee
    Posted 07-14-2015 05:55

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: lnason

    LAL has the "Folder list" (Acquisition) and "Upload"(Publishing) nodes for Sharepoint, have you tried these?


  • 3.  RE: Read Write SharePoint List Data via API

    Employee
    Posted 07-31-2015 02:19

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Salma

    We're currently working on speccing a Read Sharepoint List node - 2010 and then 2013..will have a corresponding 'Upload to Sharepoint List' too...can't promise you any dates yet as to when they will be implemented - may be end of 2015


  • 4.  RE: Read Write SharePoint List Data via API

    Employee
    Posted 09-16-2016 00:59

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: NWR

    Has the ability to read from SharePoint lists has been implemented yet and if so is it possible to provide information on how to do this?


  • 5.  RE: Read Write SharePoint List Data via API

    Employee
    Posted 09-16-2016 02:32

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: awilliams1024

    Hi,

    unfortunately there is no packaged functionality currently available in the product that enables the acquisition/publishing of data from/to SharePoint lists; however it is still a candidate on our roadmap.

    It would be useful to understand which version of SharePoint you would like to integrate with as there are significant differences in the APIs for SharePoint 2010 and SharePoint 2013 (SOAP vs. REST respectively).

    While there is currently no packaged functionality for SharePoint integration, it would be possible to use to create custom library nodes that leverage the HTTP node to access the SharePoint APIs.

    Regards,
    Adrian


  • 6.  RE: Read Write SharePoint List Data via API

    Employee
    Posted 09-19-2016 09:36

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: NWR

    Hello Adrian

    Thanks for the reply

    It appears we are using SharePoint 2007 so may be a bit out of date for the 2010 and 2013.

    I have not had any joy using the HTTP node to pick up any information as of yet so any additional help you can provide is much appreciated


  • 7.  RE: Read Write SharePoint List Data via API

    Employee
    Posted 09-19-2016 09:53

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: NWR

    Thanks Adrian

    We currently use SharePoint 2007 so the 2010 and 2013 options may be no use

    I have not had much joy using the HTTP node so any help is greatly appreciated