Goals

To direct push D365 Employee Information to the Adonis database.

Important Links

https://adonishr.atlassian.net/wiki/spaces/UD/pages/3645079565 Step by step guide on how to consume using Adonis API calls.

Methods

FL_Dynamics_Create

This is the main method to use if you wanted to upload a person from Dynamics to Adonis for the first time. You may use the example JSON script below.

FL_Dynamics_Update

For the update method, you may eliminate a parameter that you don’t want to update.

Parameter Details

Parameters / Items	Evaluation	Location	Error Code/ Text

Parameters / Items	Evaluation	Location	Error Code/ Text
ExternalEmployeeID	Not Null or not "" (001)		001: <ExternalEmployeeID> is mandatory cannot be NULL.
NAME FirstName MiddleName LastName	FirstName, LastName Not Null or not "" (001) MiddleName can be Null or ““		001: <FirstName> is mandatory cannot be NULL. 001: <LastName> is mandatory cannot be NULL.
JobID	Not Null or not "" (001)		001: <JobID> is mandatory cannot be NULL.
ADDRESS Address1 Address2 Address3	Address1 Not Null or not "" (001) Address2, Address3 can be Null or ““		001: <Address1> is mandatory cannot be NULL.
Country	If Address1 is not Null then Country is not Null ELSE Null or ““ (001)		001: <Country> is mandatory cannot be NULL.
ZipCode	If Address1 is not Null then ZipCode is not Null ELSE Null or ““ (001)		001: <ZipCode> is mandatory cannot be NULL.
Email	If email is incorrect email format (003)		003: <Email> incorrect email format
Telephone	Numeric characters only (002)		002: <Telephone> numeric characters only.
BirthDate	Not Null or not "" (001) if format of date different than ‘YYYY-MM-DD' (004)		001: <BirthDate> is mandatory cannot be NULL. 004: <BirthDate> ‘YYYY-MM-DD' wrong date format
Gender	It can be Null or ““
LegalEntity	Not Null or not "" (001) If the LegalEntity do not exist in the cross-reference table (007)	SELECT FROM WHERE PW001P01.CLIENT=(SELECT NUMORGID FROM PWORG WHERE PWORG.ORGCODE='LegalEntity')	001: <LegalEntity> is mandatory cannot be NULL. 007: <LegalEntity> not found in the <Organization Structure> cross-reference table
EmploymentStartDate	Not Null or not "" (001) if format of date different than ‘YYYY-MM-DD' (004) If EmploymentStartDate date exceeds EmploymentEndDate date (005)		001: <EmploymentStartDate> is mandatory cannot be NULL. 004: <EmploymentStartDate> ‘YYYY-MM-DD' wrong date format 005: <EmploymentStartDate> date cannot exceeds <EmploymentEndDate> date.
EmploymentEndDate	if format of date different than ‘YYYY-MM-DD' (004) If EmploymentEndDate date is less than EmploymentStartDate date (006)		004: <EmploymentEndDate> ‘YYYY-MM-DD' wrong date format 006: <EmploymentEndDate> date cannot be less than <EmploymentStartDate> date.
ContractType	Not Null or not "" (001) If the ContractType do not exist in the cross-reference table (007)	General Codes > Contracts > Contract Type	001: <ContractType> is mandatory cannot be NULL. 007: <ContractType> not found in the <Contract Type> cross-reference table
TerminationCode	If the TerminationCode do not exist in the cross-reference table (007)	General Codes > Personal Details > Termination Reason	007: <TerminationCode> not found in the <Termination Reason> cross-reference table
ContactPerson FirstName MiddleName LastName	If the FirstName is not Null then FirstName, LastName Not Null or not "" (001) MiddleName can be Null or ““ else leave it null		001: <FirstName> is mandatory cannot be NULL. 001: <LastName> is mandatory cannot be NULL.
Relationship	If the ContactPerson is not Null then If the Relationship do not exist in the cross-reference table (007) Not Null or not "" (001) else leave it null	General Codes > Family > Relationship Codes	007: <Relationship> not found in the <Relationship Codes> cross-reference table 001: <Relationship> is mandatory cannot be NULL.
ContactPhone	If the ContactPhone is not Null then incorrect format (002) Not Null or not "" (001) else leave it null		002: <ContactPhone> numeric characters only. 001: <ContactPhone> is mandatory cannot be NULL.
ContactAddress Address1 Address2 Address3	It can be Null or ““
ContactCountry	It can be Null or ““
ContactZipCode	It can be Null or ““
ContactGender	It can be Null or ““

JSON Example

{
    "request": {
        "ExternalEmployeeID": "10022",      
        "Name": [
        {
                "FirstName":"Bob",
                "MiddleName":"Smith",
                "LastName":"Cruz" 
        }
        ],        
        "Jobid": "0011",
        "Address": [
        {
                "Address1":"Østregata 12",
                "Address2":"Arendal",
                "Address3":"" 
        }
        ], 
        "Country": "NO",    
        "ZipCode": "4822",                            
        "Email": "name@email.com",                                
        "Telephone": "+47 76543210",
        "Birthdate": "1980-01-01",
        "Gender": "M",  
        "LegalEntity": 0,                      
        "EmploymentStartDate": "2022-06-01",
        "ContractType": "1980-01-01",
        "ContactPerson": [
        {
                "FirstName":"John",
                "MiddleName":"Salvador",
                "LastName":"Cruz" 
        }
        ], 
        "Relationship": "Father",      
        "ContactPhone": "+4712342567",
        "ContactAddress": [
        {
                "Address1":"Barbu 22",
                "Address2":"Arendal",
                "Address3":"" 
        }
        ], 
        "ContactCountry": "NO",    
        "ContactZipCode": "4822",           
        "ContactGender": "M",  
        "Authentication_Token": "XXXX"
    }
}

Housekeeping

APM Adonis Personnel Manager

Need to set up the XREF (cross-reference) tables. i.e we will create an INTERFACE_XREF called “DYNAMICS” in the PW001C000_XREF Table. Each standard code in Dynamics will be defined in our system, so we can map what they are referring for. We set this up in the General Codes.

Parameters / Items	Location
ContractType	General Codes > Contracts > Contract Type
TerminationCode	General Codes > Personal Details > Termination Reason
Relationship	General Codes > Family > Relationship Codes

We create an interface ‘DYNAMICS’

To set up the codes for CONTRACT TYPE, Go to Contracts > Contract Type. Choose the DYNAMICS as Interface, The Xref Code is the code from Dynamics for PERM. Adonis will match both codes.

Knowledge Base

AIS - Dynamics 365 CU Methods