I'm trying to import the content of a .json file and run it in a Docker container, but I get next error when run the docker container: Error: Traceback (most recent call last): File "/stockalert-app/./app/main.py", line 22, in <module> main()…
I have a problem with a query to select some data from my database, My database has 3 tables: movies, actors, movies_actors. ACTORS TABLE +-----------+ | ID | NAME | +-----------+ | 1 | Bob | +-----------+ | 2 |…
I am developing a light weight web app in ASP.NET with C# and I would like to store some data such as site analytics etc. Instead of using a SQL server database could I use a JSON file instead? So…
I have a json file with thousands of lines and 90 json objects. Each object come with the following structure: { "country_codes": [ "GB" ], "institution_id": "ins_118309", "name": "Barclaycard (UK) - Online Banking: Personal", // I want to extract this…
I have write the follow code to get the data formated as JSON {"billNumber":"0003","entityActivityId":572,"customerFullName":"التوكيلات التجارية","customerMobileNumber":"0506436506","customerPreviousBalance":0,"issueDate":"2022-08-16","expireDate":"2022-09-23","billItemList":{"name":"*","quantity":1,"unitPrice":900,"discount":0,"discountType":"FIXED","vat":"0.15"}} but I want to be as follwoing: the deferrence is the [] in the details data. {"billNumber":"0003","entityActivityId":572,"customerFullName":"التوكيلات التجارية","customerMobileNumber":"0506436506","customerPreviousBalance":0,"issueDate":"2022-08-16","expireDate":"2022-09-23","billItemList":[{"name":"*","quantity":1,"unitPrice":900,"discount":0,"discountType":"FIXED","vat":"0.15"}]} my code is : dt1 = dt.ToString("yyyy-MM-dd")…
(I know this has a bad title) I'm using firebase and express for this project but this doesn't work. src/index.js import { initializeApp } from "firebase/app"; import { doc, getFirestore } from "firebase/firestore"; import { collection, addDoc, getDoc } from…
I'm trying to import multiple json files into my postgres Database with the following code. import json import psycopg2 con = psycopg2.connect(database="kw_du", user="postgres", password="f67dd8hzFE5",host="localhost") cur = con.cursor() with open(r"C:UsersdiegoOneDriveDesktopWorkplace220906nu_2022_09_01.json", 'r') as data_file: data = json.load(data_file) with con.cursor() as cur: cur.executemany('INSERT…
Im trying to send JSON data to the Api controller where HttpPost can add that data to file. JSON File: { "students": [ { "Id": 1, "Name": "Ravi", "Department": "IT" }, { "Id": 2, "Name": "Raj", "Department": "hr" }, {…
I'm new to ASP.NET and I'm trying to make a GET request to the YesNo API. However, when trying to deserialize the JSON response and assign the value to to a variable I get null values. Any assistance would be…
I have this existing query: SELECT to_json(table1) FROM table1 To return all of table in a nice json format. I need to add a join to this query, so my new query looks something like this: SELECT (field1, field2, table2field1)…