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

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 https://github.com/devinus/poison, 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.

ltgaxkeh

ltgaxkeh

Forgive me :no_mouth: I’m still a beginner in Elixir and MVC. I’m more of an OOP peep (.NET to be exact) :joy: Perhaps, I’m having difficulty understanding but I’m willing to learn.

Anyway, a big thanks for the response and effort.

Is there an approach for a concern like this where a beginner like me can understand?

sribe

sribe

Just tell us whether our responses made sense to you, and if not, try your best to explain your thinking so we can take another try :slight_smile:

Where Next?

Popular in Questions Top

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
vonH
In asking this question I am more interested about the expressiveness of the language itself and less concerned about the availability of...
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
minhajuddin
I have seen a lot of code which picks the first element from a list using Enum.at(0) instead of List.first. Is there a reason why people ...
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
fireproofsocks
Forgive me if this is obvious, but how does one delete a database record WITHOUT selecting it first? https://hexdocs.pm/ecto/Ecto.Repo.h...
New
ovidiubadita
Hey all, I discovered Elixir and I love it. I always wanted to learn a functional programming and I intended to go for Haskell, but afte...
New
Qqwy
Original source of discussion: This topic on the Pragmatic Programmers' Functional Web Development with Elixir, OTP, and Phoenix forum. ...
New
skosch
To my knowledge, put_in, Map.update etc. all have the one limitation of not automatically creating intermediate keys when needed (for exa...
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

Other popular topics Top

sergio
In Ruby, I can go: User.find_by(email: "foobar@email.com").update(email: "hello@email.com") How can I do something similar in Elixir? ...
New
_russellb
I want to try my hand at web scraping. What tools/libraries do I need to use. I’m hoping to turn this into something professional so don’...
New
jononomo
I am trying to figure out how Mix knows whether the environment is test, dev, or prod -- where is this set? Thanks.
New
Jim
As a follow up to my earlier question: I have the code compiling and running but not getting a successful login from the rest server. ...
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
mgjohns61585
Could someone help me? I'm making my first elixir program, number guessing game. I can't figure out how to convert the user's guess from ...
New
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
belgoros
I’m not a pro in using Regex and can’t figure out why the following behaviour happens, especially if we take into account the difference ...
New
romenigld
I am trying to run a deploy with docker and I successfully runned with this command: docker build -t romenigld/blog-prod . but when I t...
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

We're in Beta

About us Mission Statement