You can translate the question and the replies:

Optional URL Parameter for HTTP JSON Datasource

Hello, Is there a way to create interpolation variable and make it as an optional for GET Request on HTTP JSON datasource
user
22-08-2021 21:59:04 -0400

1 Answer

Hi, For your scenario, to make the interpolation variable as an optional field, I could use the interpolation function called ExecuteIfIsNotNull. You can use the ExecuteIfIsNotNull interpolation function in the URL of the GET method. For more information about the ^[ExecuteIfIsNotNull](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#using-the-whereexpression-variable) syntax in the WHEREEXPRESSION Variable in the Virtual DataPort Administration Guide. Additionally, if you still need help and if you are a user with valid support access then you can create a support case in [Denodo Support Site](https://support.denodo.com/) so that our support team will assist you further. Hope this helps!
Denodo Team
24-08-2021 06:16:40 -0400
You must sign in to add an answer. If you do not have an account, you can register here