We want to set up a procedure to trigger a pipeline in Azure Data Factory trough Board to refresh our sql tables in the datawarehouse
However when checking the log we get the following error:
{"ControlFlow":false, "StackTrace":"System.Threading.Tasks.TaskCanceledException: A task was canceled.\r\n at BEng.RestApi.ConnectionSupport.PreAuthorize()\r\n at BEng.RestApi.RestApiExecutor.CallRestApi(CallRestApiArguments arguments)\r\n at BEng.NetProcedure.FLWCallRestApi(oStmType oStm, ClientRequestWithFilters request, CallRestApiArguments arguments)"}
Is it at all possible to trigger an ADF pipeline via rest call API in Board :and if so what should we do to trigger an ADF pipeline from Board?
Note: we were able to successfully run the pipeline from Postman.
Below the steps we have undertaken preceding the error message.
1 set up a pipeline in ADF to be triggered via BOARD
2 register BOARD in ADF registration area
3 retrieve Application (client) Id and Directory (tenant) ID from ADF
4 create a client secret in ADF
5 assign Api permissions in ADF to BOARD
6 Use the client ID, client secret, and tenant ID to generate an Access Token in ADF
7 Use the access token to make a POST request to the Azure Data Factory REST API to trigger the pipeline in Postman
The pipeline was successfully triggered in postman
8 create a new datasource in BOARD
Name: api test pipeline
Type: api
Authentication type: OAUTH V2 (client credential)
Add authorization data to : Request URL
Address token Url: access token received in step 5
Client id: Application (client) ID retrieved in step 3
Client secret: the secret as in step 4
Client authentication: send client credentials in body
Scope: https://management.azure.com/.default
Resource: -
Audience: -
API base Url: https://management.azure.com/subscriptions/{subscription_id}/resourceGroups/{resource_group_name}/providers/Microsoft.DataFactory/factories/{factory_name}/pipelines/{pipeline_name}/createRun?api-version=2018-06-01
9 create a procedure in BOARD with:
Rest Api Call
selectApi Path
Method = Post
Parameters = blank as the information is already in the base url.
When running the procedure in the log the following appears:
When running the procedure in the log the error appears as stated above.
Best regards,
Mirko
