locked
ADF V2 Custom activity RRS feed

  • Question

  • Building on the example given here in ADFV2 documentation here - https://docs.microsoft.com/en-us/azure/data-factory/transform-data-using-dotnet-custom-activity#executing-commands

    Here are the issues I am seeing, the custom activity code area is not editable, so I can't seem to add the extended properties where needed. I could use the UI but still figuring out the value for a connectionString extended property and how it should look. It would be much easier to use the json to add the secure string in the extended property. Any ideas as to what value would look like for a data lake connection string?

    Monday, September 24, 2018 8:29 PM

All replies

  • Hello,

    I haven't been able to create the connection string in the UI, have you tried passing the extended properties as a JSON file as described here:

    https://docs.microsoft.com/en-us/azure/data-factory/transform-data-using-dotnet-custom-activity#passing-objects-and-properties

    As far as what the JSON would look like, have you tried something like this:

    {
    	"extendedProperties": {
    		"connectionString": {
    			"type": "SecureString",
    			"value": "adl://[accountname].azuredatalakestore.net/"
    		}
    	}
    }


    • Proposed as answer by Jason_J (Azure) Monday, September 24, 2018 10:14 PM
    Monday, September 24, 2018 10:14 PM
  • Yes. I tried this, however I realize that it can't be used as is -

    dynamic activity = JsonConvert.DeserializeObject(File.ReadAllText("activity.json"));
    Console.WriteLine(activity.typeProperties.extendedProperties.connectionString.value


    As this would give a RuntimeBinderException: 'Newtonsoft.Json.Linq.JValue' does not contain a definition for 'value'




    • Edited by Saj Alloo Tuesday, September 25, 2018 1:40 PM
    Tuesday, September 25, 2018 1:39 PM