![]() |
Chilkat HOME Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi DLL Go Java Node.js Objective-C PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(Ruby) QuickBooks - Read an AccountDemonstrates how to fetch the information for a specific Quickbooks account. The account information is fetched by Id. The account Ids can be obtained by querying the accounts and parsing the JSON that is returned. Note: This example requires Chilkat v11.0.0 or greater. For more information, see https://developer.intuit.com/app/developer/qbo/docs/api/accounting/ecommerce/account#read-an-account
require 'chilkat' success = false # 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" # } jsonToken = Chilkat::CkJsonObject.new() success = jsonToken.LoadFile("qa_data/tokens/qb-access-token.json") rest = Chilkat::CkRest.new() # 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. bAutoReconnect = true success = rest.Connect("sandbox-quickbooks.api.intuit.com",443,true,bAutoReconnect) if (success == false) print rest.lastErrorText() + "\n"; exit end sbAuth = Chilkat::CkStringBuilder.new() sbAuth.Append("Bearer ") sbAuth.Append(jsonToken.stringOf("access_token")) rest.put_Authorization(sbAuth.getAsString()) rest.AddHeader("Accept","application/json") rest.put_AllowHeaderFolding(false) # The company ID is the 123146096291789 # The account ID is 29 responseBody = rest.fullRequestNoBody("GET","/v3/company/123146096291789/account/29?minorversion=45") if (rest.get_LastMethodSuccess() == false) print rest.lastErrorText() + "\n"; exit end # We should expect a 200 response if successful. if (rest.get_ResponseStatusCode() != 200) print "Request Header: " + "\n"; print rest.lastRequestHeader() + "\n"; print "----" + "\n"; print "Response StatusCode = " + rest.get_ResponseStatusCode().to_s() + "\n"; print "Response StatusLine: " + rest.responseStatusText() + "\n"; print "Response Header:" + "\n"; print rest.responseHeader() + "\n"; print responseBody + "\n"; exit end # Load the JSON response into a JSON object for parsing. # A sample JSON response is shown below. json = Chilkat::CkJsonObject.new() json.Load(responseBody) # These will be used for parsing date/time strings.. dtime = Chilkat::CkDateTime.new() bLocalTime = true # Show the JSON.. json.put_EmitCompact(false) print json.emit() + "\n"; # Get some information from the JSON.. print "Name: " + json.stringOf("Account.Name") + "\n"; print "Id: " + json.stringOf("Account.Id") + "\n"; # Load the CreateTime into a CkDateTime... dtime.SetFromTimestamp(json.stringOf("Account.MetaData.CreateTime")) dt = Chilkat::CkDtObj.new() dtime.ToDtObj(bLocalTime,dt) print dt.get_Month().to_s() + "/" + dt.get_Day().to_s() + "/" + dt.get_Year().to_s() + " " + dt.get_Hour().to_s() + ":" + dt.get_Minute().to_s() + "\n"; print "Success." + "\n"; # Use this online tool to generate parsing code from sample JSON: # Generate Parsing Code from JSON # ------------------------------------------------------ # The JSON response looks like this: # { # "Account": { # "Name": "Accounts Payable (A/P)", # "SubAccount": false, # "FullyQualifiedName": "Accounts Payable (A/P)", # "Active": true, # "Classification": "Liability", # "AccountType": "Accounts Payable", # "AccountSubType": "AccountsPayable", # "CurrentBalance": -1602.67, # "CurrentBalanceWithSubAccounts": -1602.67, # "CurrencyRef": { # "value": "USD", # "name": "United States Dollar" # }, # "domain": "QBO", # "sparse": false, # "Id": "33", # "SyncToken": "0", # "MetaData": { # "CreateTime": "2016-09-10T10:12:02-07:00", # "LastUpdatedTime": "2016-09-17T13:10:36-07:00" # } # }, # "time": "2016-10-24T15:35:25.067-07:00" # |
© 2000-2025 Chilkat Software, Inc. All Rights Reserved.