RDMS API: Metadata search is not working

eirik.torhaug1

I am doing the following query to the RDMS API:

query='Variable.is=Consumption+Dataset.In.is=ECMWF.Ens Weekly Long Term&MaxResults=10000'

result = requests.get('https://sprod1.rdms.refinitiv.com/api/v1/Metadata/Search?query='+query, headers=headers, verify=True)

values = result.json()

It returns other variables than consumption, like wind etc, meaning the + operator does not filter as I want to. How can I return only consumption curves?

billy.dineen

Hello,

The cause of this is that the + operator does not operate within this query parameter as you expect.

In order to achieve the results you are looking for please include double quotes around consumption.

Such as:

Variable.is="Consumption"+Dataset.In.is=ECMWF.Ens Weekly Long Term

This will return CurveIDs where Variable.is is exactly equal to consumption.

I have included a help guide which will explain the syntax for the query string parameter

Please let me know if you have any further questions.

Thanks

Billy

billy.dineen

Hi,

We have picked up this question and we will get back to you with an answer shortly.

Thanks

eirik.torhaug1

Thanks, now I only get consumption curves! But how do I get curves with Variable.is="Consumption" AND Dataset.In.is=ECMWF.Ens Weekly Long Term? This query does not work, as it returns also GFS curves f.ex:

query='+Variable.is="Consumption"+Dataset.In.is="ECMWF.Ens Weekly Long Term"&MaxResults=10000'

raksina.samasiri

https://community.developers.refinitiv.com/discussion/comment/121043#Comment_121043

Hi @billy.dineen ,

Could you please check the follow-up questions.

Thanks,
AHS

billy.dineen

Hi,

Unfortunately I am unable to recreate this issue, when I use the following I get the expected run of results:

query='+Variable.is="Consumption"+Dataset.In.is="ECMWF.Ens Weekly Long Term"'

My only suggestion would be to ensure that the "+" symbols are being URL encoded within your REST API call.

So the corrected query would be:

query='%2BVariable.is="Consumption"%2BDataset.In.is="ECMWF.Ens Weekly Long Term"'

Thanks

Billy