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