scottklement.com

Posted: **Tue Aug 10, 2021 7:25 pm**

I am reading JSON using YAJL_BUF_LOAD_TREE to load the JSON and then read the data using YALJ_GET_STRING/NUMBER.

But when loading the JSON data which is having either NULL/blanks values, it is erroring out with a error message
"lexical error: invalid char in json text"

Code: Select all

{"data":{
"trdate6":null,
"trdate7":null,
"trdate9":null,
"arvtime2":"09/10/2021",
"morestop2":"Yes"}}

Code: Select all

docNode = yajl_buf_load_tree(%Addr(PLPAYLOD):
            %len(%trim(PLPAYLOD)):ErrMsg);

Is there a way to handling it?

Posted: **Tue Aug 10, 2021 7:46 pm**

This is an invalid JSON document. If unsure, you can use the website https://jsonlint.com/ to check your document and see if it's valid.

It's not valid to have a json element with no value like this: "trdate9": ,

You would need to change that to: "trdate9": null,

Posted: **Tue Aug 10, 2021 7:52 pm**

It was typing error it is coming with NULL in field.. but when i check in debug mode it showing blanks.. and the it gives me that error

Posted: **Tue Aug 10, 2021 8:06 pm**

Found the issue.. Before it actual goes to YAJL_LOAD* , a procedure is called to remove the null that's why it is failing. Fixed it and now it working!!

Thanks!!

scottklement.com

YAJL_BUF_LOAD_TREE Handling Null Values

YAJL_BUF_LOAD_TREE Handling Null Values

Re: YAJL_BUF_LOAD_TREE Handling Null Values

Re: YAJL_BUF_LOAD_TREE Handling Null Values

Re: YAJL_BUF_LOAD_TREE Handling Null Values