Using imports API to create objects and associate them with pre-existing objects

KElliott5 — Thu, 09 Jan 2025 11:51:09 GMT

I am using the Import API to ingest some objects and for most use cases that is working fine.

In one of my use cases however I am importing objects which will have an association with a pre-existing object (i.e. not an object that is included within the import). The association definitions are set up already.

My assumption was that I could both import the objects and create the associations at the same time, by using the following in the mapping JSON for the relevant CSV column:

{"columnObjectTypeId": "2-137774576", "columnName": "brandid", "toColumnObjectTypeId": "2-137774399","columnType": "FLEXIBLE_ASSOCIATION_LABEL"}

However, that is returning the following error:

Response: {"status":"error","message":"toColumnObjectTypeId 2-137774399 for FlexibleAssociationColumn column brandid does not match provided objectTypes in import: [2-137774576]","correlationId":"6fb4ddb9-94f0-448a-8591-ae5d0b7cad75","context":{"toColumnObjectTypeId":["ObjectTypeId{metaTypeId=2, innerId=137774399}"]},"category":"VALIDATION_ERROR"}

I am confident that the object type IDs are correct. My hypothesis therefore is that in order to create the association at the same time as the import, I would need to have both the objects involved in the association within the import.

Since that isn't possible in my instance, I should instead use the Associations API to create the association after the initial import. Is that correct? Or have I missed something?

Re: Using imports API to create objects and associate them with pre-existing objects

Jaycee_Lewis — Thu, 09 Jan 2025 17:20:45 GMT

Hey, @KElliott5 👋 Thanks for your question. I believe you are on the right path with the last question in your post. Because the target objects are not part of the current import operation, you'll need to break this up into two requests:

do the import without associations
hit the Associations API to create the relationship with your pre-existing objects

Hey @evaldas @MadisonMoniz @Danielle_J, do you have any additional feedback for @KElliott5?

Thank you very much for taking a look! — Jaycee

topic Re: Using imports API to create objects and associate them with pre-existing objects in APIs & Integrations

Using imports API to create objects and associate them with pre-existing objects

Re: Using imports API to create objects and associate them with pre-existing objects