Hi Hubspot team,
Hope you have a nice day!
Firstly, I wanna say am new to Hubspot. In addition, my purpose is to know how to build the request to import deals with company and contact association via Import API.
This is the request which I try to do but not sure whether it’s correct or not (I also leave some comments about what I got concerned in this request).
Please advise and thanks in advanced!
{
"name": "Import Deals Process",
"dateFormat": "DAY_MONTH_YEAR",
"files": [
{
"fileName": "deals_import.csv",
"fileFormat": "CSV",
"fileImportPage": {
"hasHeader": true,
"columnMappings": [
{
"columnObjectTypeId": "0-3",
"columnName": "Pipeline",
"propertyName": "pipeline"
},
{
"columnObjectTypeId": "0-3",
"columnName": "Deal Stage",
"propertyName": "dealstage"
},
{
"columnObjectTypeId": "0-3",
"columnName": "Deal Name",
"propertyName": "dealname"
},
{
"columnObjectTypeId": "0-3",
// columnName is just record id? Is it good practice? or do we need to specify Company and Contact in column name?
"columnName": "Record ID",
"propertyName": "recordid",
"idColumnType": "HUBSPOT_OBJECT_ID"
},
{
// columnObjectTypeId is it should be 0-1 or 0-3, cause this is the column to link contact?
"columnObjectTypeId": "0-1",
// columnName should be 'Associated Email' or 'Email' for deduplicate purpose? I would like to use existing contact.
"columnName": "Associated Email",
"propertyName": "email",
// is column type is correct for this case?
"columnType": "HUBSPOT_ALTERNATE_ID"
},
{
// // columnObjectTypeId is it should be 0-1 or 0-2, cause this is the column to link company?
"columnObjectTypeId": "0-2",
// Column should be 'Associated Company' or 'Company Domain Name' for deduplicate purpose - I would like to use existing company?
"columnName": "Associated Company",
"propertyName": "email",
// is column type is correct for this case?
"columnType": "HUBSPOT_ALTERNATE_ID"
}
]
}
}
]
}