Questions tagged [json]
JSON (JavaScript Object Notation) is a textual data storage and interchange format.
0
votes
0answers
6 views
How do I know when to create a new controller & JSON parsing [on hold]
Hello I'm new to ruby on rails, and I'd like to ask some questions.
How do I know when to create a new controller?
How do I parse JSON?
0
votes
0answers
4 views
Needing regex to extraxt date format [on hold]
I am needing to extract data from a message, new to this site and just trying to finish my projects. I would like to extract the date format, I currently have the ip extracted but im needing the date ...
-1
votes
0answers
11 views
jq on non-well-formed JSON file
So, a program I'm using dumped its data in a quasi-JSON like this:
{"id": "A0001", "weight": 10.5, "category": "A"}
{"id": "A0002", "weight": 8.0, "category": "A"}
{"id": "A0001", "weight": 22.3, "...
1
vote
0answers
20 views
I want to push either a TSV file or JSON up to a Google Sheet
I have several large files of key/value pairs delimited by an equal sign ("="). One file is the master file. For each file, I want to populate columns A, B, and C as follows:
A: The unique key for ...
0
votes
0answers
15 views
Flask disable JSON response escaping
I am trying to pass a url in a json response for a REST API using flask and when I try to send a url it goes from "https://www.google.com/" to /\ on the slashes. How can I prevent this from happening?
0
votes
0answers
7 views
How To Solve JSON API Error?
I have an error With JSON API Plugin in wordpress. I have made a application for my website. my application use the "JSON API" plugin to get data. It was working but today it did not work. My json api ...
1
vote
0answers
10 views
AWS S3 CLI: sum bytes in all top-level prefixes with a single --query?
I have an S3 bucket with a bunch of top-level prefixes. I have a relatively inefficient way of summing the bytes across top-level prefixes:
Get the list of prefixes via aws s3 ls [bucket name], ...
0
votes
0answers
16 views
AWS S3/Athena: How to receive JSON in query result?
Let's say, I have messages in amazon-s3 with following structure:
{ "msg_type": "foo", "msg_body": { "str_field": "hello", "int_field": 1 } }
When perform following query in Athena:
SELECT * FROM ...
0
votes
1answer
41 views
Protect Custom Google Chrome Extension
I had developed my very own custom chrome extension and sell it to my clients.
But clients saying that the protection wasn't good enough due to their users are still able to remove and disable the ...
1
vote
0answers
33 views
Could not convert database value to Doctrine Type json
I`m new user of Symfony 4 framework and i wish to build a correct login system using built-in auth system. However, i got an error while doctrine query.
Here is my screenshot:
And here is my ...
0
votes
0answers
12 views
navigate and expand children upon clicking [migrated]
I'm currently working on a project using the below script to navigation and expand upon click. But the issue is that I want the navigation to stay open upon click not collapse.
But the current issue ...
0
votes
0answers
13 views
Changing JSON default for C++ in VS Code
For instance when I want to debug C++ in VS Code, I click debug and choose C++(GDB/LLDB) which creates a JSON file. In there it wants the destination of my MinGW file. Can I edit the default setting ...
1
vote
1answer
64 views
How can I sort this JSON data?
How can I sort this JSON data?
Hello,
I am curling a web service and I get this output as JSON using curl and jq. How can I sort the list by percentage, ascending or descending?
{
"result": {
"...
0
votes
1answer
46 views
Excel Transpose Certain JSON Fields
I'm pulling data into Excel via a webhook (JSON). It appears in Power Query Editor like this:
| name | groupName | key | value |
| host1 | group1 | tag1 | val1 |
| host1 | group1 | ...
0
votes
1answer
179 views
Issue with replacing Json variable with shell script value using curl
#!/bin/bash
#CONFIG_FILE_PATH is the path of the json file as argument while running the script
CONFIG_FILE_PATH=$1
CUST_NAME=$2
curl -X POST -i -H "Accept: application/json" -H "Content-Type:...
0
votes
0answers
43 views
How do I install json_pp with Chocolatey?
Chocolatey doesn't seem to have json_pp.
https://chocolatey.org/packages?q=json_pp
I have it on my desktop, but I believe it is through Cygwin. Is there a way I can install json_pp on my laptop ...
1
vote
1answer
22 views
“Format Document” command doesn't format JSON
I have a JSON document opened in Visual Studio Community 2017 on Windows 10. I am trying to format the document using the "Format Document" command (Ctrl+K,Ctrl+D). When I do that I get the following ...
11
votes
3answers
1k views
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, ...
0
votes
1answer
75 views
Excel table to JSON with additional fields from other sheet
I had gone through
Saving Excel sheet as JSON file, which helped me to convert EXCEL table to JSON but I wish to add some additional fields to this JSON file.
I am asking the following information ...
0
votes
0answers
50 views
json to excel, values of top keys should be in once cell each
I am looking for a non copy-paste way to convert a json file to an excel table, such that I am having the top keys in one column, and the rest in another column. Now the "rest" might be a single value,...
-2
votes
1answer
47 views
Regex to match Bro IDS logs
How to write a single regex to get subject CN,O,ST,C in the strings if exist.
Sample input:
{"ts":1537159826.804384,"uid":"CGvaSh4uPO39lxSdU2","id.orig_h":"192.168.8.32","id.orig_p":1287,"id.resp_h":...
0
votes
1answer
300 views
Shell scripting and Json [closed]
Basically, I have an openwrt router. I want it to run a shell script to connect to an API, using its MAC address as authentication and download a JSON file.
As the API is not yet built I have made a ...
0
votes
1answer
138 views
How to set Base64 encryption key as Environment (system) Variable on Windows 10
I have an application that connects to BigQuery using multiple creds from .json file. Being that this app will eventually reside on Pivotal Cloud Foundry and will need to be set as User Provided ...
0
votes
1answer
204 views
How can one download a video from a news site? [closed]
How would one go about downloading the main video shown on this webpage? It seems very tricky getting into the source code.
https://www.news.com.au/technology/innovation/military/putins-super-weapons-...
-1
votes
1answer
149 views
Parsing JSON with BusyBox tools
I have a POSIX-compatible install script which determines the latest version of some software by grepping info from a json blob retrieved from a software registry:
meta=$(wget -qO - https://registry....
0
votes
1answer
41 views
Setup timezone for server
I have a server on Berlin for example, but i have clients in all over the world for an application that provides APIs for Android and iOS. Now I'm confused how should i save the times in the database ...
0
votes
0answers
261 views
How to create a script to trigger IFTTT from Raspberry Pi when temperature reaches certain value?
I have a Raspberry Pi monitoring my room temperature and I have a server running displaying the temperature in json format (see picture):
My question is how can I create a script that triggers IFTTT ...
0
votes
0answers
46 views
Watch a JSON file and see updates live
I'm trying to monitor a JSON file a program uses as logger. The file changes multiple times a second, and I'd like to keep an eye on how the values evolve over time.
What I've tried so far:
jq and ...
1
vote
1answer
205 views
json lexer not available in sphinx?
I tried to use the json lexer in a *.rst document with sphinx. This one works:
.. code-block:: console
//Comment
key1: value,
key2: value2,
But when I try to use json like this:
.. code-...
0
votes
0answers
491 views
How to fix php myadmin json extension is missing
When I tried to load myadmin in localhost I am getting this error.
phpMyAdmin - Error The json extension is missing. Please check your
PHP configuration.
I have tried everything in at this ...
0
votes
1answer
40 views
Firefox JSON View - Enable loose parsing?
In the latest versions of Firefox, it has this nifty JSON Viewer built in.
Works great, looks awesome, love it.
I have some web servers I deal with that send back JSON that is not strictly proper, ...
2
votes
2answers
3k views
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 ...
4
votes
2answers
9k views
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.
0
votes
0answers
221 views
XMLHttpRequest() cannot get result to show up from GET request. but will work direct in browser
I want to use a URL for a GET request and then display the results.
The data I want returned is in JSON.
I just keep getting an empty string or null value.
I think I did everything right has far as ...
1
vote
0answers
392 views
How to parse JSON array data from GMail to Google Spreadsheet?
OK, I hope to be clear while explaining what I would like to do... I've setup a personal ADSB station (helping me with other tasks, too) putting antenna for 1090, Raspberry Pi 3B, filter and amplifier ...
0
votes
2answers
5k views
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 ...
0
votes
1answer
53 views
Webservice doesn't evaluate with multiple Arguments [REST API]
I am trying to fill a cell with a JSON response from the coindesk API using other cell that contain specific dates.
Here is a small screenshot of the formula:
This works only if I use the start ...
2
votes
1answer
467 views
Using sed to compact JSON arrays
I have a JSON output in the following format:
{
"DaysCfg": {
"Range": {
"lowerDate": "2017-07-28T00:00:00.000-04:00",
"upperDate": "2017-08-04T00:00:00.000-04:00"
},
"...
2
votes
1answer
749 views
How to represent this table structure using JSON?
New to JSON, wold like your advice:
What is the best way to represent this table structure using JSON
Physical check
Check existing printer checked INSPECTOR REMARKS HERE
Printer visual ...
2
votes
2answers
1k views
Sniff wireless traffic between two machines via Wireshark
Foreword: I am woefully inexperienced with this. As in, this is literally my first time encountering something like this. Please bear with me.
Hello everyone,
The situation is as follows. We (as in, ...
0
votes
0answers
266 views
How to bypass client-side http response to show hidden items in json field?
If I send a HTTP request to an API, I get the following as one of the fields of the JSON response.
"item_count": 20
The number 20 is capped on the client side browser and does not show the ...
1
vote
0answers
190 views
json view \n as newline in browser
I've been looking around but every answer I found seems to be close but not accurate.
I have a json returned by an web api ("content-type: application/json" in response header) that has newlines in ...
1
vote
2answers
264 views
how do I insert text between specific lines?
I am working with AutoIT to add a new entry to a text file. However I need to add it between the last line and second last line.
var informationtechnologydivisionmanager = [
{
"name": "...
0
votes
0answers
36 views
How do I learn to write a program that can extract objects from JSON/XML?
Disclaimer
First off, this is one of my first questions on SE, so I apologize if I break any written or unwritten conventions.
Introduction
At my job in a kind of customer service/support role, I ...
0
votes
1answer
587 views
Loading a json key-value map into Power Query
I'm trying to load my Firebase data to Power BI, the data is a JSON map of the following format
{
"soh4gf1k": {
"name": "bill",
"age": "40",
"maritalStatus": "married"
...
1
vote
0answers
92 views
How to easily generate JSON out of a running AWS EC2 instance for usage in “run-instances --cli-input-json=”?
How to easily generate json out of a running instance for usage in run-instances --cli-input-json=?
The purpose is to recreate instance without too much manual handling or too much json editing.
I ...
0
votes
1answer
2k views
Convert JSON to YAML using PowerShell
I have a json data like this.
sample.json
[
{
"id": 0,
"name": "Cofine",
"title": "laboris minim qui nisi esse amet non",
"description": "Consequat laborum quis exercitation culpa. ...
1
vote
1answer
5k views
How to edit parameters sent through a form on the Firebug console?
When you sent data over a form, you can see what exactly you sent if you see the logs on the Firebug console. It also gives you an option to resend the data. Is there is a way to edit that data within ...
0
votes
1answer
478 views
Alter specific text to string as a key in JSON
I'm trying to convert numbers as shown in figure below to a JSON key with value in an object. Please can someone help me with that? The image below shows what I'm trying to do in notepad++.
2
votes
2answers
589 views
Split one file into multiple files
I have one file which is in Json format like below:
{
"sources":[{
"field1":1000,
"field2":"winevent_log",
"field3":"winevent_log",
"field4":"os_security",
...
