I have this curl. curl -H "Content-Type: application/json" -X POST -d '{"file_server": {"method": "api/file", "parameter": [{"filepath":"tehnnhjhst", "FileBase64String":"test"}]}}' http://localhost:4000/api/some_method But I got this JSON response: {"errors":{"parameter":["is invalid"]}} This is…

You’ve defined :parameter as a :string but you’re passing an array, as you state. I would expect there to be an error. Are you using changesets for your model? They help validate your datatypes with some nice error messages.

Yes im using changesets to my model. def changeset(struct, params \\ %{}) do struct |> cast(params, [:method, :parameter]) |> validate_required([:method, :parameter]) end So array in :string (varchar(255), utf8_general_ci in my MySql database) is not allowed? [image]

I’m confused. An array is not a string. You should get an error message.

Thanks for your reply. So there is no way to handle array?

Yes, but I don’t know if MySQL handles array data types. [Josh Petitt] How to store array with Ecto using Postgres postgresql, phoenix-framework, ecto asked by Josh Petitt on 01:08PM - 11 Oct 15 UTC

Thank you for your reply. I just wanted to store the “parameter” as a plain text to my database (Ignoring that it is an array).

Then send it as string. Or maybe hook into the json decode and make it a string there. I’m not sure if that one works though.

I just hook it in JSON encode. params = Map.put(params, "parameter", Poison.encode!(params["parameter"])

Elixir Programming Language Forum

Invalid paremeter when passing an array

Questions & Help Questions

wfgilman March 27, 2017, 3:19am 6

Yes, but I don’t know if MySQL handles array data types.