Best Of

@James_Lord totally agree it would be great to have a global setting to adjust this.

You can actually determine whether a card has 'drill to final dataset' turned on by hitting this endpoint: https://{instance}.domo.com/api/content/v1/cards?urns=&parts=domoapp,drillPath,masonData,problems,properties,certification,datasources,dateInfo,drillPathURNs,library,metadata,metadataOverrides,owners,slicers,subscriptions,pages,viewInfo,adminAllPages&includeFiltered=false.

There is a key called "allowTableDrill" that is a boolean to indicate whether drill to final has been disabled.

@James_Lord you are totally right, that endpoint isn't working for me anymore either (but it was working a few years ago).

It's definitely possible to create a report to show which cards allow final drill to table, but it might be a little more involved.

This endpoint will show whether the card has "allowTableDrill" enabled, but you need to pass an individual card Id to it: https://{instance}.domo.com/api/content/v1/cards/template?urns={cardId}.

Using the JSON no code connector and the DomoStats card report, passing the Card ID column using the Dynamic Paramters, you should be able to create a Domo dataset that shows which cards has drill to table enabled.

@James_Lord I'm using "x-domo-developer-token" in the header and passing an access token generated from admin: https://domo-support.domo.com/s/article/360042934494?language=en_US

@James_Lord I think your dynamic parameter and URL are a bit off. Here's what my config looks like: