Super User Stack Exchange
Super User Stack Exchange

Questions tagged [json]

JSON (JavaScript Object Notation) is a textual data storage and interchange format.

JSON (JavaScript Object Notation) is a serializable data interchange format intended to be machine and human readable.

JSON-formatted data consists of attribute-value pairs, e.g.:

{
  "firstName": "John",
  "lastName": "Smith",
  "age": 35
}
163 questions
228
votes
4 answers

Copy JSON from console.log in developer tool to clipboard?

Using Chrome Developer Tools, i have printed a JSON object with console.log. is there a way that I can copy it to the clipboard?
Anagio
  • 3,088
  • 5
  • 21
  • 29
47
votes
8 answers

How to decode/decipher Mozilla Firefox proprietary .jsonlz4 format? (sessionstore-backups/recovery.jsonlz4)

I'm trying to get a handle on Mozilla Firefox's proprietary file format .jsonlz4, used, for example, for sessionstore-backups/recovery.jsonlz4, but to no avail. How do I get back my data, specifically, some long text I've typed in some textareas of…
cnst
  • 2,435
  • 6
  • 28
  • 45
37
votes
6 answers

Google Chrome Plugin for JSON Reading

Is there a Chrome plugin that renders JSON files in Chrome? Currently Chrome just tries to download them, and that's kind of boring.
stevedbrown
  • 423
  • 1
  • 5
  • 10
31
votes
3 answers

How can I enable pretty-printing in Chrome manually?

There are some great Chrome extensions around for pretty-printing JSON (great SU question here: Google Chrome Plugin for JSON Reading), but they all seem to depend on detecting whether the incoming document is in a JSON format automagically. Knowing…
A. Wilson
  • 613
  • 1
  • 6
  • 14
23
votes
2 answers

JSON Validator for Notepad++?

I'm looking for a plugin that can check the current opened file and instantly tell me whether it is valid JSON or not (eg whether there's a comma or a bracket missing) — is there any? I'm currently using JSONView on Chrome but it's a pain to always…
Mahn
  • 852
  • 2
  • 10
  • 22
15
votes
2 answers

How to navigate to position in Notepad++

I would like to navigate to position in text file. Not line number, but character position. Absolute character position from the beginning of file. How to do this in Notepad++? Any other plain text editor is ok. I am editing JSON file.
Dims
  • 12,244
  • 78
  • 161
  • 252
13
votes
2 answers

Can a file system's logical structure (including symlink targets) be represented in a single lightweight file (non-binary)?

After playing with multiple SQL and NoSQL databases over the years I feel the best way for me to ensure portability in my personal apps that are data-centric is to avoid all bonafide databases entirely. I see the file system as a beautiful database…
Sridhar Sarnobat
  • 1,395
  • 2
  • 13
  • 25
11
votes
2 answers

parsing json in bash with pipe operators

I'm using the AWS CLI client to get the status of a snapshot but the output is in JSON. eg. { "DBClusterSnapshots": [ { "AvailabilityZones": [ "us-east-2a", "us-east-2b", …
neubert
  • 6,863
  • 35
  • 76
  • 138
10
votes
3 answers

Can't import JSON in Excel 2016 using "Get & Transform" feature

According to Microsoft's documentation I should be able to import JSON files by: Click the Data tab, then Get Data > From File > From JSON.
Gabriel Fair
  • 3,605
  • 12
  • 35
  • 65
10
votes
5 answers

Saving Excel sheet as JSON file

Is there a simple way to convert a simple excel sheet to a JSON file? For example the source sheet could look like: A B 1 firstName age 2 Alice 22 3 Bob 33 and the saved JSON: [{firstName: 'Alice', age: 22}, {firstName:…
Bjorn Reppen
  • 211
  • 1
  • 2
  • 6
9
votes
1 answer

Loading a json file into Power Query

I am trying to load a JSON file I pulled from data.gov into Power Query for manipulation, but I can't figure out how to get Power Query to convert the JSON file to a tabular format. Is there a way to convert JSON to a table in Power Query without…
CountZero
  • 93
  • 1
  • 1
  • 4
8
votes
3 answers

Import json data into Excel

I have a text file in json format and want to read it into Excel. A very simplified example of the json file has the following structure: { [ { 'a': 10, 'b': 20 }, { 'a': 20, 'b': 22 }, { 'a': 11, 'b': 24 } ] } I want to convert it to Excel…
Ricardo Marimon
  • 201
  • 1
  • 2
  • 4
7
votes
5 answers

Can I retrieve and access a simple JSON object via HTTP in LibreOffice Calc?

I've located a web API resource that I'd like to access from LibreOffice Calc. It returns a simple JSON/JavaScript object that's basically just a handful of name value pairs, one of which I want to pull out and put in a cell. I know programming but…
hippietrail
  • 4,505
  • 15
  • 53
  • 86
6
votes
4 answers

Extracting a list of values from JSON file to Excel or a text file

I want to extract usernames from a JSON data file. [{"username": "Cobra", "user_id": 146231486, "event_type": 2, "title": null, "class_id": 4211, "war_state" : null, "superpower_expire_date": 1441178060.0, "role": 3, "event_state": 2, "avatar_id":…
WR20
  • 61
  • 1
  • 1
  • 2
6
votes
2 answers

Module not found: Can't resolve 'uuid/v4'

I am a beginner in React programming and I was following this tutorial in Youtube: https://youtu.be/hQAHSlTtcmY and everything went well until it was required to install uuid library and after that when I run the page I get an error saying: "Failed…
Jokamutta
  • 63
  • 1
  • 1
  • 5
1
2 3
…
10 11