How To Update Account In Quickbooks Online Using C#

In this article, we will learn how to update an account in Quickbooks online from .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 the account from Quickbooks online by calling Account API.
• We are querying account by Name.
• For querying/get account we have to define QueryService
• We need to pass the ServiceContext object into QueryService.
• We must need account Id and SyncToken for an update.
• We will create an account 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 account object in DataService.Update<Account>() for updating an account.
• It will return the newly updated account object, you can store the required details to the database according to your needs.
• The code is as below.

public ActionResult UpdateAccount()
{
  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_ACCOUNT_QUERYBYNAME = string.Format("select * from Account where Name = '{0}'", "Tabish Income Account");

     var queryService = new QueryService<Account>(serviceContext);
     Account ObjAccountFound = queryService.ExecuteIdsQuery(EXISTING_ACCOUNT_QUERYBYNAME).FirstOrDefault<Account>();

     //If Account found on Quickbooks online
     if (ObjAccountFound != null)
     {
         Account ObjAccount = new Account();
         ObjAccount.Id = ObjAccountFound.Id;
         ObjAccount.SyncToken = ObjAccountFound.SyncToken;
         ObjAccount.Name = "Tabish Vision Income Account";
         ObjAccount.AccountTypeSpecified = true;
         ObjAccount.AccountType = ObjAccountFound.AccountType;

         DataService dataService = new DataService(serviceContext);

         Account UpdateEntity = dataService.Update<Account>(ObjAccount);
         if (UpdateEntity != null && !string.IsNullOrEmpty(UpdateEntity.Id))
         {
             //you can write Database code here
             ViewBag.IsSuccess = true;
         }
     }
     return View();
  }
  catch (IdsException ex)
  {
     return View();
  }
  catch (Exception ex)
  {
     return View();
  }
}

• If there is an account named “Tabish Income Account” in Quickbooks online then its Name will be updated as “Tabish Vision Income Account”.