Automatic addition of ampersand in load (using variable)

Anonymous — Wed, 08 Aug 2018 06:00:37 GMT

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_token=**token 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_token=**token information here**&spreadsheetKey=$(vKey)&appID=]

(qvx);

resolves to

Let vKey = '**spreadsheet key**';

LOAD

FROM

[http://localhost:5555/data?connectorID=GoogleDriveConnector&table=ListWorksheets&encrypted_refresh_token=**token 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.

topic Automatic addition of ampersand in load (using variable) in App Development

Automatic addition of ampersand in load (using variable)