skipIfKnownColumn not working in import api

Develop, Build & Integrate APIs & Integrations
1

Hi! I’m using hubspot import api and there are some columns whose values should not be overwritten. It’s working using UI but not when using import API. I’ve already set “skipIfKnownColumn”: true in the column mapping but values still gets overwritten. Any ideas as to why?

2

Hi, @JM20 :waving_hand: Thanks for your question. I’d like to ask a few of our community champions for their feedback — hey @SteveHTM @Kevin-C @Mike_Eastwood have you managed to send `“skipIfKnownColumn”: true` successfully using the Import API? I understand how to set this in-app, as noted by the OP, and I found some older community posts indicating it was possible, but I’ve not been successful in finding the matching developer documentation for this action.

Thank you for any and all your help! — Jaycee

3

Yep - I confirm that I’ve been unable to find any such such documentation or community reference. It makes sense that it would exist in some form, but I can’t see it.

Steve

4

Thanks for your responses. This is actually where I saw the community post that it’s possible to use skipIfKnownColumn property : https://community.hubspot.com/t5/APIs-Integrations/Don-t-override-existing-value-option-in-Bulk-impo…

but no official documentation.

So, is this functionality really supported?

5

Undocumented in 2021 - and still undocumented in 2024. You have to wonder who might know the truth here…

6

Hey @SteveHTM That is a valid question. I’m submitting this to the team that owns these endpoints to see if we can get a confirmation on if this possible/not possible. If not possible, I’ll update the post @JM20 linked so that it stops causing confusion. I’ll update this post as soon as I hear back. — Jaycee

7

Hey @Jaycee_Lewis,

I’m facing the same problem.
Did you get a response from the API team?
Thanks in advance,

Q.

8

Hey, @JM20 can you DM me the import ID and portal ID for the Import where adding this to your column mapping failed, please? My internal requested it so they can take a more in-depth look. If you have an example as well @SteveHTM I can share that too. The more, the merrier :blush:

Thank you!

9

Thanks. Sent you a dm