REST API - Create a record in an external table
Last modified on 2023/07/17 16:18
Contents
POST /E_TEST1
- This method allows a new record in an external table E_TABLE to be created.
example /E_TEST1
- The method supports the creation of a single record per call.
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
None
Optional parameters
None
Optional fields
None
HTTP status codes for the method
StatusHeader
| Code | Error | Description |
|---|
Status201
| 201 | Created | Request successfully processed and element created. |
Status401
| 401 | Unauthorized | Incorrect authentication process for accessing the resource: Incorrect login/password, invalid session, incorrect Service Manager account.
example { "error": "Invalid Login / Password" } |
Status500
| 500 | Internal Server Error | Generic error message displayed when an unexpected condition is encountered and there is no specific message associated.
example { "error": "An error occured. A text message is returned in the body." } |
Examples
Example of the body of an HTTP request
{
"THE_RESOURCE_NAME": "Ressource Name",
"THE_XML": "the XML"
}
"THE_RESOURCE_NAME": "Ressource Name",
"THE_XML": "the XML"
}
Result with a status code 201 returned
{
"HREF": "https://{your_server}/api/v1/{your_account}/E_TEST1/5"
}
"HREF": "https://{your_server}/api/v1/{your_account}/E_TEST1/5"
}
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)" } } |
||