Unable to read JSON Key should not be null

[Junaid11]

Hello,

I simply read JSON file thrugh it connector but today I am facing below Issue of Key should not be null or empty but when I open this JSON to browser it shows the Data. What is this error and how this file can be imported? I am attaching the pictures for further guidance.

Thank you

[v-yanjiang-msft · Accepted solution]

Hi @Junaid11 ,

A JSON object is a key-value data format, something like this:

{
  "first_name" : "Sammy",
  "last_name" : "Shark",
  "location" : "Ocean",
  "online" : true,
  "followers" : 987 
}

Key-value pairs have a colon between them as in "key" : "value". Each key-value pair is separated by a comma, so the middle of a JSON looks like this: "key" : "value", "key" : "value", "key": "value". In our example above, the first key-value pair is "first_name" : "Sammy".

It seems there's no key in your file, please check it.

More reference: An Introduction to JSON

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

[vanessafvg]

could it potentially be a white space?  

[Junaid11]

Hello @vanessafvg ,

I have checked JSON is valid. No white spaces.