Dear All.
I am facing the following issue trying to bring in data to Graylog via GELF TCP Input.
If the data contains json-related characters, like { " } : , call these X,
then the record loading will fail.
For example, a field named SQL_TEXT, containing text like below, will fail:
AAA { “bbb”:“cccc cccc” dd } ee , ff AAA
How can I escape a certain X character before I bring it for input?
I tried with:
slash, double slash, slash and “n”, before and after X, but record doesn’t load again.
for example, for the field above, the JSON X-chars were escaped with a double slash before, as below:
"_SQL_TEXT":"AAA \\{ \\"bbb\\"\\:\\"cccc cccc\\" dd \\} ee \\, ff AAA"
can you please advise?
best regards
Altin
PS. escape I have done inside jSON _MYFIELD - where json-related chars are expected.
Then the Json syntax brings all fields together to make the record string to be send.