Create Automation Query Activity

POST https://{{et_subdomain}}.soap.marketingcloudapis.com/Service.asmx

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

RESPONSES

status: OK

"\u003c?xml version=\"1.0\" encoding=\"utf-8\"?\u003e\n\u003csoap:Envelope xmlns:soap=\"http://www.w3.org/2003/05/soap-envelope\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:wsa=\"http://schemas.xmlsoap.org/ws/2004/08/addressing\" xmlns:wsse=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd\" xmlns:wsu=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd\"\u003e\n    \u003cenv:Header xmlns:env=\"http://www.w3.org/2003/05/soap-envelope\"\u003e\n        \u003cwsa:Action\u003eCreateResponse\u003c/wsa:Action\u003e\n        \u003cwsa:MessageID\u003eurn:uuid:d9b4dfd1-f4f9-4a9f-9a6c-8bfe5a5576c7\u003c/wsa:MessageID\u003e\n        \u003cwsa:RelatesTo\u003eurn:uuid:33234422-ce59-4376-a320-7307a9d55e4d\u003c/wsa:RelatesTo\u003e\n        \u003cwsa:To\u003ehttp://schemas.xmlsoap.org/ws/2004/08/addressing/role/anonymous\u003c/wsa:To\u003e\n        \u003cwsse:Security\u003e\n            \u003cwsu:Timestamp wsu:Id=\"Timestamp-666e7f23-7d25-448e-b527-1f6535684d1a\"\u003e\n                \u003cwsu:Created\u003e2019-07-17T20:08:53Z\u003c/wsu:Created\u003e\n                \u003cwsu:Expires\u003e2019-07-17T20:13:53Z\u003c/wsu:Expires\u003e\n            \u003c/wsu:Timestamp\u003e\n        \u003c/wsse:Security\u003e\n    \u003c/env:Header\u003e\n    \u003csoap:Body\u003e\n        \u003cCreateResponse xmlns=\"http://exacttarget.com/wsdl/partnerAPI\"\u003e\n            \u003cResults\u003e\n                \u003cStatusCode\u003eOK\u003c/StatusCode\u003e\n                \u003cStatusMessage\u003eQueryDefinition created\u003c/StatusMessage\u003e\n                \u003cOrdinalID\u003e0\u003c/OrdinalID\u003e\n                \u003cNewID\u003e0\u003c/NewID\u003e\n                \u003cNewObjectID\u003e64315dd7-95c6-430d-940e-09f72147f8a1\u003c/NewObjectID\u003e\n                \u003cObject xsi:type=\"QueryDefinition\"\u003e\n                    \u003cPartnerKey xsi:nil=\"true\" /\u003e\n                    \u003cObjectID\u003e64315dd7-95c6-430d-940e-09f72147f8a1\u003c/ObjectID\u003e\n                    \u003cCustomerKey\u003edataview_Sent\u003c/CustomerKey\u003e\n                    \u003cName\u003eDataView_Sent\u003c/Name\u003e\n                    \u003cQueryText\u003eSelect * from [_Sent]\u003c/QueryText\u003e\n                    \u003cTargetType\u003eDE\u003c/TargetType\u003e\n                    \u003cDataExtensionTarget\u003e\n                        \u003cPartnerKey xsi:nil=\"true\" /\u003e\n                        \u003cObjectID xsi:nil=\"true\" /\u003e\n                        \u003cCustomerKey\u003eDataView_Sent\u003c/CustomerKey\u003e\n                        \u003cName\u003eDataView_Sent\u003c/Name\u003e\n                    \u003c/DataExtensionTarget\u003e\n                    \u003cTargetUpdateType\u003eOverwrite\u003c/TargetUpdateType\u003e\n                \u003c/Object\u003e\n            \u003c/Results\u003e\n            \u003cRequestID\u003e7083439f-1f48-4ea3-8fbf-0a052648e269\u003c/RequestID\u003e\n            \u003cOverallStatus\u003eOK\u003c/OverallStatus\u003e\n        \u003c/CreateResponse\u003e\n    \u003c/soap:Body\u003e\n\u003c/soap:Envelope\u003e"