SynAPI Web Method for Payroll Timesheets

This involves using SynAPI to expose stored procedure for importing Timesheets into Synergetic.

As part of this process we create stored procedure dbo.uspuPayrollTimesheet which:

• Takes an XML string as parameter.

• Returns an xml data set and will add the TimesheetsSeq for where we are creating new records.

• An error message will be returned in case that there were any issues with the import.

We also create a custom web service method called USetTimesheets. This will call the custom stored procedure created in the above step to import Timesheet records into Synergetic.

XML FORMAT:

12345

NPAY1

01/01/2020

01/01/2020

1

20

test

Orgview Integration is designed to import Timesheets into Synergetic under Timesheets area.

SETUP

Synergetic Side: Synergetic staff is responsible for setting up everything on Synergetic side and assist the client with testing the Integration once it has been setup on their system. Client must raise a new CASE if they want to use Orgview Integration on their system. Once the Web Service is setup on client’s environment, we’ll need to share the GUID and password which they will need to forward to Orgview for setup and Authentication.

Orgview Side: Orgview staff assists the client with setting up and testing everything from Orgview’s end.

SynAPI needs to be configured before this can be setup.