Hello,
I have seen a few of these questions but none with answers that work for me.
Scenario: I am using this article to fetch SharePoint Search results when I get to the Parse JSON action, I get the error: The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array."
Below, I check that Rows is of type Array so i am completely dumbfounded on why it says it is Null when there are the standard 10 results populating (see Row Count = 10). The Search is pulling data but i cannot get the rows to acknowledge the data.
This is the current Select Properties From line: body('Parse_JSON')?[PrimaryQueryResult']?[RelevantResults']?['Table']?['Rows']
I am also open to any other way to parse this JSON to get the search results. I do not have to use this article but i am wondering what i am doing wrong in general and open to learning.'
Thank you in advance, I will def select a correct answer on this i have been struggling for 3 days.
Schema :
{
"type": "object",
"properties": {
"odata.metadata": {
"type": "string"
},
"ElapsedTime": {
"type": "integer"
},
"PrimaryQueryResult": {
"type": "object",
"properties": {
"RelevantResults": {
"type": "object",
"properties": {
"RowCount": {
"type": "integer"
},
"Table": {
"type": "object",
"properties": {
"Rows": {
"type": "array",
"items": {
"type": "object",
"properties": {
"Cells": {
"type": "array",
"items": {
"type": "object",
"properties": {
"Key": {
"type": "string"
}
},
"required": [
"Key"
]
}
}
},
"required": [
"Cells"
]
}
}
}
},
"TotalRows": {
"type": "integer"
},
"TotalRowsIncludingDuplicates": {
"type": "integer"
}
}
}
}
},
"Properties": {
"type": "array",
"items": {
"type": "object",
"properties": {
"Key": {
"type": "string"
}
},
"required": [
"Key"
]
}
}
}
}
