Modifying Data Using Data Change Notification

Syntax

DCN with payload requires a JavaScript Object Notation (JSON) string (dcn_request) that contains one or more :upsert and/or :delete operations that are applied to the Unwired Server cache (CDB).

http://unwired_server.sybase.com:unwired_server_port/onepage/servlet/UWPServlet?
&cmd=dcn
&username=userName
&password=password
&package=unwired_server_PackageName 
&dcn_request={"pkg":"dummy","messages":[{"id":"1","mbo":"CustomerWithParam","op":":upsert","cols":{"id":"10001","fname":"Adam"}}]}
&dcn_filter=fully_qualified_name_of_dcn_filter

Parameters

unwired_server – Unwired Server host name to which the DCN is issued.
unwired_server_port – Unwired Server port number.
&username – authorized Unwired Server user with permission to modify the MBO.
&password – authorized user's password.
&package – Unwired Server package that contains the MBO. The format is package:version. For example, e2e_package:1.0.
&dcn_request – the JSON string that contains the data, which must include:
- Package name (pkg)
- A list of messages (messages), where each message includes:
  - A message ID (id) used to report back the status.
  - Mobile business object name (mbo).
  - Operation name (op): ":upsert", ":delete", or an operation name of the specified MBO. ":upsert" and ":delete" are special operation names to specify payload data.
  - Bindings (cols): a list of name/value pairs covering at least all primary key attributes of the MBO. For payload data, the bindings contain the payload specified as MBO attribute/parameter names and their values.
(Optional) &dcn_filter – custom filter used to convert any JSON strings. By default, Unwired Server expects all DCN requests to be a valid JSON string. Use the DCN filter to convert incoming DCN request strings to a valid JSON string.

Examples

Upsert example – This JSON string included in a DCN contains a single :upsert operation that updates or inserts (upserts) data in the Unwired Server cache for the Department MBO.

dcn_request={"pkg":“TestPackage",
"messages":
	[{"id":"1","mbo":"Department",
		"op":":upsert",
		"cols":{"DepartmentID":"3333",
				 "DepartmentName":"Test Value",
									"DepartmentHeadID":"501"}}]
}

Delete example – Example JSON string included in the DCN sent to Unwired Server used to delete a row of data from the Unwired Server cache for the Department MBO:
```
dcn_request={"pkg":“TestPackage",
	"messages":[{"id":"1","mbo":"Department",
"op":":delete",
	"cols":{"DepartmentID":"3333"}}]}
```

Usage

Follow these guidelines when constructing a DCN:

The format of non string data is the same as parameter default values in Unwired WorkSpace. For example, specify timestamp values in a format similar to 2009-03-04T17:03:00+05:30.
Base binding names on MBO names rather than EIS names.
The :upsert operation requires:
- All MBO Primary key attributes to properly upsert the data.
- Any other MBO attributes used in the upsert.
- All columns used in the operation must use attribute names (not column names to which it is mapped).
The :delete operation requires:
- The MBO Primary key attribute to properly delete the data.
- That all columns used in the operation must use attribute names (not the column names to which it is mapped).