Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Quickbooks Online integration c#

My company uses QuickBooks Online, and I would like to write some c# scripts that retrieve very basic information like a list of customers and list of invoices from the QuickBooks Online subscription.

I would also like to submit invoices and payments.

I have created a QuickBooks IPP account (at developer.intuit.com).

I am able to authenticate myself (OAuth) just fine. My questions are:

1) Do I need to authenticate myself every time I wish to connect to QBO IPP (to retrieve a list of customers, submit an invoice, etc.)? Or can my app authenticate itself once & stay 'connected' for months?

2) Is there any sample code to do basic things such as obtain a list of customers, submit an invoice, etc.? I downloaded the sample MVC app from this link

And it was quite helpful - but when I try to get some of the code to work, I just get errors - which leads me to my first question - can I authenticate myself ONCE and use those tokens (appToken, and appTokenSecret) many times in order to perform simple tasks (obtain customer list), or do I have to authenticate myself every time?

Thank you.

like image 909
briscoea Avatar asked Nov 23 '14 04:11

briscoea


People also ask

What programming language is QuickBooks Online written in?

Quickbooks is written in C++ and uses Sybase as the backend database.

Is QuickBooks Online being discontinued?

What does service discontinuation mean? Your access to QuickBooks Desktop Payroll Services, Live Support, Online Backup, Online Banking, and other services through QuickBooks Desktop 2019 software will be discontinued after May 31, 2022. This also means you won't receive critical security updates starting June 1, 2022.

What does C mean in register QuickBooks Online?

C means cleared through the bank and checked off but not reconciled. On the other hand, R means reconciled. Transactions with R status will no longer show up on the next reconciliation screen at all. If you want to modify the transaction's status, you can tap on the checkbox to change the letter.

Does gusto integrate with QuickBooks Online?

With the Gusto integration, wages, taxes, and reimbursements will automatically appear as expenses in your QuickBooks Online account. If you’re new to Gusto, this integration also helps simplify payroll setup by importing company and employee data.

What are the best QuickBooks Online integrations for your business?

The best QuickBooks Online integrations are those that can simplify business tasks and help make your business more efficient. What works for one business may not work for yours, so explore the QuickBooks App Store and give integrations a test run to find the best apps for your business.

Does QuickBooks have CRM integrations?

QuickBooks Online has many popular CRM integrations. Some of the most popular options include HubSpot, Method:CRM, Salesforce, and Insightly CRM. Does QuickBooks Desktop have integrations? QuickBooks Desktop does have integrations, although it doesn’t have as many as QuickBooks Online.

How does the ShipStation with QuickBooks integration work?

The ShipStation with QuickBooks integration is an easy way to sync data between the two programs. You can send product or customer data directly to QuickBooks, sync your orders, and import shipped orders as invoices or sales receipts.


1 Answers

Re - 1) Do I need to authenticate myself every time I wish to connect to QBO IPP (to retrieve a list of customers, submit an invoice, etc.)? Or can my app authenticate itself once & stay 'connected' for months?

Please find below steps to get OAuth tokens using which you can make API call against your QBO account. If you create an app in appcenter, you'll get consumerKey and consumerSecret. https://developer.intuit.com/Application/Create/IA

Using the above two tokens, you can generate accessToken and accessSecret from the OAuthPlayground. https://appcenter.intuit.com/Playground/OAuth/IA PN - After completing C2QB(OAuth) flow, you should use 'App Menu API Test.' option which will show you accessToken and accessSecret.

These tokens are valid for 180 days (at max). When these tokens are more than 150 days old (and <180 days), you can make Reconnect API call to revalidate those again. Ref https://developer.intuit.com/docs/0050_quickbooks_api/0020_authentication_and_authorization/oauth_management_api#Reconnect

So you can always persist these tokens and reuse it.

To let end users connect their QB data with you SaaS app, you need to implement a wizard called 'Connect to Quickbook'. Using 3-legged Oauth your app will be able to capture the acessToken and acessSecret corresponding to the end-user's qbo account. Ref - https://developer.intuit.com/docs/0100_accounting/0060_authentication_and_authorization/connect_from_within_your_app#7._Add_the_Connect_to_QuickBooks_button

Re - 2) Is there any sample code to do basic things such as obtain a list of customers, submit an invoice, etc.?

Please refer - https://developer.intuit.com/docs/0100_accounting/0500_developer_kits/0150_ipp_.net_devkit_3.0/0002_synchronous_calls#/Data_Services_API

and how to add invoice or sales receipt quickbooks rest api v3.0

like image 88
Manas Mukherjee Avatar answered Oct 08 '22 05:10

Manas Mukherjee