0

i have a lookup activity in ADF which retrieves data from table like below { "count": 1, "value": [ { "Notebook_path": "/Users/Name@work.com/Project/ingestion/Cust1/ADT" } ], "effectiveIntegrationRuntime": "AutoResolveIntegrationRuntime (um)", "billingReference": { "activityType": "PipelineActivity", "billableDuration": [ { "meterType": "AzureIR", "duration": 0.016666666666666666, "unit": "DIUHours" } ] }, "durationInQueue": { "integrationRuntimeQueue": 0 } }

now i want to use the Notebook_path from above results and pass it to a Notebook activity to run that particular notebook as in the output, from lookup activity.

since its in array its creating problems . would appreciate some help here .

tried a lot of things but dint help.

Thanks in Advance

Darkmaster
  • 29
  • 1
  • 3

1 Answers1

0
  • I have a similar lookup output. The following is a reference image of the same.

enter image description here

  • You can use the following dynamic content to get the desired result.
@activity('Lookup1').output.value[0]['notebook_path']

enter image description here

  • My pipeline failed because I don't have a notebook, but you can see that the activity is trying to access the required path.

enter image description here

Saideep Arikontham
  • 5,558
  • 2
  • 3
  • 11
  • Saideep, buddy u r awesome .............! i was scratching my head from 2 days. i reached till @activity('Lookup1').output.value[0] i could not figure out the rest. thanks so much buddy. ill bug u again if i have more to learn :)_ – Darkmaster Feb 15 '23 at 16:38