Through the GET method you can extract data from the published tables.
Path parameter: this shall be entered immediately after .../sdeiRESTWs/resources/rfDataExchangeInterface/ and can have the following values:
XML for XML format (.../sdeiRESTWs/resources/rfDataExchangeInterface/XML). The result will be in the web rowset format.
JSON for JSON format (.../sdeiRESTWs/resources/rfDataExchangeInterface/JSON). The structure of the returned JSON file has the following structure:
JSON Format
{
"data": [
{"row": [
<val col1>,
<val col2>,
...
<val colN>
]},
....
{"row": [
<val col1>,
<val col2>,
...
<val colN>
]},
],
"metadata": {
"column-count": <N>,
"column-definition": [
{
"column-index": 1,
"column-name": <Col Name>,
"column-type": <Col Type>,
"column-type-name": <Col Type Name>
},
{
"column-index": 2,
"column-name": <Col Name>,
"column-type": <Col Type>,
"column-type-name": <Col Type Name>
},
.....
{
"column-index": N,
"column-name": <Col Name>,
"column-type": <Col Type>,
"column-type-name": <Col Type Name>
}
]
}
}
CSV for CSV format (.../sdeiRESTWs/resources/rfDataExchangeInterface/CSV)
HTML for HTML format (.../sdeiRESTWs/resources/rfDataExchangeInterface/HTML)
Query parameters: these must be entered after the path parameter. The first character is '?', followed by the query parameters divided by '&'. (.../sdeiRESTWs/resources/rfDataExchangeInterface/XML?<param1=valoare>&<param2=valoare>&...<paramN=valoare>)
clientID: the ID of the tenant - mandatory
roleID: the ID of the role used to access the data - mandatory
userName: the user authentication name - mandatory
password: the user authentication password - mandatory
publishName: the table's publishing name - mandatory
csvSeparator: separator for CSV Out. This is made up of a single character. The comma is the default separator;
csvTextDelimiter: text delimiter for CSV Out. This is made up of a single character. The " character is the default delimiter;
whereParams: the values of the dynamic parameters specified in the "SQL Where" condition of the published table, separated by the ; (semicolon) character if there are multiple parameters.