Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

The instruction below only be used for WorkBook release 13.0 and before where to the old Microsoft authentication method still available. For the newer release, please use please refer to this article Storage Providers > OneDrive for Business (MS OAuth 2.0)

WorkBook integrates with Microsoft OneDrive for Business for document storage. This enables your organizations to use the Microsoft Office365 offerings together with WorkBook. This specific guide will guide you to set up the OneDirve.

...

guide takes you through setup and configuration, plus testing and troubleshooting the connection.

Note

Please notify your implementation consultant if you plan to use Office 365 as storage during installation or consultingyour storage provider, otherwise authentication will fail.

Warning

Certain characters are not allowed in SharePoint so be informed during a test run you might see errors on that specific partyou may see errors relating to this when you run a test.

ON THIS PAGE YOU WILL FIND:

Table of Contents
minLevel2
maxLevel2

...

REQUIREMENTS

...

INSTALLATION & CONFIGURATION

Once you’re ready to Before you start the configuration, please note you need to make sure that you have access to an administrative user within WorkBook as well as on Office 365will need system administrator rights in both WorkBook and Office 365 to complete the installation. The specific user must have full access to the SharePoint site that will host the files WorkBook automatically creates and manages.

Within WorkBook navigate go to:

  • Settings > folders, reports & documents > storage, and folders setup

  • Select the 3rd item “storage provider

  • Create a new storage provider

...

At the bottom of the view fill out the following details:

  • ServiceEndpointUri ( This will be : the full address to your SharePoint site suffixed with /_api/ )

  • ServiceResourceId ( This will be : the domain of your SharePoint installation prefixed with https:// )

...

For example:

ServiceEndpointUri: https://bytangram.sharepoint.com/_api/
ServiceResourceId: https://bytangram.sharepoint.com

  • Once the Endpoint and ResourceId is filled out within WorkBook you can go ahead and press the authenticateicon

  • A In the pop-up will show window (make sure you have enabled pop up for this -ups in your browser) Enter your and enter the Microsoft details for your administrative account and press Next

...

  • Once authenticated you are good to go!

    • You can now enable Office 365 and perform a test to make sure the integration is working as intended.

...

TESTING

After completing the authentication and enabling Office 365 you’re able to Once you have enabled Office 365 and completed the authentication you can test the solution to make sure ensure the connection is established.

  • Test To test the connection by clicking , click on the test storage provider icon and run test

...

TROUBLESHOOTING

IT DOESN’T AUTHENTICATE

If you can’t authenticate correctly you have to make sure that you informed the ByTangram team that you’re using Office 365 and want to integrate storage into it, If you do not you’re not going to be able to connect it

Have you informed your implementation consultant that you are using Office 365 as your storage provider in WorkBook? If not, please inform them so that connection can be setup correctly.

MY TEST CONNECTION FAILS

Some of this

The test

might fail

may fail due to certain characters not allowed in SharePoint.

If your failed testing results

fail in WorkBook

are unrelated to the above, it might be due to incorrect setup, please revisit the options above. If you are still stuck, feel free to contact our support team directly. We will be happy to help you move forward.

Best of luck!

ARTICLE

EXAMPLE TEST DATA

This screenshot is an example of the test that was performed by

the ByTangram team. This information is no longer relevant but might help you in completing

our team and can be used as a reference to help you complete the relevant fields.

Image Modified

NOTHING SHOWS UP IN THE BOTTOM GRID

When you create a new storage provider the bottom grid might not update instantly. If you don’t see anything, please either refresh the page or navigate to a different storage provider and back again. This will refresh the grid and show the settings for it.
Example screenshot

of the issue

:

Image Modified

...

Filter by label (Content by label)
showLabelsfalse
showSpacefalse
cqllabel = "storage-providers" and space = currentSpace ( ) and title !~ "\"Storage Providers > OneDrive for Business\""