DSS API - Filter data

Maurip00 Registered Posts: 5 ✭✭✭

I am using curl to get data from a dataset via REST service and API following the documentation found here:

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:


What am I doing wrong?

Best Answer


Setup Info
      Help me…