Parse a nested json in memsql

Hello
Is there a way to parse nested json in memsql. for inserting into a flat table
Here is the example

{
“serviceDate”: 1585759961,
“recapGroupId”: “13-rgetd-hgrtso”,
“vendorNb”: 54231,
“itemsId”: “fgrhr-hdgdt”,
“activities”: [
{
“activityId”: “1111-hdgdt”,
“companyId”: 1111,
“transactions”: [
{
“transactionId”: 123,
“cost”: 100
},
{
“transactionId”: 459,
“cost”: 200
}
]
},
{
“activityId”: “222222-hdgdt”,
“companyId”: 2222,
“transactions”: [
{
“transactionId”: 256,
“cost”: 300
},
{
“transactionId”: 456,
“cost”: 400
}
]
}
]
}

Your best bet right now would be to write a stored procedure (SP) to extract the desired information and insert it into the target table. The JSON_TO_ARRAY() function shipped in 7.0 could make that SP easier to write. Or, flatten it from a client-side application and insert it to the desired table.

What do you want the result to look like exactly (in the target table) when you’re done?

Keep your eyes open for features in 7.1, planned for late spring, that will make this easier still.

Using SP but would like to convert transactions from example into tuples and do a bulk inset into table.Any workable solution for this in v6.8.