I am trying to create an ETM Channel to create new Event Builders at Item Level.
Fields Usage Type and Event Type are Integers. I tried with value “1” for both fields but it is failing.
Can anyone please help me in getting the Usage Type and Event Type values?
Best answer by KevinM
Hi Manish
We created an event builder ETM channel - here are the values you need:
Event Type - This is what type of Event the event builder is to be used in conjunction with.
The options available are as follows:
and
Usage - This is for what the event builder will be used for.
The options available are as follows:
Below is the RAW code from our event builder channel - hopefully can be of some help as well :)
{
"targetResource" : "eventBuilder",
"targetClass" : null,
"mapping" : [ {
"field" : "break",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "!inbound[\"Matches at\"];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "self",
"searches" : [ {
"criteria" : [ {
"field" : "item",
"value" : null,
"csvLookup" : null,
"match" : null,
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Item\"].toUpperCase();\t",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
}, {
"field" : "category",
"value" : null,
"csvLookup" : null,
"match" : null,
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Category\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "eventBuilderType",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "inbound[\"Matches at\"];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "item",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Item\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
}, {
"criteria" : [ {
"field" : "name",
"value" : "inbound[\"Item\"].toUpperCase();\t",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "eventType",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "inbound[\"Event Type\"];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "category",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Category\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "usage",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "inbound['Usage'];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "seriousness",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Impact\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "priority",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Urgency\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "sla",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"SLA\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "callbackReqd",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "true;",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "suggestedActions",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "inbound[\"Suggested Actions\"];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "process",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound['Process'].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "startProcess",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "inbound['Start Process'];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
} ],
"entityFields" : null,
"pre" : { },
"cacheOptions" : [ ],
"notes" : null
}The import file is an xlsx file - with columns in the following order (from left to right)
Matches Event Item Level
Item
CSG
Event Type
Category
Useage
Impact
Urgency
SLA
Call Back Required
Process
Start Process
Suggested Actions
Hope this helps
Kev
Hi Manish
We created an event builder ETM channel - here are the values you need:
Event Type - This is what type of Event the event builder is to be used in conjunction with.
The options available are as follows:
and
Usage - This is for what the event builder will be used for.
The options available are as follows:
Below is the RAW code from our event builder channel - hopefully can be of some help as well :)
{
"targetResource" : "eventBuilder",
"targetClass" : null,
"mapping" : [ {
"field" : "break",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "!inbound[\"Matches at\"];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "self",
"searches" : [ {
"criteria" : [ {
"field" : "item",
"value" : null,
"csvLookup" : null,
"match" : null,
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Item\"].toUpperCase();\t",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
}, {
"field" : "category",
"value" : null,
"csvLookup" : null,
"match" : null,
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Category\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "eventBuilderType",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "inbound[\"Matches at\"];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "item",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Item\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
}, {
"criteria" : [ {
"field" : "name",
"value" : "inbound[\"Item\"].toUpperCase();\t",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "eventType",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "inbound[\"Event Type\"];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "category",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Category\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "usage",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "inbound['Usage'];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "seriousness",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Impact\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "priority",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Urgency\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "sla",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"SLA\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "callbackReqd",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "true;",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "suggestedActions",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "inbound[\"Suggested Actions\"];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "process",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound['Process'].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "startProcess",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "inbound['Start Process'];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
} ],
"entityFields" : null,
"pre" : { },
"cacheOptions" : [ ],
"notes" : null
}The import file is an xlsx file - with columns in the following order (from left to right)
Matches Event Item Level
Item
CSG
Event Type
Category
Useage
Impact
Urgency
SLA
Call Back Required
Process
Start Process
Suggested Actions
Hope this helps
Kev
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.