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
        }


         
        }