Questions tagged [json]
JSON (JavaScript Object Notation) is a textual data storage and interchange format.
172 questions
1
vote
2
answers
95
views
How do I process a JSON file into a table in Excel?
I'm trying to load a JSON file into Excel. It loads in Power Query and I can drill into individual rows but cannot extract the whole file directly to a table. How can I load it directly?
Given the ...
1
vote
0
answers
96
views
policies.json file for doh and extension restrictions
definition >> DOH = DNS Over HTTP or HTTPS
I want to implement child protection on single machines: family filter and custom blocklisting of websites (social media prevalently)
System: Windows ...
1
vote
1
answer
280
views
How can I see the number of elements a field contains in a JSON file opened with Notepad++?
I can see the number of elements a field contains in a JSON file opened with PyCharm 2024.2.3:
How can I view the same within Notepad++?
-1
votes
1
answer
405
views
Will jq output valid json even if error?
Is jq guaranteed to always output valid json, even if it encounters an error while running? Error could be due to poorly formatted input, for example. Outputting valid json and not outputting anything ...
21
votes
2
answers
5k
views
How can I set Chrome (and Brave) to _always_ pretty-print JSON results without installing an extension?
I visit JSON endpoints that look like: https://dummyjson.com/test
I don't want to manually click the "Pretty-print" checkbox every time.
How can I change a browser setting to make the "...
1
vote
0
answers
508
views
convert the .json file back to .jsonlz4 file as it was in Firefox
Hello every professional engineer
I knew how to convert the Firefox file sessionstore.jsonlz4 to .json file by using this website https://www.jeffersonscher.com/ffu/scrounger.html
and after editing ...
2
votes
0
answers
298
views
How can I jump to the parent node of a JSON object in Notepad++?
Let's say my cursor in Notepad++ is here:
How can I easily jump to the parent node? E.g., is there a keyboard shortcut for that?
Full JSON used in the example:
{
"boats": [
{
...
0
votes
1
answer
1k
views
How to find the lowest "latest version" of Google Chrome
Before 2023, this was an easy question to answer. Google hosted a JSON at Omahaproxy (https://omahaproxy.appspot.com/json) which would give a simple response when queried.
Asking...
(Invoke-WebRequest ...
0
votes
1
answer
390
views
Extremely slow json.load of a network response in WSL
Decoding a json response takes a lot of time on my system - Precision 5520 (11th gen I7, 64 GB) with Linux 20.04 LTS under WSL2 under Windows 10 Pro. Here is the relevant part of the code:
def ms_now()...
1
vote
0
answers
405
views
Why is cURL returning just two square brackets with this request?
This curl request returns empty square brackets []:
curl "https://www.bathnes.gov.uk/NodeAPI/geoDataLookup/getGeoJSON/-2.8530120849609375/51.263633525637/-2.126541137695313/51.456574106519724/11&...
1
vote
1
answer
228
views
How to create a static website from MBOX file
I have a large MBOX file (16000 emails) from a public email group which is now closed. For archival and research purposes, I would like to serve these emails on a website. How can I go about ...
0
votes
0
answers
95
views
Quickest way to add variable text from a text file to a JSON file in specific places
I'm trying to find the easiest and quickest way to fetch a list of names in different lines from a text file and appending them to a specific field in a structured JSON file that repeats itself over ...
7
votes
0
answers
4k
views
Can you filter JSON with multiple keys in Firefox?
Can you filter based on multiple keys in the Firefox JSON viewer? Lets say I have the following JSON:
{
"obj": [{
"online": true,
"count": 5,
...
1
vote
2
answers
538
views
Multiply numerical value after a string in a json file by 3?
I'm trying to replace a number in a set of text files. The number will be different for each file, but it will always occur after a specific string.
Here's the original file:
"structures&...
2
votes
0
answers
1k
views
How can I do basic validation of JSON in an Excel cell?
I have an Excel sheet that has a column that consists entirely of JSON values.
For example, cell A1:
{
"selected_pet": "dog",
"other_pets": [
"cat",
...