Import API - 400 Bad Request

Developer Support APIs & Integrations
1

Hello everyone, I encountered a problem - when sending a request, I get a 400 error without any response inside. From the side of Hubspot, I do not see this request in the logs. Has anyone experienced this problem?
Curl

curl --request POST \
 --url https://api.hubspot.com/crm/v3/imports \
 --header 'Accept: application/json' \
 --header 'Authorization: Bearer pat-eu1-******' \
 --header 'Content-Type: multipart/form-data' \
 --form 'importRequest={"name":"test_import","files":[{"fileName":"test1.csv","fileFormat":"CSV","dateFormat":"YEAR_MONTH_DAY","marketableContactImport":false,"fileImportPage":{"hasHeader":true,"columnMappings":[{"columnName":"id","propertyName":"Record ID","idColumnType":"HUBSPOT_ALTERNATE_ID","columnObjectTypeId":"0-1"},{"columnName":"username","propertyName":"First Name","columnObjectTypeId":"0-1"},{"columnName":"email","propertyName":"Email","columnObjectTypeId":"0-1"},{"columnName":"register_date","propertyName":"Create Date","columnObjectTypeId":"0-1"},{"columnName":"last_activity_date","propertyName":"Last Activity Date","columnObjectTypeId":"0-1"},{"columnName":"teams","propertyName":"Associated Ticket IDs","columnObjectTypeId":"0-1"},{"columnName":"organizations","propertyName":"Associated Company IDs","columnObjectTypeId":"0-1"}]}}]}' \
 --form 'files=@/path_to_file/test1.csv'

Pretty Json

{
 "name":"test_import",
 "files":[
 {
 "fileName":"test1.csv",
 "fileFormat":"CSV",
 "dateFormat":"YEAR_MONTH_DAY",
 "marketableContactImport":false,
 "fileImportPage":{
 "hasHeader":true,
 "columnMappings":[
 {
 "columnName":"id",
 "propertyName":"Record ID",
 "idColumnType":"HUBSPOT_ALTERNATE_ID",
 "columnObjectTypeId":"0-1"
 },
 {
 "columnName":"username",
 "propertyName":"First Name",
 "columnObjectTypeId":"0-1"
 },
 {
 "columnName":"email",
 "propertyName":"Email",
 "columnObjectTypeId":"0-1"
 },
 {
 "columnName":"register_date",
 "propertyName":"Create Date",
 "columnObjectTypeId":"0-1"
 },
 {
 "columnName":"last_activity_date",
 "propertyName":"Last Activity Date",
 "columnObjectTypeId":"0-1"
 },
 {
 "columnName":"teams",
 "propertyName":"Associated Ticket IDs",
 "columnObjectTypeId":"0-1"
 },
 {
 "columnName":"organizations",
 "propertyName":"Associated Company IDs",
 "columnObjectTypeId":"0-1"
 }
 ]
 }
 }
 ]
}

test1.csv

id;username;email;register_date;last_activity_date;teams;organizations
530471;Test1;test1@mail.com;"2023-07-24 17:55:29";"2023-08-14 17:56:23";"{""Test1`s team"",""Test 2`s team""}";"{""Test1`s organization"",""Test 2`s organization""}"
530481;"Test 2";test2@mail.com;"2023-07-24 20:36:25";"2023-08-14 20:39:20";"{""Test 2`s team"",""Test1`s team""}";"{""Test 2`s organization"",""Test1`s organization""}"
2

Perhaps because the csv file is not comma seperated and uses semi colons as delimiter?

Some other questions to consider:

Are the teams and organizations data in the csv file in the correct format for the corresponding Hubspot defined properties?

Is the last_activity_date a default Hubspot property? Is it allowed to be set via Import?