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
(PHP ActiveX) Xero Get InvoicesGet Xero company invoices. For more information, see https://developer.xero.com/documentation/api/invoices
<?php // This example requires the Chilkat API to have been previously unlocked. // See Global Unlock Sample for sample code. // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.Http') $http = new COM("Chilkat.Http"); // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.JsonObject') $jsonToken = new COM("Chilkat.JsonObject"); $success = $jsonToken->LoadFile('qa_data/tokens/xero-access-token.json'); if ($success == 0) { print $jsonToken->LastErrorText . "\n"; exit; } $http->AuthToken = $jsonToken->stringOf('access_token'); // Replace the value here with an actual tenant ID obtained from this example: // Get Xero Tenant IDs $http->SetRequestHeader('Xero-tenant-id','83299b9e-5747-4a14-a18a-a6c94f824eb7'); $http->Accept = 'application/json'; // resp is a Chilkat.HttpResponse $resp = $http->QuickRequest('GET','https://api.xero.com/api.xro/2.0/Invoices'); if ($http->LastMethodSuccess != 1) { print $http->LastErrorText . "\n"; exit; } print 'Response Status Code: ' . $resp->StatusCode . "\n"; // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.JsonObject') $jsonResponse = new COM("Chilkat.JsonObject"); $jsonResponse->Load($resp->BodyStr); $jsonResponse->EmitCompact = 0; print $jsonResponse->emit() . "\n"; if ($resp->StatusCode != 200) { print 'Failed.' . "\n"; exit; } // Sample output... // (See the parsing code below..) // // Use the this online tool to generate parsing code from sample JSON: // Generate Parsing Code from JSON // { // "Id": "bda1f62f-0d63-4178-8d54-e91fd226987a", // "Status": "OK", // "ProviderName": "Chilkat2222", // "DateTimeUTC": "\/Date(1587210234493)\/", // "Invoices": [ // { // "Type": "ACCPAY", // "InvoiceID": "0032f627-3156-4d30-9b1c-4d3b994dc921", // "InvoiceNumber": "9871", // "Reference": "", // "Payments": [ // { // "PaymentID": "22974891-3689-4694-9ee7-fd2ba917af55", // "Date": "\/Date(1579737600000+0000)\/", // "Amount": 148.50, // "Reference": "Chq 409", // "HasAccount": false, // "HasValidationErrors": false // } // ], // "CreditNotes": [ // ], // "Prepayments": [ // ], // "Overpayments": [ // ], // "AmountDue": 0.00, // "AmountPaid": 148.50, // "AmountCredited": 0.00, // "IsDiscounted": false, // "HasAttachments": false, // "HasErrors": false, // "Contact": { // "ContactID": "d6a384fb-f46f-41a3-8ac7-b7bc9e0b5efa", // "Name": "Melrose Parking", // "Addresses": [ // ], // "Phones": [ // ], // "ContactGroups": [ // ], // "ContactPersons": [ // ], // "HasValidationErrors": false // }, // "DateString": "2020-01-15T00:00:00", // "Date": "\/Date(1579046400000+0000)\/", // "DueDateString": "2020-01-24T00:00:00", // "DueDate": "\/Date(1579824000000+0000)\/", // "Status": "PAID", // "LineAmountTypes": "Exclusive", // "LineItems": [ // ], // "SubTotal": 135.00, // "TotalTax": 13.50, // "Total": 148.50, // "UpdatedDateUTC": "\/Date(1221560931500+0000)\/", // "CurrencyCode": "AUD", // "FullyPaidOnDate": "\/Date(1579737600000+0000)\/" // }, // { // "Type": "ACCPAY", // "InvoiceID": "673dd7cc-beb7-4697-83d4-0c47cb400cc2", // "InvoiceNumber": "", // "Reference": "", // "Payments": [ // { // "PaymentID": "4d06f609-5200-4364-9c8b-d4379a945252", // "Date": "\/Date(1580688000000+0000)\/", // "Amount": 974.60, // "Reference": "DD # 96013", // "HasAccount": false, // "HasValidationErrors": false // } // ], // "CreditNotes": [ // { // "CreditNoteID": "7df8949c-b71f-40c0-bbcf-39f2f450f286", // "CreditNoteNumber": "03391", // "ID": "7df8949c-b71f-40c0-bbcf-39f2f450f286", // "HasErrors": false, // "AppliedAmount": 218.90, // "DateString": "2020-01-29T00:00:00", // "Date": "\/Date(1580256000000+0000)\/", // "LineItems": [ // ], // "Total": 218.90 // } // ], // "Prepayments": [ // ], // "Overpayments": [ // ], // "AmountDue": 0.00, // "AmountPaid": 974.60, // "AmountCredited": 218.90, // "IsDiscounted": false, // "HasAttachments": false, // "HasErrors": false, // "Contact": { // "ContactID": "d0cd2c4f-18a0-4f7c-a32a-2db00f29d298", // "Name": "PC Complete", // "Addresses": [ // ], // "Phones": [ // ], // "ContactGroups": [ // ], // "ContactPersons": [ // ], // "HasValidationErrors": false // }, // "DateString": "2020-01-28T00:00:00", // "Date": "\/Date(1580169600000+0000)\/", // "DueDateString": "2020-02-04T00:00:00", // "DueDate": "\/Date(1580774400000+0000)\/", // "Status": "PAID", // "LineAmountTypes": "Exclusive", // "LineItems": [ // ], // "SubTotal": 1085.00, // "TotalTax": 108.50, // "Total": 1193.50, // "UpdatedDateUTC": "\/Date(1221561913790+0000)\/", // "CurrencyCode": "AUD", // "FullyPaidOnDate": "\/Date(1580688000000+0000)\/" // }, // { // "Type": "ACCPAY", // "InvoiceID": "c12aff7e-12bf-4185-8702-460929f19674", // "InvoiceNumber": "", // "Reference": "", // "Payments": [ // ], // "CreditNotes": [ // ], // "Prepayments": [ // ], // "Overpayments": [ // ], // "AmountDue": 2166.99, // "AmountPaid": 0.00, // "AmountCredited": 0.00, // "CurrencyRate": 1.000000, // "IsDiscounted": false, // "HasAttachments": false, // "HasErrors": false, // "Contact": { // "ContactID": "d0cd2c4f-18a0-4f7c-a32a-2db00f29d298", // "Name": "PC Complete", // "Addresses": [ // ], // "Phones": [ // ], // "ContactGroups": [ // ], // "ContactPersons": [ // ], // "HasValidationErrors": false // }, // "DateString": "2020-04-10T00:00:00", // "Date": "\/Date(1586476800000+0000)\/", // "DueDateString": "2020-05-05T00:00:00", // "DueDate": "\/Date(1588636800000+0000)\/", // "Status": "AUTHORISED", // "LineAmountTypes": "Exclusive", // "LineItems": [ // ], // "SubTotal": 1969.99, // "TotalTax": 197.00, // "Total": 2166.99, // "UpdatedDateUTC": "\/Date(1497965301980+0000)\/", // "CurrencyCode": "AUD" // } // ] // } // $Id = $jsonResponse->stringOf('Id'); $Status = $jsonResponse->stringOf('Status'); $ProviderName = $jsonResponse->stringOf('ProviderName'); $DateTimeUTC = $jsonResponse->stringOf('DateTimeUTC'); $i = 0; $count_i = $jsonResponse->SizeOfArray('Invoices'); while ($i < $count_i) { $jsonResponse->I = $i; $Type = $jsonResponse->stringOf('Invoices[i].Type'); $InvoiceID = $jsonResponse->stringOf('Invoices[i].InvoiceID'); $InvoiceNumber = $jsonResponse->stringOf('Invoices[i].InvoiceNumber'); $Reference = $jsonResponse->stringOf('Invoices[i].Reference'); $AmountDue = $jsonResponse->stringOf('Invoices[i].AmountDue'); $AmountPaid = $jsonResponse->stringOf('Invoices[i].AmountPaid'); $AmountCredited = $jsonResponse->stringOf('Invoices[i].AmountCredited'); $IsDiscounted = $jsonResponse->BoolOf('Invoices[i].IsDiscounted'); $HasAttachments = $jsonResponse->BoolOf('Invoices[i].HasAttachments'); $HasErrors = $jsonResponse->BoolOf('Invoices[i].HasErrors'); $ContactContactID = $jsonResponse->stringOf('Invoices[i].Contact.ContactID'); $ContactName = $jsonResponse->stringOf('Invoices[i].Contact.Name'); $ContactHasValidationErrors = $jsonResponse->BoolOf('Invoices[i].Contact.HasValidationErrors'); $DateString = $jsonResponse->stringOf('Invoices[i].DateString'); $Date = $jsonResponse->stringOf('Invoices[i].Date'); $DueDateString = $jsonResponse->stringOf('Invoices[i].DueDateString'); $DueDate = $jsonResponse->stringOf('Invoices[i].DueDate'); $Status = $jsonResponse->stringOf('Invoices[i].Status'); $LineAmountTypes = $jsonResponse->stringOf('Invoices[i].LineAmountTypes'); $SubTotal = $jsonResponse->stringOf('Invoices[i].SubTotal'); $TotalTax = $jsonResponse->stringOf('Invoices[i].TotalTax'); $Total = $jsonResponse->stringOf('Invoices[i].Total'); $UpdatedDateUTC = $jsonResponse->stringOf('Invoices[i].UpdatedDateUTC'); $CurrencyCode = $jsonResponse->stringOf('Invoices[i].CurrencyCode'); $FullyPaidOnDate = $jsonResponse->stringOf('Invoices[i].FullyPaidOnDate'); $CurrencyRate = $jsonResponse->stringOf('Invoices[i].CurrencyRate'); $j = 0; $count_j = $jsonResponse->SizeOfArray('Invoices[i].Payments'); while ($j < $count_j) { $jsonResponse->J = $j; $PaymentID = $jsonResponse->stringOf('Invoices[i].Payments[j].PaymentID'); $Date = $jsonResponse->stringOf('Invoices[i].Payments[j].Date'); $Amount = $jsonResponse->stringOf('Invoices[i].Payments[j].Amount'); $Reference = $jsonResponse->stringOf('Invoices[i].Payments[j].Reference'); $HasAccount = $jsonResponse->BoolOf('Invoices[i].Payments[j].HasAccount'); $HasValidationErrors = $jsonResponse->BoolOf('Invoices[i].Payments[j].HasValidationErrors'); $j = $j + 1; } $j = 0; $count_j = $jsonResponse->SizeOfArray('Invoices[i].CreditNotes'); while ($j < $count_j) { $jsonResponse->J = $j; $CreditNoteID = $jsonResponse->stringOf('Invoices[i].CreditNotes[j].CreditNoteID'); $CreditNoteNumber = $jsonResponse->stringOf('Invoices[i].CreditNotes[j].CreditNoteNumber'); $ID = $jsonResponse->stringOf('Invoices[i].CreditNotes[j].ID'); $HasErrors = $jsonResponse->BoolOf('Invoices[i].CreditNotes[j].HasErrors'); $AppliedAmount = $jsonResponse->stringOf('Invoices[i].CreditNotes[j].AppliedAmount'); $DateString = $jsonResponse->stringOf('Invoices[i].CreditNotes[j].DateString'); $Date = $jsonResponse->stringOf('Invoices[i].CreditNotes[j].Date'); $Total = $jsonResponse->stringOf('Invoices[i].CreditNotes[j].Total'); $k = 0; $count_k = $jsonResponse->SizeOfArray('Invoices[i].CreditNotes[j].LineItems'); while ($k < $count_k) { $jsonResponse->K = $k; $k = $k + 1; } $j = $j + 1; } $j = 0; $count_j = $jsonResponse->SizeOfArray('Invoices[i].Prepayments'); while ($j < $count_j) { $jsonResponse->J = $j; $j = $j + 1; } $j = 0; $count_j = $jsonResponse->SizeOfArray('Invoices[i].Overpayments'); while ($j < $count_j) { $jsonResponse->J = $j; $j = $j + 1; } $j = 0; $count_j = $jsonResponse->SizeOfArray('Invoices[i].Contact.Addresses'); while ($j < $count_j) { $jsonResponse->J = $j; $j = $j + 1; } $j = 0; $count_j = $jsonResponse->SizeOfArray('Invoices[i].Contact.Phones'); while ($j < $count_j) { $jsonResponse->J = $j; $j = $j + 1; } $j = 0; $count_j = $jsonResponse->SizeOfArray('Invoices[i].Contact.ContactGroups'); while ($j < $count_j) { $jsonResponse->J = $j; $j = $j + 1; } $j = 0; $count_j = $jsonResponse->SizeOfArray('Invoices[i].Contact.ContactPersons'); while ($j < $count_j) { $jsonResponse->J = $j; $j = $j + 1; } $j = 0; $count_j = $jsonResponse->SizeOfArray('Invoices[i].LineItems'); while ($j < $count_j) { $jsonResponse->J = $j; $j = $j + 1; } $i = $i + 1; } ?> |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.