Copy JSON from Azure Function to Azure SQL Database Table

Anonymous — Wed, 10 Jul 2024 10:57:40 GMT

Good morning.

I am trying to store a JSON from an Azure Function to a SQL Table.

How can i put this date in a SQL Table?

The output from de Azure Function task is:

{
"DimensionValueAttributes": [],
"ResultsByTime": [
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-03-17",
"Start": "2024-03-16"
},
"Total": {
"UnblendedCost": {
"Amount": "771.0744764944",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-03-18",
"Start": "2024-03-17"
},
"Total": {
"UnblendedCost": {
"Amount": "777.8501557578",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-03-19",
"Start": "2024-03-18"
},
"Total": {
"UnblendedCost": {
"Amount": "874.8442349155",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-03-20",
"Start": "2024-03-19"
},
"Total": {
"UnblendedCost": {
"Amount": "880.5272406791",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-03-21",
"Start": "2024-03-20"
},
"Total": {
"UnblendedCost": {
"Amount": "884.4424507833",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-03-22",
"Start": "2024-03-21"
},
"Total": {
"UnblendedCost": {
"Amount": "903.7372262467",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-03-23",
"Start": "2024-03-22"
},
"Total": {
"UnblendedCost": {
"Amount": "851.2754391236",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-03-24",
"Start": "2024-03-23"
},
"Total": {
"UnblendedCost": {
"Amount": "816.3155713969",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-03-25",
"Start": "2024-03-24"
},
"Total": {
"UnblendedCost": {
"Amount": "814.6512443249",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-03-26",
"Start": "2024-03-25"
},
"Total": {
"UnblendedCost": {
"Amount": "877.8727533747",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-03-27",
"Start": "2024-03-26"
},
"Total": {
"UnblendedCost": {
"Amount": "873.6408082756",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-03-28",
"Start": "2024-03-27"
},
"Total": {
"UnblendedCost": {
"Amount": "880.2867928045",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-03-29",
"Start": "2024-03-28"
},
"Total": {
"UnblendedCost": {
"Amount": "847.9090854186",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-03-30",
"Start": "2024-03-29"
},
"Total": {
"UnblendedCost": {
"Amount": "842.7054471426",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-03-31",
"Start": "2024-03-30"
},
"Total": {
"UnblendedCost": {
"Amount": "809.3805247084",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-04-01",
"Start": "2024-03-31"
},
"Total": {
"UnblendedCost": {
"Amount": "812.124645423",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-04-02",
"Start": "2024-04-01"
},
"Total": {
"UnblendedCost": {
"Amount": "871.3367751164",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-04-03",
"Start": "2024-04-02"
},
"Total": {
"UnblendedCost": {
"Amount": "878.9998377159",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-04-04",
"Start": "2024-04-03"
},
"Total": {
"UnblendedCost": {
"Amount": "931.3561545275",
"Unit": "USD"
}
}
},
{
"Estimated": false,
"Groups": [],
"TimePeriod": {
"End": "2024-04-05",
"Start": "2024-04-04"
},
"Total": {
"UnblendedCost": {
"Amount": "918.8637577945",
"Unit": "USD"
}
}
}
],
"effectiveIntegrationRuntime": "integrationRuntime1 (West Europe)",
"executionDuration": 0,
"durationInQueue": {
"integrationRuntimeQueue": 1
}
}

Re: Copy JSON from Azure Function to Azure SQL Database Table

Anonymous — Thu, 11 Jul 2024 01:58:47 GMT

Hi Anonymous

This community is dedicated to discussing issues related to Microsoft Fabric.

To provide you with more professional help, we recommend using a dedicated Microsoft Q&A forum for Azure Data Factory (ADF) related queries.

They are always ready to help you better. Here's a link to your question in Microsoft Questions:

Ask a question - Microsoft Q&A

Regards,

Nono Chen

topic Copy JSON from Azure Function to Azure SQL Database Table in Pipelines

Copy JSON from Azure Function to Azure SQL Database Table

Re: Copy JSON from Azure Function to Azure SQL Database Table