Trouble using flow variables in JSON Path node
Hi everyone,
I’m having a hard time using flow variables in the JSON Path node. I define the flow variables just before using a Column Expression node, but when I try to configure the JSON Path node with these variables, I get the following error:
Errors loading flow variables into node : Invalid return type: [String, String]
To illustrate, I’m sharing a small example workflow. It doesn’t have any real-world meaning, but the idea is to automate the extraction of information from a JSON using JSON Path, and to determine the path dynamically using a loop and the current iteration number.
I’m not sure if the variables need to be converted to arrays or handled differently, and I haven’t been able to figure it out yet.
I came across the Weekend Challenge post https://community.knime.com/c/ask-the-community/weekend-challenge-parse-json-using-variables about parsing JSON using variables and found the discussion very useful. In particular, I wanted to mention @ArjenEX and @gonhaddock , who shared insights and solutions in that thread.
I’m trying to follow the approach of controlling almost all fields with flow variables, as suggested in that challenge, but I’m still stuck at this step.
If anyone could guide me on how to properly format or convert flow variables for use in the JSON Path node, it would be really helpful!
Thanks in advance!