def test_get_record_dict_simple_summary(self): report = ReportParser(self.build_mock_report('summary_basic_single_group')) records = report.records_dict() field_value = records[0]["Created Date"] self.assertEquals(len(records), 13) self.assertIsNotNone(field_value)
def test_get_record_dict_simple_tabular(self): report = ReportParser(self.build_mock_report('tabular_basic')) records = report.records_dict() field_value = records[0]["Mailing Street"] self.assertEquals(len(records), 20) self.assertIsNotNone(field_value)
def test_get_record_dict_simple_tabular(self): report = ReportParser(self.build_mock_report('tabular_basic')) records = report.records_dict() field_value = records[0]["Mailing Street"] self.assertEquals(len(records), 20) self.assertIsNotNone(field_value)
def test_get_record_dict_simple_summary(self): report = ReportParser( self.build_mock_report('summary_basic_single_group')) records = report.records_dict() field_value = records[0]["Created Date"] self.assertEquals(len(records), 13) self.assertIsNotNone(field_value)
def load_report(report_id, sf): report_details = sf.get_report(report_id) parser = ReportParser(report_details) report = parser.records_dict() df = pd.DataFrame(report) while report_details["allData"] == False: existing_ids = ",".join(list(df["18 Digit ID"])) reportFilter = [{ "value": f"{existing_ids}", "operator": "notEqual", "column": "Contact.X18_Digit_ID__c", }] report_details = sf.get_report(report_id, filters=reportFilter) _parser = ReportParser(report_details) _report = _parser.records_dict() _df = pd.DataFrame(_report) df = df.append(_df, ignore_index=True) return df
def load_report(report_id, sf): report = sf.get_report(report_id) parser = ReportParser(report) report = parser.records_dict() report = pd.DataFrame(report) return report