How to create Virtual Pages from API?

mthiebou · November 2, 2019, 11:22am

For a demo i need to show the client that i can connect to the Ninox API.

The following example works

<?php snippet( 'html-header') ?>


<?php

$response = Remote::get('https://api.ninoxdb.de/v1/teams/g2Y9XYZKvtJhTZCRW/databases/ck8hywuqzo7x/tables/A/records?page=1&perPage=15', [
  'headers' => [
    'Authorization: Bearer api-code',
    'Content-Type: application/json'
  ],
  
]);

$books = json_decode($response->content(), true)

?>
<ul class="books">
    <?php foreach ($books as $book): ?>
    <?php $b = $book['fields'] ?>
    <li>
      <?= $b['Titel'] ?>
    </li>
    <?php endforeach ?>
  </ul>
<?php snippet( 'html-footer') ?>

Trying the Virtual Pages from API solution, but it doesn’t work.

This is the model

<?php

class ReviewsPage extends Page
{
    public function children()
    {
        $results = [];
        $pages   = [];
        $request = Remote::get('https://api.ninoxdb.de/v1/teams/g2Y9XYZKvtJhTZCRW/databases/ck8hywuqzo7x/tables/A/records?page=1&perPage=15', [
  'headers' => [
    'Authorization: Bearer api-key',
    'Content-Type: application/json'
  ],
  
]);

        if ($request->code() === 200) {
            $results = $request->json(false)->results;
        }

        foreach ($results as $key => $review) {
            $pages[] = [
                'slug'     => Str::slug($review->display_title),
                'num'      => $key+1,
                'template' => 'review',
                'model'    => 'review',
                'content'  => [
                    'title'    => $review->display_title,
                    'headline' => $review->headline,
                    'byline'   => $review->byline,
                    'summary'  => $review->summary_short,
                    'date'     => $review->publication_date,
                    'link'     => $review->link->url,
                    'linkText' => $review->link->suggested_link_text,
                    'cover'    => $review->multimedia->src
                ]
            ];
        }

        return Pages::factory($pages, $this);
    }
}

getting the following error

Trying to get property ‘results’ of non-object

if ($request->code() === 200) {
            $results = $request->json(false)->results;
        }

if i dump $request i`m getting the following

with

dump( json_decode($response->content(), true));

im getting the following

pixelijn · November 2, 2019, 1:16pm

Since you are dealing with an array, you have to use array syntax:

 foreach ($results as $key => $review) {
            $pages[] = [
                'slug'     => Str::slug($review['display_title']),
                'num'      => $key+1,
                'template' => 'review',
                'model'    => 'review',
                'content'  => [
                    'title'    => $review['display_title'],
                     // etc
                   
                ]
            ];
        }

mthiebou · November 2, 2019, 2:56pm

Hello Pixelijn, Thanks! it works now. But its extremely slow. Any ideas?


        if ($request->code() === 200) {
            $results = json_decode($request->content(), true);
        }

        foreach ($results as $book) {
            $b = $book['fields'];
            $pages[] = [
                'slug'     => Str::slug($b['boeknr']),
                'num'      => 0,
                'template' => 'review',
                'model'    => 'review',
                'content'  => [
                    'title'       => $b['Titel'],
                    'author'    => $b['Auteur'],
                    'year' => $b['ZoekJaar']

      
                ]
            ];
        }

        return Pages::factory($pages, $this);
    }
}

Topic		Replies	Views
Generating virtual page from local page + set template and parent page Questions 🤔	1	259	October 1, 2021
Airtable and virtual pages Solved ✅	14	728	March 23, 2021
Having problems getting remote::request to work Solved ✅ panel	9	504	October 11, 2020
Log in with virtual page Solved ✅	4	282	January 14, 2020
Creating pages from JSON, https problems Questions 🤔	3	767	March 13, 2018

How to create Virtual Pages from API?

Related Topics