Import child object

Question

Hi Community!

I would like to import Assets child objects filtered by the "Category" column in my CSV.

For example, I have on my CSV:

Name, Category, Model,...

* LAP-001, Laptop, Macbook Air,...
* PHONE-003, Phone, Iphone 15 Pro,...

And I would like to populate the child objects below.

But I can't find any specific documentation on the subject or an example that would solve this problem (AQL Query, tests, example). All the documentation is very vague.

I've already imported objects by creating a CSV by category, but I think there's a more effective solution.

Can you help me?

Elise Vernier_en3d8w · Answer

Hey @Fernando Eugênio da Silva,

Thank you for your help, but I've already import the laptop apart from the other objects. So I know your solution.

I would like to know if we can import Laptop and Phone in the same CSV as child objects.

I'm blocked when I click on Create child mapping.

I hope it's clearer.

Fernando Eugênio da Silva · Answer

Hey @Elise Vernier ,

If I understand correctly what you are trying to do is the following:

You have the ObjectType Device and Laptop, where Laptop is a child item of Device. Now you want to import a csv with all the laptops, but with the Devices associated, am I correct?

If this is the case you need to have a column in your csv where in this case you will map the name of the laptop linked to your Device. Like this example:

So when you perform the import, you are indicating the attribute that links Device and Laptop, you must indicate an AQL similar to this: Name = ${your-device-colum}

Using the example in the print, I am importing Laptops and associating Devices with the AQL: Name = ${Device Name}

Take a look at here to lear more: https://support.atlassian.com/jira-service-management-cloud/docs/create-attributes-and-references-from-your-data/

Hope this helps you!