Should work. You may end up having conflicts with the (many) quotes enclosing the different parts. Does it work if you replace the outer double quotes with square brackets? Like in
LET vToken = 'a3122423421f'; // Use single quotes
CUSTOM CONNECT TO [Provider=QVRestConnector.exe;url="blablabla"...];
so this really is an issue, also for me
LET vAPIKey = 'XYZ';
CUSTOM CONNECT TO "Provider=QvRestConnector.exe;
this doesnt work but if I paste the key directly into the Connectionstring it works. But I need variables for dynamic requests.
it seems like variables do not get proper resolved in the connection string. Anyone an idea why ? this only seems to affect the REST connector.
If it is not any query parameter but a query header a possible workaround I found is using
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION (
HTTPHEADER "Authorization" "Bearer $(vAccessToken)"
So adding the header to the JSON load instead of the Connectionstring but this seems to only work with complex request headers and doesn't work with pagination so it is very limited