Forum Discussion

Jonwig's avatar
Jonwig
Frequent Visitor
3 years ago
Solved

Salesforce Marketing Cloud SOAP issue - ContinueRequest

I'm running SOAP calls to Salesforce Marketing Cloud inside Power Query.   In Salesforce marketing cloud we have more than alot 2,500 records, so for querying the data we need to use ContinueReques...
  • ams1's avatar
    3 years ago

    Hi Jonwig ,

     

    I see no activity on this for a while - do you still thave the problem?

     

    If you still have the problem, my first question is: have you considered moving to REST API instead of SOAP?

     

    If we navigate to the SOAP API documentation https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/web_service_guide.html  I think the first thing we'll see is a recommendation to use REST API (see below):

    Marketing Cloud has a new model for storing, finding, managing, creating, sharing, and distributing all content-related objects. Access the objects created with the new Content Builder tools using the REST API. Your existing SOAP API integrations only function with the Classic tools in Marketing Cloud.

     

    If you still have a problem and insist on using SOAP, then please say so and I'll try to have a look.

  • Jonwig's avatar
    3 years ago

    Thanks for the reply,

     

    We didn't manage to solve the problem internally in PowerBI so bought some third party ODBC drivers before we invested too much time in building our own. These are working quite nicely, just had an additional cost.

    For anyone interested in the future, there are two options we found Cdata and Devart. Both worked with our tests desktop and server side. We went with Devart due to the pricing model.

     

    Kind regards,

     

    Jon