JsonPathOnUrl "Values" works, "Formula" not

Hi everyone,

I've got a problem using the JsonPathOnUrl function (SeoTools

I would like to call the Wincher api (seo tool for keyword monitoring). There is an authentication via http header (Bearer token) needed.

This works fine while I'm using the JsonPathOnUrl function inserting the answer as values.

When I swich to "formula" I get the following error message.

Exception: JsonReaderException Message: Error reading JToken from JsonReader. Path ",line 0, position 0.

Can anyone help me?

Thanks a lot and best regards


This sounds a bit complicated to solve on this forum. Can you email me the workbook and preferably the authentication details so I can debug?