Get a list of ALL dashboards with specific fields only

November 12, 2020 21:59

I am trying to build a data set to import into an ElastiCube to see which dashboards a user has access to, among other things. This is about building a DASHBOARDS table.

My GETs all come back with all fields. All I want is: dashboardId, title, shares, owner

api/v1/dashboards?fields=dashboardId,title,owner,shares

returns just the fields I need but only for the one user

api/v1/dashboards/admin?dashboardType=owner&ownerInfo=true&ownershipType=allRoot

returns all the dashboards; but way too much information. How can I limit this to just the fields I need?

Comments

1 comment

Moti Granovsky November 16, 2020 10:22

Hi David, you can use the "fields" argument with the admin endpoint as well:

/api/v1/dashboards/admin?dashboardType=owner&ownerInfo=true&ownershipType=allRoot&fields=dashboardId,title,owner,shares

I get the response structure:

{
    "title": "Sample ECommerce",
    "oid": "5edeac92312bbe002b67a5d1",
    "shares": [
        {
            "shareId": "5ed8f9a3800b79ad85d448cc",
            "type": "user"
        }
    ],
    "owner": "5ed8f9a3800b79ad85d448cc",
    "ownerInfo": {
        "email": "moti.gra@sisense.com",
        "firstName": "moti.gra"
    },
    "ownershipType": "owner"
}

I've tried it out on a relatively old version (L8.0.5), I believe it should work on any other version where the admin endpoint exists.

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?