Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Solvica
Contributor II
Contributor II

Create a SharePoint Qlik connector via Qlik API

Hi all,

We have automated a process that we repeat at the start of every project in our company. The automation starts with an input form and, with that info, it sets up a space, create/set standard apps/scripts used in every project, creates a sharepoint site... until there all good.

Now, we would like to automate the creation of the SharePoint connector that the apps will use to connect to the new sharepoint site created in a previous step. I plan to do that using a Call URL block.

I have reviewed this post to prepare the request in Postman: https://qlik.dev/manage/data-connections/auth-data-connections. After a number of attempts, I see no success.

My session already has a SharePoint  Access Token that I have requested to MS-Graph in order to create the sharepoint site, so I suppose I can use that one -given that I set up the right scope in graph, as I believe I did-, to identify Qlik against SharePoint during the creation of the new connector.

The headers in my POST request must be OK because I use them in other qlik endpoints and it works.

The endpoint I am using is the one in the documentation: https://{myTennant}.qlikcloud.com/api/v1/dcaas/actions/data-connections

I'm trying now different variations of something like this in the body of my POST request:

 

 

{
    "datasourceID": "rest",
    "connectionName": "Office 365 Sharepoint",
    "space": {spaceIdOfSomeSpaceInMyTennant},
    "connectionProperties": {
        "OAuthMechanism": "1",
        "Catalog": {SomeNameForTHeConection},
        "authCode": {someSuperLongTokenProvidedByMSGraph}
    }
}

 

 

This is the response I get in postman:

 

 

{
    "status": 403,
    "errors": [
        {
            "code": "DCAAS-2001",
            "title": "Data source is not enabled",
            "meta": {
                "description": "datasource 'undefined' not found or is not enabled"
            }
        }
    ]
}

 

 

Orientation will be really appreciated.

Thanks,

Gines

Labels (3)
0 Replies