Questions tagged [json]
JSON (JavaScript Object Notation) is a textual data storage and interchange format.
144
questions
0
votes
1
answer
63
views
jq filtering - Cannot index array with string ""value"
I am trying to get the application name and print its corresponding apiDefinition for a specific key which is embedded in the value parameter. I get error "Cannot index array with string"
As ...
- 1
0
votes
0
answers
21
views
Rest API w/ JsonServer in Ubuntu - Connection Refused
I was requested to create a Web Server with an API in it to test firewall rule we are planning to implement soon. I am quite new with all this network stuff, so I'm a bit lost on it.
I need to call ...
- 1
0
votes
0
answers
14
views
Adding a json variable to gitlab.yml file
Suppose we want to run the following command in a gitlab.yml file:
aws lambda invoke --function-name function_name --invocation-type Event \ --payload json_var \ response.json
How do we set json_var ...
1
vote
1
answer
52
views
In PowerShell, how to save a DateTime variable into a file to be retrieved later?
I want to log the timestamp when a certain line is executed so that the script can know how long it has passed since last execution of that line, even if the script is stopped in between and the ...
- 98
0
votes
0
answers
25
views
How to print a string in regex from a JSON file for strings that have multiple decimals?
I have a bunch of strings in a JSON file trying to separate them by how many decimals they have.
For example: one string is "NEW 5.1" and another is "NEW 5.1.1"
How do I ...
- 1
0
votes
1
answer
22
views
Prevent the youtube-dl process fork when downloading metadata for a video in a playlist
Storing the metadata for a video using in a file using youtube-dl can be done in bash by calling
youtube-dl -j https://www.youtube.com/watch?v=${video_id} > metadata.json
However, when the video ...
- 403
0
votes
0
answers
43
views
Restore information in unsaved tabs from JSON "Session.sublime_session" file in Back up session file
Basically all tab information was lost after an update, I backed up all info before the update obviously, but when restoring it, it just won't restore, there are no solutions in the forums so.
TLDR; ...
0
votes
0
answers
19
views
Search for the object with a known value in JSON
Let's say I have a JSON like the following but with much more data and much more nesting
{
"dont_want_1": {
"a": 1
},
"dont_want_2": {
"b": 2
},
...
1
vote
1
answer
361
views
Ubuntu/WSL disappeared from Windows Terminal?
I am using WSL/Ubuntu 20.04 on Windows Terminal, and I wanted to change my font color. When I copied settings into my settings.json file, the Ubuntu profile disappeared from Windows Terminal`.
My ...
- 13
1
vote
1
answer
372
views
How can i convert a .bin file to a .json file [closed]
There is a ".bin" file on my pc that i want to convert. I tried to do it with a ISO reader but it wont work. The only thing i know about this file, it stores some json data that i want to ...
- 13
1
vote
0
answers
44
views
How stop multiples projects in vscode with the launch.json
I have in my launch.JSON a configuration that allows me to start two different API projects at the same time (Web API One and Web API Two), both are components of the same project, everything works ...
3
votes
2
answers
637
views
Can i get excel to retain the format of this JSON cell?
I've pasted this json into a cell in excel
{
"Name": [
"OldName",
"NewName"
],
"Address[Id: 1].Postcode": [
"AL10 8DN&...
- 299
0
votes
2
answers
53
views
Is there a keyboard shortcut to select text at random location and climb to the top with one click?
As you can see, there are more than 70000 lines, it would take a lifetime to climb to the top using SHIFT + Page Up or SHIFT + UP ARROW.
Is there any shortcut to getting to the top quickly?
10
votes
2
answers
1k
views
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": [
...
- 6,041
1
vote
1
answer
128
views
Change one .json key value with an already existing one using jq
My test.json file contains the 2 keys:
{
"id": "123",
"name": "John"
}
And I want to achieve something like this:
{
"id": "John"...
- 13
0
votes
1
answer
262
views
JSON conversion in Power Query - how automatically get list of object property names
This is a question based on comment in Excel: Power Query - how to repeat block of code for each row in a table.
Let's say we have a JSON with array of object each with N properies:
{
"data&...
- 830
1
vote
1
answer
2k
views
jq and array of two things: key and value
I have this script:
curl -sX 'GET' \
'https://api.coingecko.com/api/v3/exchange_rates' \
-H 'accept: application/json' | jq -rc '.[]|select(.)|keys,(.[].value|tostring)'
and the source of the ...
- 2,377
0
votes
1
answer
720
views
Splitting Multi-valued JSON elements into an Array with PowerShell
I'm working with some JSON data in PowerShell. Some elements are multi-valued, delimited with a semi-colon, but its not always the same elements that are multi-valued. I would like to convert multi-...
- 241
0
votes
1
answer
704
views
How to convert a plain txt file to json format
I have a huge plain txt file which its content is:
p1=a05b518f35e9f55a37d27965f3bf8735|p2=dabfa1619199d358d5ee7a38768a564a|p3=...
I want to convert it to JSON format with a pn-hash pair. I found this ...
- 3
0
votes
0
answers
34
views
Power Query to extract JSON parameter values from the data
Hope you are doing well!...I am trying to split the different parameter values for just the correct ,added and removed codes at a vbillid level..In the attached excel file the column codemap has the ...
- 107
0
votes
1
answer
1k
views
Import XML or JSON data into Excel using URL from a cell
I have an API call to make from my Excel spreadsheet that will have various parameters depending on the data entered in the spreadsheet.
I have formatted the URL properly and have it in a cell that is ...
- 105
0
votes
1
answer
156
views
List of JSON strings as command arguments
I've been working with GitLab CI recently to automate some busy tasks, namely auto releasing binaries for version tags.
For those who don't know Gitlab CI, it is very straightforward. It pulls the ...
- 21
0
votes
0
answers
1k
views
JSON error - Expecting 'EOF', '}', ',', ']', got '{'
I have a big json file but don't know it shows some error...
{
"_index": "ttmnt",
"_type": "********ils",
"_id": "********DC",
"...
- 41
-2
votes
1
answer
2k
views
How can i convert a .bin (binary) to a .json (json) file with linux?
I don't know how to convert a binary file back to a .json file. I have been searching for a while now and could not find a single answer, well, i did but none of which worked.
Can this be done in ...
1
vote
0
answers
20
views
Firefox strange JSON null respone
I was browsing a blog, I think made on wordpress, and when I clicked on an interal link I got a strange response, my firefox browser returned the JSON viewer with a NULL response.
Then I refreshed the ...
0
votes
1
answer
176
views
How do I use the dejsonlz4 tool?
Would somebody mind explaining how to use the dejsonlz4 tool in very basic laymans terms?
https://github.com/avih/dejsonlz4
I recently formatted a drive and lost my Firefox bookmarks as I forgot to ...
1
vote
3
answers
332
views
How to remove white space after parsing from JSON with sed
How can I remove any white space if any after parsing from JSON?
whereami -r Parse result without sed.
{
"ip": "95.16.15.10",
"country_code": "US",
"...
- 113
1
vote
0
answers
4k
views
Notepad++: how to automatically format JSON when opening the file
I work with many JSON files.
It would be useful to automatically format JSON when opening the file in Notepad++.
At the moment, I'm using JSON viewer plugin. I have to select the text and choose ...
1
vote
1
answer
53
views
Strange tar archive
I have few files that were transferred from another server. The files suppose to contain archive of directories with code and data.
files have .tar extension.
When I run:
tar -xvf xxxxx.tar
I get the ...
- 113
0
votes
0
answers
194
views
Regular expression to match blocks of { } in JSON
I have the following piece of JSON that occurs on about a hundred and fifty files in an application I am working on.
{
path: "/cms/scenarios/:scenarioId/impacts/add",
...
- 125
1
vote
1
answer
122
views
A local key/value store for Windows
Is there any equivalent of sqlite as a key/value store that will run on Windows? I have a bunch of data in JSON files that I'd love to be able to view and query like I can with relational tabular data ...
- 191
0
votes
1
answer
2k
views
How to hide tabs in windows terminal through its settings file?
I’ve spent almost an hour on trying to figure this out but I have not quite figured it out.
Also, where can I find an exhaustive list of what's settings can be changed in the .json file? Microsoft ...
- 105
1
vote
1
answer
225
views
Linux shell backslash-newline for long JSON string
I am using curl with a really long -d, --data <data> field containing JSON.
I would like to use backslash-newline to wrap around the JSON in the middle of the JSON string.
Here's an example: (...
0
votes
1
answer
1k
views
How to install jsoncpp on CentOS 8
I have tried:
$ sudo dnf install jsoncpp
Last metadata expiration check: 0:31:37 ago on Fri 17 Jul 2020 02:02:47 PM CST.
No match for argument: jsoncpp
Error: Unable to find a match: jsoncpp
And I ...
- 486
2
votes
2
answers
247
views
Select JSON records as Excel table via Power Query
I have a URL that points to a sample server that returns JSON records:
https://sampleserver6.arcgisonline.com/arcgis/rest/services/LocalGovernment/Events/MapServer/0/query?where=1%3D1&outFields=*&...
- 105
6
votes
2
answers
15k
views
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 ...
- 63
0
votes
0
answers
84
views
Saving content of individual cells within a column as separate JSON files
Is there a way to create a collection of JSON Files in a folder based on the content of individual cells in a column in excel?
So basically, I have a spreadsheet with a column starting with cell B12 ...
0
votes
1
answer
46
views
Excel 2016 Power Query - Expanding a fixed list like you do a record
I am using Power Query to Get Data from a json file. The elements in my json file that come up as "Record" I can expand the fields inside, all good. But some of the elements come up as "List". Now ...
- 13
-2
votes
1
answer
2k
views
How to send 200 curl requests in specific one second of time in Linux terminal?
First of all let me explain my problem and what I am going to do. I would like to post 200 curl requests (the response of them is not important) to an API of my web server only in one second and ...
- 1
1
vote
1
answer
84
views
How do I open JSON events in Firefox console?
I'd like to view output in my console in firefox.
Here's an example that I'd like to see:
That's an example on Chrome. It's very easy to open the JSON object.
I can even go one level further and ...
- 485
0
votes
1
answer
1k
views
jq filter for only 'null' values
I am using the below command but did not get the expected output
kubectl get po -o json -n velero | jq '[.items[] | {name:.metadata.name, limits:.spec.containers[].resources.limits} | select(.limits==&...
0
votes
1
answer
99
views
Loading seccomp rules from file
I'm trying to implement a simple container. I would like users to be able to specify whitelisted syscalls in a profile.json file.
Example content of profile.json file:
{
"whitelisted_syscalls": ["...
- 3
2
votes
0
answers
128
views
How can I (re-)import the exported queue into Handbrake?
I had a queue in Handbrake, it was pointing at files on my D-drive in the NEW Movies folder. Now I want to make it point at video files on my E-drive, in the Old Videos folder.
I exported the queue ...
- 57
1
vote
1
answer
927
views
Surround Field from JSON with quotes
I want to change a field in json from number to string format.
I create the json output from a dynamical created text file like this:
LastUpdate=2019-12-01T13:26:46.388817319+01:00
State=NOT OK
...
- 146
1
vote
1
answer
851
views
For Firefox Quantum (v70) where can I find the theme/persona background image?
Is there a way to get the background image for a Firefox theme downloaded from the Mozilla add-on website? Mainly I want the image for this theme:
https://addons.mozilla.org/en-CA/firefox/addon/...
- 21
1
vote
2
answers
66
views
files to one json file
I'm a bit lost to create a json from few files.
I have several files like named : CLT.txt, LYO.txt ....
Inside of us I have date + value :
dd/mm/yyyy hh:mm xxxxx
I add new line on each file every 5 ...
- 15
1
vote
0
answers
894
views
OpenSSL Digital Signature with ES256
I am trying to reproduce a valid signature for the JSON Web Token.
I make the privat key with: openssl ecparam -genkey -name prime256v1 -noout -out private.pem
also convert this from Pem to P8 with: ...
- 11
1
vote
0
answers
931
views
Is it possible to import Firefox cookies into Chrome?
I have exported my cookies in Firefox to a TXT file and also to a JSON file.
Is it possible to import either file into Chrome? I have tried a number of extensions from the Chrome Web Store but none ...
- 11
0
votes
1
answer
94
views
javascript in mongoshell
I want to make a join query in mongodb. Mongo doesn't have any join operator so i have to split the query in two parts.
first:
var a = db.articoli.find({_id: 4010}, {ordini:1});
var b = a[0].ordini;
...
1
vote
1
answer
188
views
Json Parsing with Jsonpath based on string condition filters [closed]
I am fairly new with Jsonpath and am forced to use due to a project dependency.
The sample json loooks like this
{
"people": {
"a": {"First":"James", "last": "d"},
"b": {"First":"Jacob", "...
- 11