Prolateral Consulting Ltd
Prolateral Consulting Ltd
Support
Support
Knowledgebase Articles
Help
Setup examples
Support

Prolateral offers primary and backup domain (DNS) services, with servers in key geographic locations providing the best service possible.

Problem

How do I list my Clients (end-users) under my Partner account using the Partner API and specify which fields I want returned?
Listing (API GET) all clients using the RESTful Partner API with only selected fields returned?

Solution

The following example of code shows you how to GET a list of clients (end-users) under your partner account and specify which _fields_ to return in the results.

Prerequisites

To use the Partner API you must meet the following criteria

  • Have a working development environment.
  • Have an active Partner account. If you need a partner account you can sign up here.
  • Enabled your account to use the API and set the access controls.
  • Have valid API Credentials.
  • Optional - Setup your development environment to initially use the Sandbox Testing Portal.

For Partner API reference documentation please see https://portal.my-engine.com/apidocs/index.html

Example Code

The examples below use the sandbox for testing. For a production environment remember to change the following:

  • API Url
  • Partner ID
  • Partner API Key

<?php
/**
 * client-list-limit-fields.php
 * 
 * This example with do an API GET for a list of existing clients under that partner.
 * But this time we only request certain fields.
 * 
 */
$apiPartnerId = "<PartnerID>";
$apiSecretKey = "___PartnerKey___";

$apiUrl       = "https://sandbox.my-engine.com/api-v1/clients";

$crlf         = "<br />";

// Set the parameters
$queryParameters = array();
$queryParameters["fields"] = "!(id,username,email,surname,active,client_status_id)";
// For a full set of fields please refer to the API Documentation

// Init Curl
$curl = curl_init();

// API Authentication:
curl_setopt($curl, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
curl_setopt($curl, CURLOPT_USERPWD, "$apiPartnerId:$apiSecretKey");

// Set Curl Options
$parameters = http_build_query($queryParameters, '', '&');
curl_setopt($curl, CURLOPT_URL, $apiUrl . "?" . $parameters);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);

// API GET 
$jsonResult = curl_exec($curl);

// Check for a valid HTTP 200 success and process the returned result
// or handler the failure.
if (curl_getinfo($curl, CURLINFO_RESPONSE_CODE) == 200) {
    $result = json_decode($jsonResult, true);

    if (json_last_error() == JSON_ERROR_NONE)   {
        // We have valid Json data, so lets display the results.
        foreach ($result['data'] as $client) {
            echo "ClientID = " . $client["id"] . $crlf;
            echo "Active Status = " . $client["active"] . $crlf;
            echo "Client Verified Status = " . $client["client_status_id"] . $crlf;
            echo "Username = " . $client["username"] . $crlf;
            echo "Email = " . $client["email"] . $crlf;
            echo "Surname = " . $client["surname"] . $crlf. $crlf;
        }    
    }
    
} else {
    echo "Response Code = " . curl_getinfo($curl, CURLINFO_RESPONSE_CODE) . $crlf;
    
    $result = json_decode($jsonResult, true);
    if (json_last_error() == JSON_ERROR_NONE)   {
        echo "error = " . $result["error"]["name"] . $crlf;
        echo "url = " . $result["error"]["url"] . $crlf;
        echo "message = " . $result["error"]["message"] . $crlf;
    } else {
        echo $jsonResult;
    }
}

curl_close($curl);



/**
 * client-list-limit-fields.cs
 * 
 * This example with do an API GET for a list of existing clients under that partner.
 * But this time we only request certain fields.
 * 
 */


using Newtonsoft.Json;
using System;
using System.Collections.Specialized;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Threading.Tasks;

namespace clients_list_limit_fields
{
    class Program
    {
        private const string apiPartnerId = "<PartnerID>";
        private const string apiSecretKey = "_PartnerKey_";

        private const string apiUrl = "https://sandbox.my-engine.com/api-v1/clients";

        static async Task Main(string[] args)
        {
            // Build our parameters
            NameValueCollection queryParameters = System.Web.HttpUtility.ParseQueryString(string.Empty);
            queryParameters.Add("fields", "!(id,username,email,surname,active,client_status_id)");

            // Create HTTP resource
            HttpClient client = new HttpClient();

            // Add an Accept header for JSON format.
            client.DefaultRequestHeaders.Add("ContentType", "application/json");

            // Set the Authorisation
            var authToken = System.Text.Encoding.UTF8.GetBytes(apiPartnerId + ":" + apiSecretKey);
            client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic", System.Convert.ToBase64String(authToken));

            // Do the GET request.
            HttpResponseMessage response = await client.GetAsync(apiUrl + "?" + queryParameters.ToString());
            if (response.IsSuccessStatusCode)
            {
                var content = response.Content.ReadAsStringAsync();

                dynamic details = JsonConvert.DeserializeObject(content.Result);

                if (details.ContainsKey("data"))
                {
                    foreach (var item in details["data"])
                    {
                        // View the entire record
                        // Console.WriteLine("data = {0}", item);

                        // Display the data we want.
                        Console.WriteLine("ClientID = {0}", item["id"]);
                        Console.WriteLine("Active Status = {0}", item["active"]);
                        Console.WriteLine("Client Verified Status = {0}", item["client_status_id"]);
                        Console.WriteLine("Username = {0}", item["username"]);
                        Console.WriteLine("Email = {0}", item["email"]);
                        Console.WriteLine("Surname = {0} \n", item["surname"]);
                    }

                }
                else
                {
                    Console.WriteLine("response = {0}", response);
                    Console.WriteLine("json response = {0}", details);
                }

            }
            else
            {
                // Get the Json Error response and convert it
                var jsonResponseStr = response.Content.ReadAsStringAsync().Result;
                dynamic jsonResponse = JsonConvert.DeserializeObject(jsonResponseStr);
                Console.WriteLine("name = {0}", jsonResponse["error"]["name"]);
                Console.WriteLine("url = {0}", jsonResponse["error"]["url"]);
                Console.WriteLine("message = {0}", jsonResponse["error"]["message"]);
                Console.WriteLine("{0} ({1})", (int)response.StatusCode, response.ReasonPhrase);
            }

            //Dispose once all HttpClient calls are complete.
            client.Dispose();
        }

    }
}


'
' client-list-limit-fields.vb
' 
' This example with do an API GET for a list of existing clients under that partner.
' But this time we only request certain fields.
' 
'

Imports Newtonsoft.Json
Imports System
Imports System.Collections.Specialized
Imports System.Net.Http
Imports System.Net.Http.Headers
Imports System.Threading.Tasks


Module Program

    Private Const apiPartnerId As String = "<PartnerID>"
    Private Const apiSecretKey As String = "_PartnerKey_"

    Private Const apiUrl As String = "https://sandbox.my-engine.com/api-v1/clients"

    Public Sub Main(args As String())
        clientsList().Wait()
    End Sub


    Public Async Function clientsList() As Task
        ' Build our parameters
        Dim queryParameters As NameValueCollection = System.Web.HttpUtility.ParseQueryString(String.Empty)
        queryParameters.Add("fields", "!(id,username,email,surname,active,client_status_id)")

        ' Create HTTP resource
        Dim client As New HttpClient()

        ' Add an Accept header for JSON format.
        client.DefaultRequestHeaders.Add("ContentType", "application/json")

        ' Set the Authorisation
        Dim authToken = System.Text.Encoding.UTF8.GetBytes(apiPartnerId + ":" + apiSecretKey)
        client.DefaultRequestHeaders.Authorization = New AuthenticationHeaderValue("Basic", System.Convert.ToBase64String(authToken))

        ' Do the GET request.
        Dim response As HttpResponseMessage = Await client.GetAsync(apiUrl)
        If response.IsSuccessStatusCode Then

            Dim content = response.Content.ReadAsStringAsync()

            Dim details As Object = JsonConvert.DeserializeObject(content.Result)
            If details.ContainsKey("data") Then

                For Each item In details("data")

                    ' View the entire record
                    ' Console.WriteLine("data = {0}", item)

                    ' Display the data we want.
                    Console.WriteLine("ClientID = {0}", item("id"))
                    Console.WriteLine("Active Status = {0}", item("active"))
                    Console.WriteLine("Client Verified Status = {0}", item("client_status_id"))
                    Console.WriteLine("Username = {0}", item("username"))
                    Console.WriteLine("Email = {0}", item("email"))
                    Console.WriteLine("Surname = {0} {1}", item("surname"), vbCrLf)
                Next
            Else
                Console.WriteLine("response = {0}", response)
                Console.WriteLine("json response = {0}", details)
            End If
        Else
            ' Get the Json Error response And convert it
            Dim jsonResponseStr = response.Content.ReadAsStringAsync().Result
            Dim jsonResponse As Object = JsonConvert.DeserializeObject(jsonResponseStr)
            Console.WriteLine("name = {0}", jsonResponse("error")("name"))
            Console.WriteLine("url = {0}", jsonResponse("error")("url"))
            Console.WriteLine("message = {0}", jsonResponse("error")("message"))
            Console.WriteLine("{0} ({1})", response.StatusCode, response.ReasonPhrase)
        End If

        'Dispose once all HttpClient calls are complete.
        client.Dispose()


    End Function

End Module




/**
 * client-list-limit-fields.js
 * 
 * This example with do an API GET for a list of existing clients under that partner.
 * But this time we only request certain fields.
 * 
 */

var apiPartnerId = "<PartnerID>";
var apiSecretKey = "_PartnerKey_";

var apiUrl = "https://sandbox.my-engine.com/api-v1/clients";

var queryParameters = { "fields": "!(id,username,email,surname,active,client_status_id)" };
var parameters = $.param(queryParameters, true);

// Setup the Ajax request
var settings = {
    url: apiUrl + "?" + parameters,
    headers: {
        'Authorization': 'Basic ' + btoa(apiPartnerId + ":" + apiSecretKey),
        'cache-control': 'no-cache'
    },
    crossDomain: true,
    dataType: 'json',
    async: true,
    method: "GET"
};

// API GET
$.ajax(settings)
    .done(function(response) {
        $.each(response.data, function(index, value) {
            console.log("ClientID = " + value.id);
            console.log("Active Status = " + value.active);
            console.log("Client Verified Status = " + value.client_status_id);
            console.log("Username = " + value.username);
            console.log("Email = " + value.email);
            console.log("Surname = " + value.surname);
            console.log(" ");
        });

    })
    .fail(function(request, textStatus, errorThrown) {
        try {
            var errObj = $.parseJSON(request.responseText);
            console.log("API Error - " + errObj.name);
            console.log("API Msg   - " + errObj.message);
            console.log("API url   - " + errObj.url);
        } catch (e) {
            console.log("Error - " + errorThrown);
            console.log("Status - " + request.status);
            console.log(request);
        }
    });
like it, love it, then share it. Share this article on social media.

Did you enjoy this article?

Disclaimer

The Origin of this information may be internal or external to Prolateral Consulting Ltd. Prolateral makes all reasonable efforts to verify this information. However, the information provided in this document is for your information only. Prolateral makes no explicit or implied claims to the validity of this information. Any trademarks referenced in this document are the property of their respective owners.