Retrieve QuickBooks IDs for all Customers

Integration Export can be used to retrieve QuickBooks IDs by navigating to Setup > Integrations > Quickbooks > Customers > More > Export. The third page provides all QBO IDs and names.

Or use the QuickBooks developer tools to retrieve all QuickBooks Customer IDs: 

Steps: 

1. Click API Docs and select API Explorer. 
2. Select environment from the drop-down menu. 
3. Click Customer on the left hand side. 
4. Then click Query a Customer. 
5. Click Try It on the basic query. 
6. Add "MAXRESULTS 1000" at the end of the query, because by default QBO returns only 100 records. This edit provides up to 1000 records.

   Example: Select * from Customer Where Metadata.LastUpdatedTime > '2015-03-01' MAXRESULTS 1000.  If more then 1000 records, use the date range to get the results in batches by using the created date:

   Example: Select * from Customer WHERE MetaData.CreateTime >= '2020-01-01T00:00:00-00:00' AND MetaData.CreateTime <= '2020-06-01T00:00:00-00:00' MAXRESULTS 1000.

7. Copy and paste the resulting list and convert it to  CSV.