title: Azure Data Factory Lookup and For Each
body: <p>I have a Data Factory Pipeline that I want to have iterate through the rows of a SQL Lookup activity. I have narrowed the query down to three columns and 500 rows. </p>
  
  <p>I understand that to reference a value in the table I use:</p>
  
  <pre><code>@{activity('lookupActivity').output.value[row#].colname}
  </code></pre>
  
  <p>However, the for each needs to have something to iterate over. My first guess is to set some array variable to the rows of the returned sql query. So what do I set that variable to?</p>
  
  <pre><code>@{activity('lookupActivity').output.value?
  </code></pre>
  
  <p>Lastly, it looks like almost all data is represented as a json in ADF, is this true? And how could I view the output of this look up as a json so I can understand what my dynamic content needs to look like?</p>