|
Chilkat • HOME • Android™ • Classic ASP • C • C++ • C# • Mono C# • .NET Core C# • C# UWP/WinRT • DataFlex • Delphi ActiveX • Delphi DLL • Visual FoxPro • Java • Lianja • MFC • Objective-C • Perl • PHP ActiveX • PHP Extension • PowerBuilder • PowerShell • PureBasic • CkPython • Chilkat2-Python • Ruby • SQL Server • Swift 2 • Swift 3,4,5... • Tcl • Unicode C • Unicode C++ • Visual Basic 6.0 • VB.NET • VB.NET UWP/WinRT • VBScript • Xojo Plugin • Node.js • Excel • Go
(MFC) 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
#include <CkJsonObject.h> #include <CkRest.h> #include <CkStringBuilder.h> void ChilkatSample(void) { CkString strOut; // 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. CkJsonObject jsonToken; bool success = jsonToken.LoadFile("qa_data/tokens/qb-access-token.json"); CkRest rest; // Connect to the REST server. bool bTls = true; int port = 443; bool bAutoReconnect = true; bool success = rest.Connect("sandbox-quickbooks.api.intuit.com",port,bTls,bAutoReconnect); CkStringBuilder sbAuth; sbAuth.Append("Bearer "); sbAuth.Append(jsonToken.stringOf("access_token")); rest.put_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 CkJsonObject jsonReq; jsonReq.UpdateString("DocNumber","1070"); jsonReq.UpdateString("SyncToken","0"); jsonReq.UpdateString("domain","QBO"); jsonReq.UpdateNumber("Balance","150.0"); jsonReq.UpdateString("BillAddr.City","Bayshore"); jsonReq.UpdateString("BillAddr.Line1","4581 Finch St."); jsonReq.UpdateString("BillAddr.PostalCode","94326"); jsonReq.UpdateString("BillAddr.Lat","INVALID"); jsonReq.UpdateString("BillAddr.Long","INVALID"); jsonReq.UpdateString("BillAddr.CountrySubDivisionCode","CA"); jsonReq.UpdateString("BillAddr.Id","2"); jsonReq.UpdateString("TxnDate","2015-07-24"); jsonReq.UpdateNumber("TotalAmt","150.0"); jsonReq.UpdateString("CustomerRef.name","Amy's Bird Sanctuary"); jsonReq.UpdateString("CustomerRef.value","1"); jsonReq.UpdateString("CustomerMemo.value","Added customer memo."); jsonReq.UpdateString("ShipAddr.City","Bayshore"); jsonReq.UpdateString("ShipAddr.Line1","4581 Finch St."); jsonReq.UpdateString("ShipAddr.PostalCode","94326"); jsonReq.UpdateString("ShipAddr.Lat","INVALID"); jsonReq.UpdateString("ShipAddr.Long","INVALID"); jsonReq.UpdateString("ShipAddr.CountrySubDivisionCode","CA"); jsonReq.UpdateString("ShipAddr.Id","109"); jsonReq.UpdateNewArray("LinkedTxn"); jsonReq.UpdateString("DueDate","2015-08-23"); jsonReq.UpdateString("PrintStatus","NeedToPrint"); jsonReq.UpdateString("EmailStatus","NotSet"); jsonReq.UpdateBool("sparse",false); jsonReq.UpdateInt("Line[0].LineNum",1); jsonReq.UpdateNumber("Line[0].Amount","150.0"); jsonReq.UpdateString("Line[0].SalesItemLineDetail.TaxCodeRef.value","NON"); jsonReq.UpdateString("Line[0].SalesItemLineDetail.ItemRef.name","Services"); jsonReq.UpdateString("Line[0].SalesItemLineDetail.ItemRef.value","1"); jsonReq.UpdateString("Line[0].Id","1"); jsonReq.UpdateString("Line[0].DetailType","SalesItemLineDetail"); jsonReq.UpdateString("Line[1].DetailType","SubTotalLineDetail"); jsonReq.UpdateNumber("Line[1].Amount","150.0"); jsonReq.UpdateNewObject("Line[1].SubTotalLineDetail"); jsonReq.UpdateBool("ApplyTaxAfterDiscount",false); jsonReq.UpdateString("CustomField[0].DefinitionId","1"); jsonReq.UpdateString("CustomField[0].Type","StringType"); jsonReq.UpdateString("CustomField[0].Name","Crew #"); jsonReq.UpdateString("Id","239"); jsonReq.UpdateInt("TxnTaxDetail.TotalTax",0); jsonReq.UpdateString("MetaData.CreateTime","2015-07-24T10:35:08-07:00"); jsonReq.UpdateString("MetaData.LastUpdatedTime","2015-07-24T10:35:08-07:00"); CkStringBuilder sbRequestBody; jsonReq.EmitSb(sbRequestBody); rest.AddHeader("Content-Type","application/json"); rest.AddHeader("Accept","application/json"); rest.put_AllowHeaderFolding(false); CkStringBuilder sbResponseBody; success = rest.FullRequestSb("POST","/v3/company/<realmID>/invoice",sbRequestBody,sbResponseBody); if (success != true) { strOut.append(rest.lastErrorText()); strOut.append("\r\n"); SetDlgItemText(IDC_EDIT1,strOut.getUnicode()); return; } int respStatusCode = rest.get_ResponseStatusCode(); // Success is indicated by a 200 response status code. strOut.append("response status code = "); strOut.appendInt(respStatusCode); strOut.append("\r\n"); CkJsonObject jsonResponse; jsonResponse.LoadSb(sbResponseBody); jsonResponse.put_EmitCompact(false); strOut.append(jsonResponse.emit()); strOut.append("\r\n"); if (rest.get_ResponseStatusCode() != 200) { strOut.append("Failed."); strOut.append("\r\n"); SetDlgItemText(IDC_EDIT1,strOut.getUnicode()); 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" // } // // Chilkat functions returning "const char *" return a pointer to temporary internal memory owned and managed by Chilkat. // See this example explaining how this memory should be used: const char * functions. int LineNum; const char *Amount = 0; const char *SalesItemLineDetailTaxCodeRefValue = 0; const char *SalesItemLineDetailItemRefName = 0; const char *SalesItemLineDetailItemRefValue = 0; const char *Id = 0; const char *DetailType = 0; const char *DefinitionId = 0; const char *invType = 0; const char *Name = 0; const char *InvoiceTxnDate = jsonResponse.stringOf("Invoice.TxnDate"); const char *InvoiceDomain = jsonResponse.stringOf("Invoice.domain"); const char *InvoicePrintStatus = jsonResponse.stringOf("Invoice.PrintStatus"); const char *InvoiceTotalAmt = jsonResponse.stringOf("Invoice.TotalAmt"); const char *InvoiceDueDate = jsonResponse.stringOf("Invoice.DueDate"); bool InvoiceApplyTaxAfterDiscount = jsonResponse.BoolOf("Invoice.ApplyTaxAfterDiscount"); const char *InvoiceDocNumber = jsonResponse.stringOf("Invoice.DocNumber"); bool InvoiceSparse = jsonResponse.BoolOf("Invoice.sparse"); const char *InvoiceCustomerMemoValue = jsonResponse.stringOf("Invoice.CustomerMemo.value"); int InvoiceDeposit = jsonResponse.IntOf("Invoice.Deposit"); const char *InvoiceBalance = jsonResponse.stringOf("Invoice.Balance"); const char *InvoiceCustomerRefName = jsonResponse.stringOf("Invoice.CustomerRef.name"); const char *InvoiceCustomerRefValue = jsonResponse.stringOf("Invoice.CustomerRef.value"); int InvoiceTxnTaxDetailTotalTax = jsonResponse.IntOf("Invoice.TxnTaxDetail.TotalTax"); const char *InvoiceSyncToken = jsonResponse.stringOf("Invoice.SyncToken"); const char *InvoiceShipAddrCountrySubDivisionCode = jsonResponse.stringOf("Invoice.ShipAddr.CountrySubDivisionCode"); const char *InvoiceShipAddrCity = jsonResponse.stringOf("Invoice.ShipAddr.City"); const char *InvoiceShipAddrPostalCode = jsonResponse.stringOf("Invoice.ShipAddr.PostalCode"); const char *InvoiceShipAddrId = jsonResponse.stringOf("Invoice.ShipAddr.Id"); const char *InvoiceShipAddrLine1 = jsonResponse.stringOf("Invoice.ShipAddr.Line1"); const char *InvoiceEmailStatus = jsonResponse.stringOf("Invoice.EmailStatus"); const char *InvoiceBillAddrCountrySubDivisionCode = jsonResponse.stringOf("Invoice.BillAddr.CountrySubDivisionCode"); const char *InvoiceBillAddrCity = jsonResponse.stringOf("Invoice.BillAddr.City"); const char *InvoiceBillAddrPostalCode = jsonResponse.stringOf("Invoice.BillAddr.PostalCode"); const char *InvoiceBillAddrId = jsonResponse.stringOf("Invoice.BillAddr.Id"); const char *InvoiceBillAddrLine1 = jsonResponse.stringOf("Invoice.BillAddr.Line1"); const char *InvoiceMetaDataCreateTime = jsonResponse.stringOf("Invoice.MetaData.CreateTime"); const char *InvoiceMetaDataLastUpdatedTime = jsonResponse.stringOf("Invoice.MetaData.LastUpdatedTime"); const char *InvoiceId = jsonResponse.stringOf("Invoice.Id"); const char *time = jsonResponse.stringOf("time"); int i = 0; int count_i = jsonResponse.SizeOfArray("Invoice.Line"); while (i < count_i) { jsonResponse.put_I(i); LineNum = jsonResponse.IntOf("Invoice.Line[i].LineNum"); Amount = jsonResponse.stringOf("Invoice.Line[i].Amount"); SalesItemLineDetailTaxCodeRefValue = jsonResponse.stringOf("Invoice.Line[i].SalesItemLineDetail.TaxCodeRef.value"); SalesItemLineDetailItemRefName = jsonResponse.stringOf("Invoice.Line[i].SalesItemLineDetail.ItemRef.name"); SalesItemLineDetailItemRefValue = jsonResponse.stringOf("Invoice.Line[i].SalesItemLineDetail.ItemRef.value"); Id = jsonResponse.stringOf("Invoice.Line[i].Id"); DetailType = jsonResponse.stringOf("Invoice.Line[i].DetailType"); i = i + 1; } i = 0; count_i = jsonResponse.SizeOfArray("Invoice.LinkedTxn"); while (i < count_i) { jsonResponse.put_I(i); i = i + 1; } i = 0; count_i = jsonResponse.SizeOfArray("Invoice.CustomField"); while (i < count_i) { jsonResponse.put_I(i); DefinitionId = jsonResponse.stringOf("Invoice.CustomField[i].DefinitionId"); invType = jsonResponse.stringOf("Invoice.CustomField[i].Type"); Name = jsonResponse.stringOf("Invoice.CustomField[i].Name"); i = i + 1; } SetDlgItemText(IDC_EDIT1,strOut.getUnicode()); } |
||||
© 2000-2022 Chilkat Software, Inc. All Rights Reserved.