Aug 30 2021 02:40 PM
Hi, I've started noticing issues with search REST api results lately where there are some new properties returned in the schema and some null values.
Ex: _api/search/query?querytext='Filename:B315N1001A.dwg AND ParentLink:106982_P'&selectproperties='Filename,DefaultEncodingURL,SPSiteUrl,UniqueID'&sortlist='LastModifiedTime:descending'
Returned values with Null (these values where never null before)
"Key": "PartitionId",
"Value": null,
"ValueType": "Null"
},
{
"Key": "Culture",
"Value": null,
"ValueType": "Null"
},
New properties that where never there before:
{
"Key": "DocumentSignature",
"Value": "-XXXXXX;-XXXXXX;-XXXXXX;-XXXXXX",
"ValueType": "Edm.String"
},
{
"Key": "CollapsingStatus",
"Value": "0",
"ValueType": "Edm.Int32"
}.
This is causing issues with my json parsing schema.
Any info on this?
Aug 30 2021 06:18 PM
Aug 31 2021 07:39 PM
Sep 03 2021 04:53 AM - edited Sep 03 2021 04:53 AM
I am facing the very same issue that results in failure of Json parsing. Is there any update from microsoft on this issue.
Sep 03 2021 07:24 AM - edited Sep 03 2021 07:25 AM
Here are some findings in the results I'm getting. I've updated my power automate json schema (now I will always put things like "anyOf": ["type": "string", "type": "null"] in my schema definition) but I'm worried about the impact of these types of changes as I'm building flows for a lot of customers...:
RelevantResults.Properties
Removed
○ GenerationId
○ indexSystem
○ GeoLocationSource
Table.Rows.Cells
Changes
UniqueID:
Before Example: "Value": "36b8e7c3-deb7-42a2-89bf-551ccbbab779"
Now : "Value": "{36b8e7c3-deb7-42a2-89bf-551ccbbab779}"
PartitionId
Before Example: "Value": "a348e418-3879-46f3-b30e-c4bc1eaca908", "ValueType": "Edm.Guid"
Now: "Value": null, "ValueType": "Null"
Culture
Before Example: "Value": "fr-FR","ValueType": "Edm.String"
Now: "Value": null, "ValueType": "Null"
Sep 03 2021 01:37 PM
SolutionSep 06 2021 01:08 PM
Sep 07 2021 12:08 AM
@Martin Coupal Not really as Culture is just echoing the culture passed in on the query. If you want to know the language of an item look at DetectedLanguage.
Sep 03 2021 01:37 PM
Solution