René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"_from_api_repr_scalar fails, if parameter value is None","articleBody":"Tested on latest (2.6.0) version, using python 3.8 on linux.\r\n\r\nIf `ArrayQueryParameter` contaning at least one `None` value is added to `query_parameters`, when using `job.query_parameters`  (result after submitting the job) `'NoneType' object has no attribute 'mode'` will be raised.\r\n\r\nThis is because:\r\n- `_from_api_repr_scalar` is called on `ArrayQueryParameter`\r\n- `_QUERY_PARAMS_FROM_JSON[array_type](value, None) for value in values`, the `value` is None\r\n- this corresponds to `_int_from_json(None, None)`\r\n- `_not_null(None, None)` is called\r\n- `return value is not None or field.mode != \"NULLABLE\"` raises exception\r\n\r\nStack trace:\r\n```\r\nAttributeError: 'NoneType' object has no attribute 'mode'\r\n  (snip)\r\n  File \"(snip)/site-packages/google/cloud/bigquery/job/query.py\", line 632, in query_parameters\r\n    return self._configuration.query_parameters\r\n  File \"(snip)/site-packages/google/cloud/bigquery/job/query.py\", line 314, in query_parameters\r\n    return _from_api_repr_query_parameters(prop)\r\n  File \"(snip)/site-packages/google/cloud/bigquery/job/query.py\", line 79, in _from_api_repr_query_parameters\r\n    return [_query_param_from_api_repr(mapping) for mapping in resource]\r\n  File \"(snip)/site-packages/google/cloud/bigquery/job/query.py\", line 79, in \u003clistcomp\u003e\r\n    return [_query_param_from_api_repr(mapping) for mapping in resource]\r\n  File \"(snip)/site-packages/google/cloud/bigquery/query.py\", line 632, in _query_param_from_api_repr\r\n    return klass.from_api_repr(resource)\r\n  File \"(snip)/site-packages/google/cloud/bigquery/query.py\", line 257, in from_api_repr\r\n    return cls._from_api_repr_scalar(resource)\r\n  File \"(snip)/site-packages/google/cloud/bigquery/query.py\", line 239, in _from_api_repr_scalar\r\n    converted = [\r\n  File \"(snip)/site-packages/google/cloud/bigquery/query.py\", line 240, in \u003clistcomp\u003e\r\n    _QUERY_PARAMS_FROM_JSON[array_type](value, None) for value in values\r\n  File \"(snip)/site-packages/google/cloud/bigquery/_helpers.py\", line 48, in _int_from_json\r\n    if _not_null(value, field):\r\n  File \"(snip)/site-packages/google/cloud/bigquery/_helpers.py\", line 43, in _not_null\r\n    return value is not None or field.mode != \"NULLABLE\"\r\n```\r\n","author":{"url":"https://github.com/peku33","@type":"Person","name":"peku33"},"datePublished":"2020-12-08T13:30:34.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/422/python-bigquery/issues/422"}