json syntax for collection splitter not accepted

Tryg

I am trying to import objects that go into different collections, record groups, series, etc. I've used json like this before:,
except everything was the same collection type, so I could use a constant, e.g.,
"collectionType": "series";
instead of substituting the the value in column 38 of the import spreadsheet. My collection splitter parameters are:
{
""relationshipType"": ""part_of"",
“collectionType"": ”^38”,
""matchOn"": [""idno""]
}

the log complains as follows:
2024-05-30 19:08:54 - ERROR --> [loadImporterFromFile:/tmp/php3WFsCc] invalid json for refinery options for group _group_24_9/source 24 = {
"relationshipType": "part_of",
“collectionType": ”^38”,
"matchOn": ["idno"]
}

Should I have an entry for col 38 like SKIP | 38 in the mapper, or not?

monica

Tryg
If column 38 holds the collectionType value, then you don't need to tell it to skip that column, just don't map that column at all (except here in the refinery).

Is it only giving this error when your collectionType field is empty? If so you will need to set a default with collectionTypeDefault to a constant value.

However this error is saying your JSON is invalid. While you haven't shared it here in a code box, so it messes the formatting up a bit, I can see next to collectionType you have a smartquote, which is different from the other quotes, this is probably causing it (might be smartquotes around ^38 too)

You will want:
{ "relationshipType": "part_of", "collectionType": "^38", "collectionTypeDefault": "series", "matchOn": ["idno"] }

Tryg

Sharp eyes!! thank you...