auth = dmda.DomoTokenAuth(
domo_instance=os.environ['DOMO_INSTANCE'],
domo_access_token=os.environ["DOMO_ACCESS_TOKEN"],
)
await auth.print_is_token()🎉 token_auth token retrieved from domo-community ⚙️TrueDataCenter
a class based approach to searching the datacenter
DomoDatacenter
DomoDatacenter (auth:domolibrary.client.DomoAuth.DomoAuth=None)
class for quering entities in the datacenter
sample implementation of search_datacenter
additional_filters_ls = [
datacenter_routes.generate_search_datacenter_filter(
"dataprovidername_facet", "Jupyter Data"
)
]
res = await DomoDatacenter.search_datacenter(
auth=auth,
# additional_filters_ls=additional_filters_ls,
# search_text="*kb*",
entity_type=datacenter_routes.Datacenter_Enum.DATASET.value,
)
dataset_id = res[0]['databaseId']
pd.DataFrame(res[0:5])| entityType | databaseId | searchId | createDate | lastModified | lastIndexed | highlightedFields | language | requestAccess | score | ... | used | owners | ownersLocalized | cloudName | cloudId | winnerText | systemTagFields | ownedByType | customer | transportType | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | dataset | da552832-c04d-46ac-936a-f982d9d3f2e6 | {'indexName': None, 'databaseId': 'da552832-c0... | 1675366713000 | 1738167477000 | 1738167718121 | {} | English | False | 3009.00000 | ... | False | [{'id': '1893952720', 'type': 'USER', 'display... | {'localizedMessage': 'Jae Wilson1', 'count': 1} | Domo | domo | SalesProject01_hello world_INT * | [system_tags] | USER | mmmm-0012-0200 | NaN |
| 1 | dataset | b78ce093-28df-4af9-abbf-679e2d2fb341 | {'indexName': None, 'databaseId': 'b78ce093-28... | 1711462699000 | 1738252685000 | 1738253213145 | {} | English | False | 311.99368 | ... | False | [{'id': '29257675', 'type': 'USER', 'displayNa... | {'localizedMessage': 'Shivam Desai - BTP', 'co... | Domo | domo | DEV | NBA Swish Central v2 | [system_tags] | USER | mmmm-0012-0200 | API |
| 2 | dataset | 91cd5172-0d76-4189-a747-526b4cedbf34 | {'indexName': None, 'databaseId': '91cd5172-0d... | 1738086823000 | 1738163953000 | 1738165072316 | {} | English | False | 168.57076 | ... | False | [{'id': '1728973208', 'type': 'USER', 'display... | {'localizedMessage': 'Peter Shull', 'count': 1} | Domo | domo | Example Sales Data | [system_tags] | USER | mmmm-0012-0200 | WEBFORM |
| 3 | dataset | 20b70c3e-4b35-4661-b3ce-1e45f1a88183 | {'indexName': None, 'databaseId': '20b70c3e-4b... | 1723755561000 | 1738084497000 | 1738084826873 | {} | English | False | 133.76259 | ... | False | [{'id': '29257675', 'type': 'USER', 'displayNa... | {'localizedMessage': 'Shivam Desai - BTP', 'co... | Domo | domo | DEV | WNBA Swish Central v2 | [system_tags] | USER | mmmm-0012-0200 | NaN |
| 4 | dataset | 7c307366-ae67-482d-b063-05c4361d5a35 | {'indexName': None, 'databaseId': '7c307366-ae... | 1709328995000 | 1738082906000 | 1738082938090 | {} | English | False | 120.52569 | ... | False | [{'id': '29257675', 'type': 'USER', 'displayNa... | {'localizedMessage': 'Shivam Desai - BTP', 'co... | Domo | domo | [1947-2024] NBA Playoff Records | [system_tags] | USER | mmmm-0012-0200 | WEBFORM |
5 rows × 48 columns
sample implementation search_datasets
additional_filters_ls = [
generate_search_datacenter_filter(
"dataprovidername_facet", "Jupyter Data"
)
]
(await DomoDatacenter.search_datasets(
auth=auth,
# search_text="*kb*",
# additional_filters_ls=additional_filters_ls,
))[0:5][DomoDataset(id='da552832-c04d-46ac-936a-f982d9d3f2e6', display_type='api', data_provider_type=None, name='SalesProject01_hello world_INT *', description=None, row_count=0, column_count=0, stream_id=None, owner={'id': '1893952720', 'name': 'Jae Wilson1', 'type': 'USER', 'group': False}, formula={}, Schema=DomoDataset_Schema(dataset_id='da552832-c04d-46ac-936a-f982d9d3f2e6', columns=[]), Stream=DomoStream(id=None, dataset_id='da552832-c04d-46ac-936a-f982d9d3f2e6', transport_description=None, transport_version=None, update_method=None, data_provider_name=None, data_provider_key=None, account_id=None, account_display_name=None, account_userid=None, has_mapping=False, configuration=[], configuration_tables=[], configuration_query=None), Tags=DomoTags(tag_ls=['provider_type : api *', 'proj_phase : 01 *', 'proj_name : SalesProject *', 'ds_type : INT *']), PDP=<domolibrary.classes.DomoPDP.Dataset_PDP_Policies object at 0x7ce4116f44d0>, Certification=None),
DomoDataset(id='b78ce093-28df-4af9-abbf-679e2d2fb341', display_type='DataFlow', data_provider_type=None, name='DEV | NBA Swish Central v2', description=None, row_count=40463, column_count=100, stream_id=1925, owner={'id': '29257675', 'name': 'Shivam Desai - BTP', 'type': 'USER', 'group': False}, formula={'calculation_d8cc4e08-07b4-4724-a4b0-63ba1b1dc7fe': {'templateId': 3987, 'id': 'calculation_d8cc4e08-07b4-4724-a4b0-63ba1b1dc7fe', 'name': 'BPG', 'formula': 'IFNULL(`Blocks/Game`, (`Blocks` / `Games Played`))', 'status': 'VALID', 'dataType': 'DOUBLE', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Blocks/Game`', 'columnPosition': 7}, {'columnName': '`Blocks`', 'columnPosition': 23}, {'columnName': '`Games Played`', 'columnPosition': 34}], 'variable': False}, 'calculation_cbd3295c-6d0f-474b-9dbb-9ef6e982bab2': {'templateId': 3996, 'id': 'calculation_cbd3295c-6d0f-474b-9dbb-9ef6e982bab2', 'name': 'Series Filter', 'formula': "CASE\n\n\t\tWHEN DOMO_BEAST_MODE(3993) = 'Finals' THEN \n CASE WHEN `F` = 'x' THEN `Full Team Name` END\n \n \tWHEN DOMO_BEAST_MODE(3993) = 'EC Finals' THEN \n CASE WHEN `ECF` = 'x' THEN `Full Team Name` END\n \n WHEN DOMO_BEAST_MODE(3993) = 'WC Finals' THEN \n CASE WHEN `WCF` = 'x' THEN `Full Team Name` END\n \n \tWHEN DOMO_BEAST_MODE(3993) = 'EC Semi Finals' THEN \n CASE WHEN `ECSF` = 'x' THEN `Full Team Name` END\n \n \tWHEN DOMO_BEAST_MODE(3993) = 'WC Semi Finals' THEN \n CASE WHEN `WCSF` = 'x' THEN `Full Team Name` END\n \n \tWHEN DOMO_BEAST_MODE(3993) = 'EC First Round' THEN \n CASE WHEN `ECFR` = 'x' THEN `Full Team Name` END\n \n \tWHEN DOMO_BEAST_MODE(3993) = 'WC First Round' THEN \n CASE WHEN `WCFR` = 'x' THEN `Full Team Name` END\n \nEND\n\t\n", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`F`', 'columnPosition': 70}, {'columnName': '`Full Team Name`', 'columnPosition': 85}, {'columnName': '`ECF`', 'columnPosition': 181}, {'columnName': '`Full Team Name`', 'columnPosition': 198}, {'columnName': '`WCF`', 'columnPosition': 301}, {'columnName': '`Full Team Name`', 'columnPosition': 318}, {'columnName': '`ECSF`', 'columnPosition': 419}, {'columnName': '`Full Team Name`', 'columnPosition': 437}, {'columnName': '`WCSF`', 'columnPosition': 538}, {'columnName': '`Full Team Name`', 'columnPosition': 556}, {'columnName': '`ECFR`', 'columnPosition': 657}, {'columnName': '`Full Team Name`', 'columnPosition': 675}, {'columnName': '`WCFR`', 'columnPosition': 776}, {'columnName': '`Full Team Name`', 'columnPosition': 794}], 'variable': False}, 'calculation_0d54b3dc-d779-4df7-b66b-ca588b46b954': {'templateId': 4065, 'id': 'calculation_0d54b3dc-d779-4df7-b66b-ca588b46b954', 'name': 'Logo 2', 'formula': 'CASE WHEN MAX(`SZN2`) THEN CONCAT(\'<img src="\', `Logo URL`, \'"style="width:auto;height:auto"></>\') END', 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': True, 'bignumber': False, 'columnPositions': [{'columnName': '`SZN2`', 'columnPosition': 14}, {'columnName': '`Logo URL`', 'columnPosition': 48}], 'variable': False}, 'calculation_1e52ba73-d76d-4d24-9ce6-b55db0ae3bf6': {'templateId': 4056, 'id': 'calculation_1e52ba73-d76d-4d24-9ce6-b55db0ae3bf6', 'name': 'FT%', 'formula': 'SUM(`Free Throws Made`) / SUM(`Free Throw Attempts`)', 'status': 'VALID', 'dataType': 'DECIMAL', 'persistedOnDataSource': True, 'isAggregatable': True, 'bignumber': False, 'columnPositions': [{'columnName': '`Free Throws Made`', 'columnPosition': 4}, {'columnName': '`Free Throw Attempts`', 'columnPosition': 30}], 'variable': False}, 'calculation_c54ebaa4-3a3f-48ff-9a17-e7ca9b0ef776': {'templateId': 4063, 'id': 'calculation_c54ebaa4-3a3f-48ff-9a17-e7ca9b0ef776', 'name': 'Playoff Appearances?', 'formula': 'COUNT(DISTINCT `Player ID`)', 'status': 'VALID', 'dataType': 'LONG', 'persistedOnDataSource': True, 'isAggregatable': True, 'bignumber': False, 'columnPositions': [{'columnName': '`Player ID`', 'columnPosition': 15}], 'variable': False}, 'calculation_17d4bb0d-a802-4f92-9404-98573e4bb804': {'templateId': 3995, 'id': 'calculation_17d4bb0d-a802-4f92-9404-98573e4bb804', 'name': 'Conference Adjustment', 'formula': "CASE \n\n\tWHEN `Team` = 'NJN' OR `Team` = 'WSB'\n THEN 'Eastern'\n \n WHEN `Team` = 'SEA' OR `Team` = 'VAN' OR `Team` = 'KCK' OR `Team` = 'SDC'\n THEN 'Western'\n \n WHEN `Team` = 'NOH' OR `Team` = 'NOK'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 2004\n \t\t\tTHEN 'Western'\n ELSE 'Eastern'\n END\n \n WHEN `Team` = 'MIA'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 1989\n \t\t\tTHEN 'Eastern'\n ELSE 'Western'\n END\n \n WHEN `Team` = 'HOU' OR `Team` = 'SAS'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 1980\n \t\t\tTHEN 'Western'\n ELSE 'Eastern'\n END\n \n WHEN `Team` = 'MIL' OR `Team` = 'CHI'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 1980\n \t\t\tTHEN 'Eastern'\n ELSE 'Western'\n END\n \n WHEN `Team` = 'BAL'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 1968\n \t\t\tTHEN 'Eastern'\n ELSE 'Western'\n END\n \n WHEN `Team` = 'CIN'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 1962\n \t\t\tTHEN 'Eastern'\n ELSE 'Western'\n END\n \n WHEN `Team` = 'ATL'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 1977\n \t\t\tTHEN 'Eastern'\n ELSE 'Western'\n END\n \n WHEN `Team` = 'DET'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 1983\n \t\t\tTHEN 'Eastern'\n ELSE 'Western'\n END\n \n ELSE `Conference`\n\nEND", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Team`', 'columnPosition': 13}, {'columnName': '`Team`', 'columnPosition': 31}, {'columnName': '`Team`', 'columnPosition': 79}, {'columnName': '`Team`', 'columnPosition': 97}, {'columnName': '`Team`', 'columnPosition': 115}, {'columnName': '`Team`', 'columnPosition': 133}, {'columnName': '`Team`', 'columnPosition': 181}, {'columnName': '`Team`', 'columnPosition': 199}, {'columnName': '`SZN1`', 'columnPosition': 245}, {'columnName': '`Team`', 'columnPosition': 344}, {'columnName': '`SZN1`', 'columnPosition': 390}, {'columnName': '`Team`', 'columnPosition': 489}, {'columnName': '`Team`', 'columnPosition': 507}, {'columnName': '`SZN1`', 'columnPosition': 553}, {'columnName': '`Team`', 'columnPosition': 653}, {'columnName': '`Team`', 'columnPosition': 671}, {'columnName': '`SZN1`', 'columnPosition': 717}, {'columnName': '`Team`', 'columnPosition': 826}, {'columnName': '`SZN1`', 'columnPosition': 872}, {'columnName': '`Team`', 'columnPosition': 972}, {'columnName': '`SZN1`', 'columnPosition': 1018}, {'columnName': '`Team`', 'columnPosition': 1127}, {'columnName': '`SZN1`', 'columnPosition': 1173}, {'columnName': '`Team`', 'columnPosition': 1273}, {'columnName': '`SZN1`', 'columnPosition': 1319}, {'columnName': '`Conference`', 'columnPosition': 1418}], 'variable': False}, 'calculation_b1e5e805-090a-47b1-b30e-1e979a39bcc0': {'templateId': 3999, 'id': 'calculation_b1e5e805-090a-47b1-b30e-1e979a39bcc0', 'name': 'List of All Defensive Players', 'formula': "CASE \n\n\tWHEN `All Defensive?` = 'Yes' \n \n \tTHEN CASE\n\n\t\tWHEN DOMO_BEAST_MODE(3846) = '1st Team'\n \tTHEN CASE WHEN `All-Defensive 1st Team?` = 'x' THEN `Player` END\n \n \tWHEN DOMO_BEAST_MODE(3846) = '2nd Team'\n \tTHEN CASE WHEN `All-Defensive 2nd Team?` = 'x' THEN `Player` END\n \t\n END\n \nEND\n\t", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`All Defensive?`', 'columnPosition': 13}, {'columnName': '`All-Defensive 1st Team?`', 'columnPosition': 121}, {'columnName': '`Player`', 'columnPosition': 158}, {'columnName': '`All-Defensive 2nd Team?`', 'columnPosition': 241}, {'columnName': '`Player`', 'columnPosition': 278}], 'variable': False}, 'calculation_89c666dd-3c88-4ec4-8152-429a3ffed30c': {'templateId': 3989, 'id': 'calculation_89c666dd-3c88-4ec4-8152-429a3ffed30c', 'name': 'Stat', 'formula': "(CASE WHEN (DOMO_BEAST_MODE(3848) = 'Points') THEN `Points` WHEN (DOMO_BEAST_MODE(3848) = 'Assists') THEN `Assists` WHEN (DOMO_BEAST_MODE(3848) = 'Rebounds') THEN `Total Rebounds` WHEN (DOMO_BEAST_MODE(3848) = 'Steals') THEN `Steals` WHEN (DOMO_BEAST_MODE(3848) = 'Blocks') THEN `Blocks` END)", 'status': 'VALID', 'dataType': 'LONG', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Points`', 'columnPosition': 51}, {'columnName': '`Assists`', 'columnPosition': 106}, {'columnName': '`Total Rebounds`', 'columnPosition': 163}, {'columnName': '`Steals`', 'columnPosition': 225}, {'columnName': '`Blocks`', 'columnPosition': 279}], 'variable': False}, 'calculation_5105ab71-c8dc-44a7-a632-d955fcbb6891': {'templateId': 4094, 'id': 'calculation_5105ab71-c8dc-44a7-a632-d955fcbb6891', 'name': 'Team Championships', 'formula': "COUNT(CASE \n \tWHEN `Series` = 'F' AND `PO WINS` = 4 THEN `Team`\n END)", 'status': 'VALID', 'dataType': 'LONG', 'persistedOnDataSource': True, 'isAggregatable': True, 'bignumber': False, 'columnPositions': [{'columnName': '`Series`', 'columnPosition': 24}, {'columnName': '`PO WINS`', 'columnPosition': 43}, {'columnName': '`Team`', 'columnPosition': 62}], 'variable': False}, 'calculation_ed7c0742-8321-4dd4-a74e-fd92cdbebdd3': {'templateId': 4002, 'id': 'calculation_ed7c0742-8321-4dd4-a74e-fd92cdbebdd3', 'name': 'FILTER - Games Played', 'formula': "CASE \n\t\tWHEN \n \tDOMO_BEAST_MODE(4001) = '65+ Games Played'\n THEN CASE WHEN `Games Played` >= 65 THEN 'Keep'\n ELSE 'Filter Out' END\n \n WHEN \n DOMO_BEAST_MODE(4001) = '50+ Games Played'\n THEN CASE WHEN `Games Played` >= 50 THEN 'Keep'\n ELSE 'Filter Out' END\n \n WHEN\n DOMO_BEAST_MODE(4001) = 'Any Games Played'\n THEN CASE WHEN `Games Played` >= 1 THEN 'Keep'\n ELSE 'Filter Out' END\nEND\n ", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Games Played`', 'columnPosition': 93}, {'columnName': '`Games Played`', 'columnPosition': 265}, {'columnName': '`Games Played`', 'columnPosition': 436}], 'variable': False}, 'calculation_a66bbbce-7778-44c7-96a8-340f12ae5766': {'templateId': 4096, 'id': 'calculation_a66bbbce-7778-44c7-96a8-340f12ae5766', 'name': 'Team Playoff Appearances', 'formula': "COUNT(CASE \n \tWHEN `SZN2` >= 1975 AND `SERIES` IN ('WCFR','ECFR') THEN `TEAM`\n WHEN `SZN2` < 1975 AND `SZN2` >= 1949 AND `SERIES` IN ('WCSF','ECSF') THEN `TEAM`\n WHEN `SZN2` < 1949 AND `SERIES` IN ('QF') THEN `TEAM`\n\n END)", 'status': 'VALID', 'dataType': 'LONG', 'persistedOnDataSource': True, 'isAggregatable': True, 'bignumber': False, 'columnPositions': [{'columnName': '`SZN2`', 'columnPosition': 24}, {'columnName': '`SERIES`', 'columnPosition': 43}, {'columnName': '`TEAM`', 'columnPosition': 76}, {'columnName': '`SZN2`', 'columnPosition': 96}, {'columnName': '`SZN2`', 'columnPosition': 114}, {'columnName': '`SERIES`', 'columnPosition': 133}, {'columnName': '`TEAM`', 'columnPosition': 166}, {'columnName': '`SZN2`', 'columnPosition': 186}, {'columnName': '`SERIES`', 'columnPosition': 204}, {'columnName': '`TEAM`', 'columnPosition': 228}], 'variable': False}, 'calculation_40f0f271-3e56-4ee1-ae78-a2a12f5d527e': {'templateId': 4055, 'id': 'calculation_40f0f271-3e56-4ee1-ae78-a2a12f5d527e', 'name': '3P%', 'formula': 'SUM(`3-Pointers Made`) / SUM(`3-Pointer Attempts`)', 'status': 'VALID', 'dataType': 'DECIMAL', 'persistedOnDataSource': True, 'isAggregatable': True, 'bignumber': False, 'columnPositions': [{'columnName': '`3-Pointers Made`', 'columnPosition': 4}, {'columnName': '`3-Pointer Attempts`', 'columnPosition': 29}], 'variable': False}, 'calculation_b210d5fd-d32b-4efe-8125-8a40dc4e8a9c': {'templateId': 4345, 'id': 'calculation_b210d5fd-d32b-4efe-8125-8a40dc4e8a9c', 'name': 'FILTER - Season by Era (SZN1)', 'formula': "CASE \n\n\tWHEN DOMO_BEAST_MODE(4067) = 'Modern Era'\n THEN \n \tCASE WHEN DOMO_BEAST_MODE(4069) = 'Modern' THEN `SZN1`\n END\n \n WHEN DOMO_BEAST_MODE(4067) = 'Dynasty Era'\n THEN \n \tCASE WHEN DOMO_BEAST_MODE(4069) = 'Dynasty' THEN `SZN1`\n END\n \n WHEN DOMO_BEAST_MODE(4067) = 'Jordan Era'\n THEN \n \tCASE WHEN DOMO_BEAST_MODE(4069) = 'Jordan' THEN `SZN1`\n END\n \n WHEN DOMO_BEAST_MODE(4067) = 'Magic/Bird Era'\n THEN \n \tCASE WHEN DOMO_BEAST_MODE(4069) = 'Rivalry' THEN `SZN1`\n END\n \n WHEN DOMO_BEAST_MODE(4067) = 'Expansion Era' \n THEN \n \tCASE WHEN DOMO_BEAST_MODE(4069) = 'Expansion' THEN `SZN1`\n END \n \n WHEN DOMO_BEAST_MODE(4067) = 'Bill Russell Era'\n THEN \n \tCASE WHEN DOMO_BEAST_MODE(4069) = 'Russell' THEN `SZN1`\n END\n\n WHEN DOMO_BEAST_MODE(4067) = 'Early Years'\n THEN \n \tCASE WHEN DOMO_BEAST_MODE(4069) = 'Early' THEN `SZN1`\n END\n \n ELSE `SZN1`\n \nEND", 'status': 'VALID', 'dataType': 'LONG', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`SZN1`', 'columnPosition': 113}, {'columnName': '`SZN1`', 'columnPosition': 252}, {'columnName': '`SZN1`', 'columnPosition': 389}, {'columnName': '`SZN1`', 'columnPosition': 531}, {'columnName': '`SZN1`', 'columnPosition': 675}, {'columnName': '`SZN1`', 'columnPosition': 820}, {'columnName': '`SZN1`', 'columnPosition': 949}, {'columnName': '`SZN1`', 'columnPosition': 986}], 'variable': False}, 'calculation_b003286d-5dd7-437a-8e6f-40f5880adf10': {'templateId': 3986, 'id': 'calculation_b003286d-5dd7-437a-8e6f-40f5880adf10', 'name': 'PPG', 'formula': 'IFNULL(`Points/Game`, (`Points` / `Games Played`))', 'status': 'VALID', 'dataType': 'DOUBLE', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Points/Game`', 'columnPosition': 7}, {'columnName': '`Points`', 'columnPosition': 23}, {'columnName': '`Games Played`', 'columnPosition': 34}], 'variable': False}, 'calculation_04c376fa-6446-4220-bd58-d0f3c75c8fb2': {'templateId': 3979, 'id': 'calculation_04c376fa-6446-4220-bd58-d0f3c75c8fb2', 'name': 'Logo', 'formula': 'CONCAT(\'<img src="\', `Logo URL`, \'"style="width:auto;height:auto"></>\')', 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Logo URL`', 'columnPosition': 21}], 'variable': False}, 'calculation_6a74036d-1845-4d80-a5ea-eab9a591ee17': {'templateId': 3980, 'id': 'calculation_6a74036d-1845-4d80-a5ea-eab9a591ee17', 'name': 'List of All NBA Players', 'formula': "(CASE WHEN (`All NBA?` = 'Yes') THEN (CASE WHEN (DOMO_BEAST_MODE(4346) = '1st Team') THEN (CASE WHEN (`All-NBA 1st Team?` = 'x') THEN `Player` END) WHEN (DOMO_BEAST_MODE(4346) = '2nd Team') THEN (CASE WHEN (`All-NBA 2nd Team?` = 'x') THEN `Player` END) WHEN (DOMO_BEAST_MODE(4346) = '3rd Team') THEN (CASE WHEN (`All-NBA 3rd Team?` = 'x') THEN `Player` END) END) END)", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`All NBA?`', 'columnPosition': 12}, {'columnName': '`All-NBA 1st Team?`', 'columnPosition': 102}, {'columnName': '`Player`', 'columnPosition': 134}, {'columnName': '`All-NBA 2nd Team?`', 'columnPosition': 207}, {'columnName': '`Player`', 'columnPosition': 239}, {'columnName': '`All-NBA 3rd Team?`', 'columnPosition': 312}, {'columnName': '`Player`', 'columnPosition': 344}], 'variable': False}, 'calculation_31a8c77e-dafc-4155-89d5-fe458fe71b39': {'templateId': 4068, 'id': 'calculation_31a8c77e-dafc-4155-89d5-fe458fe71b39', 'name': 'FILTER - Season by Era', 'formula': "CASE \n\n\tWHEN DOMO_BEAST_MODE(4067) = 'Modern Era'\n THEN \n \tCASE WHEN DOMO_BEAST_MODE(4069) = 'Modern' THEN `Season`\n END\n \n WHEN DOMO_BEAST_MODE(4067) = 'Dynasty Era'\n THEN \n \tCASE WHEN DOMO_BEAST_MODE(4069) = 'Dynasty' THEN `Season`\n END\n \n WHEN DOMO_BEAST_MODE(4067) = 'Jordan Era'\n THEN \n \tCASE WHEN DOMO_BEAST_MODE(4069) = 'Jordan' THEN `Season`\n END\n \n WHEN DOMO_BEAST_MODE(4067) = 'Magic/Bird Era'\n THEN \n \tCASE WHEN DOMO_BEAST_MODE(4069) = 'Rivalry' THEN `Season`\n END\n \n WHEN DOMO_BEAST_MODE(4067) = 'Expansion Era' \n THEN \n \tCASE WHEN DOMO_BEAST_MODE(4069) = 'Expansion' THEN `Season`\n END \n \n WHEN DOMO_BEAST_MODE(4067) = 'Bill Russell Era'\n THEN \n \tCASE WHEN DOMO_BEAST_MODE(4069) = 'Russell' THEN `Season`\n END\n\n WHEN DOMO_BEAST_MODE(4067) = 'Early Years'\n THEN \n \tCASE WHEN DOMO_BEAST_MODE(4069) = 'Early' THEN `Season`\n END\n \n ELSE IFNULL(`Season`, 'Blank')\n \nEND", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Season`', 'columnPosition': 113}, {'columnName': '`Season`', 'columnPosition': 254}, {'columnName': '`Season`', 'columnPosition': 393}, {'columnName': '`Season`', 'columnPosition': 537}, {'columnName': '`Season`', 'columnPosition': 683}, {'columnName': '`Season`', 'columnPosition': 830}, {'columnName': '`Season`', 'columnPosition': 961}, {'columnName': '`Season`', 'columnPosition': 1007}], 'variable': False}, 'calculation_7eb516e8-d763-493f-a079-c3c85b64117d': {'templateId': 3991, 'id': 'calculation_7eb516e8-d763-493f-a079-c3c85b64117d', 'name': 'MPG', 'formula': 'IFNULL(`Minutes/Game`, (`Minutes Played` / `Games Played`))', 'status': 'VALID', 'dataType': 'DOUBLE', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Minutes/Game`', 'columnPosition': 7}, {'columnName': '`Minutes Played`', 'columnPosition': 24}, {'columnName': '`Games Played`', 'columnPosition': 43}], 'variable': False}, 'calculation_7b9b1fe2-1aff-4817-a1a5-d7a270759602': {'templateId': 3983, 'id': 'calculation_7b9b1fe2-1aff-4817-a1a5-d7a270759602', 'name': 'APG', 'formula': 'IFNULL(`Assists/Game`, (`Assists` / `Games Played`))', 'status': 'VALID', 'dataType': 'DOUBLE', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Assists/Game`', 'columnPosition': 7}, {'columnName': '`Assists`', 'columnPosition': 24}, {'columnName': '`Games Played`', 'columnPosition': 36}], 'variable': False}, 'calculation_d02c3d5b-3739-4f9e-b040-2e2e760d8362': {'templateId': 4069, 'id': 'calculation_d02c3d5b-3739-4f9e-b040-2e2e760d8362', 'name': 'Era Tag', 'formula': "CASE \n\t WHEN `SZN1` >= 2014 THEN 'Modern'\n WHEN `SZN1` >= 2003 AND `SZN1` < 2014 THEN 'Dynasty'\n WHEN `SZN1` >= 1990 AND `SZN1` < 2003 THEN 'Jordan'\n WHEN `SZN1` >= 1979 AND `SZN1` < 1990 THEN 'Rivalry'\n WHEN `SZN1` >= 1969 AND `SZN1` < 1979 THEN 'Expansion'\n WHEN `SZN1` >= 1960 AND `SZN1` < 1969 THEN 'Russell'\n WHEN `SZN1` < 1960 THEN 'Early'\nEND", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`SZN1`', 'columnPosition': 13}, {'columnName': '`SZN1`', 'columnPosition': 52}, {'columnName': '`SZN1`', 'columnPosition': 71}, {'columnName': '`SZN1`', 'columnPosition': 110}, {'columnName': '`SZN1`', 'columnPosition': 129}, {'columnName': '`SZN1`', 'columnPosition': 167}, {'columnName': '`SZN1`', 'columnPosition': 186}, {'columnName': '`SZN1`', 'columnPosition': 225}, {'columnName': '`SZN1`', 'columnPosition': 244}, {'columnName': '`SZN1`', 'columnPosition': 285}, {'columnName': '`SZN1`', 'columnPosition': 304}, {'columnName': '`SZN1`', 'columnPosition': 343}], 'variable': False}, 'calculation_7ff82908-da67-4df0-82d3-2381a050847e': {'templateId': 3977, 'id': 'calculation_7ff82908-da67-4df0-82d3-2381a050847e', 'name': 'List of All Stars', 'formula': "(CASE WHEN (`All Star?` = 'Yes') THEN `Player` END)", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`All Star?`', 'columnPosition': 12}, {'columnName': '`Player`', 'columnPosition': 38}], 'variable': False}, 'calculation_a8b2630b-19d0-4228-bca0-e411d46ff151': {'templateId': 3997, 'id': 'calculation_a8b2630b-19d0-4228-bca0-e411d46ff151', 'name': 'Series Compiled', 'formula': "CASE \n\n\tWHEN `F` = 'x' THEN 'Finals'\n WHEN `ECF` = 'x' THEN 'Eastern Conference Finals'\n WHEN `WCF` = 'x' THEN 'Western Conference Finals'\n WHEN `ECSF` = 'x' THEN 'Eastern Conference Semifinals'\n WHEN `WCSF` = 'x' THEN 'Western Conference Semifinals'\n WHEN `ECFR` = 'x' THEN 'Eastern Conference First Round'\n WHEN `WCFR` = 'x' THEN 'Western Conference First Round'\n\nEND\n ", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`F`', 'columnPosition': 13}, {'columnName': '`ECF`', 'columnPosition': 46}, {'columnName': '`WCF`', 'columnPosition': 100}, {'columnName': '`ECSF`', 'columnPosition': 154}, {'columnName': '`WCSF`', 'columnPosition': 213}, {'columnName': '`ECFR`', 'columnPosition': 272}, {'columnName': '`WCFR`', 'columnPosition': 332}], 'variable': False}, 'calculation_83d262e0-6b88-4029-a511-d9eca8775d97': {'templateId': 3990, 'id': 'calculation_83d262e0-6b88-4029-a511-d9eca8775d97', 'name': 'Mapped Full Team Name', 'formula': "(CASE WHEN `Full Team Name` IN ('Tri-Cities Blackhawks', 'Milwaukee Hawks', 'St. Louis Hawks', 'Atlanta Hawks') THEN 'Atlanta Hawks' WHEN `Full Team Name` IN ('Boston Celtics') THEN 'Boston Celtics' WHEN `Full Team Name` IN ('New York Nets', 'New Jersey Nets', 'Brooklyn Nets') THEN 'Brooklyn Nets' WHEN `Full Team Name` IN ('Charlotte Bobcats', 'Charlotte Hornets') THEN 'Charlotte Hornets' WHEN `Full Team Name` IN ('Chicago Bulls') THEN 'Chicago Bulls' WHEN `Full Team Name` IN ('Cleveland Cavaliers') THEN 'Cleveland Cavaliers' WHEN `Full Team Name` IN ('Dallas Mavericks') THEN 'Dallas Mavericks' WHEN `Full Team Name` IN ('Denver Nuggets') THEN 'Denver Nuggets' WHEN `Full Team Name` IN ('Fort Wayne Zollner Pistons', 'Detroit Pistons') THEN 'Detroit Pistons' WHEN `Full Team Name` IN ('Philadelphia Warriors', 'San Francisco Warriors', 'Golden State Warriors') THEN 'Golden State Warriors' WHEN `Full Team Name` IN ('San Diego Rockets', 'Houston Rockets') THEN 'Houston Rockets' WHEN `Full Team Name` IN ('Indiana Pacers') THEN 'Indiana Pacers' WHEN `Full Team Name` IN ('Buffalo Braves', 'San Diego Clippers', 'Los Angeles Clippers') THEN 'Los Angeles Clippers' WHEN `Full Team Name` IN ('Minneapolis Lakers', 'Los Angeles Lakers') THEN 'Los Angeles Lakers' WHEN `Full Team Name` IN ('Vancouver Grizzlies', 'Memphis Grizzlies') THEN 'Memphis Grizzlies' WHEN `Full Team Name` IN ('Miami Heat') THEN 'Miami Heat' WHEN `Full Team Name` IN ('Milwaukee Bucks') THEN 'Milwaukee Bucks' WHEN `Full Team Name` IN ('Minnesota Timberwolves') THEN 'Minnesota Timberwolves' WHEN `Full Team Name` IN ('New Orleans Hornets', 'New Orleans / Oklahoma City Hornets', 'New Orleans Pelicans') THEN 'New Orleans Pelicans' WHEN `Full Team Name` IN ('New York Knicks') THEN 'New York Knicks' WHEN `Full Team Name` IN ('Seattle SuperSonics', 'Oklahoma City Thunder') THEN 'Oklahoma City Thunder' WHEN `Full Team Name` IN ('Orlando Magic') THEN 'Orlando Magic' WHEN `Full Team Name` IN ('Syracuse Nationals', 'Philadelphia 76ers') THEN 'Philadelphia 76ers' WHEN `Full Team Name` IN ('Phoenix Suns') THEN 'Phoenix Suns' WHEN `Full Team Name` IN ('Portland Trailblazers') THEN 'Portland Trailblazers' WHEN `Full Team Name` IN ('Rochester Royals', 'Cincinnati Royals', 'Kansas City-Omaha Kings', 'Kansas City Kings', 'Sacremento Kings') THEN 'Sacremento Kings' WHEN `Full Team Name` IN ('San Antonio Spurs') THEN 'San Antonio Spurs' WHEN `Full Team Name` IN ('Toronto Raptors') THEN 'Toronto Raptors' WHEN `Full Team Name` IN ('New Orleans Jazz', 'Utah Jazz') THEN 'Utah Jazz' WHEN `Full Team Name` IN ('Chicago Packers', 'Chicago Zephyrs', 'Baltimore Bullets', 'Capital Bullets', 'Washington Bullets', 'Washington Wizards') THEN 'Washington Wizards' ELSE 'Historical / Discontinued Franchises' END)", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Full Team Name`', 'columnPosition': 11}, {'columnName': '`Full Team Name`', 'columnPosition': 138}, {'columnName': '`Full Team Name`', 'columnPosition': 204}, {'columnName': '`Full Team Name`', 'columnPosition': 304}, {'columnName': '`Full Team Name`', 'columnPosition': 397}, {'columnName': '`Full Team Name`', 'columnPosition': 461}, {'columnName': '`Full Team Name`', 'columnPosition': 537}, {'columnName': '`Full Team Name`', 'columnPosition': 607}, {'columnName': '`Full Team Name`', 'columnPosition': 673}, {'columnName': '`Full Team Name`', 'columnPosition': 771}, {'columnName': '`Full Team Name`', 'columnPosition': 902}, {'columnName': '`Full Team Name`', 'columnPosition': 991}, {'columnName': '`Full Team Name`', 'columnPosition': 1057}, {'columnName': '`Full Team Name`', 'columnPosition': 1175}, {'columnName': '`Full Team Name`', 'columnPosition': 1271}, {'columnName': '`Full Team Name`', 'columnPosition': 1366}, {'columnName': '`Full Team Name`', 'columnPosition': 1424}, {'columnName': '`Full Team Name`', 'columnPosition': 1492}, {'columnName': '`Full Team Name`', 'columnPosition': 1574}, {'columnName': '`Full Team Name`', 'columnPosition': 1714}, {'columnName': '`Full Team Name`', 'columnPosition': 1782}, {'columnName': '`Full Team Name`', 'columnPosition': 1885}, {'columnName': '`Full Team Name`', 'columnPosition': 1949}, {'columnName': '`Full Team Name`', 'columnPosition': 2045}, {'columnName': '`Full Team Name`', 'columnPosition': 2107}, {'columnName': '`Full Team Name`', 'columnPosition': 2187}, {'columnName': '`Full Team Name`', 'columnPosition': 2346}, {'columnName': '`Full Team Name`', 'columnPosition': 2418}, {'columnName': '`Full Team Name`', 'columnPosition': 2486}, {'columnName': '`Full Team Name`', 'columnPosition': 2562}], 'variable': False}, 'calculation_57a76172-a713-4e54-843f-2815a6722792': {'templateId': 3978, 'id': 'calculation_57a76172-a713-4e54-843f-2815a6722792', 'name': 'Position Index', 'formula': "(CASE WHEN (`Position` = 'G') THEN 1 WHEN (`Position` = 'PG') THEN 2 WHEN (`Position` = 'SG') THEN 3 WHEN (`Position` = 'G-F') THEN 4 WHEN (`Position` = 'F') THEN 5 WHEN (`Position` = 'SF') THEN 6 WHEN (`Position` = 'PF') THEN 7 WHEN (`Position` = 'F-C') THEN 7 WHEN (`Position` = 'C-F') THEN 8 WHEN (`Position` = 'C') THEN 9 ELSE 10 END)", 'status': 'VALID', 'dataType': 'LONG', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Position`', 'columnPosition': 12}, {'columnName': '`Position`', 'columnPosition': 43}, {'columnName': '`Position`', 'columnPosition': 75}, {'columnName': '`Position`', 'columnPosition': 107}, {'columnName': '`Position`', 'columnPosition': 140}, {'columnName': '`Position`', 'columnPosition': 171}, {'columnName': '`Position`', 'columnPosition': 203}, {'columnName': '`Position`', 'columnPosition': 235}, {'columnName': '`Position`', 'columnPosition': 268}, {'columnName': '`Position`', 'columnPosition': 301}], 'variable': False}, 'calculation_b74d4363-34a0-4e36-a085-fb464d8e78b3': {'templateId': 4101, 'id': 'calculation_b74d4363-34a0-4e36-a085-fb464d8e78b3', 'name': 'FILTER - Player', 'formula': "CASE \n\tWHEN IFNULL(`Player`, 'Blank') = `Player` THEN 'Keep'\n ELSE 'Filter Out'\nEND", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Player`', 'columnPosition': 19}, {'columnName': '`Player`', 'columnPosition': 40}], 'variable': False}, 'calculation_4235ce6f-75cd-4123-a885-84605c403115': {'templateId': 3988, 'id': 'calculation_4235ce6f-75cd-4123-a885-84605c403115', 'name': 'SPG', 'formula': 'IFNULL(`Steals/Game`, (`Steals` / `Games Played`))', 'status': 'VALID', 'dataType': 'DOUBLE', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Steals/Game`', 'columnPosition': 7}, {'columnName': '`Steals`', 'columnPosition': 23}, {'columnName': '`Games Played`', 'columnPosition': 34}], 'variable': False}, 'calculation_d16a9fcc-38e6-4fc6-97eb-63fc7620d2b2': {'templateId': 4000, 'id': 'calculation_d16a9fcc-38e6-4fc6-97eb-63fc7620d2b2', 'name': 'List of All Rookie Players', 'formula': "CASE \n\t\n WHEN `All Rookie?` = 'Yes'\n \n THEN CASE\n\n\t\tWHEN DOMO_BEAST_MODE(3847) = '1st Team'\n \tTHEN CASE WHEN `All-Rookie 1st Team?` = 'x' THEN `Player` END\n \n \tWHEN DOMO_BEAST_MODE(3847) = '2nd Team'\n \tTHEN CASE WHEN `All-Rookie 2nd Team?` = 'x' THEN `Player` END\n \n END\n \nEND\n\t", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`All Rookie?`', 'columnPosition': 17}, {'columnName': '`All-Rookie 1st Team?`', 'columnPosition': 121}, {'columnName': '`Player`', 'columnPosition': 155}, {'columnName': '`All-Rookie 2nd Team?`', 'columnPosition': 238}, {'columnName': '`Player`', 'columnPosition': 272}], 'variable': False}, 'calculation_d4a49d51-ab1c-439c-9ff7-88c0b2a0700c': {'templateId': 4102, 'id': 'calculation_d4a49d51-ab1c-439c-9ff7-88c0b2a0700c', 'name': 'FILTER - Season', 'formula': "CASE \n\tWHEN IFNULL(`Season`, 'Blank') = `Season` THEN 'Keep'\n ELSE 'Filter Out'\nEND", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Season`', 'columnPosition': 19}, {'columnName': '`Season`', 'columnPosition': 40}], 'variable': False}, 'calculation_22bed65e-42bc-4e34-810f-264208ba7e16': {'templateId': 3998, 'id': 'calculation_22bed65e-42bc-4e34-810f-264208ba7e16', 'name': 'Conference Filter', 'formula': "CASE\n\n\t\tWHEN DOMO_BEAST_MODE(3992) = 'Western' THEN \n CASE WHEN (CASE \n\n\tWHEN `Team` = 'NJN' OR `Team` = 'WSB'\n THEN 'Eastern'\n \n WHEN `Team` = 'SEA' OR `Team` = 'VAN' OR `Team` = 'KCK' OR `Team` = 'SDC'\n THEN 'Western'\n \n WHEN `Team` = 'NOH' OR `Team` = 'NOK'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 2004\n \t\t\tTHEN 'Western'\n ELSE 'Eastern'\n END\n \n WHEN `Team` = 'MIA'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 1989\n \t\t\tTHEN 'Eastern'\n ELSE 'Western'\n END\n \n WHEN `Team` = 'HOU' OR `Team` = 'SAS'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 1980\n \t\t\tTHEN 'Western'\n ELSE 'Eastern'\n END\n \n WHEN `Team` = 'MIL' OR `Team` = 'CHI'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 1980\n \t\t\tTHEN 'Eastern'\n ELSE 'Western'\n END\n \n ELSE `Conference`\n\nEND) = 'Western' THEN `Full Team Name` END\n \n \tWHEN DOMO_BEAST_MODE(3992) = 'Eastern' THEN \n CASE WHEN (CASE \n\n\tWHEN `Team` = 'NJN' OR `Team` = 'WSB'\n THEN 'Eastern'\n \n WHEN `Team` = 'SEA' OR `Team` = 'VAN' OR `Team` = 'KCK' OR `Team` = 'SDC'\n THEN 'Western'\n \n WHEN `Team` = 'NOH' OR `Team` = 'NOK'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 2004\n \t\t\tTHEN 'Western'\n ELSE 'Eastern'\n END\n \n WHEN `Team` = 'MIA'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 1989\n \t\t\tTHEN 'Eastern'\n ELSE 'Western'\n END\n \n WHEN `Team` = 'HOU' OR `Team` = 'SAS'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 1980\n \t\t\tTHEN 'Western'\n ELSE 'Eastern'\n END\n \n WHEN `Team` = 'MIL' OR `Team` = 'CHI'\n \tTHEN CASE \n \t\tWHEN `SZN1` >= 1980\n \t\t\tTHEN 'Eastern'\n ELSE 'Western'\n END\n \n ELSE `Conference`\n\nEND) = 'Eastern' THEN `Full Team Name` END\n \nEND\n\t\n", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Team`', 'columnPosition': 85}, {'columnName': '`Team`', 'columnPosition': 103}, {'columnName': '`Team`', 'columnPosition': 151}, {'columnName': '`Team`', 'columnPosition': 169}, {'columnName': '`Team`', 'columnPosition': 187}, {'columnName': '`Team`', 'columnPosition': 205}, {'columnName': '`Team`', 'columnPosition': 253}, {'columnName': '`Team`', 'columnPosition': 271}, {'columnName': '`SZN1`', 'columnPosition': 317}, {'columnName': '`Team`', 'columnPosition': 416}, {'columnName': '`SZN1`', 'columnPosition': 462}, {'columnName': '`Team`', 'columnPosition': 561}, {'columnName': '`Team`', 'columnPosition': 579}, {'columnName': '`SZN1`', 'columnPosition': 625}, {'columnName': '`Team`', 'columnPosition': 725}, {'columnName': '`Team`', 'columnPosition': 743}, {'columnName': '`SZN1`', 'columnPosition': 789}, {'columnName': '`Conference`', 'columnPosition': 888}, {'columnName': '`Full Team Name`', 'columnPosition': 924}, {'columnName': '`Team`', 'columnPosition': 1032}, {'columnName': '`Team`', 'columnPosition': 1050}, {'columnName': '`Team`', 'columnPosition': 1098}, {'columnName': '`Team`', 'columnPosition': 1116}, {'columnName': '`Team`', 'columnPosition': 1134}, {'columnName': '`Team`', 'columnPosition': 1152}, {'columnName': '`Team`', 'columnPosition': 1200}, {'columnName': '`Team`', 'columnPosition': 1218}, {'columnName': '`SZN1`', 'columnPosition': 1264}, {'columnName': '`Team`', 'columnPosition': 1363}, {'columnName': '`SZN1`', 'columnPosition': 1409}, {'columnName': '`Team`', 'columnPosition': 1508}, {'columnName': '`Team`', 'columnPosition': 1526}, {'columnName': '`SZN1`', 'columnPosition': 1572}, {'columnName': '`Team`', 'columnPosition': 1672}, {'columnName': '`Team`', 'columnPosition': 1690}, {'columnName': '`SZN1`', 'columnPosition': 1736}, {'columnName': '`Conference`', 'columnPosition': 1835}, {'columnName': '`Full Team Name`', 'columnPosition': 1871}], 'variable': False}, 'calculation_cf6030f9-236e-4d2a-aa3e-4a0c4dc260bb': {'templateId': 3985, 'id': 'calculation_cf6030f9-236e-4d2a-aa3e-4a0c4dc260bb', 'name': 'RPG', 'formula': 'IFNULL(`Total Rebounds/Game`, (`Total Rebounds` / `Games Played`))', 'status': 'VALID', 'dataType': 'DOUBLE', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Total Rebounds/Game`', 'columnPosition': 7}, {'columnName': '`Total Rebounds`', 'columnPosition': 31}, {'columnName': '`Games Played`', 'columnPosition': 50}], 'variable': False}, 'calculation_3005133f-efd0-4d12-b270-bf097fb5f877': {'templateId': 3982, 'id': 'calculation_3005133f-efd0-4d12-b270-bf097fb5f877', 'name': 'List of Teams', 'formula': "CONCAT(`Team`, ' - ', `Full Team Name`)", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Team`', 'columnPosition': 7}, {'columnName': '`Full Team Name`', 'columnPosition': 22}], 'variable': False}, 'calculation_b627b3d3-7008-47db-bee1-5df1cc7b2b05': {'templateId': 4057, 'id': 'calculation_b627b3d3-7008-47db-bee1-5df1cc7b2b05', 'name': 'FG%', 'formula': 'SUM(`Field Goals Made`) / SUM(`Field Goal Attempts`)', 'status': 'VALID', 'dataType': 'DECIMAL', 'persistedOnDataSource': True, 'isAggregatable': True, 'bignumber': False, 'columnPositions': [{'columnName': '`Field Goals Made`', 'columnPosition': 4}, {'columnName': '`Field Goal Attempts`', 'columnPosition': 30}], 'variable': False}, 'calculation_6dac4f6d-faa0-4d2f-b932-bd5c8d398e9d': {'templateId': 3994, 'id': 'calculation_6dac4f6d-faa0-4d2f-b932-bd5c8d398e9d', 'name': 'Series Index', 'formula': "CASE \n\tWHEN `Series` = 'F' THEN 1\n WHEN `Series` = 'ECF' THEN 2\n\tWHEN `Series` = 'WCF' THEN 3\n WHEN `Series` = 'ECSF' THEN 4\n WHEN `Series` = 'WCSF' THEN 5\n\tWHEN `Series` = 'ECFR' THEN 6\n\tWHEN `Series` = 'WCFR' THEN 7\n\tELSE 8\nEND", 'status': 'VALID', 'dataType': 'LONG', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Series`', 'columnPosition': 12}, {'columnName': '`Series`', 'columnPosition': 43}, {'columnName': '`Series`', 'columnPosition': 73}, {'columnName': '`Series`', 'columnPosition': 106}, {'columnName': '`Series`', 'columnPosition': 140}, {'columnName': '`Series`', 'columnPosition': 171}, {'columnName': '`Series`', 'columnPosition': 202}], 'variable': False}, 'calculation_749f8aa4-ef19-466f-b891-9c8ab35fbb8d': {'templateId': 3984, 'id': 'calculation_749f8aa4-ef19-466f-b891-9c8ab35fbb8d', 'name': 'Stat Avg', 'formula': "(CASE WHEN (DOMO_BEAST_MODE(3848) = 'Points') THEN DOMO_BEAST_MODE(3986) WHEN (DOMO_BEAST_MODE(3848) = 'Assists') THEN DOMO_BEAST_MODE(3983) WHEN (DOMO_BEAST_MODE(3848) = 'Rebounds') THEN DOMO_BEAST_MODE(3985) WHEN (DOMO_BEAST_MODE(3848) = 'Steals') THEN DOMO_BEAST_MODE(3988) WHEN (DOMO_BEAST_MODE(3848) = 'Blocks') THEN DOMO_BEAST_MODE(3987) END)", 'status': 'VALID', 'dataType': 'DOUBLE', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'variable': False}, 'calculation_69aeb7d7-15a3-458a-a690-a5177ee10def': {'templateId': 4095, 'id': 'calculation_69aeb7d7-15a3-458a-a690-a5177ee10def', 'name': 'Team Finals Appearances', 'formula': "COUNT(CASE \n \tWHEN `SERIES` = 'F' THEN `TEAM`\n END)", 'status': 'VALID', 'dataType': 'LONG', 'persistedOnDataSource': True, 'isAggregatable': True, 'bignumber': False, 'columnPositions': [{'columnName': '`SERIES`', 'columnPosition': 24}, {'columnName': '`TEAM`', 'columnPosition': 44}], 'variable': False}}, Schema=DomoDataset_Schema(dataset_id='b78ce093-28df-4af9-abbf-679e2d2fb341', columns=[]), Stream=DomoStream(id=1925, dataset_id='b78ce093-28df-4af9-abbf-679e2d2fb341', transport_description=None, transport_version=None, update_method=None, data_provider_name=None, data_provider_key=None, account_id=None, account_display_name=None, account_userid=None, has_mapping=False, configuration=[], configuration_tables=[], configuration_query=None), Tags=DomoTags(tag_ls=['developer_documentation', 'Jan-30-2025 15:58', 'hackercore']), PDP=<domolibrary.classes.DomoPDP.Dataset_PDP_Policies object at 0x7ce41090f950>, Certification=None),
DomoDataset(id='91cd5172-0d76-4189-a747-526b4cedbf34', display_type='webform', data_provider_type='webform', name='Example Sales Data', description=None, row_count=19378, column_count=5, stream_id=1924, owner={'id': '1728973208', 'name': 'Peter Shull', 'type': 'USER', 'group': False}, formula={}, Schema=DomoDataset_Schema(dataset_id='91cd5172-0d76-4189-a747-526b4cedbf34', columns=[]), Stream=DomoStream(id=1924, dataset_id='91cd5172-0d76-4189-a747-526b4cedbf34', transport_description=None, transport_version=None, update_method=None, data_provider_name=None, data_provider_key=None, account_id=None, account_display_name=None, account_userid=None, has_mapping=False, configuration=[], configuration_tables=[], configuration_query=None), Tags=DomoTags(tag_ls=[]), PDP=<domolibrary.classes.DomoPDP.Dataset_PDP_Policies object at 0x7ce4108f1010>, Certification=None),
DomoDataset(id='20b70c3e-4b35-4661-b3ce-1e45f1a88183', display_type='DataFlow', data_provider_type=None, name='DEV | WNBA Swish Central v2', description=None, row_count=7272, column_count=91, stream_id=None, owner={'id': '29257675', 'name': 'Shivam Desai - BTP', 'type': 'USER', 'group': False}, formula={'calculation_b540e4ad-70ed-4a1d-864b-bb0748b882fc': {'templateId': 4340, 'id': 'calculation_b540e4ad-70ed-4a1d-864b-bb0748b882fc', 'name': 'Team Finals Appearances', 'formula': "COUNT(CASE \n \tWHEN `SERIES` = 'F' THEN `TEAM`\n END)", 'status': 'VALID', 'dataType': 'LONG', 'persistedOnDataSource': True, 'isAggregatable': True, 'bignumber': False, 'columnPositions': [{'columnName': '`SERIES`', 'columnPosition': 24}, {'columnName': '`TEAM`', 'columnPosition': 44}], 'variable': False}, 'calculation_aac0dfc5-953e-4f00-9b69-dac9d03b0e3c': {'templateId': 4314, 'id': 'calculation_aac0dfc5-953e-4f00-9b69-dac9d03b0e3c', 'name': 'Logo', 'formula': 'CONCAT(\'<img src="\', `Logo URL`, \'"style="width:auto;height:auto"></>\')', 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Logo URL`', 'columnPosition': 21}], 'variable': False}, 'calculation_0c093319-9eee-47cb-8e4a-27397bfb8fd6': {'templateId': 4320, 'id': 'calculation_0c093319-9eee-47cb-8e4a-27397bfb8fd6', 'name': 'List of Teams', 'formula': "CONCAT(`Team`, ' - ', `Full Team Name`)", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Team`', 'columnPosition': 7}, {'columnName': '`Full Team Name`', 'columnPosition': 22}], 'variable': False}, 'calculation_bf37d43a-4900-4a70-8b12-267a94f89c2d': {'templateId': 4322, 'id': 'calculation_bf37d43a-4900-4a70-8b12-267a94f89c2d', 'name': 'Playoff Appearances?', 'formula': "CASE \n\tWHEN `SZN_Type` = 'PO' THEN COUNT(DISTINCT `Player ID`)\nEND", 'status': 'VALID', 'dataType': 'LONG', 'persistedOnDataSource': True, 'isAggregatable': True, 'bignumber': False, 'columnPositions': [{'columnName': '`SZN_Type`', 'columnPosition': 12}, {'columnName': '`Player ID`', 'columnPosition': 50}], 'variable': False}, 'calculation_d4f78a18-3b37-4e7a-a7bb-2f1047c79436': {'templateId': 4329, 'id': 'calculation_d4f78a18-3b37-4e7a-a7bb-2f1047c79436', 'name': 'FILTER - Player', 'formula': "CASE \n\tWHEN IFNULL(`Player`, 'Blank') = `Player` THEN 'Keep'\n ELSE 'Filter Out'\nEND", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Player`', 'columnPosition': 19}, {'columnName': '`Player`', 'columnPosition': 40}], 'variable': False}, 'calculation_d18a8984-858d-4283-97f8-0887e9a2b2f7': {'templateId': 4347, 'id': 'calculation_d18a8984-858d-4283-97f8-0887e9a2b2f7', 'name': 'Logo BM', 'formula': "CASE \n\tWHEN `SZN` = MAX(`SZN`) THEN DOMO_BEAST_MODE(4314)\n ELSE ''\nEND", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': True, 'bignumber': False, 'columnPositions': [{'columnName': '`SZN`', 'columnPosition': 12}, {'columnName': '`SZN`', 'columnPosition': 24}], 'variable': False}, 'calculation_3c682fb7-c20a-480c-b45d-6594bbdff69b': {'templateId': 4316, 'id': 'calculation_3c682fb7-c20a-480c-b45d-6594bbdff69b', 'name': 'BPG', 'formula': 'IFNULL(`Blocks/Game`, (`Blocks` / `Games Played`))', 'status': 'VALID', 'dataType': 'DOUBLE', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Blocks/Game`', 'columnPosition': 7}, {'columnName': '`Blocks`', 'columnPosition': 23}, {'columnName': '`Games Played`', 'columnPosition': 34}], 'variable': False}, 'calculation_d8cde54a-17a6-454b-ba05-1bea6ada7a8e': {'templateId': 4324, 'id': 'calculation_d8cde54a-17a6-454b-ba05-1bea6ada7a8e', 'name': 'MPG', 'formula': 'IFNULL(`Minutes/Game`, (`Minutes Played` / `Games Played`))', 'status': 'VALID', 'dataType': 'DOUBLE', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Minutes/Game`', 'columnPosition': 7}, {'columnName': '`Minutes Played`', 'columnPosition': 24}, {'columnName': '`Games Played`', 'columnPosition': 43}], 'variable': False}, 'calculation_bf04d200-3ebb-4c46-afc9-485c49b869b1': {'templateId': 4334, 'id': 'calculation_bf04d200-3ebb-4c46-afc9-485c49b869b1', 'name': 'Mapped Full Team name', 'formula': "(CASE \n \t\n WHEN `Full Team Name` IN ('Atlanta Dream') THEN 'Atlanta Dream' \n WHEN `Full Team Name` IN ('Chicago Sky') THEN 'Chicago Sky' \n WHEN `Full Team Name` IN ('Orlando Miracle', 'Connecticut Sun') THEN 'Connecticut Sun' \n WHEN `Full Team Name` IN ('Indiana Fever') THEN 'Indiana Fever' \n WHEN `Full Team Name` IN ('Los Angeles Sparks') THEN 'Los Angeles Sparks' \n WHEN `Full Team Name` IN ('Minnesota Lynx') THEN 'Minnesota Lynx' \n WHEN `Full Team Name` IN ('New York Liberty') THEN 'New York Liberty' \n WHEN `Full Team Name` IN ('Phoenix Mercury') THEN 'Phoenix Mercury' \n WHEN `Full Team Name` IN ('Utah Starzz', 'San Antonio Silver Stars', 'Las Vegas Aces') THEN 'Las Vegas Aces' \n WHEN `Full Team Name` IN ('Seattle Storm') THEN 'Seattle Storm' \n \tWHEN `Full Team Name` IN ('Detroit Shock', 'Tulsa Shock', 'Dallas Wings') THEN 'Dallas Wings' \n \tWHEN `Full Team Name` IN ('Washington Mystics') THEN 'Washington Mystics' \n \n ELSE 'Historical / Discontinued Franchises' \n \n END)", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Full Team Name`', 'columnPosition': 20}, {'columnName': '`Full Team Name`', 'columnPosition': 90}, {'columnName': '`Full Team Name`', 'columnPosition': 156}, {'columnName': '`Full Team Name`', 'columnPosition': 249}, {'columnName': '`Full Team Name`', 'columnPosition': 319}, {'columnName': '`Full Team Name`', 'columnPosition': 399}, {'columnName': '`Full Team Name`', 'columnPosition': 471}, {'columnName': '`Full Team Name`', 'columnPosition': 547}, {'columnName': '`Full Team Name`', 'columnPosition': 621}, {'columnName': '`Full Team Name`', 'columnPosition': 736}, {'columnName': '`Full Team Name`', 'columnPosition': 803}, {'columnName': '`Full Team Name`', 'columnPosition': 900}], 'variable': False}, 'calculation_d14c5fbf-934e-4f1d-8c89-f91d1154389d': {'templateId': 4348, 'id': 'calculation_d14c5fbf-934e-4f1d-8c89-f91d1154389d', 'name': 'DRPG', 'formula': '(`Total Rebounds/Game`) - (`Offensive Rebounds/Game`)', 'status': 'VALID', 'dataType': 'DOUBLE', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Total Rebounds/Game`', 'columnPosition': 1}, {'columnName': '`Offensive Rebounds/Game`', 'columnPosition': 27}], 'variable': False}, 'calculation_5bb30136-593f-4a39-8bd4-b8928deb513e': {'templateId': 4349, 'id': 'calculation_5bb30136-593f-4a39-8bd4-b8928deb513e', 'name': 'Defensive Rebounds', 'formula': '(`Total Rebounds`) - (`Offensive Rebounds`)', 'status': 'VALID', 'dataType': 'LONG', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Total Rebounds`', 'columnPosition': 1}, {'columnName': '`Offensive Rebounds`', 'columnPosition': 22}], 'variable': False}, 'calculation_06cda0f6-4fb6-4486-80b5-cc13767568f2': {'templateId': 4341, 'id': 'calculation_06cda0f6-4fb6-4486-80b5-cc13767568f2', 'name': 'Team Playoff Appearances', 'formula': "COUNT(CASE \n \t\n \tWHEN `SZN`>= 2016 AND `Series` = 'FR' THEN `Team`\n \tWHEN (`SZN` >= 2000 AND `SZN` < 2016) AND `Series` IN ('ECSF','WCSF') THEN `Team`\n WHEN `SZN` = 1999 AND `Series` IN ('ECFR','WCFR') THEN `Team`\n WHEN (`SZN` >= 1997 AND `SZN` < 1999) AND `Series` = 'SF' THEN `Team`\n \n END)", 'status': 'VALID', 'dataType': 'LONG', 'persistedOnDataSource': True, 'isAggregatable': True, 'bignumber': False, 'columnPositions': [{'columnName': '`SZN`', 'columnPosition': 32}, {'columnName': '`Series`', 'columnPosition': 49}, {'columnName': '`Team`', 'columnPosition': 70}, {'columnName': '`SZN`', 'columnPosition': 90}, {'columnName': '`SZN`', 'columnPosition': 108}, {'columnName': '`Series`', 'columnPosition': 126}, {'columnName': '`Team`', 'columnPosition': 159}, {'columnName': '`SZN`', 'columnPosition': 179}, {'columnName': '`Series`', 'columnPosition': 196}, {'columnName': '`Team`', 'columnPosition': 229}, {'columnName': '`SZN`', 'columnPosition': 250}, {'columnName': '`SZN`', 'columnPosition': 268}, {'columnName': '`Series`', 'columnPosition': 286}, {'columnName': '`Team`', 'columnPosition': 307}], 'variable': False}, 'calculation_0c17a799-0584-4e04-8893-ba82839b139d': {'templateId': 4338, 'id': 'calculation_0c17a799-0584-4e04-8893-ba82839b139d', 'name': 'Series Filter', 'formula': "CASE\n\n\t\tWHEN DOMO_BEAST_MODE(4337) = 'Finals' THEN \n CASE WHEN `F` = 'x' THEN `Full Team Name` END\n \n \tWHEN DOMO_BEAST_MODE(4337) = 'EC Finals' THEN \n CASE WHEN `ECF` = 'x' THEN `Full Team Name` END\n \n WHEN DOMO_BEAST_MODE(4337) = 'WC Finals' THEN \n CASE WHEN `WCF` = 'x' THEN `Full Team Name` END\n \n WHEN DOMO_BEAST_MODE(4337) = 'Semifinals' THEN \n CASE WHEN `SF` = 'x' THEN `Full Team Name` END\n \n \tWHEN DOMO_BEAST_MODE(4337) = 'EC Semi Finals' THEN \n CASE WHEN `ECSF` = 'x' THEN `Full Team Name` END\n \n \tWHEN DOMO_BEAST_MODE(4337) = 'WC Semi Finals' THEN \n CASE WHEN `WCSF` = 'x' THEN `Full Team Name` END\n \n WHEN DOMO_BEAST_MODE(4337) = 'Second Round' THEN \n CASE WHEN `SR` = 'x' THEN `Full Team Name` END\n \n \tWHEN DOMO_BEAST_MODE(4337) = 'EC First Round' THEN \n CASE WHEN `ECFR` = 'x' THEN `Full Team Name` END\n \n \tWHEN DOMO_BEAST_MODE(4337) = 'WC First Round' THEN \n CASE WHEN `WCFR` = 'x' THEN `Full Team Name` END\n \n WHEN DOMO_BEAST_MODE(4337) = 'First Round' THEN \n CASE WHEN `FR` = 'x' THEN `Full Team Name` END\n \nEND\n\t\n", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`F`', 'columnPosition': 70}, {'columnName': '`Full Team Name`', 'columnPosition': 85}, {'columnName': '`ECF`', 'columnPosition': 181}, {'columnName': '`Full Team Name`', 'columnPosition': 198}, {'columnName': '`WCF`', 'columnPosition': 301}, {'columnName': '`Full Team Name`', 'columnPosition': 318}, {'columnName': '`SF`', 'columnPosition': 422}, {'columnName': '`Full Team Name`', 'columnPosition': 438}, {'columnName': '`ECSF`', 'columnPosition': 539}, {'columnName': '`Full Team Name`', 'columnPosition': 557}, {'columnName': '`WCSF`', 'columnPosition': 658}, {'columnName': '`Full Team Name`', 'columnPosition': 676}, {'columnName': '`SR`', 'columnPosition': 782}, {'columnName': '`Full Team Name`', 'columnPosition': 798}, {'columnName': '`ECFR`', 'columnPosition': 899}, {'columnName': '`Full Team Name`', 'columnPosition': 917}, {'columnName': '`WCFR`', 'columnPosition': 1018}, {'columnName': '`Full Team Name`', 'columnPosition': 1036}, {'columnName': '`FR`', 'columnPosition': 1141}, {'columnName': '`Full Team Name`', 'columnPosition': 1157}], 'variable': False}, 'calculation_b44e06f6-f39e-4119-9099-c12ef7e57ba9': {'templateId': 4326, 'id': 'calculation_b44e06f6-f39e-4119-9099-c12ef7e57ba9', 'name': 'Stat', 'formula': "(CASE \n \n \tWHEN (DOMO_BEAST_MODE(3848) = 'Points') THEN `Points` \n WHEN (DOMO_BEAST_MODE(3848) = 'Assists') THEN `Assists` \n WHEN (DOMO_BEAST_MODE(3848) = 'Rebounds') THEN `Total Rebounds` \n WHEN (DOMO_BEAST_MODE(3848) = 'Steals') THEN `Steals` \n WHEN (DOMO_BEAST_MODE(3848) = 'Blocks') THEN `Blocks` \n \n END)", 'status': 'VALID', 'dataType': 'LONG', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Points`', 'columnPosition': 56}, {'columnName': '`Assists`', 'columnPosition': 116}, {'columnName': '`Total Rebounds`', 'columnPosition': 178}, {'columnName': '`Steals`', 'columnPosition': 245}, {'columnName': '`Blocks`', 'columnPosition': 304}], 'variable': False}, 'calculation_79fdfb6b-23fc-43ac-aab6-7de1d1ea14b1': {'templateId': 4333, 'id': 'calculation_79fdfb6b-23fc-43ac-aab6-7de1d1ea14b1', 'name': 'PPG', 'formula': 'IFNULL(`Points/Game`, (`Points` / `Games Played`))', 'status': 'VALID', 'dataType': 'DOUBLE', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Points/Game`', 'columnPosition': 7}, {'columnName': '`Points`', 'columnPosition': 23}, {'columnName': '`Games Played`', 'columnPosition': 34}], 'variable': False}, 'calculation_2f2d9959-81fa-4ba6-a560-3a974fae1256': {'templateId': 4342, 'id': 'calculation_2f2d9959-81fa-4ba6-a560-3a974fae1256', 'name': 'Conference Filter', 'formula': "CASE \n\tWHEN DOMO_BEAST_MODE(3992) = 'Western'\n \tTHEN CASE \n \tWHEN `Conference` = 'Western'\n THEN `Full Team Name`\n ELSE ''\n END\n WHEN DOMO_BEAST_MODE(3992) = 'Eastern'\n \tTHEN CASE \n \tWHEN `Conference` = 'Eastern'\n THEN `Full Team Name`\n ELSE ''\n END\nEND", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Conference`', 'columnPosition': 76}, {'columnName': '`Full Team Name`', 'columnPosition': 118}, {'columnName': '`Conference`', 'columnPosition': 240}, {'columnName': '`Full Team Name`', 'columnPosition': 282}], 'variable': False}, 'calculation_fa182172-ddc5-4a02-b601-cda356b180fa': {'templateId': 4315, 'id': 'calculation_fa182172-ddc5-4a02-b601-cda356b180fa', 'name': 'Position Index', 'formula': "(CASE \n \n \tWHEN (`Position` = 'G') THEN 1 \n \tWHEN (`Position` = 'PG') THEN 2 \n \tWHEN (`Position` = 'SG') THEN 3 \n \tWHEN (`Position` = 'G-F') THEN 4\n \tWHEN (`Position` = 'F-G') THEN 5\n \tWHEN (`Position` = 'F') THEN 6 \n \tWHEN (`Position` = 'SF') THEN 7 \n \tWHEN (`Position` = 'PF') THEN 8 \n \tWHEN (`Position` = 'F-C') THEN 9 \n \tWHEN (`Position` = 'C-F') THEN 10 \n \tWHEN (`Position` = 'C') THEN 11 \n \tELSE 12\n\n END)", 'status': 'VALID', 'dataType': 'LONG', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Position`', 'columnPosition': 17}, {'columnName': '`Position`', 'columnPosition': 51}, {'columnName': '`Position`', 'columnPosition': 86}, {'columnName': '`Position`', 'columnPosition': 121}, {'columnName': '`Position`', 'columnPosition': 156}, {'columnName': '`Position`', 'columnPosition': 191}, {'columnName': '`Position`', 'columnPosition': 225}, {'columnName': '`Position`', 'columnPosition': 260}, {'columnName': '`Position`', 'columnPosition': 295}, {'columnName': '`Position`', 'columnPosition': 331}, {'columnName': '`Position`', 'columnPosition': 368}], 'variable': False}, 'calculation_b83ed853-26d6-41c8-94a3-5a145b0401d2': {'templateId': 4323, 'id': 'calculation_b83ed853-26d6-41c8-94a3-5a145b0401d2', 'name': 'SPG', 'formula': 'IFNULL(`Steals/Game`, (`Steals` / `Games Played`))', 'status': 'VALID', 'dataType': 'DOUBLE', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Steals/Game`', 'columnPosition': 7}, {'columnName': '`Steals`', 'columnPosition': 23}, {'columnName': '`Games Played`', 'columnPosition': 34}], 'variable': False}, 'calculation_7d13224d-a9c7-47af-b361-d24f2325ecf3': {'templateId': 4339, 'id': 'calculation_7d13224d-a9c7-47af-b361-d24f2325ecf3', 'name': 'Team Championships', 'formula': "COUNT(CASE \n \tWHEN `Series` = 'F' AND `Won Series?` = 'Yes' THEN `Team`\n END)", 'status': 'VALID', 'dataType': 'LONG', 'persistedOnDataSource': True, 'isAggregatable': True, 'bignumber': False, 'columnPositions': [{'columnName': '`Series`', 'columnPosition': 24}, {'columnName': '`Won Series?`', 'columnPosition': 43}, {'columnName': '`Team`', 'columnPosition': 70}], 'variable': False}, 'calculation_a4cdc256-3422-405b-8f07-533e38d7a72b': {'templateId': 4318, 'id': 'calculation_a4cdc256-3422-405b-8f07-533e38d7a72b', 'name': 'List of All Stars', 'formula': "(CASE \n \tWHEN (`All Star?` = 'Yes') THEN `Player` \n END)", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`All Star?`', 'columnPosition': 15}, {'columnName': '`Player`', 'columnPosition': 41}], 'variable': False}, 'calculation_12b2de87-1981-4643-81d4-9b95e2a73275': {'templateId': 4330, 'id': 'calculation_12b2de87-1981-4643-81d4-9b95e2a73275', 'name': 'List of All Defensive Players', 'formula': "CASE \n\n\tWHEN `All Defensive?` = 'Yes' \n \n \tTHEN CASE\n\n\t\tWHEN DOMO_BEAST_MODE(3846) = '1st Team'\n \tTHEN CASE WHEN `All-Defensive 1st Team?` = 'x' THEN `Player` END\n \n \tWHEN DOMO_BEAST_MODE(3846) = '2nd Team'\n \tTHEN CASE WHEN `All-Defensive 2nd Team?` = 'x' THEN `Player` END\n \t\n END\n \nEND\n\t", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`All Defensive?`', 'columnPosition': 13}, {'columnName': '`All-Defensive 1st Team?`', 'columnPosition': 121}, {'columnName': '`Player`', 'columnPosition': 158}, {'columnName': '`All-Defensive 2nd Team?`', 'columnPosition': 241}, {'columnName': '`Player`', 'columnPosition': 278}], 'variable': False}, 'calculation_e85008d8-01ed-47dc-8b7e-83c59568873f': {'templateId': 4317, 'id': 'calculation_e85008d8-01ed-47dc-8b7e-83c59568873f', 'name': 'List of All Rookie Players', 'formula': "CASE \n\t\n WHEN `All Rookie?` = 'Yes'\n \n THEN CASE\n\n\t\tWHEN DOMO_BEAST_MODE(3847) = '1st Team'\n \tTHEN CASE WHEN `All-Rookie 1st Team?` = 'x' THEN `Player` END\n \n END\n \nEND\n\t", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`All Rookie?`', 'columnPosition': 17}, {'columnName': '`All-Rookie 1st Team?`', 'columnPosition': 121}, {'columnName': '`Player`', 'columnPosition': 155}], 'variable': False}, 'calculation_2066fdd5-4070-4780-b7bf-78af9492edc6': {'templateId': 4331, 'id': 'calculation_2066fdd5-4070-4780-b7bf-78af9492edc6', 'name': 'FG%', 'formula': 'SUM(`Field Goals Made`) / SUM(`Field Goal Attempts`)', 'status': 'VALID', 'dataType': 'DECIMAL', 'persistedOnDataSource': True, 'isAggregatable': True, 'bignumber': False, 'columnPositions': [{'columnName': '`Field Goals Made`', 'columnPosition': 4}, {'columnName': '`Field Goal Attempts`', 'columnPosition': 30}], 'variable': False}, 'calculation_cd055271-11fd-447a-bed5-f8c41246d37a': {'templateId': 4325, 'id': 'calculation_cd055271-11fd-447a-bed5-f8c41246d37a', 'name': 'List of All WNBA Players', 'formula': "(CASE \n \n \tWHEN (`All WNBA?` = 'Yes') \n \tTHEN \n \t\t\n \t\t(CASE \n \tWHEN (DOMO_BEAST_MODE(3845) = '1st Team') \n \tTHEN \n \t\t(CASE \n \tWHEN (`All-WNBA 1st Team?` = 'x') THEN `Player` END) \n \t\t\t\n \tWHEN (DOMO_BEAST_MODE(3845) = '2nd Team') \n \tTHEN \n \t\t(CASE \n \tWHEN (`All-WNBA 2nd Team` = 'x') THEN `Player` END) \n \n \t\tEND) \n\nEND)", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`All WNBA?`', 'columnPosition': 17}, {'columnName': '`All-WNBA 1st Team?`', 'columnPosition': 172}, {'columnName': '`Player`', 'columnPosition': 205}, {'columnName': '`All-WNBA 2nd Team`', 'columnPosition': 344}, {'columnName': '`Player`', 'columnPosition': 376}], 'variable': False}, 'calculation_5ba46def-39e2-4d6b-b66b-ab28abd6fac8': {'templateId': 4328, 'id': 'calculation_5ba46def-39e2-4d6b-b66b-ab28abd6fac8', 'name': 'RPG', 'formula': 'IFNULL(`Total Rebounds/Game`, (`Total Rebounds` / `Games Played`))', 'status': 'VALID', 'dataType': 'DOUBLE', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Total Rebounds/Game`', 'columnPosition': 7}, {'columnName': '`Total Rebounds`', 'columnPosition': 31}, {'columnName': '`Games Played`', 'columnPosition': 50}], 'variable': False}, 'calculation_8e0a8dcd-d7e6-4d28-9933-0781c382a71a': {'templateId': 4327, 'id': 'calculation_8e0a8dcd-d7e6-4d28-9933-0781c382a71a', 'name': 'Stat Avg', 'formula': "(CASE \n \n \t\tWHEN (DOMO_BEAST_MODE(3848) = 'Points') THEN DOMO_BEAST_MODE(4333)\n \t\tWHEN (DOMO_BEAST_MODE(3848) = 'Assists') THEN DOMO_BEAST_MODE(4321) \n \t\tWHEN (DOMO_BEAST_MODE(3848) = 'Rebounds') THEN DOMO_BEAST_MODE(4328) \n \t\tWHEN (DOMO_BEAST_MODE(3848) = 'Steals') THEN DOMO_BEAST_MODE(4323) \n \t\tWHEN (DOMO_BEAST_MODE(3848) = 'Blocks') THEN DOMO_BEAST_MODE(4316) \n \n END)\n ", 'status': 'VALID', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'variable': False}, 'calculation_d6742774-6180-4bb5-be8d-60928882c62f': {'templateId': 4335, 'id': 'calculation_d6742774-6180-4bb5-be8d-60928882c62f', 'name': 'Series Compiled', 'formula': "CASE \n\n\tWHEN `F` = 'x' THEN 'Finals'\n WHEN `ECF` = 'x' THEN 'Eastern Conference Finals'\n WHEN `WCF` = 'x' THEN 'Western Conference Finals'\n WHEN `ECSF` = 'x' THEN 'Eastern Conference Semifinals'\n WHEN `WCSF` = 'x' THEN 'Western Conference Semifinals'\n WHEN `ECFR` = 'x' THEN 'Eastern Conference First Round'\n WHEN `WCFR` = 'x' THEN 'Western Conference First Round'\n WHEN `FR` = 'x' THEN 'First Round'\n WHEN `SR` = 'x' THEN 'Second Round'\n WHEN `SF` = 'x' THEN 'Semifinals'\n \n\nEND\n ", 'status': 'VALID', 'dataType': 'STRING', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`F`', 'columnPosition': 13}, {'columnName': '`ECF`', 'columnPosition': 46}, {'columnName': '`WCF`', 'columnPosition': 100}, {'columnName': '`ECSF`', 'columnPosition': 154}, {'columnName': '`WCSF`', 'columnPosition': 213}, {'columnName': '`ECFR`', 'columnPosition': 272}, {'columnName': '`WCFR`', 'columnPosition': 332}, {'columnName': '`FR`', 'columnPosition': 392}, {'columnName': '`SR`', 'columnPosition': 431}, {'columnName': '`SF`', 'columnPosition': 471}], 'variable': False}, 'calculation_be726694-1c06-43d8-b615-0f283dbcf02f': {'templateId': 4321, 'id': 'calculation_be726694-1c06-43d8-b615-0f283dbcf02f', 'name': 'APG', 'formula': 'IFNULL(`Assists/Game`, (`Assists` / `Games Played`))', 'status': 'VALID', 'dataType': 'DOUBLE', 'persistedOnDataSource': True, 'isAggregatable': False, 'bignumber': False, 'columnPositions': [{'columnName': '`Assists/Game`', 'columnPosition': 7}, {'columnName': '`Assists`', 'columnPosition': 24}, {'columnName': '`Games Played`', 'columnPosition': 36}], 'variable': False}}, Schema=DomoDataset_Schema(dataset_id='20b70c3e-4b35-4661-b3ce-1e45f1a88183', columns=[]), Stream=DomoStream(id=None, dataset_id='20b70c3e-4b35-4661-b3ce-1e45f1a88183', transport_description=None, transport_version=None, update_method=None, data_provider_name=None, data_provider_key=None, account_id=None, account_display_name=None, account_userid=None, has_mapping=False, configuration=[], configuration_tables=[], configuration_query=None), Tags=DomoTags(tag_ls=[]), PDP=<domolibrary.classes.DomoPDP.Dataset_PDP_Policies object at 0x7ce410b65100>, Certification=None),
DomoDataset(id='7c307366-ae67-482d-b063-05c4361d5a35', display_type='webform', data_provider_type='webform', name='[1947-2024] NBA Playoff Records', description=None, row_count=1756, column_count=18, stream_id=1387, owner={'id': '29257675', 'name': 'Shivam Desai - BTP', 'type': 'USER', 'group': False}, formula={}, Schema=DomoDataset_Schema(dataset_id='7c307366-ae67-482d-b063-05c4361d5a35', columns=[]), Stream=DomoStream(id=1387, dataset_id='7c307366-ae67-482d-b063-05c4361d5a35', transport_description=None, transport_version=None, update_method=None, data_provider_name=None, data_provider_key=None, account_id=None, account_display_name=None, account_userid=None, has_mapping=False, configuration=[], configuration_tables=[], configuration_query=None), Tags=DomoTags(tag_ls=[]), PDP=<domolibrary.classes.DomoPDP.Dataset_PDP_Policies object at 0x7ce4108f2810>, Certification=None)]sample implementation search_accounts
additional_filters_ls = [
generate_search_datacenter_filter(
datacenter_routes.Datacenter_Filter_Field_Enum.DATAPROVIDER.value,
"Google Sheets",
)
]
(
await DomoDatacenter.get_accounts(
auth=auth,
# additional_filters_ls=additional_filters_ls,
return_raw=False,
debug_api=False,
)
)[0:5][DomoAccount(id=50, name='**ReplicationUtility**:modocorp.domo.com', data_provider_type='dataset-copy', created_dt=datetime.datetime(2022, 10, 6, 19, 20, 34), modified_dt=datetime.datetime(2024, 10, 16, 15, 45, 49), owners=[DictDot(id='1345102715', type='USER', displayName='McWayne Mumford')], is_admin_summary=True),
DomoAccount(id=84, name='**ReplicationUtility**:domo-ncv.domo.com', data_provider_type='dataset-copy', created_dt=datetime.datetime(2023, 11, 20, 22, 25, 42), modified_dt=datetime.datetime(2025, 1, 30, 15, 58, 53), owners=[DictDot(id='152768850', type='USER', displayName='Heath Pulham')], is_admin_summary=True),
DomoAccount_Credential(id=100, name='domo-community_NF', data_provider_type='domo-access-token', created_dt=datetime.datetime(2024, 3, 24, 0, 53, 57), modified_dt=datetime.datetime(2024, 5, 29, 15, 23, 46), owners=[DictDot(id='1893952720', type='USER', displayName='Jae Wilson1')], is_admin_summary=True, target_instance=None, is_valid_full_auth=None, is_valid_token_auth=None, target_auth=None, target_user=None),
DomoAccount_Credential(id=125, name='sudo_demo', data_provider_type='domo-access-token', created_dt=datetime.datetime(2024, 6, 3, 22, 10, 45), modified_dt=datetime.datetime(2024, 6, 3, 22, 10, 45), owners=[DictDot(id='1893952720', type='USER', displayName='Jae Wilson1')], is_admin_summary=True, target_instance=None, is_valid_full_auth=None, is_valid_token_auth=None, target_auth=None, target_user=None),
DomoAccount(id=99, name='jw_sudo_demo_admin', data_provider_type='abstract-credential-store', created_dt=datetime.datetime(2024, 3, 23, 22, 11, 42), modified_dt=datetime.datetime(2024, 6, 3, 22, 12, 36), owners=[DictDot(id='1893952720', type='USER', displayName='Jae Wilson1')], is_admin_summary=True)]# domo_dataset = await dmds.DomoDataset.get_by_id(dataset_id=dataset_id, auth = auth)
# await DomoDatacenter.get_lineage_upstream(
# auth=auth,
# domo_entity=domo_dataset,
# # return_raw = True,
# # debug_api = True
# )additional_filters_ls = [
generate_search_datacenter_filter(
field=Datacenter_Filter_Field_Enum.CERTIFICATION.value,
value=Datacenter_Filter_Field_Certification_Enum.CERTIFIED.value,
)
]
print(additional_filters_ls)
await DomoDatacenter.search_cards(
auth=auth,
# additional_filters_ls=additional_filters_ls,
maximum=5,
# return_raw = True,
# debug_api = True
)[{'filterType': 'term', 'field': 'certification.state', 'value': 'CERTIFIED', 'not': False}][DomoCard(id=1036070144, title='Salesforce', description=None, type='kpi', urn='1036070144', chart_type=None, dataset_id='fff33fa8-bc96-4754-92ad-5a2f8789717f', datastore_id=None, domo_collections=None, domo_source_code=None, certification=DictDot(state='CERTIFIED', lastUpdated=1705541792599, userId='1734948150', processType='DEPARTMENT', approvalRequestId='37bb5013-8939-4cc7-9e46-ad2299832040', processName='MajorDomo - TB', adminCertified=False), owners=[DomoUser(id='1734948150', display_name='Thomas Bruno', email_address='Thomas.Bruno@elevancehealth.com', role_id=2097317660, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/1734948150', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number=None, hire_date=None, reports_to=None, publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 16, 17, 5, 1), last_activity_dt=datetime.datetime(2024, 1, 17, 23, 1, 39, 744000), custom_attributes={}, role=DomoRole(id=2097317660, name='Community_Default_Priviliged', description='Full access except for editing users and settings owners', is_system_role=0, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None)]),
DomoCard(id=1693394557, title='gov_datasetEfficiency', description='', type='kpi', urn='1693394557', chart_type=None, dataset_id='4fc29727-43a4-47ad-94a0-d0021dad8f40', datastore_id=None, domo_collections=None, domo_source_code=None, certification=DictDot(state='CERTIFIED', lastUpdated=1690401760016, userId='1893952720', processType='COMPANY', approvalRequestId='80573acf-7877-44b1-b995-2e9b869a936d', processName='Company', adminCertified=False), owners=[DomoUser(id='1893952720', display_name='Jae Wilson1', email_address='jae@datacrew.space', role_id=810756122, department='Business Improvement', title=None, avatar_key='/api/content/v1/avatar/USER/1893952720', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number=None, hire_date=None, reports_to=None, publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2020, 5, 8, 17, 55, 18), last_activity_dt=datetime.datetime(2025, 1, 30, 15, 54, 11, 742000), custom_attributes={}, role=DomoRole(id=810756122, name='super_admin', description='all grants - updated on 2024-11-07', is_system_role=0, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None)]),
DomoCard(id=702681585, title='Major Domo certification activity 1', description=None, type='kpi', urn='702681585', chart_type=None, dataset_id='241025d7-3cca-4369-b7c0-b3264277c0e1', datastore_id=None, domo_collections=None, domo_source_code=None, certification=DictDot(state='CERTIFIED', lastUpdated=1716247500838, userId='2087243500', processType='DEPARTMENT', approvalRequestId='43b45fb6-3074-4c41-a0a1-4dff57b0bd41', processName='Major Domo Activity 5 - KM', adminCertified=False), owners=[DomoUser(id='2087243500', display_name='Kelly MacAvaney', email_address='macavaney@proton.me', role_id=2097317660, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/2087243500', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number=None, hire_date=None, reports_to=None, publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 5, 9, 15, 25, 19), last_activity_dt=datetime.datetime(2024, 7, 2, 17, 23, 30, 721000), custom_attributes={}, role=DomoRole(id=2097317660, name='Community_Default_Priviliged', description='Full access except for editing users and settings owners', is_system_role=0, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None)]),
DomoCard(id=2130409888, title='Treemap Example', description=None, type='domoapp', urn='2130409888', chart_type=None, dataset_id='91cd5172-0d76-4189-a747-526b4cedbf34', datastore_id='98f731ef-0a73-43c4-a83f-cfd484789f77', domo_collections=None, domo_source_code=None, certification=DictDot(state='NOT_CERTIFIED', adminCertified=False), owners=[DomoUser(id='1728973208', display_name='Peter Shull', email_address='shullp05@gmail.com', role_id=2, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/1728973208', phone_number='706-294-3231', web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number=None, hire_date=None, reports_to=None, publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 2, 21, 21, 1, 28), last_activity_dt=datetime.datetime(2025, 1, 29, 21, 39, 16, 692000), custom_attributes={}, role=DomoRole(id=2, name='Privileged', description='Full access except for editing users and settings owners', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None)]),
DomoCard(id=919721869, title='User Action Log', description='USER ACTION LOG\nTracks every user action in your Domo instance.', type='kpi', urn='919721869', chart_type=None, dataset_id='61c4e63d-0627-41f7-b138-74968ebd7634', datastore_id=None, domo_collections=None, domo_source_code=None, certification=DictDot(state='NOT_CERTIFIED', adminCertified=False), owners=[DomoUser(id='587894148', display_name='Bryan Van Kampen', email_address='bryan@bvankampen.net', role_id=1, department='BT Partners', title='Executive Analytics', avatar_key='/api/content/v1/avatar/USER/587894148', phone_number='6304647034', web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number=None, hire_date=1588827600000, reports_to='1893952720', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2020, 5, 7, 17, 57, 47), last_activity_dt=datetime.datetime(2025, 1, 30, 16, 6, 14, 368000), custom_attributes={}, role=DomoRole(id=1, name='Admin', description='Full access to everything', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None)])]await DomoDatacenter.get_cards_admin_summary(
auth=auth,
# return_raw = True,
maximum=5,
# debug_api = True
)[DomoCard(id=332819959, title=' Forecast-Sales_MG', description=None, type='kpi', urn=None, chart_type=None, dataset_id=None, datastore_id=None, domo_collections=None, domo_source_code=None, certification=None, owners=[DomoUser(id='722128535', display_name='Miguel Guedes', email_address='Miguel.guedes@cgi.com', role_id=2, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/722128535', phone_number='+351913017621', web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number=None, hire_date=None, reports_to='1339082609', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2021, 4, 27, 8, 26, 49), last_activity_dt=datetime.datetime(2024, 1, 22, 21, 19, 58, 509000), custom_attributes={}, role=DomoRole(id=2, name='Privileged', description='Full access except for editing users and settings owners', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None)]),
DomoCard(id=1582016299, title=" Incorrect Append - Forecast Column Header Names Don't Match", description=None, type='document', urn=None, chart_type=None, dataset_id=None, datastore_id=None, domo_collections=None, domo_source_code=None, certification=None, owners=[DomoUser(id='583215149', display_name='John Jarnagin', email_address='John.Jarnagin@domo.com', role_id=1, department='Domo Customer EX Group', title='Sr. Customer Experience Eng.', avatar_key='/api/content/v1/avatar/USER/583215149', phone_number='', web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number=None, hire_date=1680757200000, reports_to=None, publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2023, 1, 30, 22, 47, 58), last_activity_dt=datetime.datetime(2024, 2, 19, 18, 5, 40, 863000), custom_attributes={}, role=DomoRole(id=1, name='Admin', description='Full access to everything', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None)]),
DomoCard(id=1644935628, title='-', description=None, type='kpi', urn=None, chart_type=None, dataset_id=None, datastore_id=None, domo_collections=None, domo_source_code=None, certification=None, owners=[DomoUser(id='29257675', display_name='Shivam Desai - BTP', email_address='SDesai@btpartners.com', role_id=2, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/29257675', phone_number='', web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number=None, hire_date=None, reports_to=None, publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 22, 15, 52, 50), last_activity_dt=datetime.datetime(2025, 1, 21, 19, 14, 42, 69000), custom_attributes={}, role=DomoRole(id=2, name='Privileged', description='Full access except for editing users and settings owners', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None)]),
DomoCard(id=1434786085, title='-', description=None, type='kpi', urn=None, chart_type=None, dataset_id=None, datastore_id=None, domo_collections=None, domo_source_code=None, certification=None, owners=[DomoUser(id='29257675', display_name='Shivam Desai - BTP', email_address='SDesai@btpartners.com', role_id=2, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/29257675', phone_number='', web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number=None, hire_date=None, reports_to=None, publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 22, 15, 52, 50), last_activity_dt=datetime.datetime(2025, 1, 21, 19, 14, 42, 69000), custom_attributes={}, role=DomoRole(id=2, name='Privileged', description='Full access except for editing users and settings owners', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None)]),
DomoCard(id=1550676785, title='-', description=None, type='kpi', urn=None, chart_type=None, dataset_id=None, datastore_id=None, domo_collections=None, domo_source_code=None, certification=None, owners=[DomoUser(id='29257675', display_name='Shivam Desai - BTP', email_address='SDesai@btpartners.com', role_id=2, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/29257675', phone_number='', web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number=None, hire_date=None, reports_to=None, publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 22, 15, 52, 50), last_activity_dt=datetime.datetime(2025, 1, 21, 19, 14, 42, 69000), custom_attributes={}, role=DomoRole(id=2, name='Privileged', description='Full access except for editing users and settings owners', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None)])]CodeEngine
import domolibrary.utils.chunk_execution as dmce(await DomoDatacenter.search_codeengine(
auth=auth,
# return_raw = True,
# maximum=5,
# debug_api = True
))[0:5]'NoneType' object has no attribute 'group'
'NoneType' object has no attribute 'group'
'NoneType' object has no attribute 'group'
expected string or bytes-like object, got 'NoneType'
expected string or bytes-like object, got 'NoneType'
expected string or bytes-like object, got 'NoneType'
expected string or bytes-like object, got 'NoneType'
'NoneType' object has no attribute 'group'[DomoCodeEngine_PackageVersion(package_id='aaee1eca-aea9-4d8a-b402-c1855f8f86a2', version='1.0.1', language='JAVASCRIPT', description=None, createdby_id='1893952720', released_dt=None, configuration={'accountsMapping': [{'accountId': '124', 'alias': 'account'}], 'mlModel': [], 'externalPackageMapping': {}}, createdby=None, accounts_mapping=[{'accountId': '124', 'alias': 'account'}], ml_model=[], functions=[DomoCodeEngine_Function(name='generateAuthHeader', displayName='Generate Auth Header', description='', language='JAVASCRIPT', code='async function generateAuthHeader(\n accountName,\n headers = {},\n isAbstract = false\n) {\n const creds = await retrieveAccountCreds(accountName, isAbstract);\n\n return { ...headers, "x-domo-developer-token": creds.domoAccessToken };\n}\n\nasync function getData(\n method,\n url,\n accountName,\n headers = {},\n params = {},\n bodyJson = null, // codeengine inputs must be typed\n bodyStr = null, // codeengine inputs must be typed\n debugApi = false,\n debugPrn = false\n) {\n if (debugApi) {\n console.log({\n url,\n method,\n body: bodyStr || bodyJson,\n });\n }\n\n let res, data;\n if (!accountName || accountName === null) {\n if (debugPrn) {\n console.log("🌵 - using user_auth");\n }\n url = url.split(".domo.com/")[1];\n res = await codeEngine.sendRequest(method, url, bodyJson || bodyStr);\n\n return { status: 200, response: res, isSuccess: true };\n } else {\n if (debugPrn) {\n console.log("🌵 - using SUDO_auth");\n }\n\n headers = await generateAuthHeader(accountName, headers, false);\n\n res = await codeEngine.axios(url, {\n method,\n headers,\n params,\n data: bodyJson || bodyStr,\n });\n data = await res.data;\n }\n\n if (res.status >= 400) {\n throw new Error(`HTTP error! status: ${res.status}`);\n }\n\n return {\n status: res.status,\n response: data,\n isSuccess: res.status < 400,\n };\n}\n\nasync function sharePage(\n page_id,\n group_id,\n accountName,\n domoInstance,\n debugApi = true,\n debugPrn = false\n) {\n const body = {\n resources: [{ type: "page", id: page_id }],\n recipients: [{ type: "group", id: group_id }],\n message: "I thought you might find this page interesting.",\n };\n\n return await getData(\n "POST",\n `https://${domoInstance}.domo.com/api/content/v1/share`,\n accountName,\n null,\n null,\n body,\n null,\n debugApi,\n debugPrn\n );\n}\n\nasync function getPages(\n accountName,\n domoInstance,\n debugApi = true,\n debugPrn = false\n) {\n const body = {\n includeVirtual: false,\n includePageTitleClause: true,\n orderBy: "parentPageTitlePageTitle",\n pageTitleSearchText: "",\n includeDataAppViews: true,\n };\n\n const res = await getData(\n "POST",\n `https://${domoInstance}.domo.com/api/content/v1/pages/adminsummary`,\n accountName,\n null,\n null,\n body,\n null,\n debugApi,\n debugPrn\n );\n\n res.response = res.response.pageAdminSummaries;\n\n return res;\n}\n', code_prefix=None), DomoCodeEngine_Function(name='getData', displayName='Get Data', description='', language='JAVASCRIPT', code='async function getData(\n method,\n url,\n accountName,\n headers = {},\n params = {},\n bodyJson = null, // codeengine inputs must be typed\n bodyStr = null, // codeengine inputs must be typed\n debugApi = false,\n debugPrn = false\n) {\n if (debugApi) {\n console.log({\n url,\n method,\n body: bodyStr || bodyJson,\n });\n }\n\n let res, data;\n if (!accountName || accountName === null) {\n if (debugPrn) {\n console.log("🌵 - using user_auth");\n }\n url = url.split(".domo.com/")[1];\n res = await codeEngine.sendRequest(method, url, bodyJson || bodyStr);\n\n return { status: 200, response: res, isSuccess: true };\n } else {\n if (debugPrn) {\n console.log("🌵 - using SUDO_auth");\n }\n\n headers = await generateAuthHeader(accountName, headers, false);\n\n res = await codeEngine.axios(url, {\n method,\n headers,\n params,\n data: bodyJson || bodyStr,\n });\n data = await res.data;\n }\n\n if (res.status >= 400) {\n throw new Error(`HTTP error! status: ${res.status}`);\n }\n\n return {\n status: res.status,\n response: data,\n isSuccess: res.status < 400,\n };\n}\n\nasync function sharePage(\n page_id,\n group_id,\n accountName,\n domoInstance,\n debugApi = true,\n debugPrn = false\n) {\n const body = {\n resources: [{ type: "page", id: page_id }],\n recipients: [{ type: "group", id: group_id }],\n message: "I thought you might find this page interesting.",\n };\n\n return await getData(\n "POST",\n `https://${domoInstance}.domo.com/api/content/v1/share`,\n accountName,\n null,\n null,\n body,\n null,\n debugApi,\n debugPrn\n );\n}\n\nasync function getPages(\n accountName,\n domoInstance,\n debugApi = true,\n debugPrn = false\n) {\n const body = {\n includeVirtual: false,\n includePageTitleClause: true,\n orderBy: "parentPageTitlePageTitle",\n pageTitleSearchText: "",\n includeDataAppViews: true,\n };\n\n const res = await getData(\n "POST",\n `https://${domoInstance}.domo.com/api/content/v1/pages/adminsummary`,\n accountName,\n null,\n null,\n body,\n null,\n debugApi,\n debugPrn\n );\n\n res.response = res.response.pageAdminSummaries;\n\n return res;\n}\n', code_prefix=None), DomoCodeEngine_Function(name='getPages', displayName='Get Pages', description='', language='JAVASCRIPT', code='async function getPages(\n accountName,\n domoInstance,\n debugApi = true,\n debugPrn = false\n) {\n const body = {\n includeVirtual: false,\n includePageTitleClause: true,\n orderBy: "parentPageTitlePageTitle",\n pageTitleSearchText: "",\n includeDataAppViews: true,\n };\n\n const res = await getData(\n "POST",\n `https://${domoInstance}.domo.com/api/content/v1/pages/adminsummary`,\n accountName,\n null,\n null,\n body,\n null,\n debugApi,\n debugPrn\n );\n\n res.response = res.response.pageAdminSummaries;\n\n return res;\n}\n', code_prefix=None), DomoCodeEngine_Function(name='retrieveAccountCreds', displayName='Retrieve Account Creds', description='', language='JAVASCRIPT', code='async function retrieveAccountCreds(accountName, isAbstract = false) {\n const creds = await codeEngine.getAccount(accountName);\n const properties = creds.properties;\n\n return !isAbstract ? properties : properties.credentials;\n}\n\nasync function generateAuthHeader(\n accountName,\n headers = {},\n isAbstract = false\n) {\n const creds = await retrieveAccountCreds(accountName, isAbstract);\n\n return { ...headers, "x-domo-developer-token": creds.domoAccessToken };\n}\n\nasync function getData(\n method,\n url,\n accountName,\n headers = {},\n params = {},\n bodyJson = null, // codeengine inputs must be typed\n bodyStr = null, // codeengine inputs must be typed\n debugApi = false,\n debugPrn = false\n) {\n if (debugApi) {\n console.log({\n url,\n method,\n body: bodyStr || bodyJson,\n });\n }\n\n let res, data;\n if (!accountName || accountName === null) {\n if (debugPrn) {\n console.log("🌵 - using user_auth");\n }\n url = url.split(".domo.com/")[1];\n res = await codeEngine.sendRequest(method, url, bodyJson || bodyStr);\n\n return { status: 200, response: res, isSuccess: true };\n } else {\n if (debugPrn) {\n console.log("🌵 - using SUDO_auth");\n }\n\n headers = await generateAuthHeader(accountName, headers, false);\n\n res = await codeEngine.axios(url, {\n method,\n headers,\n params,\n data: bodyJson || bodyStr,\n });\n data = await res.data;\n }\n\n if (res.status >= 400) {\n throw new Error(`HTTP error! status: ${res.status}`);\n }\n\n return {\n status: res.status,\n response: data,\n isSuccess: res.status < 400,\n };\n}\n\nasync function sharePage(\n page_id,\n group_id,\n accountName,\n domoInstance,\n debugApi = true,\n debugPrn = false\n) {\n const body = {\n resources: [{ type: "page", id: page_id }],\n recipients: [{ type: "group", id: group_id }],\n message: "I thought you might find this page interesting.",\n };\n\n return await getData(\n "POST",\n `https://${domoInstance}.domo.com/api/content/v1/share`,\n accountName,\n null,\n null,\n body,\n null,\n debugApi,\n debugPrn\n );\n}\n\nasync function getPages(\n accountName,\n domoInstance,\n debugApi = true,\n debugPrn = false\n) {\n const body = {\n includeVirtual: false,\n includePageTitleClause: true,\n orderBy: "parentPageTitlePageTitle",\n pageTitleSearchText: "",\n includeDataAppViews: true,\n };\n\n const res = await getData(\n "POST",\n `https://${domoInstance}.domo.com/api/content/v1/pages/adminsummary`,\n accountName,\n null,\n null,\n body,\n null,\n debugApi,\n debugPrn\n );\n\n res.response = res.response.pageAdminSummaries;\n\n return res;\n}\n', code_prefix=None), DomoCodeEngine_Function(name='sharePage', displayName='Share Page', description='', language='JAVASCRIPT', code='async function sharePage(\n page_id,\n group_id,\n accountName,\n domoInstance,\n debugApi = true,\n debugPrn = false\n) {\n const body = {\n resources: [{ type: "page", id: page_id }],\n recipients: [{ type: "group", id: group_id }],\n message: "I thought you might find this page interesting.",\n };\n\n return await getData(\n "POST",\n `https://${domoInstance}.domo.com/api/content/v1/share`,\n accountName,\n null,\n null,\n body,\n null,\n debugApi,\n debugPrn\n );\n}\n\nasync function getPages(\n accountName,\n domoInstance,\n debugApi = true,\n debugPrn = false\n) {\n const body = {\n includeVirtual: false,\n includePageTitleClause: true,\n orderBy: "parentPageTitlePageTitle",\n pageTitleSearchText: "",\n includeDataAppViews: true,\n };\n\n const res = await getData(\n "POST",\n `https://${domoInstance}.domo.com/api/content/v1/pages/adminsummary`,\n accountName,\n null,\n null,\n body,\n null,\n debugApi,\n debugPrn\n );\n\n res.response = res.response.pageAdminSummaries;\n\n return res;\n}\n', code_prefix=None)]),
DomoCodeEngine_PackageVersion(package_id='511052c6-d852-4dc4-b3dd-6a7e2115303d', version='1.0.0', language='PYTHON', description=None, createdby_id='1893952720', released_dt=None, configuration={'accountsMapping': [{'accountId': '92', 'alias': 'sudo'}, {'accountId': '125', 'alias': 'test'}], 'mlModel': [], 'externalPackageMapping': {}}, createdby=None, accounts_mapping=[{'accountId': '92', 'alias': 'sudo'}, {'accountId': '125', 'alias': 'test'}], ml_model=[], functions=None),
DomoCodeEngine_PackageVersion(package_id='b1c21da8-2c37-491f-8067-7ad75346c6fc', version='1.0.0', language='JAVASCRIPT', description=None, createdby_id='1893952720', released_dt=None, configuration={'accountsMapping': [], 'mlModel': [], 'externalPackageMapping': {}}, createdby=None, accounts_mapping=[], ml_model=[], functions=[DomoCodeEngine_Function(name='setMyLandingPage', displayName='Set My Landing Page', description='update the users landing page', language='JAVASCRIPT', code='async function setMyLandingPage(objectId, objectType ) {\n if (!([\'CARD\', \'PAGE\'].includes(objectType))) {\n throw new Error("🤯 invalid inputs: `objectType` must be \'PAGE\' or \'CARD\'");\n }\n \n const url = `/api/content/v1/landings/target/DESKTOP/entity/${objectType}/id/${String(objectId)}/me`\n \n try{\n let r = await codeengine.sendRequest(\'put\', url, {})\n return true\n \n } catch(err) {\n throw new Error(`🤯 API Error: ${err.status} - ${err.statusReason} -- check valid \\`objectId\\` (is it shared with you?)`);\n }\n} \n\n\n', code_prefix=None)]),
DomoCodeEngine_PackageVersion(package_id='517ca12c-3459-4e66-b0bb-40f000720a84', version='1.0.0', language='PYTHON', description=None, createdby_id='1893952720', released_dt=None, configuration={'accountsMapping': [{'accountId': '92', 'alias': 'admin'}], 'mlModel': [], 'externalPackageMapping': {}}, createdby=None, accounts_mapping=[{'accountId': '92', 'alias': 'admin'}], ml_model=[], functions=None),
DomoCodeEngine_PackageVersion(package_id='fc484f87-4e05-45a5-8e1b-8f6fac8cac5b', version='1.0.0', language='PYTHON', description=None, createdby_id='1893952720', released_dt=None, configuration={'accountsMapping': [], 'mlModel': [], 'externalPackageMapping': {}}, createdby=None, accounts_mapping=[], ml_model=[], functions=[DomoCodeEngine_Function(name='greeting', displayName='Greeting', description='', language='PYTHON', code='def greeting(name): \n print("Hello " + name)\n return "Hello " + name', code_prefix=None)])]