|
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 3,4,5...) Quickbooks Update an InvoiceDemonstrates how to update an invoice using the Quickbooks REST API. For more information, see https://www.developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/invoice#full-update-an-invoice
func chilkatTest() { // This example requires the Chilkat API to have been previously unlocked. // See Global Unlock Sample for sample code. // First get our previously obtained OAuth2 access token. let jsonToken = CkoJsonObject()! var success: Bool = jsonToken.loadFile("qa_data/tokens/qb-access-token.json") let rest = CkoRest()! // Connect to the REST server. var bTls: Bool = true var port: Int = 443 var bAutoReconnect: Bool = true var success: Bool = rest.connect("sandbox-quickbooks.api.intuit.com", port: port, tls: bTls, autoReconnect: bAutoReconnect) let sbAuth = CkoStringBuilder()! sbAuth.append("Bearer ") sbAuth.append(jsonToken.string(of: "access_token")) rest.authorization = sbAuth.getAsString() // -------------------------------------------------------------------------- // Note: The above code to setup the initial REST connection // can be done once. After connecting, any number of REST calls can be made. // If the connection is lost, the next REST method call will automatically // reconnect if needed. // -------------------------------------------------------------------------- // Create the following JSON: // { // "DocNumber": "1070", // "SyncToken": "0", // "domain": "QBO", // "Balance": 150.0, // "BillAddr": { // "City": "Bayshore", // "Line1": "4581 Finch St.", // "PostalCode": "94326", // "Lat": "INVALID", // "Long": "INVALID", // "CountrySubDivisionCode": "CA", // "Id": "2" // }, // "TxnDate": "2015-07-24", // "TotalAmt": 150.0, // "CustomerRef": { // "name": "Amy's Bird Sanctuary", // "value": "1" // }, // "CustomerMemo": { // "value": "Added customer memo." // }, // "ShipAddr": { // "City": "Bayshore", // "Line1": "4581 Finch St.", // "PostalCode": "94326", // "Lat": "INVALID", // "Long": "INVALID", // "CountrySubDivisionCode": "CA", // "Id": "109" // }, // "LinkedTxn": [ // ], // "DueDate": "2015-08-23", // "PrintStatus": "NeedToPrint", // "EmailStatus": "NotSet", // "sparse": false, // "Line": [ // { // "LineNum": 1, // "Amount": 150.0, // "SalesItemLineDetail": { // "TaxCodeRef": { // "value": "NON" // }, // "ItemRef": { // "name": "Services", // "value": "1" // } // }, // "Id": "1", // "DetailType": "SalesItemLineDetail" // }, // { // "DetailType": "SubTotalLineDetail", // "Amount": 150.0, // "SubTotalLineDetail": {} // } // ], // "ApplyTaxAfterDiscount": false, // "CustomField": [ // { // "DefinitionId": "1", // "Type": "StringType", // "Name": "Crew #" // } // ], // "Id": "239", // "TxnTaxDetail": { // "TotalTax": 0 // }, // "MetaData": { // "CreateTime": "2015-07-24T10:35:08-07:00", // "LastUpdatedTime": "2015-07-24T10:35:08-07:00" // } // } // // Use the this online tool to generate the code from sample JSON: // Generate Code to Create JSON let jsonReq = CkoJsonObject()! jsonReq.update("DocNumber", value: "1070") jsonReq.update("SyncToken", value: "0") jsonReq.update("domain", value: "QBO") jsonReq.updateNumber("Balance", numericStr: "150.0") jsonReq.update("BillAddr.City", value: "Bayshore") jsonReq.update("BillAddr.Line1", value: "4581 Finch St.") jsonReq.update("BillAddr.PostalCode", value: "94326") jsonReq.update("BillAddr.Lat", value: "INVALID") jsonReq.update("BillAddr.Long", value: "INVALID") jsonReq.update("BillAddr.CountrySubDivisionCode", value: "CA") jsonReq.update("BillAddr.Id", value: "2") jsonReq.update("TxnDate", value: "2015-07-24") jsonReq.updateNumber("TotalAmt", numericStr: "150.0") jsonReq.update("CustomerRef.name", value: "Amy's Bird Sanctuary") jsonReq.update("CustomerRef.value", value: "1") jsonReq.update("CustomerMemo.value", value: "Added customer memo.") jsonReq.update("ShipAddr.City", value: "Bayshore") jsonReq.update("ShipAddr.Line1", value: "4581 Finch St.") jsonReq.update("ShipAddr.PostalCode", value: "94326") jsonReq.update("ShipAddr.Lat", value: "INVALID") jsonReq.update("ShipAddr.Long", value: "INVALID") jsonReq.update("ShipAddr.CountrySubDivisionCode", value: "CA") jsonReq.update("ShipAddr.Id", value: "109") jsonReq.updateNewArray("LinkedTxn") jsonReq.update("DueDate", value: "2015-08-23") jsonReq.update("PrintStatus", value: "NeedToPrint") jsonReq.update("EmailStatus", value: "NotSet") jsonReq.updateBool("sparse", value: false) jsonReq.updateInt("Line[0].LineNum", value: 1) jsonReq.updateNumber("Line[0].Amount", numericStr: "150.0") jsonReq.update("Line[0].SalesItemLineDetail.TaxCodeRef.value", value: "NON") jsonReq.update("Line[0].SalesItemLineDetail.ItemRef.name", value: "Services") jsonReq.update("Line[0].SalesItemLineDetail.ItemRef.value", value: "1") jsonReq.update("Line[0].Id", value: "1") jsonReq.update("Line[0].DetailType", value: "SalesItemLineDetail") jsonReq.update("Line[1].DetailType", value: "SubTotalLineDetail") jsonReq.updateNumber("Line[1].Amount", numericStr: "150.0") jsonReq.updateNewObject("Line[1].SubTotalLineDetail") jsonReq.updateBool("ApplyTaxAfterDiscount", value: false) jsonReq.update("CustomField[0].DefinitionId", value: "1") jsonReq.update("CustomField[0].Type", value: "StringType") jsonReq.update("CustomField[0].Name", value: "Crew #") jsonReq.update("Id", value: "239") jsonReq.updateInt("TxnTaxDetail.TotalTax", value: 0) jsonReq.update("MetaData.CreateTime", value: "2015-07-24T10:35:08-07:00") jsonReq.update("MetaData.LastUpdatedTime", value: "2015-07-24T10:35:08-07:00") let sbRequestBody = CkoStringBuilder()! jsonReq.emitSb(sbRequestBody) rest.addHeader("Content-Type", value: "application/json") rest.addHeader("Accept", value: "application/json") rest.allowHeaderFolding = false let sbResponseBody = CkoStringBuilder()! success = rest.fullRequestSb("POST", uriPath: "/v3/company/<realmID>/invoice", requestBody: sbRequestBody, responseBody: sbResponseBody) if success != true { print("\(rest.lastErrorText!)") return } var respStatusCode: Int = rest.responseStatusCode.intValue // Success is indicated by a 200 response status code. print("response status code = \(respStatusCode)") let jsonResponse = CkoJsonObject()! jsonResponse.loadSb(sbResponseBody) jsonResponse.emitCompact = false print("\(jsonResponse.emit()!)") if rest.responseStatusCode.intValue != 200 { print("Failed.") return } // Sample output... // (See the parsing code below..) // // Use the this online tool to generate parsing code from sample JSON: // Generate Parsing Code from JSON // { // "Invoice": { // "TxnDate": "2015-07-24", // "domain": "QBO", // "PrintStatus": "NeedToPrint", // "TotalAmt": 150.0, // "Line": [ // { // "LineNum": 1, // "Amount": 150.0, // "SalesItemLineDetail": { // "TaxCodeRef": { // "value": "NON" // }, // "ItemRef": { // "name": "Services", // "value": "1" // } // }, // "Id": "1", // "DetailType": "SalesItemLineDetail" // }, // { // "DetailType": "SubTotalLineDetail", // "Amount": 150.0, // "SubTotalLineDetail": {} // } // ], // "DueDate": "2015-08-23", // "ApplyTaxAfterDiscount": false, // "DocNumber": "1070", // "sparse": false, // "CustomerMemo": { // "value": "Added customer memo." // }, // "Deposit": 0, // "Balance": 150.0, // "CustomerRef": { // "name": "Amy's Bird Sanctuary", // "value": "1" // }, // "TxnTaxDetail": { // "TotalTax": 0 // }, // "SyncToken": "1", // "LinkedTxn": [ // ], // "ShipAddr": { // "CountrySubDivisionCode": "CA", // "City": "Bayshore", // "PostalCode": "94326", // "Id": "118", // "Line1": "4581 Finch St." // }, // "EmailStatus": "NotSet", // "BillAddr": { // "CountrySubDivisionCode": "CA", // "City": "Bayshore", // "PostalCode": "94326", // "Id": "117", // "Line1": "4581 Finch St." // }, // "MetaData": { // "CreateTime": "2015-07-24T10:35:08-07:00", // "LastUpdatedTime": "2015-07-24T10:53:39-07:00" // }, // "CustomField": [ // { // "DefinitionId": "1", // "Type": "StringType", // "Name": "Crew #" // } // ], // "Id": "239" // }, // "time": "2015-07-24T10:53:39.287-07:00" // } // var LineNum: Int var Amount: String? var SalesItemLineDetailTaxCodeRefValue: String? var SalesItemLineDetailItemRefName: String? var SalesItemLineDetailItemRefValue: String? var Id: String? var DetailType: String? var DefinitionId: String? var invType: String? var Name: String? var InvoiceTxnDate: String? = jsonResponse.string(of: "Invoice.TxnDate") var InvoiceDomain: String? = jsonResponse.string(of: "Invoice.domain") var InvoicePrintStatus: String? = jsonResponse.string(of: "Invoice.PrintStatus") var InvoiceTotalAmt: String? = jsonResponse.string(of: "Invoice.TotalAmt") var InvoiceDueDate: String? = jsonResponse.string(of: "Invoice.DueDate") var InvoiceApplyTaxAfterDiscount: Bool = jsonResponse.bool(of: "Invoice.ApplyTaxAfterDiscount") var InvoiceDocNumber: String? = jsonResponse.string(of: "Invoice.DocNumber") var InvoiceSparse: Bool = jsonResponse.bool(of: "Invoice.sparse") var InvoiceCustomerMemoValue: String? = jsonResponse.string(of: "Invoice.CustomerMemo.value") var InvoiceDeposit: Int = jsonResponse.int(of: "Invoice.Deposit").intValue var InvoiceBalance: String? = jsonResponse.string(of: "Invoice.Balance") var InvoiceCustomerRefName: String? = jsonResponse.string(of: "Invoice.CustomerRef.name") var InvoiceCustomerRefValue: String? = jsonResponse.string(of: "Invoice.CustomerRef.value") var InvoiceTxnTaxDetailTotalTax: Int = jsonResponse.int(of: "Invoice.TxnTaxDetail.TotalTax").intValue var InvoiceSyncToken: String? = jsonResponse.string(of: "Invoice.SyncToken") var InvoiceShipAddrCountrySubDivisionCode: String? = jsonResponse.string(of: "Invoice.ShipAddr.CountrySubDivisionCode") var InvoiceShipAddrCity: String? = jsonResponse.string(of: "Invoice.ShipAddr.City") var InvoiceShipAddrPostalCode: String? = jsonResponse.string(of: "Invoice.ShipAddr.PostalCode") var InvoiceShipAddrId: String? = jsonResponse.string(of: "Invoice.ShipAddr.Id") var InvoiceShipAddrLine1: String? = jsonResponse.string(of: "Invoice.ShipAddr.Line1") var InvoiceEmailStatus: String? = jsonResponse.string(of: "Invoice.EmailStatus") var InvoiceBillAddrCountrySubDivisionCode: String? = jsonResponse.string(of: "Invoice.BillAddr.CountrySubDivisionCode") var InvoiceBillAddrCity: String? = jsonResponse.string(of: "Invoice.BillAddr.City") var InvoiceBillAddrPostalCode: String? = jsonResponse.string(of: "Invoice.BillAddr.PostalCode") var InvoiceBillAddrId: String? = jsonResponse.string(of: "Invoice.BillAddr.Id") var InvoiceBillAddrLine1: String? = jsonResponse.string(of: "Invoice.BillAddr.Line1") var InvoiceMetaDataCreateTime: String? = jsonResponse.string(of: "Invoice.MetaData.CreateTime") var InvoiceMetaDataLastUpdatedTime: String? = jsonResponse.string(of: "Invoice.MetaData.LastUpdatedTime") var InvoiceId: String? = jsonResponse.string(of: "Invoice.Id") var time: String? = jsonResponse.string(of: "time") var i: Int = 0 var count_i: Int = jsonResponse.size(ofArray: "Invoice.Line").intValue while i < count_i { jsonResponse.i = i LineNum = jsonResponse.int(of: "Invoice.Line[i].LineNum").intValue Amount = jsonResponse.string(of: "Invoice.Line[i].Amount") SalesItemLineDetailTaxCodeRefValue = jsonResponse.string(of: "Invoice.Line[i].SalesItemLineDetail.TaxCodeRef.value") SalesItemLineDetailItemRefName = jsonResponse.string(of: "Invoice.Line[i].SalesItemLineDetail.ItemRef.name") SalesItemLineDetailItemRefValue = jsonResponse.string(of: "Invoice.Line[i].SalesItemLineDetail.ItemRef.value") Id = jsonResponse.string(of: "Invoice.Line[i].Id") DetailType = jsonResponse.string(of: "Invoice.Line[i].DetailType") i = i + 1 } i = 0 count_i = jsonResponse.size(ofArray: "Invoice.LinkedTxn").intValue while i < count_i { jsonResponse.i = i i = i + 1 } i = 0 count_i = jsonResponse.size(ofArray: "Invoice.CustomField").intValue while i < count_i { jsonResponse.i = i DefinitionId = jsonResponse.string(of: "Invoice.CustomField[i].DefinitionId") invType = jsonResponse.string(of: "Invoice.CustomField[i].Type") Name = jsonResponse.string(of: "Invoice.CustomField[i].Name") i = i + 1 } } |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.