Skip to main content
Topics#IntegrationPregunta de Kelvin Tian
Kelvin Tian (Superceed) preguntó en #Integration
23 may 2021, 17:22

I use called in before using dml still error like this shows System.CalloutException: You have uncommitted work pending. Please commit or rollback before calling out

List <Case> lstSub =[Select Subject from Case];

for (Case Subject : lstSub){

    String capSubject= Subject.Subject;

    String newcapSubject = '\''+ capSubject + '\'';

    String reform = capSubject.replaceAll('\\s','%20');

    String url =('http://wauchat.com:5000/emotion/en/');

    url = url+reform;

    Http http = new Http();

    HttpRequest request = new HttpRequest();

    request.setEndpoint(url);

    request.setMethod('GET');

    HttpResponse response = http.send(request);

    if (response.getStatusCode() == 200) {

        Map<String, Object> results = (Map<String, Object>) JSON.deserializeUntyped(response.getBody());

        Object result = results.get('result');

        try {

            Case subUpdate = [Select Emotion__c from Case WHERE Subject= :capSubject LIMIT 1];

            System.debug(subUpdate);

            subUpdate.Emotion__c = (String)result;

            update subUpdate;

    } catch(Exception e) {

            System.debug('An unexpected error has occurred: ' + e.getMessage());

    }

    }

    

}

 
1 respuesta
Escribir una respuesta...
0/9000