How to execute a SQL query against Salesforce marketing cloud using SOAP API?

Question

I am a new SOAP API user trying to access Salesforce marketin cloud. My requirement is to execute a query to pull records from the _Job dataview present in salesforce marketing cloud as below:

select * from _Job

The SOAP API documentation has the following method available.

System.String query = Query(QueryRequest, RequestID, Results)

I did not find any sample code to build the QueryRequest. Please help me creating the QueryRequest and executing it.

Additionally the following link describes how to create and perform a query using QueryDefinition Object here:

https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/creating_a_query_activity.htm

How do I define the TargetType for QueryDefinition? The example uses a value DE and executes the query to populate a data extension. What other values can be specified and used. For instance, is there a value to export the result to a file? If yes, how do I achieve that?

Thanks in advance.

John Rhoads · Accepted Answer · 2019-02-21 18:11:39Z

1

The system views (prefixed with underscore) aren't available to the API. I would suggest you create a data extension that is Select * from _Send and then run the api against that DE.

answered Feb 21, 2019 at 18:11

John Rhoads

261 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Meenakshi Dash Over a year ago

Hi John! I have posted another related question and here is the link to it. stackoverflow.com/questions/54815433/… . I will appreciate it if you can answer this. Thank you.

Collectives™ on Stack Overflow

How to execute a SQL query against Salesforce marketing cloud using SOAP API?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related