Forum Discussion

smpa01's avatar
smpa01
Community Champion
1 year ago
Solved

Unable to refresh dfg2 cicd programatically

##fails
requests.post("https://api.fabric.microsoft.com/v1/workspaces/<ws_id>" + '/dataflows'+'/<df_id>'+"/jobs/instances", headers={"authorization": "Bearer " + token},params = {"jobType": "Refresh"}  )

 

##fails
payload = {
    "executionData":{
        "DataflowName": "dfg2test", 
        "OwnerUserPrincipalName": "[email protected]", 
        "OwnerUserObjectId": "<df_id>" 
    }
}
token = get_token()
req = requests.post("https://api.fabric.microsoft.com/v1/workspaces/<ws_id>" + '/dataflows'+'/<df_id>'+"/jobs/instances", headers={"authorization": "Bearer " + token},params = {"jobType": "Refresh"}, data=payload  )

I am not being able to refresh dfgen2 programmatically, I follwed https://learn.microsoft.com/en-us/fabric/data-factory/dataflow-gen2-public-apis#get-dataflow and https://learn.microsoft.com/en-us/rest/api/fabric/core/job-scheduler/run-on-demand-item-job?tabs=HTT... 

I am getting this. I can manually refesh it as well as through scheduled jobs

There was a problem refreshing the dataflow: 'Something went wrong, please try again later. If the error persists, please contact support.'. Error code: UnknowErrorCode. (Request ID: 37753040-f20b-49d9-a04e-bc589ab12eaf).

 

Using the same SPN, I am able to execute List Dataflows 

 

The more contradictory part of the documentation is Run On Demand Item Job (says SPN can consume endpoint) vs Run On Demand Execute (says SPN can't consume endpoint) 

 

My question is - 

  1. Can a SPN programmatically run a refresh df g2 cicd
  2. If yes, what am I doing wrong?

miguel 

  • The on demand execute endpoint documentation is correct. SPN is not supported just yet. 

    You can request this through the ideas site for prioritization:

    https://aka.ms/FabricIdeas

     

1 Reply

  • miguel's avatar
    miguel
    Community Admin

    The on demand execute endpoint documentation is correct. SPN is not supported just yet. 

    You can request this through the ideas site for prioritization:

    https://aka.ms/FabricIdeas