You can translate the question and the replies:

How to configure a JSON data source.

Hi, I'm trying to connect to a REST API (https://help.ivanti.com/ht/help/en_US/ISM/2019.1/admin/Content/Configure/API/Get-All-Business-Objects.htm) using Session ID method (auth token) I am able to do it connecting via Postman, but struggling to configure in VDP. Any help appreciated.
user
04-03-2020 19:42:50 -0500
code

2 Answers

Hi, To connect to the REST API using Session ID, I would create two [JSON](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/json_sources/json_sources#json-sources) Data sources/Base views such that I would use the first datasource for 'login' and other one for retrieving the 'data'. * On successful login, the view will return the **Session_key** as one of the output field. * The second data source should be configured to have an **HTTP header** like **‘Authorization = @Sessionkey’**. This way the base view will have a mandatory input parameter (Sessionkey). * Finally, third view (from the second Datasource) for performing a [NESTED join](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/creating_join_views/creating_join_views#creating-join-views) between the aforementioned views using ‘Sessionkey = Session_key’ as join condition. Thus, when a user executes this join view, it will fetch the session_key from the left side of the join and then, once done, it will get the data from the second view. You can have a look at the [HTTP Path](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/http_path#http-path) section of Virtual DataPort Administration Guide for more details. Hope this helps!
Denodo Team
10-03-2020 02:03:52 -0400
code
Your solution did the trick. Brilliiant, thanks.
user
10-03-2020 18:57:06 -0400
You must sign in to add an answer. If you do not have an account, you can register here