title: Azure Data Factory Copy Activity error mapping JSON to SQL
body: <p>I have an Azure Data Factory Copy Activity that is using a REST request to elastic search as the Source and attempting to map the response to a SQL table as the Sink. Everything works fine except when it attempts to map the <code>data</code> field that contains the dynamic JSON. I get the following error:</p>
  
  <blockquote>
    <p>{
        "errorCode": "2200",
        "message": "ErrorCode=UserErrorUnsupportedHierarchicalComplexValue,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The retrieved type of data JObject with value {\"name\":\"department\"} is not supported yet, please either remove the targeted column or enable skip incompatible row to skip them.,Source=Microsoft.DataTransfer.Common,'",
        "failureType": "UserError",
        "target": "CopyContents_Paged",
        "details": []
    }</p>
  </blockquote>
  
  <p>Here's an example of my mapping configuration:</p>
  
  <pre><code>    "type": "TabularTranslator",
      "mappings": [
          {
              "source": {
                  "path": "['_source']['id']"
              },
              "sink": {
                  "name": "ContentItemId",
                  "type": "String"
              }
          },
          {
              "source": {
                  "path": "['_source']['status']"
              },
              "sink": {
                  "name": "Status",
                  "type": "Int32"
              }
          },
          {
              "source": {
                  "path": "['_source']['data']"
              },
              "sink": {
                  "name": "Data",
                  "type": "String"
              }
          }
      ],
      "collectionReference": "$['hits']['hits']"
  }
  </code></pre>
  
  <p>The JSON in the <code>data</code> object is dynamic so I'm unable to do an explicit mapping for the nested fields within it. That's why I'm trying to just store the entire JSON object under <code>data</code> in a column of a SQL table.</p>
  
  <p>How can I adjust my mapping configuration to allow this to work properly?</p>