Sun Data Mashup Engine REST Support
This topic provides information about REST support.
Note – Requires Java CAPS 6 Update 1.
- Resources
- Identified Resources
- Tables, views, federated views, data mashups of relational/rss feed
- Reaching to particular page, row and column
- Supported Parameters
- Page: Supports pagination of large result sets
- Row: Reaches a particular row irrespective of the page
- Column: Reaches a particular column
- Extra parameters: depends upon the application configuration
- Constructing Resource URIs in encoding mode
Data Mashup Engine support of REST.
- To get all the records, the URL is:page=0&row=0&column=0
- To reach a particular page, such as the 2nd page, the URL is: page=2&row=0&column=0
If you attempt to reach an invalid page, such as ‐1, the URL returns all the pages.
- To reach a particular row, such as the 10th row, the URL is: page=2&row=10&column=0
The page value is ignored and only 10th row is displayed. If you attempt to reach a row with an invalid row, all the pages and all the rows are returned.
- To get all the records of a particular attribute, such as CUSTOMER_ID, the URL is: page=0&row=0&column=CUSTOMER_ID
This lists all the records of attribute CUSTOMER_ID.
- To get only values of the CUSTOMER_ID in 2nd page, the URL is: page=2&row=0&column=CUSTOMER_ID
- To drill down to the 2nd row of the CUSTOMER_ID value , the URL is: page=2&row=2&column=CUSTOMER_ID
In this instance, the page attribute value is ignored.
Note – Currently the Data Mashup Engine does not support POST request.
- Runtime-Input Arguments
- Runtime-input arguments can be added at Design time
- Runtime arguments for flat files and tab delimited files are added automatically
- Using Runtime arguments with REST Query
- The default way to Reach page=0&row=0&column=0&FILE_LOC_STUDENTINFO=0
FILE_LOC_STUDENTINFO is the runtime argument. Once the runtime argument is defined at design time, it is mandatory to mention this argument while accessing URL.
FILE_LOC_STUDENTINFO=0 is the runtime argument that you are accessing with default values. You can overwrite this value by specifying a file name, such as page=0&row=0&column=0&FILE_LOC_STUDENTINFO=test.xls.
Note – test.xls is the file name that you overwrite; this must be configured in GlassFish as part of application configuration.
Previous Next
This page (revision-5) was last changed on
08-Dec-08 15:37 PM, -0800
by lkraft.
This page was created on
08-Dec-08 15:21 PM, -0800 by lkraft.
More info...
| Version |
Date |
Author |
Size |
Changes ... |
|
10
|
16-Jun-09 16:29 PM, -0700
|
CarolT |
3823 |
to previous
|
|
9
|
16-Jun-09 16:28 PM, -0700
|
CarolT |
3839 |
to previous
|
to last
|
|
8
|
16-Jun-09 16:28 PM, -0700
|
CarolT |
3854 |
to previous
|
to last
|
|
7
|
18-Dec-08 14:19 PM, -0800
|
lkraft |
3404 |
to previous
|
to last
|
|
6
|
08-Dec-08 15:44 PM, -0800
|
lkraft |
3402 |
to previous
|
to last
|
|
5
|
08-Dec-08 15:37 PM, -0800
|
lkraft |
3451 |
to previous
|
to last
|
|
4
|
08-Dec-08 15:35 PM, -0800
|
lkraft |
3513 |
to previous
|
to last
|
|
3
|
08-Dec-08 15:34 PM, -0800
|
lkraft |
3511 |
to previous
|
to last
|
|
2
|
08-Dec-08 15:27 PM, -0800
|
lkraft |
3517 |
to previous
|
to last
|
|
1
|
08-Dec-08 15:21 PM, -0800
|
lkraft |
3515 |
to last
|