c# ImportRequestValidatorError.INVALID_PROPERTY_NAMES

[SImadEddine]

Hello everyone,
I succedded to import basic csv files with predefined columns but trying with custom new columns, the api returns the following error :

{
 "status": "error",
 "message": "The following property names are invalid: [Street Address, Company Name, Postal Code, Phone Number, Website URL, Company identification number, VAR Number, [MR] Secteur d'activité, Internal Customer ID].",
 "correlationId": "85d3e595-a848-4848-8eb4-f7f15c4054df",
 "context": {
 "invalidProperties": [
 "Street Address",
 "Company Name",
 "Postal Code",
 "Phone Number",
 "Website URL",
 "Company identification number",
 "VAR Number",
 "[MR] Secteur d'activité",
 "Internal Customer ID"
 ]
 },
 "category": "VALIDATION_ERROR",
 "subCategory": "ImportRequestValidatorError.INVALID_PROPERTY_NAMES"
}

I tried to check the documentation and finding the issue but without success. Here is an example of Street Address column.

Here is my json request.

{
 "name": "Association Label Import",
 "dateFormat": "DAY_MONTH_YEAR",
 "files": [
 {
 "fileName": "hubspot_sample.csv",
 "fileFormat": "CSV",
 "fileImportPage": {
 "hasHeader": true,
 "columnMappings": [
 {
 "columnObjectTypeId": "0-1",
 "columnName": "last_name",
 "propertyName": "lastname"
 },
 {
 "columnObjectTypeId": "0-1",
 "columnName": "first_name",
 "propertyName": "firstname"
 },
 {
 "columnObjectTypeId": "0-1",
 "columnName": "phone_number",
 "propertyName": "Phone Number"
 },
 {
 "columnObjectTypeId": "0-1",
 "columnName": "email",
 "propertyName": "email"
 },
 {
 "columnObjectTypeId": "0-2",
 "columnName": "internal_customer_id",
 "propertyName": "Internal Customer ID"
 },
 {
 "columnObjectTypeId": "0-2",
 "columnName": "company_identification_number",
 "propertyName": "Company identification number"
 },
 {
 "columnObjectTypeId": "0-1",
 "columnName": "company_name",
 "propertyName": "Company Name"
 },
 {
 "columnObjectTypeId": "0-1",
 "columnName": "street_address",
 "propertyName": "Street Address"
 },
 {
 "columnObjectTypeId": "0-2",
 "columnName": "VAT_number",
 "propertyName": "VAR Number"
 },
 {
 "columnObjectTypeId": "0-1",
 "columnName": "City",
 "propertyName": "city"
 },
 {
 "columnObjectTypeId": "0-1",
 "columnName": "postal_code",
 "propertyName": "Postal Code"
 },
 {
 "columnObjectTypeId": "0-2",
 "columnName": "secteur_activite",
 "propertyName": "[MR] Secteur d'activité"
 },
 {
 "columnObjectTypeId": "0-2",
 "columnName": "website_URL",
 "propertyName": "Website URL"
 }
 ]
 }
 }
 ]
}

The csv data file

last_name,first_name,phone_number,email,internal_customer_id,company_identification_number,company_name,VAT_number,City,postal_code,street_address,secteur_activite,website_URL
ln1,fn1,0123456789,test@test.fr,CC001765,479282999,SASU MARCHANDISES,FR50479289999,Paris,75015,17 RUE CHANTE CLAIR,Autre (précisez),https://www.marchandises.com

CODE

Anyone has an idea ? Thanks.

[Jaycee_Lewis]

Hey, @SImadEddine Thanks for your question.

I’d start by double-checking all the “internal names” for the properties you are getting an error with. We can see in your first screenshot for the property “Street Address” you used:

• “street_address” (incorrect)
• instead of “address” (correct)

You can verify these values in-app (like your example) or by making a request to the Properties API to return all your Contact properties and search for each property’s internal value manually.

Another example:

You received an error for Postal code:

• “postal_code” (incorrect)
• “zip” (correct)

You’ll have to do this on your end for the custom properties that returned an error, but here are the correct values for the default HubSpot created properties that were not set correctly:

"Street Address",
 "Company Name",
 "Postal Code",
 "Phone Number",
 "Website URL",

• Street Address = "address”
• Postal Code = "zip”
• Company Name = "company”
• Phone Number = "phone”
• Website URL = "website”

I hope this helps get you moving forward! — Jaycee

[SImadEddine]

Hey @Jaycee_Lewis , yes you are alright i was using the labels as names.
Thanks.