How do I import a JSON-file with multiple values?

[Johannes Buverud]

Example:

I have two object types

- "Certificate", with attribute "Store" (which have unlimitd cardinality since a certificate can be in multiple Certificate Stores.) 

- "Certificate Store"

I have created three Certificate Store objects: "Store1", "Store2" and "Store3"

I have a JSON file with two certificates "Cer1" and "Cer2" and their related stores. The first certificate has two related stores, the second has one :

When I create an import, I have to choose which of the three Data Locators containg the stores to be mapped to the refereed Certification Store:

Maybe I can select all of them in this example, but this will then not work when a new file needs to be imported with certificates containing more stores than two stores.

Does the JSON file has to be reformatted, and if so how? Or is there another way to do this?

[Alexander Sundström · Accepted solution]

Hi Johannes,

The value need to be piped, like :

value = "Store1||Store2"

Even if arrays are valid JSON, the current implementation does not support importing from an array without specifying the element index, this is something that will change in the future, but the work around is to make value to a String instead, and separate each value using ||

Best Regards
Alexander 

[Johannes Buverud]

Removing the brackets and replacing the comma with the pipes did it, thanks!

[Johannes Buverud]

And one more thing (which you had in your example); the inverted commas between the values also has to be removed.

For the record, this is what works:

"#store":  {"value" : "Store1||Store2"} 

and also

"#store":  "Store1||Store2"

[Michal]

I doesnt seem to work for me. Can You show me full JSON file which You import with Insight?

[Robert Hutze]

I doesnt seem to work for me. Can You show us full JSON file which You import with Insight? Pls add JSON source here as a comment. 

Thx

Robert

[Johannes Buverud]

The actual file I import has sensitive data, but this is an example of the full format:

[
 {
 "name": "Cer1",
 "Store": "Store1||Store2"
 },
 {
 "name": "Cer2",
 "Store": "Store1||Store2||Store3"
 }
]

 The "Object Mapping (IQL)" for the Store attribute in the Import Job is like this:

"Stores" IN (${Store${0}})

(where "Stores" is the attribute containing the Stores I import.)

[Robert Hutze]

Thanks! Major new info is the mapping details ("Object Mapping (IQL)").