What is the proper way to get a data import to run that populates a multi-select list lookup value? I am getting the following error when running the data import:
“Known Cause → Invalid lookup value ‘[Job Site]’ in list lookup ‘Contact Role’ on data item ‘ContactRole’ on table ‘DirectoryIntegration’”
The issue is the brackets in the lookup value that was exported. If I remove the brackets in the CSV record, it will import fine. I do the mapping type setup as Multi-Select List Lookup.
There is a topic in Nextworld Help called Data Import Mapping configurations that goes through the nuances of different mapping types/options. If this doesn’t answer your question and you need more specific guideance please let me know! I can find answers and update our doc to be more helpful 
Thanks. I looked at that topic and do have my mapping using comma delimited but I’m still getting the brackets around the value which is causing the import to fail as it can’t find the lookups. I think the issue is actually the data export including the brackets and I’m not sure if there is a way in exports to define the output of a multi-select lookup.
@Kailey I was able to get around my multi-select lookup issue but now running into an issue with another import that is doing a table lookup by multiple values. The problem is I need to include the Contact Role Grouping as part of that but when searching by table lookup with multiple values, it’s using no case fetches but since this is a multi-select lookup value, it’s not able to find records. It’s using \“ContactRoleGrouping\”: {\“$nocase\”: \“[supp]\”} as the search but if I were to query directly in something like Postman, it would be like this:
“ContactRoleGrouping”: [
"SUPP"
],
Any idea how I would include a mult-select lookup as part of a import table lookup by multiple values?
