How to dynamically change date values in a Web API data source connection (URL)?
In certain instances, it may be necessary to dynamically modify the dates specified in the “From” and “To” fields within a web URL. This can be accomplished through the use of dashboard parameters. The following steps outline how to achieve this functionality:
Step 1: Create Date Type Parameters
First, create date type parameters in any of your existing data sources. Make sure to select the date format that is supported in your web API.
Step 2: Use the Parameter in Your Web API
Next, use this parameter when you create a data source in your web API.
Step 3: Connect the Data Source and Configure the Widgets
Now, connect the data source and configure the widgets. The data will be displayed based on the dashboard parameter.
Step 4: Change the Dashboard Parameter Value
Finally, you can change the dashboard parameter value in preview or while viewing the dashboard. The widgets will then be rendered based on the updated value.
By following these steps, you can dynamically change the date values in your web URL. This allows for greater flexibility and customization in your data visualization and analysis.