REST API v3: GET database collections

This method is used to request all collections in a database. It is an HTTP GET call to the following address:

https://api.copernica.com/v3/database/$id/collections?access_token=xxxx

In this, $id should be replaced by the numerical identifier or the name of the database you want to request the collections from.

Available parameters

This method only support paging parameters. More information on these parameters can be found in the article on paging.

Returned fields

The method returns a JSON object that contains a 'data' property with all the collections for the database. Each collection contains the following fields:

Variable Description
ID The ID of the collection.
name Name of the collection.
database ID of the database this collection belongs to.
fields Array with the fields in the collection.
intentions Array with the intentions for the collection (either 1 or null for email/sms/pdf).

JSON example

The JSON for a single collection might look something like this:

{  
   "ID":"25935",
   "name":"Orders",
   "database":"7453",
   "fields":{  
      "start":0,
      "limit":100,
      "count":7,
      "data":[  
         {  
            "ID":"9277",
            "name":"email",
            "type":"email",
            "value":"test@copernica.nl",
            "displayed":true,
            "ordered":false,
            "length":"100",
            "textlines":"0",
            "hidden":false,
            "index":false
         },
         ...
      ],
      "total":2
   }
}

PHP example

The following PHP script demonstrates how to use the API method:

// dependencies
require_once('copernica_rest_api.php');

// change this into your access token
$api = new CopernicaRestAPI("your-access-token", 3);

// parameters to pass to the call
$parameters = array(
   'limit'     =>  100
);

// do the call, and print result
print_r($api->get("database/{$databaseID}/collections", $parameters));

The example above requires the CopernicaRestApi class.

More information