title: Azure Data Factory, Passing REST GET response to stored procedure in Azure SQL Database
body: <p>I'm trying to build a (I think) very simple pipeline:</p>
  <ol>
  <li>Get the textual body of a GET operation.</li>
  <li>Pass the (json) output as-is (= no transformations needed in ADF) to a &quot;Json&quot; parameter of a stored procedure in an Azure SQL Server database. The stored procedure handles the (complex) parsing/mapping.</li>
  </ol>
  <p>I thought that this can be done with just 1 Copy activity, but now I think I'm wrong.</p>
  <p>In de Copy activity the Sink configuration looks like this:</p>
  <pre><code>&quot;sink&quot;: {
    &quot;type&quot;: &quot;AzureSqlSink&quot;,
    &quot;sqlWriterStoredProcedureName&quot;: &quot;[dbo].[spParseJson]&quot;,
    &quot;sqlWriterTableType&quot;: &quot;What to enter here?&quot;,
    &quot;storedProcedureTableTypeParameterName&quot;: &quot;What to enter here?&quot;,
    &quot;storedProcedureParameters&quot;: {
    &quot;Json&quot;: {
       &quot;type&quot;: &quot;String&quot;,
       &quot;value&quot;: &quot;&lt;output of Source&gt;&quot;
       }
     }
   }
  </code></pre>
  <p>I really tried to read and understand the documentation, but imho the documentation doesn't explain much or in a bad vague way.</p>
  <p>The &quot;output of Source&quot; should be the output from Source. But what function or variable to use for that?</p>
  <p>What should I enter for &quot;sqlWriterTableType&quot; / &quot;storedProcedureTableTypeParameterName&quot;? After some digging I understand that ADF will create temp tables and such, but that isn't what I want.</p>
  <p>I've also tried an other approach:</p>
  <ol>
  <li>Use the Web activity to just download the Json.</li>
  <li>Execute SP with the input: @Activity(&quot;WebactivityName&quot;).output.</li>
  </ol>
  <p>But then I found out that the Web activity is limited to 1MB. The Json is about 1,5 MB. If the limit wouldn't be there, then I would have a solution. Argh.</p>
  <p>FYI:
  The content of the Json has a dynamically changing schema and is not well structured, so there's really no way that I can use the standard mapping capabilities in ADF.</p>
  <p>Any help or guidance is appreciated. If you know of some documentation that is informative then that would also help.</p>