Python – TypeError: Object of type “int64” is not JSON serializable


I have a data frame that stores store name and daily sales count. I am trying to insert this to Salesforce using the Python script below.

However, I get the following error:

TypeError: Object of type "int64" is not JSON serializable

Below, there is the view of the data frame.

Store A,10
Store B,12
Store C,5

I use the following code to insert it to Salesforce.

update_list = []
for i in range(len(store)):
    update_data = {
        "name": store["entity_name"].iloc[i],
        "count__c": store["count"].iloc[i] 

sf_data_cursor = sf_datapull.salesforce_login()

I get the error when the last line above gets executed.

How do I fix this?

Answer rating: 128

json does not recognize NumPy data types. Convert the number to a Python int before serializing the object:

"count__c": int(store["count"].iloc[i])

Answer rating: 93

You can define your own encoder to solve this problem.

import json
import numpy as np

class NpEncoder(json.JSONEncoder):
    def default(self, obj):
        if isinstance(obj, np.integer):
            return int(obj)
        if isinstance(obj, np.floating):
            return float(obj)
        if isinstance(obj, np.ndarray):
            return obj.tolist()
        return super(NpEncoder, self).default(obj)

# Your codes .... 
json.dumps(data, cls=NpEncoder)