Forum Discussion

smpa01's avatar
smpa01
Community Champion
2 years ago

Methods available to datamart API

gbrueckl    I ran the following method on datamart just to test if refreshes method is avaialble to datamart apiPath ( as it is availabale to dataset apiPath)     -- the following returns ...
notebook
  • smpa01's avatar
    smpa01
    Community Champion
    2 years ago

    gbrueckl  Thanks.

     

    The documenation does not list any method for datamart

    yet the following succeeds  on a workspace_apiPath  concat('/groups/abcdef-ghij-klmn-opqr-stuvwx',

    '/datamarts') that made me think that I might be able to call other methods.
     
    I am little confused here as datamrts don't have any API methods yet it succedds
    and I thought I would be able to call additional methods on apiPath?

     

     

     

    cteThree as (    
select dm
from cteTwo
LATERAL VIEW explode(pbi_api_udf(concat( workspace_apiPath, '/datamarts'), '${pbi_access_token}')) AS dm
)

the above returns an object
{
		"capabilities": "4",
		"lastRefreshTimeUTC": "2024-05-28T22:47:54.263Z",
		"modifiedByUser": "{displayName=user, [email protected], objectId=9e1103aa-a128-4bec-8b8e-d1004422b3b7}",
		"name": "DEV",
		"state": "1",
		"datasetObjectId": "f331fd8e-b3ce-4b24-90aa-c5a0d6699aaf",
		"lastRefreshStatus": "1",
		"datamartType": "Sql",
		"apiPath": "/groups/grpID/datamarts",
		"nextRefreshTimeUTC": "9999-12-31T23:59:59.997Z",
		"datasetId": "1955466",
		"version": "638477205269348724",
		"ownerUser": "{displayName=user, [email protected], objectId=9e1103aa-a128-4bec-8b8e-d1004422b3b7}",
		"lastModifiedTimeUTC": "2024-05-29T00:58:29.79",
		"status": "1",
		"objectId": "245952d6-0487-4f2a-abcb-89689d4813c5",
		"folderObjectId": "f8a6fefa-0df7-4fe7-ac93-dc0a9003594e",
		"dataflowObjectId": "659bd422-955c-43b7-8304-4e50b8f1ab48",
		"createdDate": "2024-05-28T15:06:43.76"
	}