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

aadeshere1
I have a another noob question about loop. Since elixir is immutable, while loop is not directly possible. total = 10 while total != 0 ...
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
shahryarjb
Hello, I get Persian date from my client and convert it to normal calendar like this: def jalali_string_to_miladi_english_number(persi...
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
baxterw3b
Hi guys, i’m new in the Elixir world, and i have to say, that i love it! i’m having some problem to understand anonymous functions with ...
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
JDanielMartinez
Hi! May someone helps me, please! I have two apps into an umbrella project: the first one is Database, which manages queries, and the se...
New
dblack
I’ve got an issue with an app and I’ve no idea of how to troubleshoot it. I’m hoping someone here might have seen something similar. I p...
New
hariharasudhan94
I would like to know what is the best IDE for elixir development?
New
WestKeys
Currently suffering from paralysis by [HTTP client] analysis. This is rather unusual in Elixirland as there tends to be consensus on the ...
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
johnnyicon
Hi all, I’ve just started learning Elixir and Phoenix Framework, so please pardon my n00bness at this stage. I’m trying to use Postgres...
New
shahryarjb
Hello, I have map which I want to convert it to string like this: the map: %{last_name: "tavakkoli", name: "shahryar"} the string I ne...
New
josevalim
Hi everyone, One of the features added to Elixir early on to help integration with Erlang code was the idea of overridable function defi...
New
hariharasudhan94
lets say i have a sample like a = 20; b = 10; if (a > b) do {:ok, "a"} end if (a < b) do {:ok, b} end if (a == b) do {:ok, "equa...
New
aesmail
Hello guys, I have finally made it. I created an admin interface for a framework. It’s been on my todo list for years and with the curre...
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
freewebwithme
Using vs code and installed ElixirLS: support and debugger. And I got an error popped up on start up says Failed to run ‘elixir’ comma...
New
WestKeys
Currently suffering from paralysis by [HTTP client] analysis. This is rather unusual in Elixirland as there tends to be consensus on the ...
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

We're in Beta

About us Mission Statement