In this article, we will learn how to get items from 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.
public ActionResult GetAllItem() { List<Item> ItemList = new List<Item>(); 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; // Create a QuickBooks QueryService using ServiceContext QueryService<Item> querySvc = new QueryService<Item>(serviceContext); ItemList = querySvc.ExecuteIdsQuery("SELECT * FROM Item").ToList(); return View(ItemList); } catch (IdsException ex) { return View(ItemList); } catch (Exception ex) { return View(ItemList); } }
@model List<Intuit.Ipp.Data.Item> @{ ViewBag.Title = "GetAllItem"; } <h2>Quickbooks online Item List</h2> <div> <table class="table table-bordered"> <tr> <th>QBO ID</th> <th>Item Name</th> <th>Account Type</th> <th>Sales Description</th> </tr> @foreach (var item in Model) { <tr> <td>@item.Id</td> <td>@item.Name</td> <td>@item.Type</td> <td>@item.Description</td> </tr> } </table> </div>
string EXISTING_ITEM_QUERYBYNAME = string.Format("select * from Item where Name = '{0}'", "Vision Keyboard"); Item objItemFound = querySvc.ExecuteIdsQuery(EXISTING_ITEM_QUERYBYNAME).FirstOrDefault<Item>();
So that’s how we can get items or query items from Quickbooks online.
Output:
In this article, we have to show Create and Used PIPE in angular
In this article, we have to show Create and Used PIPE in angular
In this article, we have to show Create and Used PIPE in angular