Java

QuickBooks - Query a Customer

See more QuickBooks Examples

Demonstrates how to query QuickBooks customers.

A sample JSON response body is available at Sample Quickbooks Customer Query JSON Response

Chilkat2 Java

import com.chilkatsoft.chilkat2.ChilkatException;
import com.chilkatsoft.chilkat2.JsonObject;
import com.chilkatsoft.chilkat2.Rest;
import com.chilkatsoft.chilkat2.StringBuilder;

public class ChilkatExample {

    public static void main(String[] args) {
        // This example assumes the Chilkat API to have been previously unlocked.
        // See Global Unlock Sample for sample code.

        // Get our previously obtained OAuth2 access token, which should contain JSON like this:
        // {
        //   "expires_in": 3600,
        //   "x_refresh_token_expires_in": 8726400,
        //   "refresh_token": "L011546037639r ... 3vR2DrbOmg0Sdagw",
        //   "access_token": "eyJlbmMiOiJBMTI4Q0 ... oETJEMbeggg",
        //   "token_type": "bearer"
        // }

        JsonObject jsonToken = new JsonObject();
        jsonToken.loadFile("qa_data/tokens/qb-access-token.json");

        Rest rest = new Rest();

        // Connect using TLS.
        // A single REST object, once connected, can be used for many Quickbooks REST API calls.
        // The auto-reconnect indicates that if the already-established HTTPS connection is closed,
        // then it will be automatically re-established as needed.
        boolean bAutoReconnect = true;
        try {
            rest.connect("sandbox-quickbooks.api.intuit.com", 443, true, bAutoReconnect);
        } catch (ChilkatException e) {
            System.out.println(e.getLastErrorText());
            return;
        }

        StringBuilder sbAuth = new StringBuilder();
        sbAuth.append("Bearer ");
        sbAuth.append(jsonToken.stringOf("access_token"));
        rest.setAuthorization(sbAuth.getAsString());

        rest.addHeader("Accept", "application/json");
        rest.setAllowHeaderFolding(false);

        String query = "select * from Customer";
        rest.addQueryParam("query", query);
        rest.addQueryParam("minorversion", "45");

        // The company ID is 123146096291789
        String responseBody;
        try {
            responseBody = rest.fullRequestNoBody("GET", "/v3/company/123146096291789/query");
        } catch (ChilkatException e) {
            System.out.println(e.getLastErrorText());
            return;
        }

        // We should expect a 200 response if successful.
        if (rest.getResponseStatusCode() != 200) {
            System.out.println("Request Header: ");
            System.out.println(rest.getLastRequestHeader());
            System.out.println("----");
            System.out.println("Response StatusCode = " + rest.getResponseStatusCode());
            System.out.println("Response StatusLine: " + rest.getResponseStatusText());
            System.out.println("Response Header:");
            System.out.println(rest.getResponseHeader());
            System.out.println(responseBody);
            return;
        }

        // Load the JSON response into a JSON object for parsing.
        // A sample JSON response is shown below.
        JsonObject json = new JsonObject();
        json.setEmitCompact(false);
        json.load(responseBody);

        // Use this online tool to generate parsing code from sample JSON:
        // Generate Parsing Code from JSON

        // Iterate over each customer returned.
        int numRecords = json.sizeOfArray("QueryResponse.Customer");
        int i = 0;
        while (i < numRecords) {
            json.setI(i);
            System.out.println("Name: " + json.stringOf("QueryResponse.Customer[i].FullyQualifiedName"));
            System.out.println("Id: " + json.stringOf("QueryResponse.Customer[i].Id"));
            System.out.println("City: " + json.stringOf("QueryResponse.Customer[i].BillAddr.City"));
            System.out.println("----");
            i = i + 1;
        }

        System.out.println("Success.");
    }
}