# Unable to import data into Hubspot using Python

**URL:** <https://community.hubspot.com/t/unable-to-import-data-into-hubspot-using-python/84833>\
**Category:** APIs & Integrations\
**Tags:** python\
**Created:** [July 6, 2023, 5:34pm UTC](https://community.hubspot.com/t/unable-to-import-data-into-hubspot-using-python/84833 "2023-07-06T17:34:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![FemiAnthony](https://avatars.discourse-cdn.com/v4/letter/f/e36b37/32.png) [@FemiAnthony](https://community.hubspot.com/u/FemiAnthony)\
**Post date:** [July 6, 2023, 5:34pm UTC](https://community.hubspot.com/t/unable-to-import-data-into-hubspot-using-python/84833/1 "2023-07-06T17:34:31Z")

</div>

Hi, I’m trying to import data into Hubspot in a test account using Python and I keep getting this error : **Unable to process JSON**  
My JSON has been validated and the file looks like this:

{  
“name”: “Hubspot Extract”,  
“importOperations”: {  
“0-1”: “CREATE”  
},  
“dateFormat”: “DAY\_MONTH\_YEAR”,  
“files”: [  
{  
“fileName”: “institutions.csv”,  
“fileFormat”: “CSV”,  
“fileImportPage”: {  
“hasHeader”: true,  
“columnMappings”: [  
{  
“idColumnType”: “HUBSPOT\_COMPANY\_ID”,  
“columnObjectTypeId”: “0-1”,  
“columnName”: “ACCOUNT\_ID”,  
“propertyName”: “account\_id”  
},  
{  
“columnObjectTypeId”: “0-1”,  
“columnName”: “INSTITUTION\_NAME”,  
“propertyName”: “company\_name”  
},  
{  
“columnObjectTypeId”: “0-1”,  
“columnName”: “COMPANY\_ID”,  
“propertyName”: “company\_id”  
},  
{  
“columnObjectTypeId”: “0-1”,  
“columnName”: “STREET”,  
“propertyName”: “billing\_street”  
},  
{  
“columnObjectTypeId”: “0-1”,  
“columnName”: “CITY”,  
“propertyName”: “billing\_city”  
},  
{  
“columnObjectTypeId”: “0-1”,  
“columnName”: “STATE\_CODE”,  
“propertyName”: “billing\_state”  
},  
{  
“columnObjectTypeId”: “0-1”,  
“columnName”: “ZIP”,  
“propertyName”: “billing\_postal\_code”  
},  
{  
“columnObjectTypeId”: “0-1”,  
“columnName”: “COUNTRY\_CODE”,  
“propertyName”: “billing\_country”  
}  
]  
}  
}  
]  
}