Version :- Denodo 8.0
i want to use rest api url as one data source, for which i configured it as
Now we dont have instance ID this will be fulfilled from another data source which is base view of oracle DB.
In oracle DB we have two fields like instance name (label) and instance ID for it.Now user will only provide instance name(label) in rest api we exposed and with help of this label(instance name) we will hit base view which is oracle base view and will fetch instance id.
This Instance Id we want to act as response for variable available in above datasource url.
This will allow to get the data of label from two different datasources,when label(instance name) will be provided.
We are unable to integrate this scenario, could you please suggest steps