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: 
APiccoli
Employee
Employee

Consume Data Products Dataset with oData API

The recent release of Data Product embeds the ability to let external systems and business partner to consume Data-Set trough an oData API.

References

To enable the possibility to consume oData you need to create a Data Product -  Working with data products.

This gives you immediately the ability to share the data included on DATA Product  through an oData API endpoint

APiccoli_0-1778596750896.png

The menu open a page that provides you the API end point for each Data Set o the Data Product

APiccoli_1-1778596750898.png

and down the window you can fide the details on using the API, pagination , query parameters ….

APiccoli_2-1778596750899.png

APiccoli_3-1778596750899.png

each Data Set has his own API endpoint so is possible to use a single space for sharing to multiple parties, depending on the enforcement of your security policies.

Authentication and Authorization

The authentication is based to an API-Key that you need to provide during the rest call in the header with the common couple

authorization :  Bearer eyxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

APiccoli_4-1778596750899.png

The better, modern, and secure way to provide this Authorization Key is by using a Qlik Cloud oAuth2 configuration. References are on the help Creating and managing OAuth clients

Create an oAuth configuration with the minimum permissions required

APiccoli_5-1778596750900.png

APiccoli_6-1778596750901.png

Select

Client Type “Web”

APiccoli_7-1778596750901.png

Give a name, better if clearly refer to the external system or business partner to easily manage, disable, delete the configuration and then select as authorization "Scopes" “user_default” that provides Full access to your account and content

APiccoli_8-1778596750902.png

and then add also “dataproduct:consume” thar provide the ability to Read and consume data products.

APiccoli_9-1778596750902.png

Select “Allow Machine-to-Machine (M2M)”

APiccoli_10-1778596750903.png

Saving the configuration, it will provide oAuth Client and Client Secret that must be saved and keep in a safe place

APiccoli_11-1778596750904.png

and last, we need to set the Consent method as trust 

APiccoli_12-1778596750904.png

User permission:

 The first API call run using the oAuth2 credential (equal to a first user access ) will create and user with the name  of the of the oauth2 configuration
 APiccoli_13-1778596750905.png

You need to assign to the user the role you have created to consume Data Products, or having this role assigned it to all users.
You need to assign “Can Consume Data”  permission on both Spaces the one where resides the Data-Set included on the Data Product and the one where you have Activated the Data Product.

APiccoli_14-1778596750905.png

 

APiccoli_15-1778596750906.png

Finally you can provide the correct endpoints and oAut2 credentials to your business partner. to access the data.

References:

Labels (1)
0 Replies