REST API - Update a record in an external table
Last modified on 2023/07/17 16:18
Contents
PUT /E_TABLE/{e_table_id}
- This method allows a specified record in an external table E_TABLE to be modified.
example /E_TEST1/4
Notes
See Service Manager REST API Conventions
- The external table must contain a primary key.
- You must supply a table in JSON format in the body of the HTTP request.
- If successful, an HTTP status code 201 is returned and a URL link (HREF) to the created resource is provided.
CommonNotes_JSONandFields
JSON Format / Field Format:
- The field names are those of the Service Manager.data model.
example available_field_1
- To update a field, respect the following JSON format: "field_name":"value".
- JSON object names, including those representing Service Manager database fields, are not case sensitive.
example field_name, Field_Name and FIELD_NAME are equivalent
List of parameters / fields
Mandatory parameters
You must use the parameter below in the URL.
| Parameter | Type | Description / Example |
|---|---|---|
| e_table_id | integer | Record identifier |
Optional parameters
None
Optional fields
- You can use all the fields from the external table E_TABLE in the body of the HTTP request.
- You must use at least one of the objects. Otherwise an error is returned.
- In addition to the fields provided by EasyVista, you can also assign values to fields which you have added to the Service Manager database. These are fields with the prefix e_.
example e_field_name_xyz
HTTP status codes for the method
StatusHeader
| Code | Error | Description |
|---|
Status201
| 201 | Created | Request successfully processed and element created. |
Status400
| 400 | Bad Request | Request could not be run correctly due to malformed syntax.
example { "error": "Nothing to update (check fieldnames)" } or when the "Suspend a ticket" method is called but the ticket is already suspended. The response returned is: { "error": "The request is already suspended. Operation aborted."} or when the "Reopen a ticket" method is called but the ticket is not suspended. The response returned is: { "error": "The request is not suspended. Operation aborted."} |
Status401
| 401 | Unauthorized | Incorrect authentication process for accessing the resource: Incorrect login/password, invalid session, incorrect Service Manager account.
example { "error": "Invalid Login / Password" } |
Status404
| 404 | Not found | Resource not found: Incorrect URI, missing resource, incorrect communication with the server, rfc_number not found.
example { "error": "Resource not found" } |
Status405
| 405 | Method not allowed | Unauthorized request method, i.e. it is not supported or not appropriate for the resource.
example { "error": "Invalid input parameter" } |
Examples
Example of the body of an HTTP request
{
"THE_RESOURCE_NAME": "Resource_name modified through rest api"
}
"THE_RESOURCE_NAME": "Resource_name modified through rest api"
}
Result with a status code 201 returned
{
"HREF": "http://{your_serveur}/api/v1/{your_account}/E_TEST1/4"
}
"HREF": "http://{your_serveur}/api/v1/{your_account}/E_TEST1/4"
}
ConventionsAPI
REST API Conventions
| Convention | Meaning | |
|---|---|---|
| Orange | Parameters used in an HTTP request string which do not correspond to Service Manager database fields.
example Method View a list of assets https://{your_server}/api/v1/{your_account}/assets?max_rows=3&fields=asset_tag |
|
| Black and Bold | Parameters used in the URL of an HTTP request which correspond to Service Manager database fields.
example Method View an asset https://{your_server}/api/v1/{your_account}/assets/{asset_id} |
|
| Green | Parameters used in the body of an HTTP request which represent JSON object names corresponding to Service Manager database fields; they allow the value of a database field to be assigned or modified.
example Method Close an incident/request { "closed": { "end_date": "11/20/2016 12:12:12", } } |
|
| Parameters used in the body of an HTTP request which represent JSON object names not corresponding to Service Manager database fields.
example Method Reopen an incident/request { "restarted": { "comment": "string (required)" } } |
||