InfluxQLQueryApiImpl cannot cast JsonNull

[leonardo-belotti-aiknow]

Hi,
I'm trying to use queryJSON method of InfluxQLQueryApi.
If I have null values resulting from my query, the library fires an exception because of the cast forced to String.

As we can see from line 337 of the class:

JsonArray jvals = sobj.get("values").getAsJsonArray();
                    if (jvals != null) {
                        for(JsonElement jval : jvals) {
                            List<Object> values = new ArrayList();
                            JsonArray jae = jval.getAsJsonArray();
                            int index = 0;

                            for(JsonElement je : jae) {
                                List<String> columnKeys = new ArrayList(serie.getColumns().keySet());
                                if (this.extractor != null) {
                                    String stringVal = je.getAsString();
                                    Object ov = this.extractor.extractValue((String)columnKeys.get(index), stringVal, id, serie.getName());
                                    values.add(ov);
                                } else {
                                    values.add(je.getAsString());
                                }

                                ++index;
                            }

                            Objects.requireNonNull(serie);
                            serie.addRecord(new InfluxQLQueryResult.Series.Record(serie, values.toArray()));
                        }
                    }

When it gets the null value, the instruction String stringVal = je.getAsString(); fires the exception.

Am I doing something wrong?

[NguyenHoangSon96]

HI @leonardo-belotti-aiknow
Can you capture the exception? I need more info
Any chance that the null is the "je" 🤔

[leonardo-belotti-aiknow]

Hi @NguyenHoangSon96
sorry for late reply.

Confirming je contains "null", the exception is:

java.lang.UnsupportedOperationException: JsonNull

But how can I manage "null" values occurrences?

[NguyenHoangSon96]

Hi @NguyenHoangSon96 sorry for late reply.

Confirming je contains "null", the exception is:

java.lang.UnsupportedOperationException: JsonNull

But how can I manage "null" values occurrences?

HI @leonardo-belotti-aiknow
No problem
Regarding of this issue
I don't think it comes from the influx client library
Maybe you should check null for "je" variable or something 🤷‍♂️
A full stack trace error capture will be helpful