Solved

Update Variable Value dynamically

  • 13 October 2021
  • 1 reply
  • 100 views

Hello I am using GoodData for our application. My question is related to variable and update its value dynamically.

I will explain you what I have done so far.
I have created variable with name organisation_id and set type to filter variable and selected attribute as a id column of one of our database table (Please check attached image - 1)
After that I have set user-specific value for that variable 
e.g. organisation_id = 12, 34, 56 etc.

After that I have create custom matrix and use this variable in MAQL
e.g. 
SELECT COUNT(id) WHERE organisation_id
(Please check attached image - 2)


And then I have added this matrix in insights and in the widget and it filter the data which related to value of organisation_id variable i.e. it only display data related to id - 12, 34, 56 

My Question is:
Can we update variable value using API?

like in above example we set organisation_id = 12, 34, 56

now I want to update organisation_id = 89, 90 and get result related to 89 and 90

Instead of updating organisation_id value from variable setting can we update it using API?

**I embedded the dashboard using iframe**
basically before loading iframe can we update variable value using any inbuilt API of GoodData instead of updating it manually from variable setting page?

icon

Best answer by Joseph Heun 13 October 2021, 11:16

View original

1 reply

Userlevel 3

Updating a Variable can be done through API as mentioned here: 

https://help.gooddata.com/api#/reference/dashboards-and-reporting/create-a-variable/update-a-variable-value

Reply