I'm working on a project where I fetch data from a database using a stored procedure. The data is returned in XML format like this: <record> <field name="ID">8f7e-25fbcce2cdc7</field> <field name="TRANSACTIONSTATUS">202</field> <field name="TRANSAMT">1.90</field> <field name="SNDNAME">MR. Jade</field> <field name="RECVNAME">MR. Lucas</field> <field name="SNDACCTNUMBER">8224002623</field>…
I am exploring FastAPI, and got it working on my Docker Desktop on Windows. Here's my main.py which is deployed successfully in Docker: #main.py import fastapi import json from fastapi.responses import JSONResponse app = fastapi.FastAPI() @app.get('/api/get_weights1') async def get_weights1(): weights…
I'm trying to filter a json response and use the filtered response to update several documents in my mongodb collection. The Json response looks like this: {"88996940":{"charge":"5","start_count":"10","status":"Completed","remains":"90","currency":"USD"}, "88996961":{"charge":"8","start_count":"50","status":"Completed","remains":"50","currency":"USD"}, "88999796":{"charge":"7","start_count":"80","status":"Completed","remains":"20","currency":"USD"}} "88996940","88996961" and "88999796" are the order id's. I want to filter…
I want to return JSON format from my database using asp.net mvc5 c#. I tried a lot of ways but was unable to generate data as per my requirement. I need the JSON array in this format. { "draw":0, "recordsTotal":2,…