Thanks for your complete and reproduceable question. I tried using the OData Reader and FeatureReader.
The FeatureReader has the Where Clause greyed out, so I suspect a filter is not implemented. Could not find a filter option in the Reader either.
The raw response is XML, so a workaround is to use a HTTPCaller and use that to do the request, then parse the response body using the XMLFragmenter.
The filter syntax is explained here, but I have not got it working with your dataset so far.
I've struggled a lot with the CBS API's and their lack of good documentation. Here's a url that works for me:
https://opendata.cbs.nl/ODataApi/odata/70072ned/UntypedDataSet?$filter=RegioS eq 'GM1709'
So it appears to be the ' around the value that does the trick.
Thanks for your complete and reproduceable question. I tried using the OData Reader and FeatureReader.
The FeatureReader has the Where Clause greyed out, so I suspect a filter is not implemented. Could not find a filter option in the Reader either.
The raw response is XML, so a workaround is to use a HTTPCaller and use that to do the request, then parse the response body using the XMLFragmenter.
The filter syntax is explained here, but I have not got it working with your dataset so far.
Attached sample workspace using a HTTPCaller.
I've struggled a lot with the CBS API's and their lack of good documentation. Here's a url that works for me:
https://opendata.cbs.nl/ODataApi/odata/70072ned/UntypedDataSet?$filter=RegioS eq 'GM1709'
So it appears to be the ' around the value that does the trick.
Hello,
Thank you but when I paste your URL I can't select a Feature Type to read.
I've tried the default reader and also the feature reader.
What could me wrong?
Hello,
Thank you but when I paste your URL I can't select a Feature Type to read.
I've tried the default reader and also the feature reader.
What could me wrong?
Don't use the OData reader, use a HTTPCaller instead and work with the _response_body attribtue. That's formatted as JSON so you'll need a JSONFragmenter / JSONFlattener to pull it apart.
Thanks for your complete and reproduceable question. I tried using the OData Reader and FeatureReader.
The FeatureReader has the Where Clause greyed out, so I suspect a filter is not implemented. Could not find a filter option in the Reader either.
The raw response is XML, so a workaround is to use a HTTPCaller and use that to do the request, then parse the response body using the XMLFragmenter.
The filter syntax is explained here, but I have not got it working with your dataset so far.
Thank you Niels, I will give it a try. (Never used the httpcaller before.) I will let you know if I succeed ;-)
Hello,
Thank you but when I paste your URL I can't select a Feature Type to read.
I've tried the default reader and also the feature reader.
What could me wrong?
Thank you. I will give it a try. Weird though that the default Reader can't handle filters.
Attached sample workspace using a HTTPCaller.
Wow Niels, your 2 example flows are great and both work!
The first one (feature reader) seems the easy one and has my preference.
The second one with the HTTPCaller also works but seems more complex. This one probably is faster but I don't need a lot of data.
So the trick is to start the flow with a Initiate Creator. I never used this before.
Thx again!
Cheers Richard