Page Comparison

Goals

To direct push D365 Employee Information to the Adonis database.

Important Links

AdonisWebServices - Consume example 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.

...

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)If the JobID do not exist in the cross-reference table (007) General Codes > Personal Details > Ranks		001: <JobID> is mandatory cannot be NULL. 007: <JobID> not found in the <Ranks> cross-reference table
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)	Setup > Organization StructureSELECT 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 Not Null or not "" (001)	if format of date different than ‘YYYY-MM-DD' (004) If EmploymentEndDate date is less than EmploymentStartDate date (006)	001: <EmploymentEndDate> is mandatory cannot be NULL.	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 Not Null or not "" (001)	If the TerminationCode do not exist in the cross-reference table (007)	General Codes > Personal Details > Termination Reason 001: <TerminationCode> is mandatory cannot be NULL.	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 ““

...

Code Block

{
    "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",
        "EmploymentEndDate": "2022-08-01",
        "ContractType": "1980-01-01",
        "TerminationCode": "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"
    }
}

...

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

APP Adonis Administrator

...

Portal

...

Version	Old Version 3	New Version Current
Changes made by	Anabelle Fajanel	Anabelle Fajanel
Saved on	Mar 30, 2022	Jun 03, 2022

Versions Compared

Key