Add

Overview

Adds a new query defintion to your account

Syntax

Add(1)

Function Properties

Ordinal	Type		Description
1	object	Required	JSON object representing new query definition properties

Examples

This sample code adds a query definition to your account:

1var queryDef = {
2    Name : "Example Query Definition",
3    CustomerKey : "myQueryDef",
4    TargetUpdateType : "Overwrite",
5    TargetType : "DE",
6    Target : {
7        Name : "Example Target DE",
8        CustomerKey : "example_target_de"
9    },
10    QueryText : "SELECT SubKey, Email, Name FROM [Example Target DE] where FavoriteItemID=77"
11};
12
13var status = QueryDefinition.Add(queryDef);

This sample code adds a query definition and places it inside a specific folder:

1var queryDef = {
2    Name : "Example Query Definition",
3    CustomerKey : "myQueryDef",
4    CategoryID : 123456,
5    TargetUpdateType : "Overwrite",
6    TargetType : "DE",
7    Target : {
8        Name : "Example Target DE",
9        CustomerKey : "example_target_de"
10    },
11    QueryText : "SELECT SubKey, Email, Name FROM [Example Target DE] where FavoriteItemID=77"
12};
13
14var status = QueryDefinition.Add(queryDef);