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 ( using Session ID method (auth token) I am able to do it connecting via Postman, but struggling to configure in VDP. Any help appreciated.
04-03-2020 19:42:50 -0500

2 Answers

Hi, To connect to the REST API using Session ID, I would create two [JSON]( 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]( 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]( section of Virtual DataPort Administration Guide for more details. Hope this helps!
Denodo Team
10-03-2020 02:03:52 -0400
Your solution did the trick. Brilliiant, thanks.
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