Forum Discussion
DataFormat.Error: We found extra characters at the end of JSON input.
Source: Azure Blob Storage
Source = AzureStorage.Blobs("xxxxxxdev001")
JSON data is coming from Azure Blob Storage and JSON files are PostgreSQL Server Diagnostics Logs:
let
Source = AzureStorage.Blobs("xxxxxxdev001"),
#"insights-logs-postgresqllogs1" = Source{[Name="insights-logs-postgresqllogs"]}[Data]
in
#"insights-logs-postgresqllogs1"
Error Details:
DataFormat.Error: We found extra characters at the end of JSON input.
Details:
Value={
Position=470
When I try to navigate through Binary, getting above error - not sure why? 😥
5 Replies
- amitchandak
Super User
azeem2020 , this error come when the json format has some issue. some character is not required or missing position
Those JSON files are being generated automatically by enabling Diagnostic Setting on PostgreSQL - Flexible Server.
Configure and Access Logs for Azure Database for PostgreSQL - Flexible Server - JSON format
So I assume, JSON is well formatted otherwise Microsoft should rework on their format. But here in my case - the issue is somewhere else.
azeem2020 I m facing same issue. Is this resolved at your end ?
No, I haven't attempted it for a while, but I've been working on an alternative approach to reformat the JSON using Python and then passing the file to analyzer. Please let me know if you have any opportunities to resolve it.
