Querying multiple collections is giving - Collection not found

[nithinkashyapn]

I am trying to query multiple collections as shown -

/api/collections/get/(authors|posts)

But i keep getting the error like -

{
    "error": "Collection not found"
}

Can anyone help me where i am going wrong? The individual APIs work correctly

[raffaelj]

This is not possible by default and it would only make sense if they have similar fields. Otherwise the filters wouldn’t work correctly.

If you need to query multiple collections with on api request, you have to write your own api endpoint.

What’s your actual goal? Maybe I can point you in the right direction.

[nithinkashyapn]

Hi,

I am creating a landing page which draws information from multiple collections like carousel, comments, and posts. One way how i got it to work in a single query is by using CockpitQL and calling a GraphQL API with graphql-request. Is there any other way to get the same output?

The documentation tells querying multiple is possible - https://getcockpit.com/documentation/api so only got confused

[raffaelj]

@nithinkashyapn

The documentation tells querying multiple is possible

Ah, I see. This is regex style is only to give permission to fetch multiple collections with single api keys. You can’t fetch them this way.

@nithinkashyapn

Is there any other way to get the same output?

You can create a custom api endpoint.

How to create custom API Endpoints

In Cockpit you can create a custom api entry point pretty easy: Create the following file /config/api/custom.php we now do a custom query in that file: <?php // very simple code here $test = $this->param('test'); if (!$test) { return false; } return $test; now you can query /api/custom?token=xxx&test=foo,bar,baz if you want to have the api public (without token) then create the file in a subfolder named public: /config/api/public/custom.php now you can query /api/public/custom?tes…

sample:

<?php
$authors = cockpit('collections')->find('authors');
$posts   = cockpit('collections')->find('posts');
return compact('authors', 'posts');

[artur]

Possible solution:

create a file config/api/public/multirequest.php

<?php


/**

    <requests> parameter should look like:

    {
        "posts": {
            "endpoint": "/api/collections/get/posts",
            "params": {"lang": "de"}
        },
        "footer": {
            "endpoint": "/api/singletons/get/footer",
            "params": {"lang": "de"}
        }
    }

 */


$requests = $this->param('requests');

if (!$requests) {
    $this->stop(['error' => 'requests parameter is missing'], 412);
}

$ret = [];
$cockpit = cockpit();

foreach ($requests as $k => $req) {

    if (!isset($req['endpoint'])) continue;

    $request = new Lime\Request([
        'request' => array_merge([], $req['query'] ?? [], $req['post'] ?? [], $req['params'] ?? []),
        'post' => $req['post'] ?? [],
        'cookies' => $req['cookies'] ?? [],
        'query' => $req['query'] ?? [],
        'files' => $request->files ?? [],
        'server' => $req['server'] ?? [],
        'headers' => $req['headers'] ?? [],
    ]);

    try {

        $r = $cockpit->run($req['endpoint'], $request,  false);

        $body = $r->body;
        $mime = $r->mime;

        if (\is_array($body) || \is_object($body)) {
            $mime = 'json';
        }

        $ret[$k] = [
            'status' => $r->status,
            'mime' => $mime,
            'body' => $body,
        ];

    } catch(\Throwable $e) {
        
        $ret[$k] = [
            'error' => $e->getMessage(),
            'file' => $e->getFile(),
            'line' => $e->getLine(),
        ];
    }
}

return $ret;

now you can query multiple api endpoints by requesting /api/public/multirequest