Possibility of restricting the list of possible values ​​in an "array" type field

[roll]

Overview

There is an issue for the specs that can be supported in advance in Frictionless-py as it's blocking for french open data task force Etalab (cc @lwinfree)

frictionlessdata/specs#712

[roll]

Prioritizing this one to unblock Etalab cc @lwinfree

[roll]

Hi @johanricher,

Could you please try with frictionless@4.1:

from pprint import pprint
from frictionless import Resource, Schema, Field

field = Field(name="key", type="array", array_item={"constraints": {"enum": ["a", "b"]}})
resource = Resource([["key"], [["a"]], [["b"]], [["c"]]], schema=Schema(fields=[field]))
pprint(resource.read_rows())

[roll]

Here is details - frictionlessdata/specs#409 (comment)

[geoffreyaldebert]

Hello @roll
First of all, thanks for your answer and proposition. Indeed, the solution works on python.

But the command line does not seems to work properly when we try to validate a file.

Example of schema :

...
   "fields":[
      {
         "name":"array_field",
         "title":"Array field",
         "description":"Array field description",
         "type":"array",
         "example":"",
         "array_item":{
            "constraints": {
               "enum": ["a", "b"]
            }
         }
      }
   ]
...

Example of csv file :

array_field
"[""a""]"
"[""a"",""b""]"
"[""a"",""b"",""c""]"
"[""c""]"

Value c is not in the enum list however when I execute frictionless validate --schema schema.json exemple-valide.csv the output message does not mention any error :

You have the repo for test here : https://github.com/geoffreyaldebert/schema-test

Any idea why this is working on python but not with CLI ?

Thanks for your help !

Geoffrey

cc @johanricher

[geoffreyaldebert]

@roll sorry for my latest message, I found the answer.

Property array_item was not good (it was arrayItem). With this new implementation, it works fine.

Thanks you can keep this issue closed !

cc @johanricher

[johanricher]

Great news @geoffreyaldebert! Thank you so much @roll, we really appreciate it. 👍

[roll]

Great! Thanks.

Please create an issue if you run into any troubles using it