Forum Discussion
Broken Exchange API - ExplorerActivityData
Hello everyone, I'v been trying to get the Export-ActivityExplorerData API to work but with no luck. Sometimes the script stop at 100 results , sometimes 5000 results. The script stay the same. ...
As i didn't find the edit button, here is the error output:
Write-ErrorMessage : |Microsoft.Exchange.Hygiene.DataInsights.Common.ElasticsearchDataProviderPermanentException|One or more errors occurred.
Microsoft.Exchange.Hygiene.DataInsights.Common.ElasticsearchDataProviderBadOrInvalidRequestException: Invalid scroll cookie. Exception message: Newtonsoft.Json.JsonReaderException: Error reading JObject from JsonReader. Current JsonReader item is not an object:
Integer. Path '', line 1, position 3.
at Newtonsoft.Json.Linq.JObject.Load(JsonReader reader, JsonLoadSettings settings)
at Newtonsoft.Json.Linq.JObject.Parse(String json, JsonLoadSettings settings)
at Microsoft.Exchange.Hygiene.DataInsights.ElasticsearchDataProvider.ParseScrollPaginationCookie(String watermark, DateTime& scrollCookieExpiryTime, Boolean& isExpiredCookie, String& scrollID, String& endPointMachine, String& hashedQueryFilterString, String&
errorMessage)
at Microsoft.Exchange.Hygiene.DataInsights.ElasticsearchDataProvider.ParseFilter(QueryFilter filter, SortBy[] sortBy, Int32 pageSize)
at Microsoft.Exchange.Hygiene.DataInsights.ElasticsearchDataProvider.ParseFilter(QueryFilter filter, SortBy[] sortBy, Int32 pageSize)
Au caractère C:\Users\\AppData\Local\Temp\tmpEXO_2pgp2pr2.xcy\tmpEXO_2pgp2pr2.xcy.psm1:1189 : 13
+ Write-ErrorMessage $ErrorObject
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidResult : (:) [Export-ActivityExplorerData], ElasticsearchDa...manentException
+ FullyQualifiedErrorId : [TimeStamp=Tue, 11 Feb 2025 14:58:13 GMT],Write-ErrorMessage