You can translate the question and the replies:

expired token while retreiving data

Hello Team, i have an issue retreiving data from an api , because the token expiry time excced the time to retreive all the data , a huge table. we lunch the request so after 30 min the token expire so the request get interrupted. we alreade raised the time for the token from 15 to 30. and it seems that is not the solution. we already use the pagination to retreive 10000 rows. Thank you in advance
user
28-10-2021 13:33:48 -0400
code

1 Answer

Hi, In general, if a query takes more time to retrieve the data from the source API, then the token expiration time needs to be changed accordingly since it will use the opened connection to process the entire request. For example, if my query requires one hour to process the entire data from the API, then I would change the expiration time of the token to more than one hour for retrieving all the rows without any errors. To increase the token expiration time, I would do the following steps: * Open the required data source from the Virtual DataPort and in the **"Authentication"** tab for OAuth authentication, increase the **"Access Token expires in"** time with the required value. * Save the data source for the changes to take effect. For more information, you could also refer to the section [OAuth Authentication](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/http_path#oauth-authentication) of Virtual DataPort Administration Guide. If the issue persists, I would check the **vdp.log** file available in the <DENODO_HOME>\logs\vdp\ folder to get more information about the error. Hope this helps!!
Denodo Team
29-10-2021 08:46:01 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here