Azure API - SharePoint

Azure API - SharePoint

This article assumes that you are signed up for Windows Azure. If not, please sign up at https://signup.azure.com
NB: You may need to enter a credit card number, but we don't need you to do anything which costs money, so you won't be charged.

Step 1: Set up the Azure app

Option 1 -  Set up a new Azure app

  1. Go to https://portal.azure.com and click the Azure Active Directory icon
  2. Click App registrations >New registration

    1. Enter a name e.g. “SharePoint spreadsheet reader”, select "Single tenant" option, enter "https://www.contegro.com/AzureApiAuth.ashx" as Web redirect URL, and click Register button:

      If you are going to use an account in another organization to authorize your app, please select Multitenant option.
    2. Take a note of the “Application ID” and Tenant ID values

  3. Click the “API permission”, click "Add a permission" then click "Microsoft Graph" button: 

    1. In the “Request API permissions” section, click the “Delegated permissions” button, search for “Files.Read.All”, tick the "Read all files that user can access" permission, and click "Add permission" button. The app needs this permission to read the content of documents in your Sharepoint sites.

    2. Search for “Sites.Read.All”, tick the "Read items in all site collections" permission, and click "Add permission" button. The app needs this permission to search for documents in your Sharepoint sites.
    3. Your list of configured permissions should look like this:

  4. Click “Certificates & secrets”, click "New client secret", enter the Description for the new app key, set expires duration to "Never", then click Add button:

    Take a note of the new Key value in the Value column:

When the steps above are complete, please go to step 2.

Option 2 – Update an existing Azure app

If you have already set up an app for reading calendar events, we can just add new permissions to it, and then use that app for reading data from spreadsheets

  1. Go to https://portal.azure.com and click the Azure Active Directory icon
  2. Click "App registrations", and then click your existing app
  3. Click the “Authentication” button, enter "https://www.contegro.com/AzureApiAuth.ashx" as Web redirect URL, then update account type if necessary:

    If you use an account in another organization to authorize your app, please select the Multitenant option.
  4. Follow the step 3 in "Step 1 - (Option 1)" section above to add "Read all files that user can access" and "Read items in all site collections" permissions for your app.

When the steps above are complete, please go to step 2.

Step 2 - Connect your SharePoint folder(s) to Vibe

  1. Login to the admin console
    If you have not received a login, please send a request to support@vibe.fyi
  2. Select 'Global Module Settings' in the Contegro Start menu

  3. Open the Azure API global settings, enter your Application ID, Key (client secret) and Tenant ID and click [OK]
    NOTE: We store app client ids and secrets in Azure Key Vault. We use Managed Identity Tokens (https://docs.microsoft.com/en-us/azure/active-directory/managed-identities-azure-resources/overview) to get the values out of Key Vault.

  4. To authenticate your Office 365 account, select Azure API > Settings in the Contegro Start menu

  5. In the Authentications tab:
    1) If you are currently logged into Office 365 (in the same browser session), please logout if you intend to use another account to authenticate the connection between SharePoint and Vibe.fyi.
    2) 
    Please check that pop ups are not blocked in the browser you are using to access the admin console.
    1. Select the [Authenticate new user...] option

    2. Enter a name for the account you'll use to authenticate the connection between SharePoint and Vibe and click [OK]

      A pop up will open and may prompt you to login with your MS Office 365 account. If the pop up does not open, please check that you do not have any active pop up blockers or allow the pop up to open using the browser settings.
    3. Switch back to the first browser tab (Vibe admin console) and check that the confirmation message is showing, then click [OK]

      TIP: You may need to use the refresh button to check that your account is now showing
  6. In Settings, switch to the SharePoint Folders tab, click +New Folder and enter your SharePoint folder URL, then click [SAVE].
    Please remove all other parameters except 'id' before pasting into the URL field, e.g. https://<domainname>.sharepoint.com/<subsite>/<foldername>/Forms/AllItems.aspx?id=

    TIP: You can use a single folder to store all data files or create multiple parent folders.  Please do not create sub folders within a parent.

    Example of an incorrect URL format in which newTargetListUrl and viewpath paramters should be removed...
    https://<domainname>.sharepoint.com/<subsite>/<foldername>/Forms/AllItems.aspx?
    newTargetListUrl=%example;viewpath=%example;
    id=%example

Step 3: Connecting to your SharePoint Site Content

When you open the Azure API module in the Admin Console, you will note that there are several tabs. The SharePoint Site Content tab, allows you to link to relevant SharePoint sites and sort these into groups of related information.

If you have not yet set up SharePoint Site Content, you will need to first set up a New SharePoint Site Group – giving it a name that will be informative to yourself and other users.  The name of the SharePoint Site Group is what will be visible in the drop down menu when you are editing your slide.

Once you have set up your group, add the SharePoint Sites that you will be accessing for your news items, by copying and pasting your site URL. Indicate how many items you would like to pull from this site, e.g. limiting it to the 3 most recent news items.  Remember to save you changes. There will be a 10-15 minute delay while information from the SharePoint sources are made available to your slide template.
Within your slide template, set you Content Source to SharePoint Page Content.  Your slide editor will refresh on the right-hand side pane, now showing the SharePoint Site dropdown menu.  Here you will see the names of the SharePoint Site Groups that you have created.
*If these are not yet visible try waiting a bit longer, or refreshing your Chrome browser for the new content to show. 

 


    • Related Articles

    • Windows Azure: Yammer API

      Step 1 - Create a Yammer app Login into your office 365 account and register a Yammer app at: https://www.yammer.com/client_applications Enter the following details: "Application Name" "Organization" "Support e-mail" "Website" "Redirect URI" - Please ...
    • Windows Azure: Outlook 365 calendar

      This document assumes that you are already signed up for Windows Azure. To sign up, go to https://account.windowsazure.com/SignUp . You may be asked to  enter a credit card number, but we don't need you to do anything which costs money, so you won't ...
    • Azure AD Single Sign-On (SSO)

      Streamline access for all of your Vibe.fyi users. Setup Azure SSO today so they can use their Microsoft credentials to login on any device, on any supported browser, without risking security. Step 1 - Create Azure user groups and assign users There ...
    • MicroStrategy API

      Connect MicroStrategy to Vibe To connect your raw MicroStrategy report JSON to Vibe, please follow the steps below: Create an active account for 'Vibe' and allow access to your PROD & DEV pages Supply the following information to support@vibe.fyi. ...
    • Google API - Google Sheets

      Our Google API module helps you to connect your Google Sheets data to your digital signage. NB: The Vibe.fyi support team can setup and add a Google Sheets API client ID & secret on your behalf. If your preference is to manage your own Google Sheets ...