![]() |
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
(PowerShell) QuickBooks - Read an EmployeeDemonstrates how to fetch the information for a specific Quickbooks employee. The employee information is fetched by Id. The employee Ids can be obtained by querying the employees 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/all-entities/employee#read-an-employee
Add-Type -Path "C:\chilkat\ChilkatDotNet47-x64\ChilkatDotNet47.dll" $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 = New-Object Chilkat.JsonObject $success = $jsonToken.LoadFile("qa_data/tokens/qb-access-token.json") $rest = New-Object Chilkat.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. $bAutoReconnect = $true $success = $rest.Connect("sandbox-quickbooks.api.intuit.com",443,$true,$bAutoReconnect) if ($success -eq $false) { $($rest.LastErrorText) exit } $sbAuth = New-Object Chilkat.StringBuilder $sbAuth.Append("Bearer ") $sbAuth.Append($jsonToken.StringOf("access_token")) $rest.Authorization = $sbAuth.GetAsString() $rest.AddHeader("Accept","application/json") $rest.AllowHeaderFolding = $false # The company ID is 123146096291789 # The employee ID is 58 $responseBody = $rest.FullRequestNoBody("GET","/v3/company/123146096291789/employee/58?minorversion=45") if ($rest.LastMethodSuccess -eq $false) { $($rest.LastErrorText) exit } # We should expect a 200 response if successful. if ($rest.ResponseStatusCode -ne 200) { $("Request Header: ") $($rest.LastRequestHeader) $("----") $("Response StatusCode = " + $rest.ResponseStatusCode) $("Response StatusLine: " + $rest.ResponseStatusText) $("Response Header:") $($rest.ResponseHeader) $($responseBody) exit } # Load the JSON response into a JSON object for parsing. # A sample JSON response is shown below. $json = New-Object Chilkat.JsonObject $json.Load($responseBody) # These will be used for parsing date/time strings.. $dtime = New-Object Chilkat.CkDateTime # Show the JSON. $json.EmitCompact = $false $($json.Emit()) # Get some information from the JSON.. $("Name: " + $json.StringOf("Employee.DisplayName")) $("Id: " + $json.StringOf("Employee.Id")) $("City: " + $json.StringOf("Employee.PrimaryAddr.City")) $("PostalCode: " + $json.StringOf("Employee.PrimaryAddr.PostalCode")) # Load the CreateTime into a CkDateTime... $dtime.SetFromTimestamp($json.StringOf("Employee.MetaData.CreateTime")) $bLocalTime = $true $dt = New-Object Chilkat.DtObj $dtime.ToDtObj($bLocalTime,$dt) $([string]$dt.Month + "/" + $dt.Day + "/" + $dt.Year + " " + $dt.Hour + ":" + $dt.Minute) $("Success.") # Use this online tool to generate parsing code from sample JSON: # Generate Parsing Code from JSON # ------------------------------------------------------ # The JSON response looks like this: # { # "Employee": { # "SSN": "XXX-XX-XXXX", # "PrimaryAddr": { # "Id": "116", # "Line1": "45 N. Elm Street", # "City": "Middlefield", # "CountrySubDivisionCode": "CA", # "PostalCode": "93242" # }, # "BillableTime": false, # "domain": "QBO", # "sparse": false, # "Id": "98", # "SyncToken": "0", # "MetaData": { # "CreateTime": "2015-07-24T09:34:35-07:00", # "LastUpdatedTime": "2015-07-24T09:34:35-07:00" # }, # "GivenName": "Bill", # "FamilyName": "Miller", # "DisplayName": "Bill Miller", # "PrintOnCheckName": "Bill Miller", # "Active": true, # "PrimaryPhone": { # "FreeFormNumber": "234-525-1234" # } # }, # "time": "2015-07-24T09:35:54.805-07:00" # |
© 2000-2025 Chilkat Software, Inc. All Rights Reserved.