Note: The JSON format is only supported starting with version 13.07!
Through the POST method you execute the published processes. The values are sent in XML or JSON format in the DATA section of the HTTP request.
Path parameter: this shall be entered immediately .../sdeiRESTWs/resources/rfDataExchangeInterface/ and specifies the format used to send the data (XML or JSON);
Query parameters: these must be entered after the path parameter. The first character is '?' (.../sdeiRESTWs/resources/rfDataExchangeInterface/XML?param1=valoare¶m2=valoare...)
clientID: the ID of the tenant - mandatory
roleID: the ID of the role used to access the data
userName: the user authentication name
password: the user authentication password
publishName: the table's publishing name - mandatory
The XML format used to send the data has the following structure:
<?xml version="1.0"?>
<webRowSet>
<metadata>
<param-name>Nume parametru 1</param-name>
<param-name>Nume parametru 2</param-name> ..........
<param-name>Nume parametru N</param-name>
</metadata>
<data>
<paramValue>Valoare parametru 1</paramValue>
<paramValue>Valoare parametru 2</paramValue> ..........
<paramValue>Valoare parametru N</paramValue>
</data>
</webRowSet>
The JSON format used to send the data has the following structure:
{ "<Nume parametru 1>":<Valoare parametru 1>,
"<Nume parametru 1>":<Valoare parametru 1>, .... "<Nume parametru N>":<Valoare parametru N> }
The format of the data:
Numerical data with decimals: whole_part[.fractional_part]. Without thousands and decimals separators;
Date + Time data: DD-MM-YYYY[ HH:MM:SS]. If you want to use the current date and time, enter CURRENT;
The values for the interval type parameters are sent under the form: Start Value >>Stop Value;
The String and Date data types are entered between quotes in the JSON format.
in the case of successful saving:the message returned by the process;
in the case of error: the word ERROR followed by the error message;
null in case of exception.
Examples of files:
XML Format:
<?xml version="1.0"?>
<webRowSet>
<metadata>
<param-name>AD_Org_ID</param-name>
<param-name>AD_User_ID</param-name>
<param-name>DateDoc</param-name>
<param-name>C_Project_ID</param-name>
</metadata>
<data>
<paramValue>11</paramValue>
<paramValue>101</paramValue>
<paramValue>01-03-2012>>CURRENT</paramValue>
<paramValue>1000014</paramValue>
</data>
</webRowSet>
JSON Format:
{
"AD_Org_ID":11,
"AD_User_ID":101,
"DateDoc":"01-03-2012>>CURRENT",
"C_Project_ID":1000014
}