Hi all,
I am trying to use import api to load csv file. My requirement is to create assosiasions between same object records(ex. Contact to Contact) while importing. I will import Parent contact then childs. They should be assosiated as Parent and Child labels.
I am trying to follow these rules in Hubspot Import API:
But I don’t know whether this ‘Same-object associations’ checkbox is available and can be enabled in Import API body:
Also, I don’t know hubspot property mapping for Assosiated Contact Email and Labels column in this sample file, does anybody know about mapping field for them. In Import API documentation, not all information is available:
From my last imports I got this response with multiple settings. Thinking I can enable all above things by changing some of its settings. Can someone please help me figuring out this. Thanks:
{
"state": "STARTED",
"importRequestJson": {
"portalId": 44154116,
"language": "en-us",
"numberFormatLocale": {
"language": "en",
"country": "US"
},
"dateFormat": "MONTH_DAY_YEAR",
"timeZone": "Z",
"userId": null,
"importOperations": {
"0-1": "UPSERT"
},
"optOutBusinessUnitId": null,
"invalidPropertyValues": [],
"importName": "Contact Import",
"fileImports": [
{
"columnDelimiter": null,
"estimatedLineCount": 4586,
"fileFormat": "CSV",
"charset": "UTF-8",
"fileId": 146268028197,
"pages": [
{
"columnMappings": [
{
"columnObjectType": null,
"columnObjectTypeId": "0-1",
"toColumnObjectTypeId": null,
"engagementType": null,
"columnName": "Email",
"propertyName": "email",
"ignored": false,
"idColumnType": null,
"columnType": "HUBSPOT_ALTERNATE_ID",
"foreignKeyType": null,
"associationLabels": null,
"associationIdentifierColumn": false,
"skipIfKnownColumn": false,
"marketingEventSubmissionType": null
},
{
"columnObjectType": null,
"columnObjectTypeId": "0-1",
"toColumnObjectTypeId": null,
"engagementType": null,
"columnName": "Email2",
"propertyName": "email_2",
"ignored": false,
"idColumnType": null,
"columnType": "STANDARD",
"foreignKeyType": null,
"associationLabels": null,
"associationIdentifierColumn": false,
"skipIfKnownColumn": false,
"marketingEventSubmissionType": null
},
{
"columnObjectType": null,
"columnObjectTypeId": "0-1",
"toColumnObjectTypeId": null,
"engagementType": null,
"columnName": "First Name",
"propertyName": "firstname",
"ignored": false,
"idColumnType": null,
"columnType": "STANDARD",
"foreignKeyType": null,
"associationLabels": null,
"associationIdentifierColumn": false,
"skipIfKnownColumn": false,
"marketingEventSubmissionType": null
},
{
"columnObjectType": null,
"columnObjectTypeId": "0-1",
"toColumnObjectTypeId": null,
"engagementType": null,
"columnName": "Home Phone",
"propertyName": "home_phone",
"ignored": false,
"idColumnType": null,
"columnType": "STANDARD",
"foreignKeyType": null,
"associationLabels": null,
"associationIdentifierColumn": false,
"skipIfKnownColumn": false,
"marketingEventSubmissionType": null
},
{
"columnObjectType": null,
"columnObjectTypeId": "0-1",
"toColumnObjectTypeId": null,
"engagementType": null,
"columnName": "Last Name",
"propertyName": "lastname",
"ignored": false,
"idColumnType": null,
"columnType": "STANDARD",
"foreignKeyType": null,
"associationLabels": null,
"associationIdentifierColumn": false,
"skipIfKnownColumn": false,
"marketingEventSubmissionType": null
},
{
"columnObjectType": null,
"columnObjectTypeId": "0-1",
"toColumnObjectTypeId": null,
"engagementType": null,
"columnName": "City",
"propertyName": "city",
"ignored": false,
"idColumnType": null,
"columnType": "STANDARD",
"foreignKeyType": null,
"associationLabels": null,
"associationIdentifierColumn": false,
"skipIfKnownColumn": false,
"marketingEventSubmissionType": null
}
],
"hasHeader": true
}
]
}
],
"createContactListFromImport": false,
"source": "API",
"importNotificationType": "IMPORT_COMPLETED",
"marketableContactImport": false,
"skipIfKnownImport": false,
"marketingEventObjectId": null,
"parentChildCompanyImport": false
},
"importSource": "API",
"createdAt": "2023-11-20T16:38:00.843Z",
"metadata": {
"objectLists": [],
"counters": {},
"fileIds": [
"146268028197"
]
},
"importName": "Contact Import",
"updatedAt": "2023-11-20T16:38:00.994Z",
"optOutImport": false,
"id": "40780911",
"effectiveIntegrationRuntime": "AutoResolveIntegrationRuntime (Central US)",
"executionDuration": 3,
"durationInQueue": {}
}