Guest User

Untitled

a guest
Oct 5th, 2018
224
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. SELECT (SELECT CallDurationInSeconds, CallData__c, Closed_After_DueDate__c,
  2. Reminder_Date_Time_LEX__c, PrimaryWhoId, Current_User_Assigned__c, LastModifiedById,
  3. Time_taken_to_Close_the_Task__c, Priority, Location, CallObject, OwnerId, IsAllDayEvent,
  4. AdCentralActivityId__c, Status, CallDisposition, Description, ActivitySubtype,
  5. LastModifiedDate, ActivityType, Original_Due_Date__c, Task_Closed_Date__c, Push_Counter__c,
  6. WhoId, WhatId, ActivityDate, CurrencyIsoCode, dnis__c, IsHighPriority, IsDeleted,
  7. AccountId, CallType, Call_Recording__c, EndDateTime, DurationInMinutes, IsVisibleInSelfService,
  8. CreatedById, StartDateTime, PrimaryAccountId, IsReminderSet, SFDC_Active__c, IsClosed,
  9. ReminderDateTime, SystemModstamp, CreatedDate, IsTask, AlternateDetailId, Id,
  10. Activity_Type__c FROM ActivityHistories WHERE SystemModstamp >= 2018-10-04T00:00:00Z
  11. and SystemModstamp
  12. < 2018-10-05T00:00:00Z
  13. ) FROM Account
  14.  
  15. sf = Salesforce(security_token='token', username='uname', password='pwd', instance_url='https://company.my.salesforce.com')
  16. result = sf.query(query_input)
  17. df = pd.DataFrame.from_dict(result['records'])
  18. df.drop('attributes', 1, inplace=True)
  19. df['row_hash'] = df.apply(lambda x: hash(tuple(x)), axis=1)
Add Comment
Please, Sign In to add comment