Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-17-2021 11:52 AM
I am doing a convertion of a data frame to nested dict/json. One of the column called "Problematic__c" is boolean type.
For some reason json does not accept this data type retriving error: "Object of type bool_ is not JSON serializable"
I need this as boolean as this json is later injected to Salesforce via API. I could easly make it string but the destination object accept boolean only.
Here is a python code:
all_rows = len(data)
y = []
for i in range(all_rows):
x = dict(data.iloc[i, 2:])
x["Account__r"] = dict(data.iloc[i, :1])
x["Product_Master__r"] = dict(data.iloc[i, 1:2])
y.append(x)
y=json.dumps(y)and this is expected output:
[
{
"Recommended_Action__c":"Take action Z",
"Extra_Information_JSON__c":"[{\"name\":\"Action\",\"value\":\"Verifier remplissage\"},{\"name\":\"Stock Disponible\",\"value\":\"18\"}]",
"Flag__c":"Rupture Ponctuel",
"Problematic__c":True,
"Value__c":5800.0,
"Source_Id__c":"538.0",
"Batch__c":"a2e7Y110000dO6WQAU",
"Account__r":{
"Code__c":"00001-B"
},
"Product_Master__r":{
"EAN_Code__c":"1111111111.0"
}
},
{
....
}.
.....
]Data frame called "data" has structure as below with sample values:
"Code__c":"00001-B"
"EAN_Code__c":"1111111111.0"
"Recommended_Action__c":"Take action Z",
"Extra_Information_JSON__c":"[{\"name\":\"Action\",\"value\":\"Verifier remplissage\"},{\"name\":\"Stock Disponible\",\"value\":\"18\"}]",
"Flag__c":"Rupture Ponctuel",
"Problematic__c":True,
"Value__c":5800.0,
"Source_Id__c":"538.0",
"Batch__c":"a2e7Y110000dO6WQAU",
"Code__c":"00001-B"
"EAN_Code__c":"1111111111.0"
Labels:
- Labels:
-
Pandas Python
-
Python