Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good evening,
I don't know if it's a bug or I'm doing something wrong.
When I'm setting the URL parameter in a WITH CONNECTION no Data is returned, except the Key
i.e. working:
RestConnectorMasterTable:
SQL SELECT
id,
name,
creationDate
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION (
QUERY "authorization" "Bearer",
QUERY "access_token" "$(vTOKEN)"
);
i.e. not working
RestConnectorMasterTable:
SQL SELECT
id,
name,
creationDate
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION (
URL "https://staging.exampleurl.de/v1/organizations/589b07b21d4530f2987cfd70",
QUERY "authorization" "Bearer",
QUERY "access_token" "$(vTOKEN)"
);
Can you give me some suggestions about what i'm doing wrong?
Thx a lot and greeting.
Wolf
also other approaches to retrieve data from several REST endpoint from one server will be appreciated
Hi there,
solved. It seem that, not like written in the Documentation, the REST Connector resets complety (not overwriting just the parameter) after setting the new URL. So it was necessary to set all other Query Parameters again to get it working.
RestConnectorMasterTable:
SQL SELECT
id,
name,
creationDate
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION (
URL "https://staging.exampleurl.de/v1/organizations/589b07b21d4530f2987cfd70",
QUERY "authorization" "Bearer",
QUERY "access_token" "$(vTOKEN)"
QUERY "other" "oldValue"
);