Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(Swift 2) QuickBooks - Query a CustomerDemonstrates how to query QuickBooks customers. A sample JSON response body is available at Sample Quickbooks Customer Query JSON Response For more information, see https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/customer#query-a-customer
func chilkatTest() { // 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" // } let jsonToken = CkoJsonObject() var success: Bool = jsonToken.LoadFile("qa_data/tokens/qb-access-token.json") let rest = CkoRest() // 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. var bAutoReconnect: Bool = true success = rest.Connect("sandbox-quickbooks.api.intuit.com", port: 443, tls: true, autoReconnect: bAutoReconnect) if success != true { print("\(rest.LastErrorText)") return } let sbAuth = CkoStringBuilder() sbAuth.Append("Bearer ") sbAuth.Append(jsonToken.StringOf("access_token")) rest.Authorization = sbAuth.GetAsString() rest.AddHeader("Accept", value: "application/json") rest.AllowHeaderFolding = false var query: String? = "select * from Customer" rest.AddQueryParam("query", value: query) rest.AddQueryParam("minorversion", value: "45") // The company ID is 123146096291789 var responseBody: String? = rest.FullRequestNoBody("GET", uriPath: "/v3/company/123146096291789/query") if rest.LastMethodSuccess != true { print("\(rest.LastErrorText)") return } // We should expect a 200 response if successful. if rest.ResponseStatusCode.intValue != 200 { print("Request Header: ") print("\(rest.LastRequestHeader)") print("----") print("Response StatusCode = \(rest.ResponseStatusCode.intValue)") print("Response StatusLine: \(rest.ResponseStatusText)") print("Response Header:") print("\(rest.ResponseHeader)") print("\(responseBody!)") return } // Load the JSON response into a JSON object for parsing. // A sample JSON response is shown below. let json = CkoJsonObject() json.EmitCompact = 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. var numRecords: Int = json.SizeOfArray("QueryResponse.Customer").intValue var i: Int = 0 while i < numRecords { json.I = i print("Name: \(json.StringOf("QueryResponse.Customer[i].FullyQualifiedName"))") print("Id: \(json.StringOf("QueryResponse.Customer[i].Id"))") print("City: \(json.StringOf("QueryResponse.Customer[i].BillAddr.City"))") print("----") i = i + 1 } print("Success.") } |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.