Hi,
I need a bit of help please.
I have a flow whereby I need to parse a JSON in order to get the values within the "values" element of the JSON.
The values part is an array of arrays, so I am then trying to loop through each object in here to update Dataverse.
However, before I get this far, I am setting a variable to ensure that I am getting the correct list of objects for values. Every time I run this, however, the output is empty/null. But there is data in there. What could I be doing wrong?
What would the correct output of the Parse JSON command be in order for me to see the items within 'values'?
{
"type": "object",
"properties": {
"statusCode": {
"type": "integer"
},
"headers": {
"type": "object",
"properties": {
"Transfer-Encoding": {
"type": "string"
},
"Vary": {
"type": "string"
},
"Strict-Transport-Security": {
"type": "string"
},
"request-id": {
"type": "string"
},
"client-request-id": {
"type": "string"
},
"x-ms-ags-diagnostic": {
"type": "string"
},
"OData-Version": {
"type": "string"
},
"Timing-Allow-Origin": {
"type": "string"
},
"x-ms-apihub-cached-response": {
"type": "string"
},
"x-ms-apihub-obo": {
"type": "string"
},
"Cache-Control": {
"type": "string"
},
"Date": {
"type": "string"
},
"Content-Type": {
"type": "string"
},
"Content-Length": {
"type": "string"
}
}
},
"body": {
"type": "object",
"properties": {
"@@odata.context": {
"type": "string"
},
"@@odata.type": {
"type": "string"
},
"@@odata.id": {
"type": "string"
},
"address": {
"type": "string"
},
"addressLocal": {
"type": "string"
},
"columnCount": {
"type": "integer"
},
"cellCount": {
"type": "integer"
},
"columnHidden": {
"type": "boolean"
},
"rowHidden": {
"type": "boolean"
},
"numberFormat": {
"type": "array",
"items": {
"type": "array",
"items": {
"type": "string"
}
}
},
"columnIndex": {
"type": "integer"
},
"text": {
"type": "array",
"items": {
"type": "array",
"items": {
"type": "string"
}
}
},
"formulas": {
"type": "array",
"items": {
"type": "array",
"items": {
"type": "string"
}
}
},
"formulasLocal": {
"type": "array",
"items": {
"type": "array",
"items": {
"type": "string"
}
}
},
"formulasR1C1": {
"type": "array",
"items": {
"type": "array",
"items": {
"type": "string"
}
}
},
"hidden": {
"type": "boolean"
},
"rowCount": {
"type": "integer"
},
"rowIndex": {
"type": "integer"
},
"valueTypes": {
"type": "array",
"items": {
"type": "array",
"items": {
"type": "string"
}
}
},
"values": {
"type": "array",
"items": {
"type": "array",
"items": {
"type": "string"
}
}
}
}
}
}
}
Thanks
K.
