Frustrated with the companies batch update/upsert API

I’m getting seemingly inconsistent errors when using the Huspot API, specifically the batch update and upsert services of companies.

Making the same request to both services, I am getting a different error on each one and neither of them makes sense to me.
In the case of the update, if I send the following request:

[
 {
 "url": "/crm/v3/objects/companies/batch/update",
 "body": {
 "inputs": [
 {
 "id": "f914a228-99e3-40fc-be61-a5430327394f",
 "idProperty": "billin_bs_business_id",
 "properties": {
 "billin_bs_country": "ES",
 "billin_bs_updated_at": "1730109115579",
 "company_owner_billin": "180024532"
 }
 }
 ]
 },
 "method": "POST",
 "headers": [
 {
 "key": "Content-Type",
 "value": "application/json"
 }
 ]
 }
]

I receive the following response error:

[400] Failed to find objects with unique property.

I’m pretty sure that it exists. If I search it via API or via web I find it:

If i make the same request but to the upsert service:

"url": "/crm/v3/objects/companies/batch/upsert"

I receive the following response error:

[400] Property values were not valid: [{"isValid":false,"message":"Property \"company_owner_billin\" does not exist","error":"PROPERTY_DOESNT_EXIST","name":"company_owner_billin","localizedErrorMessage":"Property \"company_owner_billin\" does not exist","portalId":39661107}].

But as you can see in the image above, the property does exist.

Can anyone help me to resolve the problem?

Thanks in advance

@mcasarrubios - quick check. Is your ‘billin_bs_business_id’ property required to have unique values in the preperty definition?

Steve

@SteveHTM yes, it is required to have unique values

Can someone confirm if this is an API bug? I’m stuck because of this and have no idea how to fix it

Hey @mcasarrubios, could you provide us more details on where you are getting stuck specifically?

Thank you,

Pam