DSS API - Filter data

Options
Maurip00
Maurip00 Registered Posts: 5 ✭✭✭

I am using curl to get data from a dataset via REST service and API following the documentation found here:
https://doc.dataiku.com/dss/api/9.0/rest/#datasets-dataset-data-get

filterstring (optional) Example: mycol1 > 0 && mycol3 > 0

Formula to select only a subset of rows based on a boolean expression

when I try to filter the data I cannot apply the boolean "and" condition with && syntax; the answer I get doesn't take into account the filter after && (instead with "or", using ||, no problem).
With this request:

$url = "https://my-site/public/api/projects/my-project/datasets/my-dataset/data?format=json&filter=val('Status')=='WK'&&val('Order')=='22416'&columns=Order,Status"curl.exe --user my-api: -H "Content-Type: application/json" -X GET $url

I get this response:

[["22417","WK"],["22522","WK"],["22853","WK"]...

What am I doing wrong?

Best Answer

Answers

Setup Info
    Tags
      Help me…