Attachments (Oracle Utilities Network Management System Initiated)

This section describes data mapping for the following:

Find Activity ID Mapping

OIC NMS Attachments Request Message			OFS findActivtyId Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM Name	NMS Column	OFS Column
request_wrapper	POST	Group	QueryParameters						Activity: Search Activity
event	request_wrapper	Group	searchInField	QueryParameters	Field				Hard code “nms_event_id”
id	event	Field	searchForValue	QueryParameters	Field
			fields	QueryParameters	Field				Hardcoded with “apptNumber,activityId”
			dateFrom	QueryParameters	Field				Use current-date function Subtract -21days Format the date YYYY-MM-DD
			dateTo	QueryParameters	Field				Use current-date function Format the date YYYY-MM-DD
			offset	QueryParameters	Field				0
			limit	QueryParameters	Field				10

Get Activity Details Mapping

OFSC findActivtyId Request Message			OFS Get ActivityDetails Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM Name	NMS Column	OFS Column
request_wrapper	POST	Group	canonical_GET		Outermosttag				Activity: Get Activity
activities	request_wrapper	Group	Template Parameters	canonical_GET	Group
externalId	activities	Field	activityId	TemplateParameters	Field				If incoming externalId is empty, retrieve from findActivityId response

Delete Existing NMS Attachment Mapping

OIC NMS Attachments Request Message			OFS deleteExistingNMSAttachment Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM Name	NMS Column	OFS Column
request_wrapper	POST	Group	canonical_GET		Outermosttag				DELETE /rest/ofscCore/v1/activities/{activityId}/{propertyLabel}
activies	request_wrapper	Group	TemplateParameters	canonical_GET	Group
externalId	activities	Field	activityId	TemplateParameters	Field				If incoming externalId is empty, retrieve it from the findActivityId response.
OFSC getActivityDetails Request Message
request_wrapper	POST	Group
activities	request-wrapper	Group
nms_sourced_attachment_[1..10]	activities	Field	propertyLabel	TemplateParameters	Field				Loop through all existing nms_sourced_attachment_x fields found in the OFS GetActivity Response message.

Get NMS Attachment Mapping

OIC NMS Attachments Request Message			NMS GetNMSAttachment Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM Name	NMS Column	OFS Column
request_wrapper		OutermostTag	execute		OutermostTag				GET /nms-ofs/rest/v1/events/{id}/attachments/{attachmentName}
event	request_wrapper	Group	HTTPHeaders	execute	Group
			StandardHTTPHeaders	HTTPHeaders	Group
			Accept	StandardHTTP Headers	Field				Hardcoded to “/”
			Template Parameters	execute	Group
id	event		id
attachments	event	Group
fileName	attachments	Field	att_name
			ConnectivityProperties		Group
			RestAPI	ConnectivityProperties	Group
nms_instanceId	attachments	Field	BaseURI	RestAPI	Field	OUTL-BRT-NMS_OFSC_InstanceIDToBucket		NMS_InstanceID, NMS_InstanceURL

Store OFS Attachment Mapping

OIC NMS Attachments Request Message			OFS storeOFSAttachment Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM Name	NMS Column	OFS Column
request_wrapper		OutermostTag	put		OutermostTag				Activity: Set File Property
event	request_wrapper	Group	HTTPHeaders	put	Group
attachments			StandardHTTPHeaders	HTTPHeaders	Group
fileName	attachments	Field	Content-Disposition						concat(“attachment;filename=”,filename)
contentType	attachments	Field	Content-Type

activities	request_wrapper		TemplateParameters	put	Group
externalId	activities	Field	activityId	TemplateParameters	Field				If incoming externalId is empty, retrieve it from the findActivityId response.
			propertyLabel	TemplateParameters	Field				“nms_sourced_attachment_[1..10]”
NMS getNMSAttachment Response Message
executeResponse		OutermostTag
streamReference	executeResponse		streamReference	put	Field

Delete Existing OFS Attachment Mapping

OIC NMS Attachments Request Message			OFS deleteExistingNMSAttachment Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM Name	NMS Column	OFS Column
request_wrapper	POST	Group	canonical_GET		Outermosttag				/rest/ofscCore/v1/activities/{activityId}/{propertyLabel}
activies	request_wrapper	Group	TemplateParameters	canonical_GET	Group
externalId	activities	Field	activityId	TemplateParameters	Field				If incoming externalId is empty, retrieve it from findActivityId response.
OFS getActivityDetails Request Message
request_wrapper	POST	Group
activities	request-wrapper	Group
nms_attachment_[1..10]	activities	Field	propertyLabel	TemplateParameters	Field

Update OFS Attachment List After Deletion Mapping

OIC NMS Attachments Request Message			OFS deleteExistingNMSAttachment Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM Name	NMS Column	OFS Column
request_wrapper	POST	Group	update_PATCH		Outermosttag				/rest/ofscCore/v1/activities/{activityId}/{propertyLabel}
activies	request_wrapper	Group	Template Parameters	update_PATCH	Group
externalId	activities	Field	activityId	TemplateParameters	Field				If incoming externalId is empty, retrieve it from findActivityId response.
OFS getActivityDetails Request Message
			updateActivity Schema	update_PATCH	Group
request_wrapper	POST	Group
activities	request-wrapper	Group
nms_attach_output	activities	Field	nms_attach_output	updateActivity Schema	Field				Content with removed attachment details was deleted. Content is stored as plaintext XML with no namespaces.