Create a SharePoint Qlik connector via Qlik API

Solvica — Fri, 15 Nov 2024 21:22:54 GMT

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

topic Create a SharePoint Qlik connector via Qlik API in Qlik Automate

Create a SharePoint Qlik connector via Qlik API