ltgaxkeh

ltgaxkeh

How to map multi level json

Hi again! How do I map a multi level json (response after HTTPoison.get)

Here’s my json:

  [
      {
        "Payor": "ASMSI",
        "RevenueSource": "NEW MEMBER",
        "DateCreated": "2/1/2018 12:33:30 AM",
        "InvoiceDetails": [
          {
            "TransactionDetails": "Dependent",
            "TransCount": "45.00",
            "Rate": "112",
            "Total": "5040",
            "Vat": "0.00",
            "Vatable": "N",
            "TotalAmount": "5040"
          },
          {
            "TransactionDetails": "Extended Dependent",
            "TransCount": "8.00",
            "Rate": "112",
            "Total": "896",
            "Vat": "0.00",
            "Vatable": "N",
            "TotalAmount": "896"
          },
          {
            "TransactionDetails": "Principal",
            "TransCount": "22.00",
            "Rate": "560",

So far I only got this idea from my controller:

%{"InvoiceDetails" => invoicedetails} = Poison.decode!(response.body)

Most Liked Responses

idi527

idi527

Map to what exactly, what shape of data do you want? If you want to decode a json object into an elixir map, you can use a json decoder, there are several.

The most popular is probably GitHub - devinus/poison: An incredibly fast, pure Elixir JSON library · GitHub, with it your code would be like this:

resp = HTTPoison.get!(url)
json = Poison.decode!(resp)

Here, json is an elixir term, probably a map. So you’d be able to use it to populate your table.

Eiji

Eiji

You can’t do that directly, because you have list there. I will give you 4 example ways to achieve what you need:

  1. Get first item using List.first/1 or last item using List.last/1
  2. Get by specified index using Enum.at/2
  3. Iterate over list and do something for every item in it using Enum.each/2 or Enum.map/2 (depends on what you need).
  4. Find element which is interesting for you by using Enum.find/2

For example:

list = Poison.decode!(response.body)
first_item = List.first(list)
last_item = List.last(list)
n = 10
nth_item = Enum.at(list, n) # where n is integer
found_item = Enum.find(list, & &1["Payor"] == "ASMSI")

# Then you can fetch specified data as you wanted:
%{"InvoiceDetails" => invoicedetails} = first_item
%{"InvoiceDetails" => invoicedetails} = last_item
%{"InvoiceDetails" => invoicedetails} = nth_item
%{"InvoiceDetails" => invoicedetails} = found_item

# Or do something for every item in list

defmodule Example do
  def sample_each(list), do: Enum.each(list, &do_sample_each/1)

  defp do_sample_each(%{"InvoiceDetails" => invoicedetails}), do: IO.inspect(invoicedetails)

  def sample_map(list), do: Enum.map(list, &do_sample_map/1)

  defp do_sample_map(%{"InvoiceDetails" => invoicedetails}), do: invoicedetails
end

:ok = Example.sample_each(list) # debugs "InvoiceDetails" for every item
invoicedetails_list = Example.sample_map(list) # returns list of invoicedetails
sribe

sribe

I think it’s both. He’s struggling with creating an impossible pattern match in order to support an unworkable template structure.

Where Next?

Popular in Questions Top

myronmarston
The Elixir Typespec docs show the following syntax for keyword lists in typespecs: # ... | [key: type] # keyword lists...
New
electic
Hi, I am new to Elixir. I am trying to use the DateTime component to insert a date into MySQL however the there seems to be no way to fo...
New
tduccuong
Hi, is there any work on GUI with Elixir, that is similar to Electron/Javascript? My idea is to bundle Phoenix and BEAM into a single se...
New
earth10
Hi, I’m just starting to build a side-project with Elixir and Phoenix and doing some basic test with Elixir alone. What strikes me is th...
New
Lily
In templates/appointment/index.html.eex: <%= for appointment <- @appointments do %> <tr> <td><%= appoi...
New
RisingFromAshes
I’ve read in another post that it may be possible with a router helper - but I couldn’t find an appropriate one, and tbh, I’m still just ...
New
bsollish-terakeet
Credo is smart enough to check for (something like) this: assert length(the_list) == 0 with this response: Checking if an enum is empt...
New
shijith.k
I am trying to start a new phoenix project with elixir 1.9, but mix phx.new does not work. It says that ** (Mix) The task "phx.new" could...
New
joaquinalcerro
Hi there, I am working with Ecto-Postgresql and I need to call all of the records from a specific table but the table has 40,000 records...
New
PeterCarter
There are pre-rolled solutions for other frameworks that do work. However, Phoenix does not seem to have these. Have people had good expe...
New

Other popular topics Top

vertexbuffer
Hello, can anybody help here..? I have a list of players and I what to delete an element, but every for loop the list is reverting to ori...
New
siddhant3030
Hi, I have to write a raw query for one of my project. But till now I have used ecto queries and don’t have much experience writing raw ...
New
mcarvalho
What is the difference between System.get_env and Application.get_env? For example, what are best practices to use one versus another.
New
joeerl
Hello again - after a longish gap I’ve decided I really must dig into Elixir and see what’s been happening here - so I have a few questio...
New
stefanluptak
Hello everybody, usually, I use a 29" ultra-wide monitor for VSCode which can easily accomodate explorer (files panel) + file with code ...
New
KronicDeth
Elixir plugin for JetBrain’s IntelliJ Platform (including Rubymine) This is a plugin that adds support for Elixir to JetBrains IntelliJ...
289 36128 110
New
shijith.k
I am trying to start a new phoenix project with elixir 1.9, but mix phx.new does not work. It says that ** (Mix) The task "phx.new" could...
New
openscript
Hello! Sorry for this astonishing simple question, but I’m really stuck. I try to set up the intellij-elixir plugin, but I don’t know ho...
New
PeterCarter
There are pre-rolled solutions for other frameworks that do work. However, Phoenix does not seem to have these. Have people had good expe...
New
vonH
In asking this question I am more interested about the expressiveness of the language itself and less concerned about the availability of...
New

We're in Beta

About us Mission Statement