Update app.py

app.py

@@ -130,25 +130,46 @@ def create_salesforce_reports(df):
         usage_report_metadata = {
             "reportMetadata": {
                 "name": f"SmartLog_Usage_Report_{datetime.now().strftime('%Y%m%d_%H%M%S')}",
-                "reportType": "SmartLog__c",
+                "developerName": f"SmartLog_Usage_Report_{datetime.now().strftime('%Y%m%d_%H%M%S')}",
+                "reportType": {
+                    "type": "CustomObject",
+                    "value": "SmartLog__c"
+                },
                 "reportFormat": "SUMMARY",
+                "reportBooleanFilter": None,
                 "reportFilters": [
-                    {"column": "Status__c", "operator": "equals", "value": "Active"},
-                    {"column": "Timestamp__c", "operator": "greaterOrEqual", "value": "THIS_MONTH"}
-                ],
-                "reportColumns": [
-                    {"field": "Device_Id__c"},
-                    {"field": "Log_Type__c"},
-                    {"field": "Status__c"},
-                    {"field": "Timestamp__c"},
-                    {"field": "Usage_Hours__c", "aggregateTypes": ["Sum"]},
-                    {"field": "Downtime__c", "aggregateTypes": ["Sum"]},
-                    {"field": "AMC_Date__c"}
+                    {
+                        "column": "SmartLog__c.Status__c",
+                        "operator": "equals",
+                        "value": "Active"
+                    },
+                    {
+                        "column": "SmartLog__c.Timestamp__c",
+                        "operator": "greaterOrEqual",
+                        "value": "THIS_MONTH"
+                    }
                 ],
+                "aggregates": ["s!SmartLog__c.Usage_Hours__c", "s!SmartLog__c.Downtime__c"],
                 "groupingsDown": [
-                    {"field": "Device_Id__c", "sortOrder": "Asc", "dateGranularity": "None"}
+                    {
+                        "name": "Device_Id__c",
+                        "field": "SmartLog__c.Device_Id__c",
+                        "sortOrder": "Asc",
+                        "sortAggregate": None,
+                        "dateGranularity": "None"
+                    }
+                ],
+                "detailColumns": [
+                    "SmartLog__c.Device_Id__c",
+                    "SmartLog__c.Log_Type__c",
+                    "SmartLog__c.Status__c",
+                    "SmartLog__c.Timestamp__c",
+                    "SmartLog__c.Usage_Hours__c",
+                    "SmartLog__c.Downtime__c",
+                    "SmartLog__c.AMC_Date__c"
                 ],
-                "folderId": LABOPS_REPORTS_FOLDER_ID
+                "folderId": LABOPS_REPORTS_FOLDER_ID,
+                "currency": None
             }
         }
         usage_result = sf.restful('analytics/reports', method='POST', json=usage_report_metadata)
@@ -159,19 +180,37 @@ def create_salesforce_reports(df):
         amc_report_metadata = {
             "reportMetadata": {
                 "name": f"SmartLog_AMC_Reminders_{datetime.now().strftime('%Y%m%d_%H%M%S')}",
-                "reportType": "SmartLog__c",
+                "developerName": f"SmartLog_AMC_Reminders_{datetime.now().strftime('%Y%m%d_%H%M%S')}",
+                "reportType": {
+                    "type": "CustomObject",
+                    "value": "SmartLog__c"
+                },
                 "reportFormat": "TABULAR",
+                "reportBooleanFilter": None,
                 "reportFilters": [
-                    {"column": "Status__c", "operator": "equals", "value": "Active"},
-                    {"column": "AMC_Date__c", "operator": "greaterOrEqual", "value": "TODAY"},
-                    {"column": "AMC_Date__c", "operator": "lessOrEqual", "value": "NEXT_N_DAYS:30"}
+                    {
+                        "column": "SmartLog__c.Status__c",
+                        "operator": "equals",
+                        "value": "Active"
+                    },
+                    {
+                        "column": "SmartLog__c.AMC_Date__c",
+                        "operator": "greaterOrEqual",
+                        "value": "TODAY"
+                    },
+                    {
+                        "column": "SmartLog__c.AMC_Date__c",
+                        "operator": "lessOrEqual",
+                        "value": "NEXT_N_DAYS:30"
+                    }
                 ],
-                "reportColumns": [
-                    {"field": "Device_Id__c"},
-                    {"field": "AMC_Date__c"},
-                    {"field": "Status__c"}
+                "detailColumns": [
+                    "SmartLog__c.Device_Id__c",
+                    "SmartLog__c.AMC_Date__c",
+                    "SmartLog__c.Status__c"
                 ],
-                "folderId": LABOPS_REPORTS_FOLDER_ID
+                "folderId": LABOPS_REPORTS_FOLDER_ID,
+                "currency": None
             }
         }
         amc_result = sf.restful('analytics/reports', method='POST', json=amc_report_metadata)