+ Start a Discussion
Force TechieForce Techie 

Salesforce to QuickBooks online

Hi All,

I am having a requirement to integrate QuickBooks online with Salesforce. In this, I am successfully getting authorized from Salesforce to my app on QuickBooks. I am using version V1 to getting request token and access token, secret credentials. But, when I am trying to make a request to getting all Accounts from QuickBooks app with using V3, got the Authentication error: Unauthorized. If anyone faces this type of exception and got success to make request from SF to QB please help me to getting out from this exception.

Thanks in advance!
ShashankShashank (Salesforce Developers) 
I woud recommend you to check with quickbooks support on this.
JeffreyStevensJeffreyStevens
Force Techie,

I would be interested in seeing your connection code for the Salesforce to quickbooks.

Thanks,

Jeff
Force TechieForce Techie

Jeffrey,

If you need more assistance on it connect with me in personal at padmesh999@gmail.com.

Thanks!

JeffStevensJeffStevens
Thanks for the link!  I've got the token and the secret returned on my first call!  
Now - when I goto the authorize page - I'm getting Error getting application from request token - do you think that's something on my Intuit developer app?  Does my app have to be in production for me to connect to it?
Thanks 
Force TechieForce Techie
Jeffrey,

Which method are you using for authentication also which endpoint are you using?

Thanks!
JeffreyStevensJeffreyStevens
I got it working.  Thanks for your help.

I was using https://appcenter.intuit.com/Connect/Begin for the endpoint, and oAuth for the method.  I didn't know there was more than one method.
 
Hamad AmaralHamad Amaral
Hi Padmesh, it seems to me you used the QuickBooks API query method to get all Accounts. I did code some classes to get tokens and hit QBO API that work fine but the query method is failing,  I think I have some issue encoding the query param. If you have the possibility would mind share your code?

Thanks in advance.
Force TechieForce Techie
Hi Hamad,

I have used this in with given format of query in QBO guide. I tried for retrieving Invoices as given below query:

Query=SELECT * FROM Invoice

Above query is sending as URL parameter of endpoint in sandbox perspective as below:

https://sandbox-quickbooks.api.intuit.com/v3/company/1292741455/query?query=Select%20%2A%20FROM%20Invoice

We found result from above successfully.

Please let me know, if you have any question.

Thanks!
Hamad AmaralHamad Amaral
Hi Padmesh,

I've been trying that without success, this is the relevante piece of code:
 
public String setSignature() {
	String signatureParams = '';
		
	if(query.length() > 0)
	{
		signatureParams = signatureParams + '&query=' + EncodingUtil.urlEncode(query.toUpperCase(), 'UTF-8').replace('+','%20');
	}
}


	Http h = new Http();
        HttpResponse res = new HttpResponse(); 
        
        HttpRequest req = new HttpRequest();
        req.setMethod('GET');
	req.setHeader('Accept-Encoding','*');
	req.setHeader('Accept','application/xml; charset=UTF-8');
		
	String query = 'select * from Account';

	if(query.length() > 0)
	{
		req.setHeader('content-type','text/plain');
	    req.setBody('query=' + EncodingUtil.urlEncode(query.toUpperCase(), 'UTF-8').replace('+','%20'));
	}
    
    req.setEndpoint('https://quickbooks.api.intuit.com/v3/company/<accountId>/query');

	String oauth_signature = setSignature();
											  
	String oauth = 'oauth_token="' + oauth_token 
			   + '",oauth_nonce="' + oauth_nonce 
			   + '",oauth_consumer_key="' + oauth_consumer_key 
			   + '",oauth_signature_method="' + oauth_signature_method 
			   + '",oauth_timestamp="' + oauth_timestamp 
			   + '",oauth_version="1.0' 
			   + '",oauth_signature="' + oauth_signature + '"';

	req.setHeader('Authorization','OAuth ' + oauth);
		
        res = h.send(req);

That piece of code generates the following:

parameters: oauth_consumer_key=<consumer_key>&oauth_nonce=1458917844&oauth_signature_method=HMAC-SHA1&oauth_timestamp=1458917844&oauth_token=<oauth_token>&oauth_version=1.0&query=SELECT%20ID%2CFULLYQUALIFIEDNAME%20FROM%20ACCOUNT

signature base string encoded: GET&https%3A%2F%2Fquickbooks.api.intuit.com%2Fv3%2Fcompany%2F212106060%2Fquery&oauth_consumer_key%3D<consumer_key>%26oauth_nonce%3D1458917844%26oauth_signature_method%3DHMAC-SHA1%26oauth_timestamp%3D1458917844%26oauth_token%3D<oauth_token>%26oauth_version%3D1.0%26query%3DSELECT%2520ID%252CFULLYQUALIFIEDNAME%2520FROM%2520ACCOUNT

OAuth: oauth_token="<oauth_token>",oauth_nonce="1458917844",oauth_consumer_key="<oauth_consumer_key>",oauth_signature_method="HMAC-SHA1",oauth_timestamp="1458917844",oauth_version="1.0",oauth_signature="ApD4QtHcMpIBQr211tbbqDyMrn8%3D"

Error: "message=ApplicationAuthenticationFailed; errorCode=003200; statusCode=401".

Can you please advise? Thanks in advance.

 
flora davisflora davis


If you are facing any issues regarding Norton, webroot, Bitdefender, Garmin, Rand McNally dock ,Turbotax login ,   you will get an instant online solution. For more details visit this link which is given below:
http://www.nortoncom-setupz.com/
http://www.nortoncom-setupz.com/norton-com-nu16/
http://www.nortoncom-setupz.com/norton-account/
http://www.nortoncom-setupz.com/norton-login/
http://www.nortoncom-setupz.com/norton-download/
http://www.nortoncom-setupz.com/norton-activate/
http://www.nortoncom-setupz.com/help/how-does-norton-security-app-lock-protect-your-device/
http://www.nortoncom-setupz.com/how-to/how-to-use-norton-power-eraser-to-scan-you/
http://www.nortoncom-setupz.com/help/norton-safe-web/
http://www.nortoncom-setupz.com/help/norton-360-lifelock/
http://bitdefender-centrals.com/
http://bitdefender-centrals.com/support/bitdefender-mobile-security-for-android-devices/
http://bitdefender-centrals.com/bitdefender-login/
http://bitdefender-centrals.com/support/5-most-common-bitdefender-issues-and-how-to-solve-them/
http://bitdefender-centrals.com/support/fix-a-problem-has-occurred-in-bitdefender-threat-scanner/
http://bitdefender-centrals.com/support/bitdefender-setup-has-encountered-an-error/
http://www.garmincomexpressz.com/
http://garmincomexpressz.com/garmin-express/
http://garmincomexpressz.com/garmin-update/
http://garmincomexpressz.com/what-is-garmin-connect/ - new
http://www.webrootcomsafex.com/
http://www.webrootcomsafex.com/webroot-login/
http://www.webrootcomsafex.com/webroot-download/
http://www.webrootcomsafex.com/webroot-reinstall/
http://www.webrootcomsafex.com/support/webroot-filtering-extension/
http://www.webrootcomsafex.com/enter-webroot-keycode/
http://www.webrootcomsafex.com/support/webroot-secureanywhere-antivirus/
http://randmcnallydockz.com/
http://randmcnallydockz.com/rand-mcnally-update/
http://randmcnallydockz.com/how-to-update-rand-mcnally-tnd-740/
http://malwarebytesloginz.com/
http://malwarebytesloginz.com/malwarebytes-download/
http://malwarebytesloginz.com/malwarebytes-support/
http://myturbotaxlogin.com/
http://myturbotaxlogin.com/turbotax-sign-in/ 
http://myturbotaxlogin.com/turbotax-support/
http://myturbotaxlogin.com/turbotax-download/
http://sites.google.com/d/1cvynpifA7bURrV3j7roX-l3zdgSCm4dU/p/1rh4K7jPqSzXOvRcEDK6UYTqdxnb0EI6j/edit
http://myturbotaxlogin.com/how-to-correct-federal-tax-returns/
flora davisflora davis
Find a counselor and talk confidentially with Vcaretherapy online therapy (http://vcaretherapy.com/) services, anyone can get therapy without traveling to any place.

An Existential Crisis (http://vcaretherapy.com/what-is-existential-crisis-and-why-do-we-need-help/)occurs when a person has survivor&#039;s guilt or start thinking life is meaningless, contact our expert team that help to cope with this

 
flora davisflora davis
Ij.start.cannon (http://ijstartcanonn.com/)Previous Next Enter Printer Model Download Driver Install into your System Process to Establish a Wifi Connection on Your Canon Printer Before accessing ij.start.cannon, your printer must be well-connected to the Wifi. So, take a look at the full-proof steps that are given below: Wireless LAN Setup: To commence the network configuration process, you &help

Garmin.com/Express (http://garmincomexpress.live/) - Download, Register, Setup, Update and Manage your Garmin Devices Online from the link www.garmin.com/express (http://garmincomexpress.live/)
Deepika Chauhan 17Deepika Chauhan 17
Hi,
Now you can easily integrate Salesforce and Quickbooks online together through third-party applications.
I recommend you to check out this application: https://eshopsync.com/quickbooks/
For more concerns, please reach out to me via an email: support@eshopsync.com

Thanks
Deepika
nishtha singh 4nishtha singh 4

How to Setup Belkin Extender ? by using 192.168.206.1 (https://belkinrangesetup-extender.com/)
nishtha singh 4nishtha singh 4

If you are having Pogo.com issues such as the servers being down, games not loading etc then please visit
pogo.com not working (https://mypogosupport.com/is-pogo-down-fix-not-working/)