GrowthLink Sync Script

gistfile1.txt

//SYNC UP WHERE CASE AND ISSUE EXIST

// Call Schema to get the report metadata
Reports.ReportMetadata reportMd = Reports.ReportManager.describeReport('00O3c000007LMmHEAW').getReportMetadata();
// Run the report and store the rows in a Reports.ReportFactWithDetail object 
Reports.ReportFactWithDetails factDetails = (Reports.ReportFactWithDetails)Reports.ReportManager.runReport('00O3c000007LMmHEAW', reportMd, true).getFactMap().get('T!T');
// For each row the report returns, update the Case
for(Reports.ReportDetailRow detailRow : factDetails.getRows()){
    HttpRequest req = new HttpRequest();
    req.setHeader('Authorization', 'Bearer ' + UserInfo.getSessionID());
    req.setHeader('Content-Type','application/json');
    req.setEndpoint('https://growthlinkhca.my.salesforce.com/services/data/v51.0/sobjects/Issue__c/'+Id.ValueOf(String.ValueOf(detailRow.getDataCells()[0].getLabel())));
    req.setBody('{}');
    req.setMethod('PATCH');
    req.setTimeout(120000);
    Http h = new Http();
    HttpResponse res = h.send(req);
    system.debug(req.getEndpoint());
    system.debug(res.getStatusCode());
    system.debug(res.getBody());
    req.setEndpoint('https://growthlinkhca.my.salesforce.com/services/data/v51.0/sobjects/Case/'+Id.ValueOf(String.ValueOf(detailRow.getDataCells()[1].getLabel())));
    res = h.send(req);
    system.debug(req.getEndpoint());
    system.debug(res.getStatusCode());
    system.debug(res.getBody());
}

//USE ANOTHER REPORT TO CATCH STRAGGLERS
// Call Schema to get the report metadata
reportMd = Reports.ReportManager.describeReport('00O3c000007v2BPEAY').getReportMetadata();
// Run the report and store the rows in a Reports.ReportFactWithDetail object 
factDetails = (Reports.ReportFactWithDetails)Reports.ReportManager.runReport('00O3c000007v2BPEAY', reportMd, true).getFactMap().get('T!T');
// For each row the report returns, update the Case
for(Reports.ReportDetailRow detailRow : factDetails.getRows()){
    HttpRequest req = new HttpRequest();
    req.setHeader('Authorization', 'Bearer ' + UserInfo.getSessionID());
    req.setHeader('Content-Type','application/json');
    req.setEndpoint('https://growthlinkhca.my.salesforce.com/services/data/v51.0/sobjects/Issue__c/'+Id.ValueOf(String.ValueOf(detailRow.getDataCells()[0].getLabel())));
    req.setBody('{}');
    req.setMethod('PATCH');
    req.setTimeout(120000);
    Http h = new Http();
    HttpResponse res = h.send(req);
    system.debug(req.getEndpoint());
    system.debug(res.getStatusCode());
    system.debug(res.getBody());
    req.setEndpoint('https://growthlinkhca.my.salesforce.com/services/data/v51.0/sobjects/Case/'+Id.ValueOf(String.ValueOf(detailRow.getDataCells()[1].getLabel())));
    res = h.send(req);
    system.debug(req.getEndpoint());
    system.debug(res.getStatusCode());
    system.debug(res.getBody());
}

//SYNC UP WHERE CASE DOES NOT EXIST

// Call Schema to get the report metadata
reportMd = Reports.ReportManager.describeReport('00O3c000007uvWzEAI').getReportMetadata();
// Run the report and store the rows in a Reports.ReportFactWithDetail object 
factDetails = (Reports.ReportFactWithDetails)Reports.ReportManager.runReport('00O3c000007uvWzEAI', reportMd, true).getFactMap().get('T!T');
// For each row the report returns, update the Case
for(Reports.ReportDetailRow detailRow : factDetails.getRows()){
    HttpRequest req = new HttpRequest();
    req.setHeader('Authorization', 'Bearer ' + UserInfo.getSessionID());
    req.setHeader('Content-Type','application/json');
    req.setEndpoint('https://growthlinkhca.my.salesforce.com/services/data/v51.0/sobjects/Issue__c/'+Id.ValueOf(String.ValueOf(detailRow.getDataCells()[0].getLabel())));
    req.setBody('{}');
    req.setMethod('PATCH');
    req.setTimeout(120000);
    Http h = new Http();
    HttpResponse res = h.send(req);
    system.debug(req.getEndpoint());
    system.debug(res.getStatusCode());
    system.debug(res.getBody());
}