Forum Discussion

Shayan12378's avatar
Shayan12378
Regular Visitor
5 months ago

I wanted to Store Rest API Response as A JSON in the SQL Database Table

I am using Copy Activity in Azure Data Factory in which I am using REST API for getting the Response from the API I am getting an array contain multiple dictionaries. I wanted to Store the Response a...
data engineering
data pipeline
Srisakthi's avatar
Srisakthi
Super User
5 months ago

Hi Shayan12378 ,

 

Have you tried enabling the checkbox "Map complex values to string"

 

Thanks,

Srisakthi

Shayan12378's avatar
Shayan12378
Regular Visitor
5 months ago

Yes

  • Srisakthi's avatar
    Srisakthi
    Super User
    5 months ago

    Hi Shayan12378 ,

     

    Can you try along with Collection reference  ?

     

    Thanks,

    Srisakthi

    • Shayan12378's avatar
      Shayan12378
      Regular Visitor
      5 months ago

      Srisakthi  With the Below  Mapping



      It is not writting any data in my SQL Table Field

      {
      "dataRead": 833639,
      "dataWritten": 0,
      "sourcePeakConnections": 1,
      "sinkPeakConnections": 1,
      "rowsRead": 60,
      "rowsCopied": 142,
      "copyDuration": 21,
      "throughput": 166.728,
      "errors": [],
      "effectiveIntegrationRuntime": "AutoResolveIntegrationRuntime (East US)",
      "usedDataIntegrationUnits": 4,
      "billingReference": {
      "activityType": "DataMovement",
      "billableDuration": [
      {
      "meterType": "AzureIR",
      "duration": 0.016666666666666666,
      "unit": "DIUHours"
      }
      ],
      "totalBillableDuration": [
      {
      "meterType": "AzureIR",
      "duration": 0.016666666666666666,
      "unit": "DIUHours"
      }
      ]
      },
      "usedParallelCopies": 1,
      "executionDetails": [
      {
      "source": {
      "type": "RestService"
      },
      "sink": {
      "type": "AzureSqlDatabase",
      "region": "East US"
      },
      "status": "Succeeded",
      "start": "3/12/2026, 7:14:16 PM",
      "duration": 21,
      "usedDataIntegrationUnits": 4,
      "usedParallelCopies": 1,
      "profile": {
      "queue": {
      "status": "Completed",
      "duration": 12
      },
      "transfer": {
      "status": "Completed",
      "duration": 5,
      "details": {
      "readingFromSource": {
      "type": "RestService",
      "workingDuration": 1,
      "timeToFirstByte": 0
      },
      "writingToSink": {
      "type": "AzureSqlDatabase",
      "workingDuration": 0
      }
      }
      }
      },
      "detailedDurations": {
      "queuingDuration": 12,
      "timeToFirstByte": 0,
      "transferDuration": 5
      }
      }
      ],
      "dataConsistencyVerification": {
      "VerificationResult": "Unsupported"
      },
      "durationInQueue": {
      "integrationRuntimeQueue": 0
      }


       
      }