Hi I'd like a way to dynamically change the URL connector string. This is an example:
LIB CONNECT TO 'StarWarsREST';
LET extension = "/people";
FROM "results" PK "__KEY_results" FK "__FK_results")
FROM JSON (wrap on) "root"
WITH CONNECTION (
LOAD [name] AS [name],
[created] AS [created]
WHERE NOT IsNull([__FK_results]);
DROP TABLE RestConnectorMasterTable;
'StarWarsREST' has the URL http://swapi.co/api and I want to make a connection to http://swapi.co/api/people. When I run this script to load data, if finishes without failure, but does not load any data. This is just an example. The ultimate goal is to change the extension variable in a nodejs script based on user input.