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
