forked from lesleyhiggins/sfmc-data-views
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathFTAF
120 lines (120 loc) · 5.58 KB
/
FTAF
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Header>
<fueloauth>{{accessToken}}</fueloauth>
</soapenv:Header>
<soapenv:Body>
<CreateRequest xmlns="http://exacttarget.com/wsdl/partnerAPI">
<Options/>
<Objects xsi:type="ns2:DataExtension" xmlns:ns2="http://exacttarget.com/wsdl/partnerAPI">
<CustomerKey>FTAF Data View</CustomerKey>
<Name>FTAF Data View</Name>
<Description>Mimics the FTAF Data View</Description>
<IsSendable>false</IsSendable>
<IsTestable>false</IsTestable>
<Fields>
<Field xsi:type="ns2:DataExtensionField">
<CustomerKey>AccountID</CustomerKey>
<Name>AccountID</Name>
<Label>AccountID</Label>
<IsRequired>true</IsRequired>
<IsPrimaryKey>false</IsPrimaryKey>
<FieldType>Number</FieldType>
</Field>
<Field xsi:type="ns2:DataExtensionField">
<CustomerKey>OYBAccountID</CustomerKey>
<Name>OYBAccountID</Name>
<Label>OYBAccountID</Label>
<IsRequired>false</IsRequired>
<IsPrimaryKey>false</IsPrimaryKey>
<FieldType>Number</FieldType>
</Field>
<Field xsi:type="ns2:DataExtensionField">
<CustomerKey>JobID</CustomerKey>
<Name>JobID</Name>
<Label>JobID</Label>
<IsRequired>true</IsRequired>
<IsPrimaryKey>false</IsPrimaryKey>
<FieldType>Number</FieldType>
</Field>
<Field xsi:type="ns2:DataExtensionField">
<CustomerKey>ListID</CustomerKey>
<Name>ListID</Name>
<Label>ListID</Label>
<IsRequired>true</IsRequired>
<IsPrimaryKey>false</IsPrimaryKey>
<FieldType>Number</FieldType>
</Field>
<Field xsi:type="ns2:DataExtensionField">
<CustomerKey>BatchID</CustomerKey>
<Name>BatchID</Name>
<Label>BatchID</Label>
<IsRequired>true</IsRequired>
<IsPrimaryKey>false</IsPrimaryKey>
<FieldType>Number</FieldType>
</Field>
<Field xsi:type="ns2:DataExtensionField">
<CustomerKey>SubscriberID</CustomerKey>
<Name>SubscriberID</Name>
<Label>SubscriberID</Label>
<IsRequired>true</IsRequired>
<IsPrimaryKey>false</IsPrimaryKey>
<FieldType>Number</FieldType>
</Field>
<Field xsi:type="ns2:DataExtensionField">
<CustomerKey>SubscriberKey</CustomerKey>
<Name>SubscriberKey</Name>
<Label>SubscriberKey</Label>
<IsRequired>true</IsRequired>
<IsPrimaryKey>false</IsPrimaryKey>
<FieldType>Text</FieldType>
<MaxLength>254</MaxLength>
</Field>
<Field xsi:type="ns2:DataExtensionField">
<CustomerKey>TransactionTime</CustomerKey>
<Name>TransactionTime</Name>
<Label>TransactionTime</Label>
<IsRequired>true</IsRequired>
<IsPrimaryKey>false</IsPrimaryKey>
<FieldType>Date</FieldType>
</Field>
<Field xsi:type="ns2:DataExtensionField">
<CustomerKey>Domain</CustomerKey>
<Name>Domain</Name>
<Label>Domain</Label>
<IsRequired>true</IsRequired>
<IsPrimaryKey>false</IsPrimaryKey>
<FieldType>Text</FieldType>
<MaxLength>128</MaxLength>
</Field>
<Field xsi:type="ns2:DataExtensionField">
<CustomerKey>IsUnique</CustomerKey>
<Name>IsUnique</Name>
<Label>IsUnique</Label>
<IsRequired>true</IsRequired>
<IsPrimaryKey>false</IsPrimaryKey>
<FieldType>Boolean</FieldType>
</Field>
<Field xsi:type="ns2:DataExtensionField">
<CustomerKey>TriggererSendDefinitionObjectID</CustomerKey>
<Name>TriggererSendDefinitionObjectID</Name>
<Label>TriggererSendDefinitionObjectID</Label>
<IsRequired>false</IsRequired>
<IsPrimaryKey>false</IsPrimaryKey>
<FieldType>Text</FieldType>
<MaxLength>36</MaxLength>
</Field>
<Field xsi:type="ns2:DataExtensionField">
<CustomerKey>TriggeredSendCustomerKey</CustomerKey>
<Name>TriggeredSendCustomerKey</Name>
<Label>TriggeredSendCustomerKey</Label>
<IsRequired>false</IsRequired>
<IsPrimaryKey>false</IsPrimaryKey>
<FieldType>Text</FieldType>
<MaxLength>36</MaxLength>
</Field>
</Fields>
</Objects>
</CreateRequest>
</soapenv:Body>
</soapenv:Envelope>