Questions tagged [json]
JSON (JavaScript Object Notation) is a textual data storage and interchange format.
167
questions
5
votes
1
answer
7k
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 ...
5
votes
1
answer
57k
views
Extract element from JSON array with jq
I have the following JSON file inp.json:
{
"x": 0,
"tx": [
{
"id": "a",
"t" : "t for a"
},
{
"id": "b"...
1
vote
1
answer
6k
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 ...
1
vote
0
answers
134
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
3
answers
11k
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&...
0
votes
2
answers
950
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?
11
votes
2
answers
3k
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": [
...
1
vote
1
answer
2k
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"...
0
votes
1
answer
2k
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&...
1
vote
1
answer
19k
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 ...
0
votes
1
answer
5k
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-...
0
votes
1
answer
3k
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 ...
0
votes
0
answers
146
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 ...
0
votes
1
answer
4k
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 ...
0
votes
1
answer
598
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 ...