关于数据sql对 json 数据解析

@ReceiveData2=

{
"iccid": "89860617030080033205",
"timeStamp": "2022-03-12T09:18:16.370Z",
"cycleStartDate": "2022-02-26T16:00:00.000Z",
"cycleEndDate": "2022-03-26T15:59:59.000Z",
"deviceCycleUsageInZones": {
"360WLW002201_MON-FLEX_50M, 3": [
{
"ratePlan": "360WLW002201_MON-FLEX_50M",
"ratePlanVersion": "3",
"zone": "360WLW002201_zone1",
"dataUsage": 12938240,
"dataUsageUnit": "bytes",
"voiceMTUsage": null,
"voiceMTUsageUnit": null,
"voiceMOUsage": null,
"voiceMOUsageUnit": null,
"smsmtusage": null,
"smsmousage": null
}
]
}
}

对于嵌套数据获取采用如下方式：

select b.value from openJson(@ReceiveData2,'$.deviceCycleUsageInZones') as a-- with ( [lmtUsage] nvarchar(max) '$.dataUsage' as json) as detail
cross apply openjson (a.value) with(value INT N'$.dataUsage' ) as b

@ReceiveData2 是接收的json结果