0

Using a Feed Importer with the JSONPath parser, I'm stumped as to how I can import the JSON objects as nodes with mapped fields. Here's the JSON that gets returned:

[
    [
        "Label",
        "Date",
        "Event ID",
        "Label",
        "Event Type",
        "Location"
    ],
    [
        "Law & Legal Services Networking Event",
        "Sep 05, 2019, 5:00 PM",
        "10f4fXXXXX45920b",
        "2019 Law & Legal Services Networking Event",
        "Career Fair",
        "Quinnipiak Club 221 Church Street"
    ],
    [
        "Advertising, Marketing & Management Networking Event",
        "Sep 05, 2019, 5:00 PM",
        "29fddXXXXX0af079f07",
        "2019 Advertising, Marketing & Management ",
        "Career Fair",
        "Quinnipiak Club 221 Church Street"
    ]
]

I've set my parser to use JSONPath (duh!) and the settings are as follows (as you can see, I'm just importing titles to test):

mapping parsing

When I test the JSON using an online JSONPath expression tester with this expression $[*][0], I seem to return what I want:

[
   "Label",
   "Law & Legal Services Networking Event",
   "Advertising, Marketing & Management Networking Event"
]

But when I run the importer, no nodes are created and the debugger reports:

debug1 debug2

What am I doing wrong here? How do I write my JSONPath expression to get to the bit that I want?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.