title: Pre-copy script in data factory or on the fly data processing
body: <p>I am copying data from a source, an API, and copying it into Azure SQL DB. But in one of the column I am getting Json objects. </p>
  
  <p>Any way i can use dynamic parameters (either through Pre-copy script or something else) in the pipeline to only take value of a particular tag from those json objects so that i can have only that value in the column. Only constraint is that I can't change the sink. It has to be Azure SQL DB.</p>
  
  <p>Json object I am getting:
  [{"self":"<a href="https://xxxxxxxx.jira.com/rest/api/2/customFieldOption/11903" rel="nofollow noreferrer">https://xxxxxxxx.jira.com/rest/api/2/customFieldOption/11903</a>","value":"Yes","id":"11903"}]</p>
  
  <p>And I want only 'value' tag response not the complete json.</p>