• Nancy rai
  • NEWBIE
  • 0 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 6
    Replies
Hi All,
We have a requirement to load Salesforce data to Azure SQL DB by developing an Azure Application. I have no knowledge of Azure but with strong experiece of C# and SQL.
Can someone please give me some ideas where to start regarding Salesforce/Azure integration?

Thanks,
David
 
Hi,
Pleae let the useage of  chatter api
 
Now i'm using rest api to connect with DOTNET  application, 

is that passible to salesforce to do the same integraion 

Hi there,

 

Does anybody know how to create a unit test for this code below? I came across this when looking for a way to run my Informatica Cloud task in Salesforce remotely. Thanks in advance for the help!

 

Eric

 

public with sharing class OrderIntegration {

    @future (callout=true) 

    public static void runjob(String username, String password, String jobName, String jobType) {

        HttpRequest req = new HttpRequest();
        HttpResponse res = new HttpResponse();
        Http http = new Http(); 

        req.setEndpoint('https://app.informaticaondemand.com/saas/api/1/runjob');
        req.setMethod('POST');
        req.setBody('username='+EncodingUtil.urlEncode(username, 'UTF-8')+
                           '&password='+EncodingUtil.urlEncode(password, 'UTF-8')+
                           '&jobName='+EncodingUtil.urlEncode(jobName, 'UTF-8')+
                           '&jobType='+EncodingUtil.urlEncode(jobType, 'UTF-8')); 

        try {
            res = http.send(req);
           }
           catch(System.CalloutException e) {
            System.debug('Job Error: '+ e);
            System.debug(res.toString());
        } 

    } 

}

Hi,

 

Any body know about how to integrate salesforce with survey monky

please send user gude or document.

 

 

Thank you

Hello,

 

I was hoping someone could post an example of a amazon s3 REST delete method that has worked. Does versioning need to be enabled for REST delete to work?

 

OR possibly spot whats wrong with this?

 

 

public pageReference deleteMode(){
    queryResults = [select ID,
                           file_name__c,
                           file_ID__c,
                           matter_number__c,
                           client_number__c,
                           fileURL__c
                    from input_form__c
                    where ID = :inputFormID];
                    
    input_form__c ifc = queryResults[0];

    fileURL = ifc.fileURL__c;

    String dateString = Datetime.now().formatGmt('EEE, dd MMM yyyy HH:mm:ss Z');

    stringToSign = 'DELETE\n' +
                   '\n' +
                   '\n' +
                   dateString + '\n' +
                   ('/xxxx' + fileURL).replaceAll(' ', '');

    //stringToSign = stringToSign.replaceAll(' ', '%20');

    System.debug('FINDME::stringToSign - ' + stringToSign);
    Blob mac = Crypto.generateMac('hmacSHA1',  Blob.valueOf(stringToSign), Blob.valueOf('xxxx'));
    stringToSign = EncodingUtil.base64Encode(mac);

    //String encoded = EncodingUtil.urlEncode(stringToSign, 'UTF-8'); 

    HttpRequest con = new HttpRequest();
    con.setHeader('Authorization','AWS xxxx:' + stringToSign);
    con.setEndPoint('http://xxxx.s3.amazonaws.com' + fileURL);
    con.setHeader('Host','xxxx.s3.amazonaws.com');

    con.setHeader('Date', dateString);
    con.setMethod('DELETE');
    
    Http http = new Http();
    HTTPResponse res = http.send(con);

    System.debug('RES.GETBODY: ' + res.getBody() + ' RES.GETSTATUS: ' + res.getStatus() + ' CON.GETENDPT: ' + con.getEndPoint());

    if (res.getStatusCode() >= 400) {
delete ifc;
}       

return null;
    }



res.getBody() is empty and res.getStatus is 'no content' which I think makes sense since its delete. But the file never gets deleted from s3.

 

Thanks!

 

Max

Hi friends,

 

I need some information about the integration of Salesforce and SQL server using Sql Server Integration Services. If you have done it before in you rprojects. Could you please share the following information with me:-

 

1. Challenges faced

2. Complexity of the Integration

3. Sample Code

4. Level of Coding Required

5. New functionality you came acsross

 

If you could also share the details about your the project and the type of integration that will also be helpful.