Custom Page / Microsoft Sharepoint Integration

[jsetzer]

Hi AppGineers!

Today it is me, looking for some help or cooperation. I am not asking for Goooooogle-search-terms but I'm looking for experience with Microsoft Sharepoint integration.

Use case

• Custom Page in AppGini
• I've already integrated a PDF-Viewer into one of my custom pages:

  

  chrome_Tin5FldW24.png (129.87 KiB) Viewed 598 times

• Next would be integrating a Sharepoint Document viewer/editor
• Search for existing Sharepoint Documents, filtered by given criteria, using PHP or Javascript/AJAX
• List retrieved data including fields like title, date-fields, document-URL, perhaps some version information
• Load and show a certain document in an <iframe/> container
  or browser tab, if iframe is not possible

What I am looking for:

• Discussion about possibilities, pros and cons.
• Sharepoint Service URLs
• Authentication
• Remote-app authorization
• Retrieving JSON or XML data using AJAX or PHP
• Document URL's
• allow*-settings for <iframe/>-embedding, if possible at all
• Tipps for document-editing (PDF?, Office documents), if possible

Anyone here who can contribute?
Thanks in advance!

[hernan]

Hi,

I only create folders in Sharepoint from AppGini, not viewing documents in AppGini from Sharepoint, but it's related.
I copy a folder structure (used as a templated folder structure for our projects) from one document library to another (the destination library) each time a new project is created in AppGini.

I used the Graph Explorer https://developer.microsoft.com/en-us/g ... h-explorer to define what API endpoints I needed and to obtain some drive ids and folder ids.
I had to previously collect my "drive_ids" and "folder_ids" .
I saved them in my DB, since according to the user group we need different drive_ids and folder_ids.

I also created and registered an app in Azure, at no cost if you have a M365 tenant. Doing this you will define and obtain the ids and secrets needed to connect.

I installed the GraphHelper utility, (from Microsoft) in my AppGini project.

From there it's just a question of calling the right endpoints and fighting with Microsoft documentation.

I don't know how much you already know about,but i leave heare a resource I found useful and may help others:
https://learn.microsoft.com/en-us/graph ... y?tabs=aad

I hope it helps.

[jsetzer]

Thanks for your response and insights.
Gonna read the docs you have provided!