How to capture clicked value out of table?

Q&A
, ,
1

I’m using embedded analytics and user sees data in table format. Assume that user clicks on one of the value, we would like to capture the value and fire another API call using that value as one of the parameter.

In other words,
I want to know if there is an event that will be fired when the user clicks.

Can we do this?

2

Hi @tbdori,
You can use a navigation action on a table to update a parameter based on a field value in the table. If you do that, it should trigger an event that would say the parameter value is changed. That would be your best bet to get that updated value after the user sets it with the action.

Thank you!

3

My goal is to capture the clicked value from the event, and then call 3rd third-party API using POST.
Thus, I can’t use URL action as it only supports GET.
Plus, I’m not interested in navigating to other sheets/visual here.

4

Hi @tbdori,
Use Navigation Action to set a parameter value on the click of the visual. You don’t actually have to use it to navigate to another sheet, but you need an action to apply a value to a parameter.

Then, you can use the GetParameter operation to retrieve the set value which you can then use in a third party API call. That will be the best way to accomplish this.

5

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community!

8

Hi @tbdori,
Instead of using an API call like I mentioned previously, you could use the onMessage event handler in the contentOptions portion of the embedding process. This will allow you to track each of the parameters within the application and would alert the front-end when the navigation action updates the parameter value.

Look for the below section here for context.

 case 'PARAMETERS_CHANGED': {
                                console.log("Parameters changed. Changed parameters:",     messageEvent.message.changedParameters);
                                break;
                            }

I’ll go ahead and mark this as the solution but let me know if you have any additional questions!