REST API v3: GET collection subprofiles
You can request all subprofiles from a collection with an HTTP GET call to the following URL:
https://api.copernica.com/v3/collection/$id/subprofiles?access_token=xxxx
The $id
should be replaced with the numerical identifier of the collection you
want to fetch the subprofiles of. Since this can be
quite a time-consuming call it is possible to use the 'dataonly' property
to speed it up.
Available parameters
The following parameters can be added to the URL as variables:
- start: First ID to retrieve.
- limit: Length of the batch.
- total: Boolean. Indicates whether to show the total or not. Setting this to 'false' will speed up the call.
- fields: Optional parameter to set conditions for subprofiles that should be returned.
- orderby: Name or ID of field to sort subprofiles by (defaults to ID).
- order: Ascending ('asc') or descending ('desc') order.
- dataonly: Boolean. If set to true the method will only retrieve the ID, fields, collection ID, profile ID and modified date to speed up the call.
If you want to retrieve the subprofiles for a specific profile in a collection you can use the method to fetch subprofiles for a profile.
Paging
More information on the start, limit and total parameters can be found in the article on paging.
Fields
The fields parameter can be used to select subprofiles. For example, if you only want to request subprofiles where the field “country” equals “The Netherlands”, you can do so using “fields”. More information on this parameter can be found in the article on the “fields” parameter.
Ordering
The orderby variable can be set to the name or the ID of a field to sort the subprofiles by it. There are also three special values to sort by:
- id: The default value; profiles are ordered based on their ID.
- random: Subprofiles are randomly ordered.
- modified: Subprofiles are ordered based on the modified timestamp.
The order variable can be used to sort in ascending ('asc') or descending ('desc') order.
Returned fields
This method returns a JSON object with the subprofiles under the data property. Each subprofile contains the following fields:
- ID: Numerical ID of the subprofile.
- secret: The "secret" code linked to a subprofile.
- fields: Associative array of field names and values.
- profile: Numerical ID of the profile the subprofile belongs to.
- collection: ID of the collection where the subprofile is stored.
- created: Timestamp for creation of subprofile in YYYY-MM-DD hh:mm:ss format.
- modified: Timestamp for last edit of subprofile in YYYY-MM-DD hh:mm:ss format.
- removed: Indicates whether the subprofile has been removed or not.
Please note that some of these fields will not be available if the dataonly parameter has been set to true.
JSON example
The JSON for a single subprofile might look something like this:
{
"ID":"20285",
"secret":"132879300b4731870080b1cd301fd43d",
"fields":{
},
"profile":"2139358",
"collection":"6312",
"created":"2008-08-25 16:14:56",
"modified":"2010-08-25 16:15:56",
"removed":false
}
PHP Example
The following PHP script demonstrates how to call 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,
'orderby' => 'country',
'fields' => array("age>16", "age<=65")
);
// do the call, and print result
print_r($api->get("collection/{$collectionID}/subprofiles", $parameters));
The example above requires the CopernicaRestApi class.