I tried to open this response in excel but did not succeed:
This is the response: [“id\tcountry\tcity”,“1\tNLD\tGroningen”,“2\tNLD\tAssen”,“3\tNLD \tLeeuwarden”,""]
What I did in excel:
Get data from file->json
Then I got a number of lines in power query editor :header = List and content per line Record.
The I choose convert to table : For delimiter I tried several but when choosing comma I get : error cannot convert a value of type Record to type text.
What am I doing wrong ?