Problem definition

If ServiceNow or JSON endpoint has a tag containing two or more values separated by a delimiter (e.g. comma), there is no way for Insight Import to split the values and associate / reference objects from those values. Example tag:

<u_services>
d76n4789db472a5589d1vgdfkf71025Lo,c68b5162db472a0035d1bedfkf98764kk
</u_services>

Overall, Insight should provide more control to manipulate and transform imported data, as the source systems often cannot be changed and they will give output as-is.

Suggested resolution

Improve Insight import so that it could separate more delimited values from a single XML tag; give Insight more power to manipulate / transform source data when importing.

Potential workaround

Use combination of Insight automation and Groovy scripting to separate the values. General idea:

1. Map the value that needs to split in in a text custom field during the Insight import
2. After the data is imported, that field value that needs to have its value split, will be stored in that custom field
3. Create an Insight automation rule that would run on newly created objects, that would trigger a Groovy script to read the stored values from that text field, split them, and use that to create / associate Insight objects.