pankaj-ag

pankaj-ag

Hello

Let me define the problem first.

I have a jsonb database column called results in my Postgres DB. When I save a value (i.e 12\25) it saves like that in the DB.

{"attri": {"input": "12\\25"}}

Now I have a JSON string

"{ "custom_key": "@attri.input"}"

When I replace the above map values in this string I got the following results.

"{\"custom_key\": \"12\\25\"}"

All this is good and working as expected but when I try to decode this string into JSON

Like this Jason.decode("{\"custom_key\": \"12\\25\"}") it gives me an error.

I also try to escape the value before replacing it in string and in that case, it gives me the following results.

"{ \"custom_key\": \"\"12\\\\25\"\"}"

And I am not able to parse this string into JSON as well.

Please let me know in case I am missing something here or you need any other clarification on the problem.

Showing Posts 1 to 1

al2o3cr

al2o3cr

Forum tip: telling the reader “it gives me an error” is vastly less helpful than showing the reader the output of trying that:

iex(1)> Jason.decode("{\"custom_key\": \"12\\25\"}")
{:error,
 %Jason.DecodeError{
   data: "{\"custom_key\": \"12\\25\"}",
   position: 19,
   token: nil
 }}

Printing the string involved makes it clearer what’s going on:

iex(2)> s = "{\"custom_key\": \"12\\25\"}"          
"{\"custom_key\": \"12\\25\"}"
iex(3)> IO.puts s
{"custom_key": "12\25"}
:ok

So the JSON parser complains about the lone \ in the input.

In your second example, this happens:

iex(4)> s = "{ \"custom_key\": \"\"12\\\\25\"\"}"
"{ \"custom_key\": \"\"12\\\\25\"\"}"
iex(5)> Jason.decode(s)
{:error,
 %Jason.DecodeError{
   data: "{ \"custom_key\": \"\"12\\\\25\"\"}",
   position: 18,
   token: nil
 }}
iex(6)> IO.puts s
{ "custom_key": ""12\\25""}
:ok

Now the extra "s around 12\\25 throw the whole thing off.

My advice: don’t try to replace values in JSON by string-replacing the whole thing - parse the JSON, do the replacements there, then re-encode.

— All posts loaded —

Where Next? Top

Trending in Questions Top

RSP87
I’m working on a project that simulates the bumbl example in the programming phoenix book. It acts almost like an email client. We have a...
New
kszambelanczyk
Hello! Could someone please give me a help/sample code, how to delete a file from s3 using waffle/waffle_ecto from Phoenix app. I creat...
New
RemyXRenard
I’m seeing that a list inside a Kino.DataTable will be interpreted as a charlist, even if the Kino.configure() is set to charlists: :as_l...
New
velrest
So my question is quite simple and i have found no conclusive answer on forum, google or AI. Should we use :erlang.float for Integer to ...
New
samoloth
Hi, I’ve just set up an application with ash_authentication. There is only magic link strategy for now, so there is no confirmation add o...
New
FlyingNoodle
If a change or preparation module uses Ash.Changeset.get_argument/2 or Ash.Query.get_argument/2 (or any of the other get_argument functio...
New
psy-q
I’m trying to set up Emacs with elixir-ls via lsp-mode and credo via Flycheck. This should mostly be preconfigured as Flycheck picks up c...
New

Other Trending Topics Top

mudasobwa
I am happy to introduce the very α version of the new programming language compiled to BEAM. Welcome Cure. It has literally three kille...
New
garrison
Hobbes is a low-level distributed database for the Elixir programming language. Hobbes provides a simple, safe, and scalable storage lay...
New
marciok
Hi there! We created Gust: A task orchestrator inspired by Airflow. For those who have never heard about Aiflow, it’s a Python-based wor...
New
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
Dmk
Xamal is a deployment tool for Elixir apps that deploys native releases to bare metal servers over SSH. It’s a port of GitHub - basecamp/...
New
Damirados
Hello everyone. After busy few months I am happy to announce v0.1.0 of Emerge & Solve. They are GUI (Emerge) and State management (S...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews