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”
}
]
}
}
]
}