Jul-03-2018, 03:01 PM
I downloaded a data base table and asked that it be converted into json. What I got was:
[{"rowId": 21,"nature": "O","symbol": "TAL","qty": 10,"daysHeld": 0,"source": "Momentum","dayEntered": "2018-01-16","pl": -40}, {"rowId": 22,"nature": "O","symbol": "SGMO","qty": 5,"daysHeld": 35,"source": "Lightning Trend","dayEntered": "2018-02-06","pl": 2300}]
When I bring it into Python/json is comes in as a list. How do I get it into a dictionary?
Also what is the statement to modify i.e. the pl 2300 to 230?
Thanx
[{"rowId": 21,"nature": "O","symbol": "TAL","qty": 10,"daysHeld": 0,"source": "Momentum","dayEntered": "2018-01-16","pl": -40}, {"rowId": 22,"nature": "O","symbol": "SGMO","qty": 5,"daysHeld": 35,"source": "Lightning Trend","dayEntered": "2018-02-06","pl": 2300}]
When I bring it into Python/json is comes in as a list. How do I get it into a dictionary?
Also what is the statement to modify i.e. the pl 2300 to 230?
Thanx