Contents
How to perform SQL query activity using SOAP API?
This page contains information about performing an SQL query activity using the SOAP API. You can use the SOAP API to perform existing query activities and return any data the activity may return. You must create the query activity in Marketing Cloud before you can use the API to perform the activity.
How to identify query activity with specified objectId?
Identify your query activity with the specified ObjectID. Use the sample code below as a model for your own code:
How to check the status of a query activity?
The response to your request includes the TaskID, which you can use as a filter with the AsyncActivityStatus object to retrieve the status of the query activity.
How to create soap requests for Data Extensions?
Open a new tab in Postman by clicking the + button. We will be using SOAP requests for all of our Data Extension needs. Start by changing the request method to POST again.
How to call a soap webservice in SQL Server?
I also read lots of articles about solving it with CLI or the “Web Service Task Editor”, or “SSIS” bit I couldn’t find any tutorials about where to start. Right now I only have Microsoft SQL server management studio.
How to create data extensions in Marketing Cloud?
Create a new package. The name you choose for this package will show up as the “Created By” name on the Data Extensions, so keep that in mind when you choose a name. After the Package is created, select Add Component. Choose Server-to-Server as the API type and authorize the component for at least Read and Write under Data Extensions.
How does the start time work in startquery?
The beginning of the time range to query. The range is inclusive, so the specified start time is included in the query. Specified as epoch time, the number of seconds since January 1, 1970, 00:00:00 UTC. Valid Range: Minimum value of 0. If the action is successful, the service sends back an HTTP 200 response.
How to use the activity API in Office 365?
Office 365 Management Activity API reference 1 Start a subscription. This operation starts a subscription to the specified content type. 2 Webhook validation. 3 Stop a subscription. 4 Notification failure and retry. 5 Retrieving content.