Displaying Json data on view ( LARAVEL )

Question

I am working in laravel project and i want to display my json data from url into the view dashboard.blade, And this is the sample json data:

{"response":{"result":{"Contacts":{"row":[{"no":"1","fl":[{"val":"CONTACTID","content":"144120000000079041"},{"val":"First Name","content":"Tata"},{"val":"Last Name","content":"Nyerere"},{"val":"Email","content":"[email protected]"},{"val":"Account Name","content":"null"},{"val":"Phone","content":"255652400670"},{"val":"Mobile","content":"null"}]},{"no":"2","fl":[{"val":"CONTACTID","content":"144120000000069001"},{"val":"First Name","content":"Daniel"},{"val":"Last Name","content":"Nyerere"},{"val":"Email","content":"[email protected]"},{"val":"Account Name","content":"null"},{"val":"Phone","content":"255754897505"},{"val":"Mobile","content":"null"}]},{"no":"3","fl":[{"val":"CONTACTID","content":"144120000000065068"},{"val":"First Name","content":"Lawrence"},{"val":"Last Name","content":"Zoho"},{"val":"Email","content":"[email protected]"},{"val":"ACCOUNTID","content":"144120000000065066"},{"val":"Account Name","content":"Zoho"},{"val":"Phone","content":"1 888 900 9646"},{"val":"Mobile","content":"null"}]}]}},"uri":"/api/json/contacts/getrecords"}}

And here is my Controller method:

 public function getDashboard()
{
    $url      = "MY URL IS HERE";
    $json     = file_get_contents($url);
    $json     = json_decode($json, true);
    $response = $json['response'];
    $result   = $response['result'];
    $contact  = $result['Contacts'];
    $data     = $contact['row'];
    return view('dashboard')->with('posts', $data);
}

And here is my dashboard.blade that displays the json data on my view page:

       @foreach($posts as $post)
            @foreach($post['fl'] as $row)
                <article class="post">
                    @if($row['val'] == 'First Name')
                       First Name: {{ $row['content'] }}
                    @endif
                </article>
            @endforeach
        @endforeach

Can anyone assist me on the issue and how to write the foreach in dashboard.blade file as i want to display the data on my view as:

First Name    Last Name     Phone:
Tata          Nyerere       255754897505

As for now it only display

First Name: Tata

Please assist me as i have spent time to solve this I will appreciate your help guys. Thanks in advance`

Tosho Trajanov · Accepted Answer · 2016-09-19 09:12:50Z

0

Use return view('dashboard')->with('leads', $contact); if you want to iterate $leads['row'] in the view.

Otherwise, you can just use return view('dashboard')->with('leads', $data); and iterate $leads in the view this way @foreach($leads as $rows)

answered Sep 19, 2016 at 9:12

Tosho Trajanov

7908 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nyerere Over a year ago

I have tried with return view('dashboard')->with('leads', $contact); with $leads['row'] as $rows i get the error 'Undefined index: First Name (View: C:\wamp\www\ZOHOCRMWIKI\resources\views\dashboard.blade.php) '

Abdou Tahiri · Accepted Answer · 2016-09-20 09:40:32Z

0

Make a change from this line

$data = $contact['row'];

to

$data = $contact;

While the second error you have with index First Name and other is because your data isn't in those format to be accessible using like that.

Your first foreach will get into those no and fl index. You better reformat your response data before passing into blade.

edited Sep 20, 2016 at 9:40

Abdou Tahiri

4,4085 gold badges27 silver badges39 bronze badges

answered Sep 20, 2016 at 6:44

cjmling

7,29911 gold badges50 silver badges83 bronze badges

4 Comments

Nyerere Over a year ago

Still error Undefined index: First Name (View: C:\wamp\www\ZOHOCRMWIKI\resources\views\dashboard.blade.php)

cjmling Over a year ago

@Nyerere look at the updated answer. You have to code more to get it working.

Nyerere Over a year ago

Can you assist on how can i reformat the json content above? @cjmling

Nyerere Over a year ago

Look now: my controller method:-

Obsidian · Accepted Answer · 2021-07-15 18:53:16Z

0

You may try json_decode(json_encode($data)).

If the data came from JsonResource, fields that are not existed in the original model will be omitted. It looks weird when you json_encode $data, it works, but not if you want to do something like $data->first_name.

edited Jul 15, 2021 at 18:53

Obsidian

3,9308 gold badges20 silver badges33 bronze badges

answered Jul 15, 2021 at 15:17

Toni Lam

1

Collectives™ on Stack Overflow

Displaying Json data on view ( LARAVEL )

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related