UCAST and mapping options

[KRTone]

Is here any example or option to use Mapping Table and Column Names with UCAST?

relate to: https://github.com/orgs/open-policy-agent/discussions/726

[srenatus]

Yes, the same options are available, but with different keys. To follow along with the example from the docs:

With req.json:

{
  "input": {
    "favorite": "pineapple"
  },
  "options": {
    "targetSQLTableMappings": {
      "ucast": {
        "fruits": {
          "$self": "fruit",
          "name": "display_name",
          "price": "price_tag"
        },
        "price": {
          "$table": "fruits"
        }
      }
    }
  }
}

And this API call, curl http://127.0.0.1:8181/v1/compile/filters/include -d @req.json -H "Accept: application/vnd.opa.ucast.linq+json", we'll get the response:

{
  "result": {
    "query": {
      "operator": "or",
      "type": "compound",
      "value": [
        {
          "field": "fruit.display_name",
          "operator": "eq",
          "type": "field",
          "value": "pineapple"
        },
        {
          "field": "fruit.price_tag",
          "operator": "eq",
          "type": "field",
          "value": "free"
        }
      ]
    }
  }
}

[KRTone]

1 ) nice! .. gone to play with
2) but with different keys - I missed this in the documentation or it is not in the documentation?

[srenatus]

Yeah that seems to be missing in the docs. Sorry about that!