B4X
B4X
Quickbooks Update an Invoice
See more QuickBooks Examples
Demonstrates how to update an invoice using the Quickbooks REST API.Chilkat B4X Downloads
Dim success As Boolean = False
' 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.
Dim jsonToken As ChilkatJsonObject
jsonToken.Initialize
success = jsonToken.LoadFile("qa_data/tokens/qb-access-token.json")
Dim rest As ChilkatRest
rest.Initialize("rest")
' Connect to the REST server.
Dim bTls As Boolean = True
Dim port As Int = 443
Dim bAutoReconnect As Boolean = True
success = rest.Connect("sandbox-quickbooks.api.intuit.com", port, bTls, bAutoReconnect)
Dim sbAuth As ChilkatStringBuilder
sbAuth.Initialize
sbAuth.Append("Bearer ")
sbAuth.Append(jsonToken.StringOf("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
Dim jsonReq As ChilkatJsonObject
jsonReq.Initialize
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")
Dim sbRequestBody As ChilkatStringBuilder
sbRequestBody.Initialize
jsonReq.EmitSb(sbRequestBody)
rest.AddHeader("Content-Type", "application/json")
rest.AddHeader("Accept", "application/json")
rest.AllowHeaderFolding = False
Dim sbResponseBody As ChilkatStringBuilder
sbResponseBody.Initialize
success = rest.FullRequestSb("POST", "/v3/company/<realmID>/invoice", sbRequestBody, sbResponseBody)
If success <> True Then
Log(rest.LastErrorText)
Return
End If
Dim respStatusCode As Int = rest.ResponseStatusCode
' Success is indicated by a 200 response status code.
Log("response status code = " & respStatusCode)
Dim jsonResponse As ChilkatJsonObject
jsonResponse.Initialize
jsonResponse.LoadSb(sbResponseBody)
jsonResponse.EmitCompact = False
Log(jsonResponse.Emit)
If rest.ResponseStatusCode <> 200 Then
Log("Failed.")
Return
End If
' 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"
' }
'
Dim LineNum As Int
Dim Amount As String
Dim SalesItemLineDetailTaxCodeRefValue As String
Dim SalesItemLineDetailItemRefName As String
Dim SalesItemLineDetailItemRefValue As String
Dim Id As String
Dim DetailType As String
Dim DefinitionId As String
Dim invType As String
Dim Name As String
Dim InvoiceTxnDate As String = jsonResponse.StringOf("Invoice.TxnDate")
Dim InvoiceDomain As String = jsonResponse.StringOf("Invoice.domain")
Dim InvoicePrintStatus As String = jsonResponse.StringOf("Invoice.PrintStatus")
Dim InvoiceTotalAmt As String = jsonResponse.StringOf("Invoice.TotalAmt")
Dim InvoiceDueDate As String = jsonResponse.StringOf("Invoice.DueDate")
Dim InvoiceApplyTaxAfterDiscount As Boolean = jsonResponse.BoolOf("Invoice.ApplyTaxAfterDiscount")
Dim InvoiceDocNumber As String = jsonResponse.StringOf("Invoice.DocNumber")
Dim InvoiceSparse As Boolean = jsonResponse.BoolOf("Invoice.sparse")
Dim InvoiceCustomerMemoValue As String = jsonResponse.StringOf("Invoice.CustomerMemo.value")
Dim InvoiceDeposit As Int = jsonResponse.IntOf("Invoice.Deposit")
Dim InvoiceBalance As String = jsonResponse.StringOf("Invoice.Balance")
Dim InvoiceCustomerRefName As String = jsonResponse.StringOf("Invoice.CustomerRef.name")
Dim InvoiceCustomerRefValue As String = jsonResponse.StringOf("Invoice.CustomerRef.value")
Dim InvoiceTxnTaxDetailTotalTax As Int = jsonResponse.IntOf("Invoice.TxnTaxDetail.TotalTax")
Dim InvoiceSyncToken As String = jsonResponse.StringOf("Invoice.SyncToken")
Dim InvoiceShipAddrCountrySubDivisionCode As String = jsonResponse.StringOf("Invoice.ShipAddr.CountrySubDivisionCode")
Dim InvoiceShipAddrCity As String = jsonResponse.StringOf("Invoice.ShipAddr.City")
Dim InvoiceShipAddrPostalCode As String = jsonResponse.StringOf("Invoice.ShipAddr.PostalCode")
Dim InvoiceShipAddrId As String = jsonResponse.StringOf("Invoice.ShipAddr.Id")
Dim InvoiceShipAddrLine1 As String = jsonResponse.StringOf("Invoice.ShipAddr.Line1")
Dim InvoiceEmailStatus As String = jsonResponse.StringOf("Invoice.EmailStatus")
Dim InvoiceBillAddrCountrySubDivisionCode As String = jsonResponse.StringOf("Invoice.BillAddr.CountrySubDivisionCode")
Dim InvoiceBillAddrCity As String = jsonResponse.StringOf("Invoice.BillAddr.City")
Dim InvoiceBillAddrPostalCode As String = jsonResponse.StringOf("Invoice.BillAddr.PostalCode")
Dim InvoiceBillAddrId As String = jsonResponse.StringOf("Invoice.BillAddr.Id")
Dim InvoiceBillAddrLine1 As String = jsonResponse.StringOf("Invoice.BillAddr.Line1")
Dim InvoiceMetaDataCreateTime As String = jsonResponse.StringOf("Invoice.MetaData.CreateTime")
Dim InvoiceMetaDataLastUpdatedTime As String = jsonResponse.StringOf("Invoice.MetaData.LastUpdatedTime")
Dim InvoiceId As String = jsonResponse.StringOf("Invoice.Id")
Dim time As String = jsonResponse.StringOf("time")
Dim i As Int = 0
Dim count_i As Int = jsonResponse.SizeOfArray("Invoice.Line")
Do While i < count_i
jsonResponse.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
Loop
i = 0
count_i = jsonResponse.SizeOfArray("Invoice.LinkedTxn")
Do While i < count_i
jsonResponse.I = i
i = i + 1
Loop
i = 0
count_i = jsonResponse.SizeOfArray("Invoice.CustomField")
Do While i < count_i
jsonResponse.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
Loop