To GoodData homepage

Topics started by scott.jacobsen

5 Topics

scott.jacobsen
scott.jacobsenParticipating Frequently
asked in SDKs and APIs

Does GD.CN support backchannel logout?

We have a multitenant application with GD dashboards embedded as iframes. Our web app is also the OIDC provider - we don’t use a 3rd party OIDC service. We have an issue where a user can log in to our web app under tenant A, and then they can see the embedded iframe containing tenant A’s data - when they view the iframe they are logged into our GD instance using OIDC. The user can then sign out of our app (their GD session remains signed in however). They then sign in to our app under tenant B. They then view the embedded iframe dashboard  - but they still see tenant A’s dashboard because their good data session as tenant A is still signed in.Does GD support OIDC backchannel logout? I think one solution would be - when a user logs out of our app - we send a backchannel logout to the GD instance as well.I’m open to other suggestions as to how to ensure when a user jumps from one tenant to another we also invalidate their GD login session from the prior tenant.

1
Jan Kos
GoodData Employee
11 months ago
scott.jacobsen
scott.jacobsenParticipating Frequently
asked in SDKs and APIs

actions/workspaces/workspace_id/analyticalDashboards/dashboard_id/managePermissions fails

curl --location 'https://mydomain.cloud.gooddata.com/api/v1/actions/workspaces/<workspace_id>/analyticalDashboards/<dashboard_id>/managePermissions' \--header 'Content-Type: application/json' \--header 'Authorization: Bearer <token>' \--data '[    {        "assigneeIdentifier": {        "id": "bright_funds_dashboard_viewers",        "type": "userGroup"        },        "permissions": ["VIEW"]    }]'Usually results in a 400 bad request error:{    "detail": "[Path '/0'] Object has missing required properties ('id','type')",    "status": 400,    "title": "Bad Request",    "traceId": "c32ef6d240a5fcd0"}but if I mash the button enough times it seems to work /shrug.Also note the json payload documented here: https://www.gooddata.com/developers/cloud-native/doc/cloud/api-and-sdk/api/api_reference_all/#operation/manageDashboardPermissionsDoes not match the format of the json payload documented here: https://www.gooddata.com/developers/cloud-native/doc/cloud/manage-organizatio

1
Moises Morales
GoodData Employee
11 months ago
scott.jacobsen
scott.jacobsenParticipating Frequently
asked in Metrics and MAQL

How do you count records with effective dates

If I have a `users` table with effective dates, so the columns like this:id, start_date, end_dateAnd I want to count the users that were active anytime in a filtered date range in sql I would just doselect count(distinct(id)) from users where start_date <= {end of range} and end_date > {start of range}The values {end of range} and {start of range} would be based on whatever date filter the user selected in the dashboard - for example if they selected YTD {start of range} would be 2023-01-01 and end of range would be 2023-02-20I can’t figure out how to do this in the metrics editor though. Is it possible?

1
Moises Morales
GoodData Employee
1 year ago
scott.jacobsen
scott.jacobsenParticipating Frequently
asked in Data sources

Are materialized views supported on the cloud native platform?

I added some materialized views to my postgres database, but they are not available to my cloud native LDM. Are they supported?

4
jacek
GoodData Employee
1 year ago
scott.jacobsen
scott.jacobsenParticipating Frequently
asked in SDKs and APIs

OIDC silent login failure

Hello, I'm working on setting up OIDC for our gd.cn instance.Unfortunately it isn't working but I can't debug the issue from the GD side.Here is the organization configuration:{    "data": {    "id": "<myorgid>",    "type": "organization",    "attributes": {        "name": "WizeHive",        "hostname": "wizehive.poc.cloud.gooddata.com",        "oauthIssuerLocation": "https://<ourhost.org>/",        "oauthClientId": "jQPiFIaePpt5EQDav00zha_XvPmku2-SltwKcy79-tk",        "oauthClientSecret": "<secret>"    }    }}Much of the login process appears to succeed. Here is a summary of the requests to the OIDC provider:GET /.well-known/openid-configuration200 - OKGET /oauth/authorize?response_type=code&client_id=jQPiFIaePpt5EQDav00zha_XvPmku2-SltwKcy79-tk&scope=openid%20profile&state=RorYXYYc2SsLpFW1w-h9-gjYPQvNxoRRb6Fh6hsjGQY%3D&redirect_uri=https%3A%2F%2Fwizehive.poc.cloud.gooddata.com%2Flogin%2Foauth2%2Fcode%2Fwizehive.poc.cloud.gooddata.com&nonce=M6P7mmX

6
scott.jacobsen
1 year ago
Welcome to the GoodData Community!Cookie settings