QuickBooks Online

How To Update Company Info In Quickbooks Online Using C#

In this article, we will learn how to update company info 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.

Follow the step as described below for updating the company info,

  • First, we have to create a ServiceContext with Auth tokens and realmId.
  • For that, we need access token and realmId
  • For getting company info, we have to define a QueryService object.
  • QueryService object needs a ServiceContext object as parameter.
  • So we have to create a Quickbooks QueryService using ServiceContext.
  • We will get company info in the ObjCompanyInfo object.
  • here we are just changing email and updating it.
  • We are not creating any new object here if you want to then you can create a new object and assign all data to it along with Id and SyncToken.
  • We are using the ObjCompanyInfo object in which we got all values from Quickbooks, and then edit only that fields which we want to update. we are only updating email here.
  • After that, We have to create a DataService object by passing a ServiceContext object as a parameter.
  • Add ObjCompanyInfo object in DataService.Update<CompanyInfo>() for updating an CompanyInfo.
  • It will return the newly updated CompanyInfo object, you can store the required details to the database according to your needs.
  • The code is as below.
public ActionResult UpdateCompanyInfo()
{
  CompanyInfo ObjCompanyInfo = new CompanyInfo();
  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;

    var queryService = new QueryService<CompanyInfo>(serviceContext);
    ObjCompanyInfo = queryService.ExecuteIdsQuery("select * from CompanyInfo").FirstOrDefault<CompanyInfo>();

    if (ObjCompanyInfo != null)
    {
        if (ObjCompanyInfo.Email == null)
        {
            ObjCompanyInfo.Email = new EmailAddress();
        }
        ObjCompanyInfo.Email.Address = "TEST@quickbooks.com";

        DataService dataService = new DataService(serviceContext);

        CompanyInfo UpdateEntity = dataService.Update<CompanyInfo>(ObjCompanyInfo);
        if (UpdateEntity != null && !string.IsNullOrEmpty(UpdateEntity.Id))
        {
            //you can write Database code here
            ViewBag.IsSuccess = true;
        }

        ViewBag.IsSuccess = true;
    }

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

 

  • View Code is as below
@{
    ViewBag.Title = "UpdateCompanyInfo";
}

<h2>Update Company Info</h2>


@if (ViewBag.IsSuccess != null && ViewBag.IsSuccess == true)
{
    <div>
        <label class="label label-success">Successfully Updated</label>
    </div>
}
  • The above code will only update the Email of company info. all other data will remain the same.

 

Tabish Rangrej

Tabish Rangrej is an Experienced .NET Team Leader, software engineer, and Author with a demonstrated history of working in the IT industry. He has quite well experience in developing, communicating, managing, and writing in his field. He has strong skills and knowledge of ASP.NET C#, ASP.NET MVC, ASP.NET CORE, Angular, AngularJS, Web API, SQL, Entity Framework, JavaScript, Jquery, Different Integrations like Quickbooks, Stripe, Google APIs, Zoho, Orion, Xero, etc., Different versioning tools like TFS, SVN, GIT, etc. and Windows services. Strong engineering professional with a Master of Computer Applications - MCA focused on Computer Science from Veer Narmad South Gujarat University, Surat. Tabish is always ready to accept new challenges and learn new things, he would like to serve better for the community.

Recent Posts

Testing hk

Testing

2 years ago

Create and Used PIPE in angular

In this article, we have to show Create and Used PIPE in angular

2 years ago

Operation

Testing

2 years ago

Create and Used PIPE in angular

In this article, we have to show Create and Used PIPE in angular

2 years ago

Create and Used PIPE in angular

In this article, we have to show Create and Used PIPE in angular

2 years ago

TETS NEW

test

3 years ago