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}")
