I am not able to encode values which I am getting from Ecto query result Poison encode method
Controller code:
def companies(conn, params) do
companies = Repo.all(
from(
c in Company,
select: {c.name, c.uid},
limit: 20
)
)
conn
|> put_resp_header("content-type", "application/json; charset=utf-8")
|> send_resp(200, Poison.encode!(companies, pretty: true))
end
Template code :
<div class="form-group row">
<%= label f, :company_id, class: "control-label" %>
<%= select f, :company_id, @companies, class: "form-control"%>
<%= error_tag f, :company_id %>
Error message:
Request: GET /companies
** (exit) an exception was raised:
** (Poison.EncodeError) unable to encode value: {"Loews Corporation", 1000285930}
(poison) lib/poison/encoder.ex:383: Poison.Encoder.Any.encode/2
(poison) lib/poison/encoder.ex:268: anonymous fn/4 in Poison.Encoder.List.encode/3
(poison) lib/poison/encoder.ex:269: Poison.Encoder.List."-encode/3-lists^foldr/2-0-"/3
(poison) lib/poison/encoder.ex:269: Poison.Encoder.List.encode/3
(poison) lib/poison.ex:41: Poison.encode!/2
Tuples can't be encoded to JSON values by Poison. If you want [{name: ..., uid: ...}, {name: ..., uid: ...}]
in the resulting JSON, you can use map()
or a map literal in select
in the query:
select: map(c, [:name, :uid])
or
select: %{name: c.name, uid: c.uid}