I'm trying to use variables in a load statement (so I can loop) bu have found something very strange.
The load is using a google sheet connector, syntax is:
LOAD
*
FROM
[http://localhost:5555/data?connectorID=GoogleDriveConnector&table=ListWorksheets&encrypted_refresh_t... information here**&spreadsheetKey=**key here**&appID=]
(qvx);
When I try to use a variable for the key, I seem to get an extra ampersand added in at the start of the key,
Let vKey = '**spreadsheet key**';
LOAD
*
FROM
[http://localhost:5555/data?connectorID=GoogleDriveConnector&table=ListWorksheets&encrypted_refresh_t... information here**&spreadsheetKey=$(vKey)&appID=]
(qvx);
resolves to
Let vKey = '**spreadsheet key**';
LOAD
*
FROM
[http://localhost:5555/data?connectorID=GoogleDriveConnector&table=ListWorksheets&encrypted_refresh_t... information here**&spreadsheetKey=&**spreadsheet key**&appID=]
(qvx);
If I take out the ampersand prior it doesn't get added in, but obviously still won't work. I've tried adding that in via its own variable or with the token information, but it always still adds in the character in red above. I haven't a clue why this is doing what it is, let alone how to solve for it.