def _salesforce_import(self, session_id, instance, user, user_company):
#print session_id, instance, user, user_company
#SESSION_ID = "00Dj0000001neXP!AQUAQIbUn9RsdTZH6MbFA7qaPtDovNU75.fOC6geI_KnEhJKyUzk2_yFx2TXgkth7zgFuJThY6qZQwH7Pq4UtlcW.Cq0aHt1"
print instance
print instance.replace("https://","")
sf = Salesforce(instance=instance.replace("https://",""),
session_id=session_id)
lol = sf.query_all("SELECT Id, Name, Email FROM Contact")
sf = pd.DataFrame(pd.DataFrame(lol).records.tolist())
sf = sf[["Name","Email"]]
sf.columns = ["name","email"]
sf = sf.dropna()
sf["domain"] = [i.split("@")[-1] if i else "" for i in sf.email]
sf["source"] = "salesforce"
sf["db_type"] = "crm"
sf["user"] = [Parse()._pointer("_User", user) for i in sf.index]
sf["user_company"] = [Parse()._pointer("UserCompany",user_company)
for i in sf.index]
Parse()._batch_df_create("UserContact", sf)
Prospecter()._batch_df_create("UserContact", sf)
print Prospecter().update("_User/"+user,
{"salesforce_integration":arrow.utcnow().timestamp,
"salesforce_token":session_id}).json()
