How to map multi level json

@ltgaxkeh What you need is just use for not for another variable, but for field from dataFirst:

<table>
  <%= for dataFirst <- @FirstLevelJson do %>
    <tr>
      <td><%= dataFirst["Payor"] %></td>
      <td><%= dataFirst["RevenueSource"] %></td>
      <td><%= dataFirst["DateCreated"] %></td>
    </tr>
    <tr>
      <table>
        <%= for dataSecond <- dataFirst["InvoiceDetails"] do %>
          <tr>
            <td><%= dataSecond["TransactionDetails"] %></td>
            <td><%= dataSecond["TransCount"] %></td>
            <td><%= dataSecond["Rate"] %></td>
            <td><%= data["Total"] %></td>
            <td><%= data["Vat"] %></td>
            <td><%= data["Vatable"] %></td>
            <td><%= data["TotalAmount"] %></td>
          </tr>
        <% end %>
      </table>
    </tr>
  <% end %>
</table>

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

Forgive me I’m still a beginner in Elixir and MVC. I’m more of an OOP peep (.NET to be exact) 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?

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

@sribe I think his problem is he cannot compose the Phoenix views that would make use of the nested JSON but I might be wrong.

Quit fighting against the structure you get, just use it instead, like:

data = Poison.decode!(...)

for dataFirst <- data

for dataSecond <- dataFirst["whatever"]

That’s assuming that the JSON you get is encoded nested the same as what you’re trying to display, something like:

[{"obj": {"details": {...}, ...}, ...]

(Regardless of how it’s structured, any pattern match that directly pulls out only a portion from decode cannot be what you want. You have to get it all.)

If there were only item, you can match nested stuff:

[%{obj: {details: mySecondLevel}} = myTopLevel]

But I don’t think that’s what you want.

Let’s say I have a template like this:

    <table>
    <%= for dataFirst <- @FirstLevelJson do %> #this is the first level of my json response (first for loop)
    <tr> #first table row which will be collapsed row which also contains my first level from my json
    <td><%= dataFirst["Payor"] %></td>
    <td><%= dataFirst["RevenueSource"] %></td>
    <td><%= dataFirst["DateCreated"] %></td>
    </tr>
<tr>
<table>
  <%= for dataSecond <- @SecondLevelJson do %> #this is the second level of my json response (second for-loop or the _InvoiceDetails_)
   <tr> #second table row which will be the expanded row which contains the second level (InvoiceDetails)
    <td><%= dataSecond["TransactionDetails"] %></td>
    <td><%= dataSecond["TransCount"] %></td>
    <td><%= dataSecond["Rate"] %></td>
    <td><%= data["Total"] %></td>
  <td><%= data["Vat"] %></td>
  <td><%= data["Vatable"] %></td>
  <td><%= data["TotalAmount"] %></td>
    </tr>
 <% end %>
</table>
</tr>
    <% end %>
    </table>

and on my controller:

%{"FirstLevelJson" => FirstLevelJson, "SecondLevelJson" => SecondLevelJson} = Poison.decode!(response.body) #I don't know if this is possible. That's why I'm asking for help if there's a way to pass this to my template
render(conn, "mytemplate.html", FirstLevelJson: FirstLevelJson, SecondLevelJson: SecondLevelJson)

Here’s what I’m trying to achieve:

image1221×435 18.7 KB

(picture from: https://www.jqueryscript.net/demo/jQuery-Plugin-For-Expandable-Bootstrap-Table-Rows/)

mymap = Poison.decode!(response.body)

In your example you’re extracting a single thing from what decode returns, and it sounds like you simply want the whole thing.

You should probably post the data as you visualize it in its final shape then. In other words, what do you expect to get from the json list you posted in OP?

Thank you for the effort. I greatly appreciate it and it serves as an additional knowledge for me. But it seems, my explanation is unclear. What I pursue is to be able to pass the first level of the json as well as the second level as values going through to my template and to be displayed on table. I visualize it like a double for loop in other language. So I’m gonna use all the data from my json response.

I’m planning to use the json data to a jquery datatable with a expand and collapse rows. For example, I’ll be displaying the first level json on collapsed rows and upon expanding the row, the second level json (Invoice details) will show