SERTICA Sync Web API Help Page

Receives a validation response

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - All Currencies was found and the validation response has been accepted.
400 Bad Request - If the received Validation fails to validate. Reason will be supplied in Response Phrase
401 Unauthorized - If credentials are invalid
500 Internal Server Error - Something unexpected failed. A logentry is saved in Sertica System Log if possible

Imports the Account(s) supplied into Sertica Sync Account Import Queue

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - Account(s) has been accepted.
400 Bad Request - If the received Validation fails to validate. Reason will be supplied in Response Phrase
401 Unauthorized - If credentials are invalid
500 Internal Server Error - Something unexpected failed. A logentry is saved in Sertica System Log if possible

Imports the Address supplied into Sertica Sync Address Import Queue
Address is imported into SERTICA next time SERTICA Sync routing is executed

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - If received Address is valid and is accepted
400 BadRequest - If validation fails. Reason is supplied in response.
401 Unauthorized - If credentials are invalid

Validates whether valid user credentials are sent.

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - If supplied credentials are valid
401 Unauthorized - If credentials are invalid

Imports the User supplied into Sertica Sync User Import Queue
User is imported into SERTICA next time SERTICA Sync routing is executed

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - If supplied credentials are valid
401 Unauthorized - If credentials are invalid

Imports the Project(s) supplied into Sertica Sync Project Import Queue

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - Project(s) has been accepted.
400 Bad Request - If the received Validation fails to validate. Reason will be supplied in Response Phrase
401 Unauthorized - If credentials are invalid
500 Internal Server Error - Something unexpected failed. A logentry is saved in Sertica System Log if possible

Imports the Incident(s) supplied into Sertica Sync Incident Import Queue

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - Incident(s) has been accepted.
400 Bad Request - If the received Validation fails to validate. Reason will be supplied in Response Phrase
401 Unauthorized - If credentials are invalid
500 Internal Server Error - Something unexpected failed. A logentry is saved in Sertica System Log if possible

Imports the invoice supplied into Sertica Invoice Management module

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - If received invoice is valid and is accepted
400 BadRequest - If validation fails. Reason is supplied in response.
401 Unauthorized - If credentials are invalid

Used to upload a scanned copy of an invoice to the service.

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials
Content-Type: image/tiff and application/pdf are currently only supported file formats

Returns:
200 OK - If invoice is found ready for import and the supplied mimetype of the document is supported
400 BadRequest - If an invoice can't be found with supplied externalReference, or the mime type isn't supported
401 Unauthorized - If credentials are invalid
404 NotFound - If invoice with externalReference1 is not found

Used to update Invoice Info on an Invoice.

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK – If received Invoice Info is valid and is accepted
400 BadRequest – If validation fails. Reason is supplied in response.
401 Unauthorized - If credentials are invalid
500 Internal Server Error - Something unexpected failed. A logentry is saved in SERTICA System Log if possible

Used to get a list of Invoices that have been approved or rejected in Sertica for InterfaceTarget CapNordic

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - With a list of approved or rejected Invoices.
401 Unauthorized - If credentials are invalid

Marks the Invoice with the ExternalReference1 value as Received.

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - Invoice was found and has been marked Received.
208 Already Reported - The Invoice was found but it was already marked as Received.
401 Unauthorized - If credentials are invalid
404 NotFound - If no invoices with ExternalReference1 was found

Used to get a list of Invoices that have been rejected in Sertica.

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - With a list of rejected Invoices.
401 Unauthorized - If credentials are invalid

Used to give the row a error message.

One of the following values will be returned:

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK – Invoice was found and the error information has been registered.
401 Unauthorized - If credentials are invalid
404 NotFound - If no Invoice was found in the SERTICA staging table that matches the InvoiceGuid
500 Internal Server Error - Something unexpected failed. A logentry is saved in SERTICA System Log if possible

Marks the Invoice with the ExternalReference1 value as Received.

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - Invoice was found and has been marked Received.
208 Already Reported - The Invoice was found but it was already marked as Received.
401 Unauthorized - If credentials are invalid
404 NotFound - If no invoices with ExternalReference1 was found

No documentation available.

Creates InvoiceExternalReferenceData record for given invoice

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - If Invoice is found and SyncImInvoiceExternalReferenceData record has been created
400 BadRequest - If both InvoiceNo and InvoiceGuid is sent but not matching
401 Unauthorized - If credentials are invalid
404 NotFound - If invoice is not found

Used to get a list of InvoiceExternalReferenceData records based on Invoice guid.

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - With a list of InvoiceExternalReferenceData records.
400 BadRequest - if given imInvoiceGuid is invalid
401 Unauthorized - If credentials are invalid

Imports the Transit Reception supplied into Sertica Sync Transit Reception Import Queue
Transit Reception is imported into SERTICA next time SERTICA Sync routing is executed

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - If received Transit Reception is valid and is accepted
400 BadRequest - If validation fails. Reason is supplied in response.
401 Unauthorized - If credentials are invalid

Returns list of Accruals

200 OK – If received response is valid and is accepted
400 BadRequest - If validation fails. Reason is supplied in response.
401 Unauthorized - If credentials are invalid
500 Internal Server Error - Something unexpected failed. A logentry is saved in SERTICA System Log if possible.

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Marks Budget Accruals Received

200 OK – If received information is valid and is accepted
400 BadRequest - If validation fails. Reason is supplied in response.
401 Unauthorized - If credentials are invalid
500 Internal Server Error - Something unexpected failed. A logentry is saved in SERTICA System Log if possible.

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Marks an Accrual Export as received

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - If received Accrual Confirmation is valid and is accepted
208 Already Reported - Accrual Export already confirmed.
404 Not Found - Accrual Export not found.
400 BadRequest - If validation fails. Reason is supplied in response.
401 Unauthorized - If credentials are invalid

Imports a supplier response to a Purchase Order

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - If received response is valid and is accepted
400 BadRequest - If validation fails. Reason is supplied in response.
401 Unauthorized - If credentials are invalid

Returns list of Purchase Orders with Positions and Delivery Costs

200 OK - If received response is valid and is accepted
400 BadRequest - If validation fails. Reason is supplied in response.
401 Unauthorized - If credentials are invalid

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Takes list of Guids and marks corresponding Purchase Orders, Positions, and Delivery Costs received

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Adds RowError on Purchase Order Export object with the specified PurchaseOrderGuid.

200 OK - If received response is valid and is accepted
401 Unauthorized - If credentials are invalid
404 NotFound - If a Purchase Order with specified guid couldnt be found
500 Internal Server Error
Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Takes a list of Purchase Order Nos with Warehouse Information, that the Purchase Order should be updated with.

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - If received response is valid and is accepted
401 Unauthorized - If credentials are invalid
404 NotFound - If one or more Purchase Orders with the specified No's couldn't be found.
500 Internal Server Error

Receives a validation response

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - All values were accepted and the validation response has been accepted.
400 Bad Request - If the received Validation fails to validate. Reason will be supplied in Response Phrase
401 Unauthorized - If credentials are invalid
500 Internal Server Error - Something unexpected failed. A logentry is saved in Sertica System Log if possible

Returns list of Exported External Committed Cost.

200 OK – If received response is valid and is accepted
400 BadRequest - If validation fails. Reason is supplied in response.
401 Unauthorized - If credentials are invalid
500 Internal Server Error - Something unexpected failed. A logentry is saved in SERTICA System Log if possible.

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Takes list of Guids and marks corresponding Exported Committed Costs received

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Adds RowError on Committed Cost Export object with the specified Committed Cost Detail Guid.

200 OK - If received response is valid and is accepted
401 Unauthorized - If credentials are invalid
404 NotFound - If a Committed Cost Detail with specified guid couldn't be found
500 Internal Server Error
Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Receives a validation response from MDM/ESB

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - Supplier was found and the validation response has been accepted.
400 Bad Request - If the received Validation fails to validate. Reason will be supplied in Response Phrase
401 Unauthorized - If credentials are invalid
404 NotFound - If no suppliers was found in Sertica that matches the ProcessedCompanysEntityId
500 Internal Server Error - Something unexpected failed. A logentry is saved in Sertica System Log if possible

Receives a update from MDM/ESB

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - Supplier was found and the update has been accepted.
400 Bad Request - If the received Validation fails to validate. Reason will be supplied in Response Phrase
401 Unauthorized - If credentials are invalid
404 NotFound - If no suppliers was found in Sertica that matches the SourceSystemsEntityId
500 Internal Server Error - Something unexpected failed. A logentry is saved in Sertica System Log if possible

Receives a rejection from MDM/ESB

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Returns:
200 OK - Supplier was found and the rejection has been accepted.
400 Bad Request - If the received rejection fails to validate. Reason will be supplied in Response Phrase
401 Unauthorized - If credentials are invalid
404 NotFound - If no suppliers was found in Sertica that matches the SourceSystemsEntityId
500 Internal Server Error - Something unexpected failed. A logentry is saved in Sertica System Log if possible

Returns list of Items with Suppliers

200 OK - If received response is valid and is accepted
400 BadRequest - If validation fails. Reason is supplied in response.
401 Unauthorized - If credentials are invalid

Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Takes list of Guids and marks corresponding Items ans ItemSuppliers as received

Returns:
200 OK - Item was found and has been marked as Received.
208 Already Reported - The Item was found but it was already marked as Received.
401 Unauthorized - If credentials are invalid
404 NotFound - If no item with specific guid was found
Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials

Adds RowError on Item Export and Item Supplier Export objects with the specified Item Guid

200 OK - If received response is valid and is accepted
401 Unauthorized - If credentials are invalid
404 NotFound - If no Item with specified guid was be found
500 Internal Server Error
Required Headers:
Authorization: Basic Http Authorization with valid Sertica credentials