How to Pass URL Parameters for QuickSight Filters and Controls?

[ngpinsights]

Hi, I want to programmatically pass parameters to the QuickSight dashboard URL for automating dashboard KPI data . I’m new to QuickSight and need help passing parameters directly in the URL to set default filter values. I have two controls for Start Date and End Date (format: DD-MMM-YYYY), and two filters for:

• Facility: All, ahpb, ohbu, mpb, appolo
• Unit: All, 7b, 8c, 12k, ahpb-05

I tried using a URL like this:

https://us-east-2.quicksight.aws.amazon.com/sn/dashboards/<dashboard_id>#p.Start%20Date=10-Oct-2021

[andres007]

Hello @ngpinsights ,

Welcome to the QuickSight Community!

Based on the documentation , this should work.

What error are you getting? I am not sure about the space in the parameter name, can you remove it and try again? i know spaces in values do work fine.

Passing Parameters with Spaces

Hello QS community, My team is using QuickSight 1 click embedding (unable to use api embedding at the moment) and we are running into issues passing a parameter with a space. Using the qs embedding javascript sdk we were able to pass in parameter values that included a space and they would render correctly on the dashboard. parameters: [ { Name: 'userGroup', Values: userGroups, }, Since we are not able to use the api embedding at…

Thank you!

[ngpinsights]

I am not getting any error but the after hitting the url, the values are not getting selected in the controls.

Tried below URL’s:
1.https://us-west-2.quicksight.aws.amazon.com/sn/dashboards/cab9d5a7-4dda-4bf0-902d-7485f97e61b1#p.StartDate=01-Oct-2021

2.https://us-west-2.quicksight.aws.amazon.com/sn/dashboards/cab9d5a7-4dda-4bf0-902d-7485f97e61b1#p.Start%20Date=01-Oct-2021

Even though after hitting the above URL, the start date is not getting set to value passed in the parameter.

Refer to attachment for controls/fields.

[ngpinsights]

@andres007 , Any update on my query?

[andres007]

Hi @ngpinsights,

Sorry I have not been able to test in my account yet. Can you take a look at this documentation?

Using parameters in a URL - Amazon QuickSight

I beleive you should be passing the data in the formats supported, like:

https://us-east-2.quicksight.aws.amazon.com/sn/dashboards/abc123-abc1-abc2-abc3-abcdefef1234#p.shipdate=2018-09-30%2008:01&p.city=New%20York&p.city=Seattle&p.teamMember=12&p.percentageRank=2.3

Let me know if this works, when can test again with my account I can confirm.

[andres007]

Confirmed, it is because the formate of the date you are using MMM does not work as a parameter, try the date in the formats provided in the documentation. e.g.