Quickbooks Online Search For Bills Returning Only Paid Bills

How To
1

I am trying to grab all my UNPAID bills only from Quickbooks Online. When I run the following scenario, it provides all of my paid bills only. Do I need to use a query to grab the unpaid bills? I’m afraid a query won’t work when the current results return only paid bills. What am I missing? If I need a query, where can I learn what the options are for queries as it relates to quickbooks online variables?

image
image1300×632 85.7 KB

2

Welcome to the Make community!

According to the official Make documentation on QuickBooks, it says:

Simply click on the “Data queries documentation” link to learn more.

For more information, see the QuickBooks page in the Make Help Centre, which covers the following:

  • Connect QuickBooks to Make
  • Invoice
  • Bill
  • Sales Receipt
  • Estimate
  • Journal Entry
  • Payment
  • Deposit
  • Credit Memo
  • Customers
  • Purchase Orders
  • Item
  • Vendor
  • File
  • Account
  • Purchase
  • Time Activity
  • Refund Receipt
  • Events
  • Other
  • Common Issues

and also,

  • Create Custom App and Client Credentials in QuickBooks
  • Create an Invoice
  • Update an Invoice
  • Delete an Invoice
  • Get an Invoice
  • Search for Invoices
  • Download an Invoice
  • Send an Invoice
  • Create a Bill
  • Update a Bill
  • Delete a Bill
  • Get a Bill
  • Search for Bills
  • Create a Sales Receipt
  • Update a Sales Receipt
  • Get a Sales Receipt
  • Search for Sales Receipts
  • Download a Sales Receipt
  • Send a Sales Receipt
  • Create an Estimate
  • Update an Estimate
  • Delete an Estimate
  • Download an Estimate
  • Send an Estimate
  • Get an Estimate
  • Search for Estimates
  • Create a Journal Entry
  • Update a Journal Entry
  • Delete a Journal Entry
  • Get a Journal Entry
  • Search for Journal Entries
  • Create Payment
  • Update a Payment
  • Delete a Payment
  • Watch Payments
  • Download a Payment
  • Send a Payment
  • Get a Payment
  • Search for Payments
  • Create a Deposit
  • Update a Deposit
  • Delete a Deposit
  • Get a Deposit
  • Search for Deposits
  • Create a Credit Memo
  • Update a Credit Memo
  • Delete a Credit Memo
  • Get a Credit Memo
  • Search for Credit Memos
  • Create a Customer
  • Update a Customer
  • Get a Customer
  • Search for Customers
  • Create a Purchase Order
  • Update a Purchase Order
  • Get a Purchase Order
  • Search for Purchase Orders
  • Delete a Purchase Order
  • Create an Item
  • Update an Item
  • Get an Item
  • Search for Items
  • Create a Vendor
  • Update a Vendor
  • Get a Vendor
  • Search for Vendors
  • Create a Text Attachment
  • Upload a File
  • Download a File
  • Delete an Attachment
  • Search for Attachments
  • Create an Account
  • Update an Account
  • Get an Account
  • Search for Accounts
  • Create a Purchase
  • Update a Purchase
  • Delete a Purchase
  • Get a Purchase
  • Search for Purchases
  • Create a Time Activity
  • Update a Time Activity
  • Get an Time Activity
  • Search for Time Activity
  • Create a Refund Receipt
  • Update a refund Receipt
  • Get a Refund Receipt
  • Search for Refund Receipts
  • New Event
  • Get My Company
  • Make an API Call
  • New invoice number

You should also take note of the following important details:

  • Fields that are left empty will be omitted (not updated).

  • You must unlink any linked transactions associated with the invoice object before deleting it.

  • Do not enter the maxresults directive. Make will add it automatically for you.

  • QuickBooks webhooks are usually a bit delayed

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

3

I looked at that documentation but I still do not see specifics on how to only return unpaid bills. Is there documentation somewhere else that is more detailed and specific on what can be used in the query?