I need a tool to modify json data with some arbitrary function applied only to specific paths expressed in some syntax (e.g. jsonpath, but may be any other). Key feature is to modify existing data structure, not to extract only some piece and then modify it. Is there something like I described? For example we…
Tag: json
Python List Comprehension to Delete Dict in List
I have a json file formatted as above and I am trying to have a function delete an entry based on the username input from a user. I want the file to then be overwritten with the entry removed. I have tried this: It partially works as everything in the Credentials section looks normal, but it appends a strange…
Python code to multiple JSON files with different names
I’m new to python and programming in general, asking for help: What to run in python code to print this data in multiple JSON files (300 files) that every file change the “name” line from #1 to #300 and the JSON files names will be like from 1.json to 300.json is it possible? Answer try this…
Add a object one level higher in pandas json
I’m new to json and pandas and want to output my data in the following schema, but I’m not sure how to add the leading ‘results’. My dataframe: My code: My Json output: My Json schema that I want: Answer Try this:
Cannot load a JSON file I just created (json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0))
I’m trying to work with json files, but I’m unable to load the file I just saved. I’m not sure what I’m doing wrong. I tried json.loads(f.read().decode(‘UTF-8’)) and json.load(f) and they both give me errors as well. Edit: The purpose of this code is to store time spent on …
check if JSON response has an object
I’m trying to filter out if a JSON response has objects, and do something if it has. My Problem is that even if it has objects, it won’t trigger the break. Here is my code: Answer print(email.get_list_of_emails()) return None. This is why you never get the break. Try to remove the print Try to cha…
Nested python dataclasses with list annotations
python ^3.7. Trying to create nested dataclasses to work with complex json response. I managed to do that with creating dataclass for every level of json and using __post_init_ to set fields as objects of other dataclasses. However that creates a lot of boilerplate code and also, there is no annotation for ne…
Filter null values from JSON
I receive the following JSON from the MS Graph API: How can I filter the null values using Python (3.9) ? Answer First of all, processing it is easier when it’s been converted to python data structure, such as a dict. The built-in json module can convert a json-string into python objects using json.load…
Issue with Base64 encoding in Python and Decoding in Java
I have two packages running, one is written in python and the other in Java. The python package encodes a json(dictionary) object and sends it to the java package which decodes it into a specific POJO. Let the json in python be: { “name”: “John”, “Age”: 24, “Income…
Extract three values from JSON output
I am trying to get three specific values from within a JSON return. I can only figure out how to get ALL the information rather than specific pieces. Here’s the JSON output (note – the date 2021-08-13:2 is going to change every week but I need that value also the 710.0 will likely change, too): Wh…