How To Update Customer In Quickbooks Online Using C#

In this article, we will learn how to update a customer in Quickbooks online in .NET MVC web application using SDK.

Before using any Quickbooks online API we need access token, if you don’t know how to get access token then you can find it here.

• First, we have to create a ServiceContext with Auth tokens and realmId.
• For that, we need access token and realmId
• We have to get Customer from Quickbooks online by calling Customer API.
• We are querying customer by customer id.
• For querying/get customer we have to define QueryService
• We need to pass ServiceContext object into QueryService.
• We must need customer Id and SyncToken for an update.
• We will create a Customer object and pass all data with updated data along with Id and SyncToken.
• After that, We have to create a DataService object by passing a ServiceContext object as a parameter.
• Add Customer object in DataService.Update<Customer>() for updating a customer.
• it will return the newly updated Customer object, you can store the required details to the database according to your needs.
• code is as below.

public ActionResult UpdateCustomer()
{
    try
    {
        OAuth2RequestValidator oauthValidator = new OAuth2RequestValidator(Access_token);
        // Create a ServiceContext with Auth tokens and realmId
        ServiceContext serviceContext = new ServiceContext(RealmId, IntuitServicesType.QBO, oauthValidator);
        serviceContext.IppConfiguration.MinorVersion.Qbo = "23";
        serviceContext.IppConfiguration.BaseUrl.Qbo = QboBaseUrl;

        string EXISTING_CUSTOMER_QUERYBYID = string.Format("select * from customer where id = '{0}'", "58");

        var queryService = new QueryService<Customer>(serviceContext);
        Customer objCustomerFound = queryService.ExecuteIdsQuery(EXISTING_CUSTOMER_QUERYBYID).FirstOrDefault<Customer>();

        if (objCustomerFound != null)
        {
            Customer ObjCustomer = new Customer();

            ObjCustomer.Id = objCustomerFound.Id;
            ObjCustomer.SyncToken = objCustomerFound.SyncToken;

            ObjCustomer.GivenName = objCustomerFound.GivenName;
            ObjCustomer.FamilyName = "Rangrej";
            ObjCustomer.ContactName = objCustomerFound.ContactName;
            ObjCustomer.CompanyName = objCustomerFound.CompanyName;

            EmailAddress ObjEmail = new EmailAddress();
            ObjEmail.Address = "tabishzrangrej.vision@gmail.com";
            ObjCustomer.PrimaryEmailAddr = ObjEmail;

            PhysicalAddress ObjAddress = new PhysicalAddress();
            ObjAddress.PostalCode = "11379";
            ObjAddress.Country = "USA";
            ObjAddress.Line1 = "51 Front Dr,near xyz hospital";
            ObjAddress.City = "New York";
            ObjCustomer.BillAddr = ObjAddress;

            TelephoneNumber ObjTelephoneNumber = new TelephoneNumber();
            ObjTelephoneNumber.FreeFormNumber = "(123) 456-0987";
            ObjCustomer.PrimaryPhone = ObjTelephoneNumber;

            DataService dataService = new DataService(serviceContext);

            Customer UpdateEntity = dataService.Update<Customer>(ObjCustomer);
            if (UpdateEntity != null && !string.IsNullOrEmpty(UpdateEntity.Id))
            {
                ViewBag.IsSuccess = true;
            }

        }

        return View();
    }
    catch (IdsException ex)
    {
        return View();
    }
    catch (Exception ex)
    {
        return View();
    }
}