Questions tagged [json-format]
JSON (JavaScript Object Notation) is a lightweight data-interchange format. The Stackexchange API delivers its data using this format. The tag is meant for questions about reading and interpreting JSON.
75
questions
5
votes
2
answers
98
views
1
vote
0
answers
94
views
6
votes
1
answer
189
views
Exporting results containing Entities to JSON?
I am looking for a straightforward way to export results from functions like ImageContents, FacialFeatures, and WolframAlpha - symbols that return stuff containing knowledgebase content.
Aside from ...
- 31k
0
votes
2
answers
143
views
How to create a Dataset from Nested JSON Data?
I'm importing data from Swarm into Mathematica, and I'm trying to create a dataset and having issues because the values are at different levels:
...
3
votes
1
answer
1k
views
How can I resolve an unexpected character error when trying to import selected data from a large JSON file?
I'm downloading this datafile from kaggle.
I want to get all the IDs.
Normally for a JSON file I'd write
...
- 4,100
0
votes
1
answer
416
views
Converting JSON to CSV but the formatting is not correct
I have a folder of about a million JSON files and I wrote this to convert them quickly to CSV, but the formatting is not correct for the software I'm feeding them into.
Here's the code I'm using:
<...
- 4,478
0
votes
0
answers
29
views
FaceFeatures - How to better customise the details of JSON output file?
I am using FacialFeatures to identify the age and gender of characters in movie frames.
I am using the following script (simplified from this source):
...
- 17
3
votes
0
answers
439
views
Lists of rules vs. Associations
It seems that generally, Mathematica users (or at least the Q&A I've read here) prefer associations to represent data in ways that many other languages would use structures.
However, when ...
- 2,409
0
votes
0
answers
29
views
How to specify authenticity of SSL for querying APIs?
While ago I was using this command with no issue, now I have an SSL error:
...
- 447
4
votes
2
answers
176
views
How to export a list of url strings as a json file?
I want to export a list of url's as a JSON file.
For instance:
...
- 7,349
3
votes
1
answer
341
views
Visualize JSON timeseries from Fitbit
I'm looking to visualize some Fitbit data which comes in json format (file) . Can someone suggest a nice way to massage this into DateListPlot?
...
- 8,059
12
votes
3
answers
767
views
Bug with Json payload with diacritics for HTTPRequest
Working in the creations of APIs with Mathematica 12.2, I got this problem with diacritics when sending JSON data.
Here is a toy code using httpbin.
...
- 26k
4
votes
1
answer
562
views
Openning JSON file, (NDJSON, new line delimited) -- big file
I am trying since many hours to open a JSON file ("new line delimited") that has this as structure
...
- 661
1
vote
0
answers
80
views
Importing A Neural Network From Mathematica For Use In R
I am experimenting with platform interoperability between Mathematica and R.
My aim is to create an untrained Neural Network using Mathematica, export this network in MXNet format as a .json file, ...
- 787
1
vote
1
answer
121
views
Export new data in JSON [closed]
While processing data in cycle my code create some json object like this:
...
4
votes
3
answers
286
views
Converting between XML and JSON?
I can't seem to find a way to convert between an XML string and RawJSON:
...
- 31k
4
votes
1
answer
134
views
How to return JSON from APIFunction without string encapsulation?
I am trying to get an APIFunction to send valid JSON. This is my demo function.
...
- 30.6k
2
votes
0
answers
64
views
Import data from a webpage with dynamically generated content
Following the example of this very detailed thread 190177 and others related to the subject, that introduced me to snooping around in the developer's tools, I tried to apply to my case, which is ...
22
votes
2
answers
2k
views
How to export a notebook to Jupyter?
I would like a tool to convert any Mathematica notebook into a Jupyter labs notebook, preserving as much content as possible (.ipynb files are just special json). Obviously, this would need to ...
- 31k
4
votes
1
answer
166
views
Importing a Part of the JSON
This is JSON I'm trying to work within Mathematica:
...
1
vote
0
answers
105
views
How to ImportString "JSON" with Unicode characters? [duplicate]
Update
The short answer is that when getting results back from an API into an HTTPResponse object the "Body" property ...
- 41.5k
3
votes
0
answers
172
views
Slight loss of precision when parsing JSON
Exporting to JSON is working well for me under 11.3. The issue present in previous versions seem to be solved:
...
- 7,928
5
votes
1
answer
139
views
How to conditionally escape strings in JSON?
If you JSON export an association with a url, it will espace the forward slashes like this:
...
- 31k
4
votes
0
answers
112
views
Importing and and manipulating large GEOJSON files based on geographic locations
I have large GeoJson data files that I would like to import (i.e. buildings in a city, see image below for data structure) and then "cut out" only the buildings that are within approx. 100 GeoDisks (...
- 41
1
vote
1
answer
463
views
How to parse complex response from SDMX-JSON endpoint in Mathematica
I am trying to use a datasource that has an SDMX-JSON endpoint. I am currently running my tests on Mathematica 10.3.1 running on 64-bit Linux.
I started off by familiarising myself with the tools to ...
- 113
1
vote
0
answers
134
views
0
votes
0
answers
322
views
Export & Import Association with Lists and Rationals without ExpressionJSON
Consider following association:
...
- 707
3
votes
2
answers
145
views
Importing from an API that has non UTF-8 strings
I am new to both Mathematica and API's. I am trying to access a dictionary of player-ids to names from the website datdota.com, but some of them have chinese characters.
relevant code:
...
7
votes
1
answer
435
views
Problem to import numbers longer than 19-digit with "JSON" or "RawJSON"
Bug introduced in 11.0.1 or earlier and fixed in 12.0.
MMA 11.0.1.0 (Windows 10, 64-bit)
I see that "JSON" import can be buggy (154245), so my question is simple: can the following behaviour be ...
- 4,795
8
votes
2
answers
255
views
Map Values in 'nested' association
JSON often returns sort of 'nested' associations like so:
...
- 619
6
votes
1
answer
68
views
Export inserts unwanted characters
I have the following sample JSON file:
{"attr1": "Sample with val1"}
When I parse it as JSON I get the expected output:
...
- 5,097
1
vote
1
answer
297
views
Error: Cannot import data as JSON format, Khan Academy API
Problem context
I'm updating my working Mathematica Khan Academy reporting application. Since updating to 11.2 I'm having some errors importing via the Khan Academy API as JSON. Update: This ...
- 417
33
votes
3
answers
9k
views
Who is to blame: parsing UTF8 encoded JSON HTTPResponse fails
Bug introduced in 11.0 or earlier and persists through 12.0
(confirmed by WRI Support but read summary below)
Answers summary
I think we need a quick summary here to justify keeping bug.
Original ...
Kuba♦
- 136k
3
votes
1
answer
551
views
Pulling Out Values from JSON Association
Having a bit of trouble pulling a value out of a JSON Association here. I am scraping this website: http://www.msn.com/en-us/money/stockdetails/history/fi-126.1.BY.NYS
I want to scrape the closing ...
- 647
0
votes
0
answers
69
views
Querying the Monero blockchain via JSON-RPC [duplicate]
When querying Monero deamon via JSON-RPC as described in Daemon RPC documentation, via Curl, everithing pass fine :
...
- 910
9
votes
3
answers
3k
views
9
votes
2
answers
531
views
How to extract a value from an XML tree
I am trying to pull out a certain value from an XML tree that I have acquired from a website:
...
- 647
5
votes
1
answer
602
views
Is it possible to grab all the links at once on a webpage?
I'm working with some webscraping using Mathematica and have run into a question: is it possible to grab all the links on a webpage that scrolls down? The page I am trying to scrape is this: "http://...
- 647
1
vote
0
answers
416
views
Export number as formatted numeric value, not string
Some related questions include here.
Is there a way to format numbers for export in CSV or JSON as numbers - not strings - with a specified number of decimal places and no exponentials?
Is output ...
- 15k
2
votes
2
answers
529
views
Using URLFetch/URLExecute to post to an internal server
I've been looking up how to do this for a while and I haven't seen any thorough explanations, just hints. Is there like a secret repository of clearly defined Mathematica code somewhere that I cant ...
- 417
4
votes
1
answer
100
views
WriteRawJSONString vs ExportString?
What's the difference between Developer`WriteRawJSONString[] and ExportString[]? I see it used a lot but don't see a difference:
- 31k
0
votes
0
answers
70
views
How to interpreter file into date and json?
I have DateAndJson.txt and want to analyse it.
...
- 6,766
6
votes
1
answer
383
views
How do I display my weather data in JSON format from Wolfram Mathematica API?
Good day
I am trying to display my weather data in a JSON format in order to use it in an iOS app (using swift in Xcode). This is what my code looks like at the moment:
...
6
votes
1
answer
6k
views
How can I generate a graph from a NetworkX JSON
I have done some network generation and analysis in Python NetworkX. I do most of my visualizations with D3, but for publications I would like to generate some graph plots with Mathematica as well as ...
- 917
1
vote
1
answer
260
views
How to interpret and extract the information from the JSON (JavaScript Object Notation)? [closed]
How to interpret and extract the information from the JSON (JavaScript Object Notation)? I would extract the information and plot the information graphically. Please advise and comment. Thank you.
<...
- 479
3
votes
0
answers
59
views
Can JLink return a structured object?
What I want to achieve seems obvious but I cannot figure it out:
I need to find a way that when I send an expression to be evaluated from a Java back end to a Mathematica kernel, I can live with it ...
- 31
7
votes
1
answer
994
views
How to get sub property from json result?
I'm brand new to Mathematica and I imported a json:
data = ImportString["{\"x\":1,\"y\":1}", "json"]
and result:
...
- 859
10
votes
2
answers
5k
views
RawJSON vs JSON format
It has been very recently, since the release of version 10.3.0 I think, that Import/Export and ImportString/ExportString functions accept a format parameter with the value of "RawJSON".
The ...
- 1,291
0
votes
0
answers
88
views
How to export heterogeneous data to single file?
I want to export structured heterogeneous data (containing images) to some standard file format. The expression to export can contain 3 atomic types: numbers, strings, images, and be nested with 2 ...
- 31k
2
votes
0
answers
115
views
Exporting organization of Mathematica's documentation to a JSON file
In this answer, @Vitaliy Kaurov explores and utilizes new Mathematica's functionality WolframLanguageData:
...
- 3,630