Author Details

avatar-teacher

Evolvous

We are a team of tech enthusiast and this section is where we love to share our experience and our knowledge. We try our best to help you understand technical topics by giving you live instances of how-to’s, guides, tips, FAQ’s and troubleshoots.

If you like it or have questions, do share your feedback in the comments section below.

Get data from QuickBook in Power Automate using a custom connector 

In this blog, we learn how to connect to accounting data in QuickBook Online (QBO) in a Power Automate using a Custom Connector. This approach provides a way to access QBO data in Microsoft PowerApps for things like recording employees timesheets, creating invoices, etc. 

Prerequisites 

    – A trial subscription works as long as it includes Microsoft PowerApps and Microsoft Flow.

Steps: 

1. Create Postman Collection

Start by importing the Postman collection found on the Intuit Developer website into Postman.
Set up and test queries in Postman (intuit.com) 

Download one of the Postman collections. Collections give you sets of pre-built requests to test with. 

2. Use collections in Postman 

You can now see the imported collection in Postman. 

Use collections in Postman Quickbook in power automate - Evolvous

Create a new collection and copy an API that you want like Customer-ReadAll in into your new collection using dragdrop. I have added two requests to my new collection. 

After that replace the variables in the URL with specific values. We are accessing a sandbox environment so {{baseurl}} should be sandbox-quickbooks.api.intuit.com. In this example company ID is 4620816365208485510 so replace {{companyid}} with your company ID. 

https://{{baseurl}}/v3/company/{{companyid}}/query?minorversion={{minorversion}}
is updated to  

https://sandbox-quickbooks.api.intuit.com/v3/company/4620816365208485510/query?minorversion=8 

If you are accessing a production QBO environment replace {{baseurl}} with quickbooks.api.intuit.com 

3. Get New Access Token 

In Postman, on the Authorization tab, we need to set up the access token for that set the values as below in related fields. 

Quickbook in Power Automate using Connector - Evolvous

———————————————————————————————–

Quickbook in Power Automate - Evolvous

———————————————————————————————–

Callback URL  https://www.getpostman.com/oauth2/callback 
Auth URL  https://appcenter.intuit.com/connect/oauth2 
Access Token URL  https://oauth.platform.intuit.com/oauth2/v1/tokens/bearer 
Client ID  [Your QuickBooks Online app Client ID]  
Client Secret  [Your QuickBooks Online app Client Secret] 
Scope  com.intuit.quickbooks.accounting 
State  1 

Click on the Get New Access Token button, It will ask for signing in. proceed with steps and it will generate an access token for you. 

4. Query

The query is in the Body tab. Click on the Send button and check the result. 

Query - Evolvous

 

5. Export collection 

Export Collection Power Automate - Evolvous

Navigate to PowerApps in Office 365. Create a custom connection by importing a Postman collection just exported. 

Enter the collection name and select the file to import in the following popup. Click on Continue.

Enter the collection name and select the file to import in the following popup - Evolvous

Configure General settings in the next step. 

Enter sandbox-quickbooks.api.intuit.com in Host 

Configure Security setting by adding following values wherever applicable. 

Client ID  [Your QuickBooks Online app Client ID]  
Client Secret  [Your QuickBooks Online app Client Secret] 
Authorization URL  https://appcenter.intuit.com/connect/oauth2 
Token URL  https://oauth.platform.intuit.com/oauth2/v1/tokens/bearer 
Refresh URL (same as Token URL)  https://oauth.platform.intuit.com/oauth2/v1/tokens/bearer 
Scope  com.intuit.quickbooks.accounting  

Check the Definition setting and create the connector. 

In the Test tab, Click on New connection to create the connection for this custom connector and test a sample API operation. 

After successfully being created, we can access this connector in Power Automate. For example, If You want to read all customer data then it can be done using below.

Select custom connector, you just created from all available. 

———————————————————————————————–

Click save and test the flow. You can use whatever API you want using this way from QuickBooks. 

====

Plus read

Power Automate Desktop to Power Automate Flow