Json – How to serialize a generic object
I'm sorry for the bad title but I really don't know how to put this any other way. The detailed problem is as follows: I have a .NET API with Controllers. I have a controller that has a reference to…
exploding deeply nested json (json flatten) / flattening pandas df
I have the data coming via REST api with nested json, Trying to explode the response but its flatteing in only the first level. Need to explode the nested part also. First step im converting data into pd df then…
Postgresql – Unnest objects from a jsonb array into separate rows
I have a table in Postgres 14.9: Name (Txt) Detail (JSONB) state (JSONB) apple [{ "code": "156", "color": "red" }, { "code": "156", "color": "blue" }] [{ "ap": "good", "op2": "bad" }] orange [{ "code": "156", "color": "red" }, {…
How to get Json-Keys as column-names in a CSV with pyson?
I have the following code: import requests import pandas api_url = "***" Headers = { "Authorization" : "***" } response = requests.get(api_url, headers=Headers) obj = pandas.read_json(response.text, orient='values') obj.to_csv('output1.csv') And I get the follwing output in a CSV: enter image description…
Convert Json string to a different type
I have an object like this "maqVeicEquip": { "item": { "tipoMaq": "03", "marca": "DAF", "idadeMediaFrota": "1", "quantidade": "2", "indOnus": "true", "valorMedio": "0.00", "outrasInformacoes": "XF105 FTT510 - BCO PACCAR", "percPropriedade": "100.00" } } I can't deserialize it because the item is…
Parsing nested json list
I have a nested json response from a vendors API. { "data":{ "id":"hidden", "type":"file_import", "attributes":{ "id":"hidden", "type":"Academics API", "dry_run":false, "status":"completed", "import_started_at":"2023-09-05T15:13:59.159Z", "import_completed_at":"2023-09-05T15:14:11.581Z", "result":{ "info":{ "terms":[], "teachers":{ "created":{ "total":0, "list":[] }, "updated":{ "total":0, "list":[ ] } }, "courses":{ "created":{ "total":0, "list":[]…
Combining API responses into one json file using PHP
The API I am using only returns a max of 1000 records per request, so I need to change the range and keep requesting until all records are returned. I am trying to keep the parent node and merge the…
I'm trying to retrieve my API settings from my appsetting.json file
I'm working on an MVC project and can't seem to retrieve my key and host from the appsetting.json file. I've added this code to try and retrieve my api settings from a appsetting.json file in my project. So far the…
Json – How replace specific quotation marks into apostrophes?
My AI model generates this string: '{"name": "hammer 1.5"", "brand": "Eurosteel"}' I want to turn it into dict using json.loads. But it is not possible because of "hammer 1.5"" in value of name key. So I want to turn my…
Using ACF plugin to add barcode information to WooCommerce product page
I am using ACF to add barcode information to the WooCommerce product page. It has to be with the terms here: Has to follow the one here: https://support.convictional.com/woocommerce/adding-barcode-values-in-woo-commerce#adding_barcode_values_in_woo_commerce with terms as they asked. [{ "id": 1, "key": "barcode", "value": "12345678912"…