Logic Apps to ADF - Error in connection

Question

Logic Apps to ADF - Error in connection

Kothai Ramanathan 946 Microsoft Employee

I am trying to connect to data factory from logic apps. I created a connection via the designer and tested that it is working fine. However, I converted the same to ARM template and the creation of the logic app was successful. When I see the action in the designer, I see the below :

The error message is not very helpful and not sure what the error is. Can you please throw some light on this ?

This is the code of the action

{
"inputs": {
"body": {
"blobName": "test",
"interchangeId": "1234"
},
"host": {
"connection": {
"name": "@parameters('$connections')['ADFConnectionDetail']['connectionId']"
}
},
"method": "post",
"path": "@markus.bohland@hotmail.de ('/subscriptions/', subscription().id, '/resourcegroups/', resourceGroup().name, '/providers/Microsoft.DataFactory/factories/', parameters('DatafactoryName'), '/pipelines/', parameters('PipelineName'), '/CreateRun' )",
"queries": {
"x-ms-api-version": "2017-09-01-preview"
}
}
}

The status of the API connection of the data factory (in the logic app) is "Connected'.

Thanks,
Kothai

Kothai Ramanathan 946 Reputation points Microsoft Employee

2020-12-02T03:31:55.167+00:00

Any update on the above will be very helpful.

Thanks,
Kothai
Kothai Ramanathan 946 Reputation points Microsoft Employee

2020-12-02T05:54:13.19+00:00

Update on this... I corrected the path variable in the above code, and now the action is successful. Yet, in the designer mode, the above error is still showing up. Not sure why. Any pointers will be helpful.
HarithaMaddi-MSFT 10,146 Reputation points

2020-12-02T11:50:25.543+00:00

Hi @Kothai Ramanathan ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

This looks to me a refresh issue from Logic App as it is not verifying the connection after the update. Please suggest if it gets updated by passing default values to parameters in JSON file and also by creating a new logic app. If the issue persists, I will work to collect more details from you to discuss with product team for further investigation.

Looking forward for your response!

1 answer

Your answer

Kothai Ramanathan 946 Reputation points Microsoft Employee

2020-12-02T03:31:55.167+00:00

Any update on the above will be very helpful.

Thanks,
Kothai
Kothai Ramanathan 946 Reputation points Microsoft Employee

2020-12-02T05:54:13.19+00:00

Update on this... I corrected the path variable in the above code, and now the action is successful. Yet, in the designer mode, the above error is still showing up. Not sure why. Any pointers will be helpful.
HarithaMaddi-MSFT 10,146 Reputation points

2020-12-02T11:50:25.543+00:00

Hi @Kothai Ramanathan ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

This looks to me a refresh issue from Logic App as it is not verifying the connection after the update. Please suggest if it gets updated by passing default values to parameters in JSON file and also by creating a new logic app. If the issue persists, I will work to collect more details from you to discuss with product team for further investigation.

Looking forward for your response!

Answer 1

Hi @Kothai Ramanathan

Apology for the delay.

Yes, you are correct that once you have updated the path to the right resource URL string then everything should be working as expected.
The issue is that the path is not correctly formed as looks like you are using the ARM template parameters. You cannot use the ARM template variable for the logic app runtime. You need to create your own parameter when the operation is evaluating in runtime as in this scenario.

"path": "@markus.bohland@hotmail.de ('/subscriptions/', subscription().id, '/resourcegroups/', resourceGroup().name, '/providers/Microsoft.DataFactory/factories/', parameters('DatafactoryName'), '/pipelines/', parameters('PipelineName'), '/CreateRun' )",

At a deeper level in your logic app's resource definition, your workflow definition's parameters object declares parameters for the values to use at your logic app's runtime.

One more observation when you export the ARM template then the path will be :

"path": "/subscriptions/@{encodeURIComponent('yoursubscriptionID')}/resourcegroups/@{encodeURIComponent('yourresourcegroup')}/providers/Microsoft.DataFactory/factories/@{encodeURIComponent('yourdatafactory')}/pipelines/@{encodeURIComponent('yourpipelinename')}/CreateRun",

I was able to repro the same issue if I change the path and it is not correctly formed and the designer shows the same issue as you have observed. Once I used the above the designer doesn't show any error.

If you want to use your own parameter then you need to define parameters section under properties of your logic app resource as you have defined it for @parameters('$connections')['ADFConnectionDetail']['connectionId']

References:
https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-azure-resource-manager-templates-overview#template-parameters
https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-actions-triggers

Hope the above helps and please let me know if you have any queries.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

Kothai Ramanathan 946 Reputation points Microsoft Employee

2020-12-03T11:40:31.747+00:00

Thank you @MayankBargali-MSFT for the details.

I had made the following changes.

I added another parameter for path in the connections
"path": "[concat(subscription().id, '/resourcegroups/', resourceGroup().name, '/providers/Microsoft.DataFactory/factories/')]"

2) then used the above in the path to the "Create a pipeline run" action of the logic app
"path": "@markus.bohland@hotmail.de (parameters('$connections')['ADFConnectionDetail']['path'], parameters('DatafactoryName'), '/pipelines/', parameters('PipelineName'), '/CreateRun' )"

Again the logic app run is successful, but the designer is still showing the error.
Kothai Ramanathan 946 Reputation points Microsoft Employee

2021-01-04T05:47:43.28+00:00

@MayankBargali-MSFT - I changed the path variable as mentioned in my earlier comment. Even then the error comes up in the designer. Further, I also tried having the direct path (without any concat or any parameters), even then the error shows up in the designer. Any pointers to resolve this, would be helpful.

Share via

Logic Apps to ADF - Error in connection

1 answer

Your answer