Author Details



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. 


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


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 ( 

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 In this example company ID is 4620816365208485510 so replace {{companyid}} with your company ID. 

is updated to 

If you are accessing a production QBO environment replace {{baseurl}} with 

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 
Auth URL 
Access Token URL 
Client ID  [Your QuickBooks Online app Client ID]  
Client Secret  [Your QuickBooks Online app Client Secret] 
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 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 
Token URL 
Refresh URL (same as Token URL) 

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