Hi,
i’m testing this: https://github.com/o1lab/xmysql
It provides a REST API for mysql, i have a lot of use case with lookup tables but i can’t make it work…
My guess is that lookup tables dont like the output with [ ]
Example of an output:
Hi @jochen
Yes of course, i’m trying to use a HTTP JSONPath data adapter. And i’m just trying the lookup with the test feature.
My xmysql Rest API give me something like this (it works well) :
And i dont know how to configure in the data adapter the Multi value JSONPath and Single value JSONPath ? everything i try did not work.
And i assumed that it is because of the “” that my REST API ?
I’ve just configured a data adapter with the JSON output you provided (simply put it into a static file, including the array) and it works as expected:
The key is to unwrap the array using JSONPath. My config assumes that there’s only a single element in the list.
If you use the multi value in pipeline rules, you should also be able to simply index the result value with [0] or so, For extractors/converters you will need to unwrap the array into a map, though.