environment='sandbox', redirect_uri='http://localhost:5000/callback', ) url = auth_client.get_authorization_url(scopes=[Scopes.ACCOUNTING]) print("finished authorizing...") print('running api call...' + url) client = QuickBooks( auth_client=auth_client, refresh_token=REFRESH_TOKEN, company_id=COMPANY_ID, ) print('finished connecting') last_year_sales = SalesReceipt.query(f"SELECT * FROM salesreceipt where TxnDate > '2018-12-01' and TxnDate < '2019-06-01' MAXRESULTS 1000", qb=client) last_years_customer_sales = {} #print(f"Scout, Customer, Phone, Email") for sale in last_year_sales: #print(f"LastCustomerName: {sale.CustomerRef.name}, LastCustomerID:{sale.CustomerRef.value}") last_years_customer_sales.update({sale.CustomerRef.value: sale.ClassRef}) # Now get this year sales this_year_sales = SalesReceipt.query(f"SELECT * FROM salesreceipt where TxnDate > '2019-12-01' and TxnDate < '2020-06-01' MAXRESULTS 1000", qb=client) #cnt = 0 this_years_customer_sales = {} for sale in this_year_sales: #cnt += 1
environment='sandbox', redirect_uri='https://developer.intuit.com/v2/OAuth2Playground/RedirectUrl', ) url = auth_client.get_authorization_url(scopes=[Scopes.ACCOUNTING]) print("finished authorizing...") print('running api call...' + url) client = QuickBooks( auth_client=auth_client, refresh_token=REFRESH_TOKEN, company_id=COMPANY_ID, ) print('finished connecting') sales = SalesReceipt.query(f"SELECT * FROM salesreceipt where MetaData.CreateTime > '2019-12-01' MAXRESULTS 1000", qb=client) cnt = 0 print(f"Scout, Customer, Phone, Email") for sale in sales: cnt += 1 scout = sale.CustomField[0].StringValue if len(scout) == 0: scout = "none" else: scout = scout.replace(',',': ') customer = Customer.get(sale.CustomerRef.value, qb=client) print(f"{scout},{customer.DisplayName},{customer.PrimaryPhone},{customer.PrimaryEmailAddr}")