<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Updated Azure Data Factory Connector in Logic Apps

Recently, I was with a client who was using Azure Logic Apps to trigger an Azure Data Factory pipeline. If you’re using Azure Logic Apps to do this, I’d like to share a tip with you.

For those of you that are using Logic Apps and passing parameters to ADF, the Connector in Logic Apps got an update where you can add a parameter directly using the GUI and no longer need to hard code this in the JSON like we had to do previously.

Let’s jump into the Azure portal to see how this works: (please view video included here to see demo)

  • In the portal, I go into my Logic Apps and I’ve got two Logic Apps.
  • I go into the ADF Connector Logic App and click on Edit.
  • Next, I click on “+ New Step” and Choose an Action; I click on Azure Data Factory and then “Create a Pipeline Run”.
  • Then, I fill in my criteria: my subscription, resource group, the Data Factory name and Data Factory pipeline name. For this demo, my Data Factory/Pipeline name is TriggerMeFromLogicApps.
  • You’ll also see Add New Parameter. Here we can hit the drop down and add parameters. Click on the parameter button, then click off that screen. This will add the parameter as an option to the connector, which you can click on that parameters field and add some dynamic content, such as Schedule Code. Then click “Save”.

Joe Abbott Logic Apps blog 1

  • This will work as it was saved and there were no errors/issues -- this will NOT trigger that pipeline with that parameter; let me show you why and what needs to be done. You must specify the name of the parameter in JSON format for this to work correctly.

Joe Abbott Logic Apps blog 2

 We don’t want to use just that parameter, we must give it a Key Value Pair:

 {

      “Key”:”Value”

 }

  • If you do NOT add the correct syntax it will still trigger the ADF Pipeline, but won’t pass any parameter values, so the ADF pipeline will just use the default value (if you set one up). See below:
  • Without Formatting the parameter – the value is there but no identifier

 
Joe Abbott Logic Apps blog 3

  • After Formatting the parameter – see how now we have a key/value pair

 Joe Abbott Logic Apps blog 4

You need to do this so that Azure Data Factory knows what you’re passing to it and you can go in and put your dynamic content in for your schedule code. I ran into a few issues with this when I first fired it up, so I hope this tip is helpful to you.

If you have questions on this or anything Azure related, you’re in the right place. Click the link below or contact us—we’re here to help every step of the way and help you take your business from good to great.

 

New Call-to-action
bg-img14.jpg

Join Our Blog

Join thousands of other SQL Server, BI and cloud pros by subscribing to our blog.

Leave a comment

Posts by Topic

see all

Recent Articles

Popular Articles