Skip to main content

Send your data to Microsoft SharePoint

Use blank export to export your data to MS SharePoint.

Introduction

You can export data from Productsup to Microsoft SharePoint using the Blank Export (empty) and Blank Export (with ID) with one of the following destinations:

  1. MS SharePoint for CSV and XLSX to export CSV and XLSX files.

  2. MS SharePoint for XML to export XML files.

Note

You may need some technical expertise to set up an export to Microsoft SharePoint.

Prerequisites

To use Microsoft SharePoint in Productsup, you need to set up the integration with Productsup:

Step 1: Create an app registration and save the account data for further setup

  1. Go to Microsoft Azure portal.

  2. Go to the Entra ID.

  3. Go to App registrations and create a new registration by taking all the steps in the wizard.

    Tip

    Name your registration Productsup-sharepoint-connector and decide on the supported accounts. A single-tenant should be enough, but this depends on your organisation.

  4. When you created the application, save separately the following details that you will need for the data source setup:

    • Application (client) id for Client Id

    • Directory (tenant) id for Tenant Id.

  5. Go to API permissions from the menu to set the permissions:

    • User.Read

    • Sites.Selected.

  6. Switch on the Grant admin consent for [Company].

  7. Go to Certificates & secrets from the menu and generate a new client secret. Give it a description and set expiry date. Save it as your Client secret for further data source setup.

Step 2: Give the application access to the specific sites

To give an enterprise application or app registration access to a specific site or multiple sites in Productsup, you need to execute a SharePoint PnP PowerShell script. You can use the script provided below as a starting point and ask your internal IT team to adjust it for you.

A CSV file mentioned in the script should contain the following:

  • A list of MS SharePoint site URLs.

  • Your admin account User Principal Name.

  • The app ID or AppDisplayName.

Note

You need the Administrator rights of your MS SharePoint account to execute the script.

# Connecting to the <Company name> SPO Service and importing the SPO PNP Module
Connect-SPOService -URL <InsertTenantSPAdminURL>
Import-Module PnP.PowerShell
##########################################################################################################################
#                                                                                                                        #
# The following part gives the respective Enterprise Application their neccessary rights.                                 #
# It does so by using the .csv file from the previous part as input for sites to give the respective rights for.         #
#                                                                                                                        #
##########################################################################################################################
$SPSitelist = <InsertPathToCSVContainingListOfSPSites>
$ADMAccount = <InsertUsedADMAccount>
$AppID = <InsertAppID>
$Displayname = <InsertAppDisplayname>
foreach ($SPSite in $SPSitelist)
{
    write-output $SPSite
    Set-SPOUser -site $SPSite -LoginName $ADMAccount -IsSiteCollectionAdmin $True -Verbose
    Connect-PnPOnline [yourtenant].sharepoint.com -Interactive -ClientId <client id of your Entra ID Application Registration>
    Grant-PnPAzureADAppSitePermission -AppId $AppID -DisplayName $Displayname -Site $SPSite -Permissions Write -Verbose
    Set-SPOUser -site $SPSite -LoginName $ADMAccount -IsSiteCollectionAdmin $False -Verbose
}

Tip

You can also toggle between Write and Read permission by changing the respective permissions parameter in the foreach loop.

If you need help with providing access, you can contact support@productsup.com.

Set up export for MS SharePoint

To export your data to MS SharePoint, you can use one of the blank export templates:

  • Blank Export (empty) lets you manually create a custom set of attributes in the export stage of Dataflow.

  • Blank Export (with ID) is similar to Blank Export (empty) but has the id attribute pre-defined as a mandatory attribute in the export stage in Dataflow.

The process of setting up the exports Blank Export (empty) and Blank Export (with ID) is similar:

  1. Go to Exports from your site's main menu.

  2. Select Add export.

  3. Select the necessary blank export in the gray banner under the search field.

    Add a Blank Export
  4. Go to Dataflow from the site's main menu and select your blank export from the drop-down menu on the left of the top toolbar.

  5. Map the needed attributes from intermediate to export by dragging a connection from an attribute in the intermediate stage to Drop or Click to add new field in the export stage.

    add new attributes in Dataflow

    Note

    For Blank Export (with ID), the id attribute is the only mandatory attribute. You must connect it with a corresponding attribute in the intermediate stage.

  6. Go to Exports, find your blank export in the list of exports, and toggle its status in the Status column to Active.

  7. Select the name of your blank export in the Export name column.

  8. Select Add Destination, and choose MS SharePoint for CSV and XLSX or MS SharePoint for XML from the drop-down menu. Select Save. See Set up MS SharePoint for CSV and XLSX or Set up MS SharePoint for XML for further setup steps.

    MS SharePoint destinations
  9. Select Export this export in the top-right corner of the page to send your data to the destination. Alternatively, the platform exports the data during the next scheduled run.

Set up MS SharePoint for CSV and XLSX

To set up the destination MS SharePoint for CSV and XLSX, enter your Microsoft SharePoint data from the Prerequisites into the following fields:

  1. In Client ID, enter your MS SharePoint client ID.

  2. In Client Secret, enter our MS SharePoint client secret's value.

    Important

    For an already set-up export.

    If, after some time, you start experiencing the export fail, it can mean that your client secret has expired, and you must update it:

    1. Generate a new client secret in your MS SharePoint account.

    2. Enter the new client secret's value in the Client Secret field. Don't use the Secret ID.

    Leave Client ID unchanged.

  3. In Tenant ID, enter your MS SharePoint tenant ID.

  4. In Upload File Path, add the location path of the file.

  5. In File Name, enter the name of the uploaded file.

  6. In File Type, select the type of the shared file: csv or xlsx.

    Note

    Check if access to the file in MS SharePoint isn't restricted.

  7. Set Active to On, to activate the destination.

  8. Select Save.

    MS SharePoint for CSV and XLSX destination set up

Set up MS SharePoint for XML

To set up the destination MS SharePoint for XML, enter your Microsoft SharePoint data from the Prerequisites into the following fields:

  1. In Client ID, enter your MS SharePoint client ID.

  2. In Client Secret, enter your MS SharePoint client secret's value.

    Important

    For an already set-up export.

    If, after some time, you start experiencing the export fail, it can mean that your client secret has expired, and you must update it:

    1. Generate a new client secret in your MS SharePoint account.

    2. Enter the new client secret's value in the Client Secret field. Don't use the Secret ID.

    Leave Client ID unchanged.

  3. In Tenant ID, enter your MS SharePoint tenant ID.

  4. In Upload URL, add the location URL of the file. The URL should end with one of the following: Shared Documents, Documents, SiteAssets, or Lists. For example, https://example.sharepoint.com/sites/examplesite/Shared Documents/

  5. In Remote Directory, enter a directory inside the Sharepoint Shared Documents, Documents, SiteAssets, or Lists, where the file should be uploaded.

  6. Set Active to On, to activate the destination.

  7. Select Save.

    MS SharePoint for XML destination set up