Details

    • Company:
      All Clients/Multiple Clients

      Description

      Data mapping  for DMS Forms is not working properly , Please check the payload json data DMS and response URl below we are getting from DMS api.

       

      Payload

      {"FormAliases":["AUS_ICRIM"],"Payload":{"candidate":{"firstName":"Gaurav","lastName":"Joshi","fullName":"Gaurav  Joshi","middleName":null,"suffix":"IX","aliasFirstName1":"Other First name 1","aliasLastName1":"Other Last name 1","aliasMiddleName1":"","alias1To":"12/3/2019 6:30:00 PM","aliasFirstName2":"Other First name 2","aliasLastName2":"Other Last name 2","aliasMiddleName2":"","alias2To":"12/1/2019 6:30:00 PM","aliasFirstName3":"Gaurav","aliasLastName3":"Joshi","aliasMiddleName3":null,"alias3From":"12/4/2019 8:01:27 AM","streetAddress1":"1111 Main St ","city1":"Philadelphia","state1":"Christmas Island","zip1":"","country1":"AU","address1From":"1/1/2000 12:00:00 AM","socialSecurityNumber":"221-73-7419","dateOfBirth":"1/1/1990 12:00:00 AM","driversLicenseState":"Washington","driversLicenseCountry":"US","driversLicenseNumber":"D12345678912","sex":"OTHER","candidateEmailAddress":"gtest9@mailinator.com","candidatePhoneNumber":"1999232286","stateAppliedToWorkIn":"Alaska","passportCounty":"AX","passportNumber":"333","motherMaidenName":null,"companyName1":"4th Employer Co","companyPhone1":"(441) 456-4444","companyStreet1":"44444 Main St ","companyCity1":"employercity4","companyState1":"Rhode Island","companyZip1":"44445","companyCountry1":"US","supervisorName1":"supervisor4","positionEndDate1":"4/4/2005 12:00:00 AM","positionWage1":"40","reasonForLeaving1":"reason 4","positionStartDate1":"4/4/2004 12:00:00 AM","positionName1":"Position4","supervisorEmail1":null,"companyName2":"3rd Employer Co","companyPhone2":"(331) 456-3333","companyStreet2":"33 Main St ","companyCity2":"employercity3","companyState2":"Rhode Island","companyZip2":"33345","companyCountry2":"US","supervisorName2":"supervisor3","positionEndDate2":"3/3/2004 12:00:00 AM","positionWage2":"30","reasonForLeaving2":"reason 3","positionStartDate2":"3/2/2003 12:00:00 AM","positionName2":"Position3","supervisorEmail2":null,"companyName3":"2nd Employer Co","companyPhone3":"(221) 456-2222","companyStreet3":"22 Main St ","companyCity3":"employercity2","companyState3":"Rhode Island","companyZip3":"22345","companyCountry3":"US","supervisorName3":"supervisor2","positionEndDate3":"2/2/2003 12:00:00 AM","positionWage3":"20","reasonForLeaving3":"reason 2","positionStartDate3":"2/2/2002 12:00:00 AM","positionName3":"Position2","supervisorEmail3":null,"companyName4":"1st Employer Co","companyPhone4":"(123) 456-1121","companyStreet4":"12 Main St ","companyCity4":"employercity1","companyState4":"Rhode Island","companyZip4":"12345","companyCountry4":"US","supervisorName4":"supervisor1","positionEndDate4":"1/1/2003 12:00:00 AM","positionWage4":"10","reasonForLeaving4":"reason 1","positionStartDate4":"1/1/2002 12:00:00 AM","positionName4":"Position1","supervisorEmail4":null,"schoolType1":"HighSchoolGed","schoolName1":"Institute High School 1","degree1":"HighSchoolDiploma","major1":"Major1","schoolCountry1":"US","schoolCity1":"instcity1","schoolState1":"Massachusetts","schoolPhone1":null,"schoolZip1":"123","schoolTerritory1":"","firstNameWhileAttendingschool1":"First name 1","lastNameWhileAttendingschool1":"Last name 1","lastUseDate1":"12/4/2019 8:03:00 AM","hasGraduatedschool1":"True","graduationDateschool1":"6/1/2004 12:00:00 AM","graduationStartDateschool1":"8/1/2000 12:00:00 AM","graduationEndDateschool1":"6/1/2004 12:00:00 AM","schoolType2":"CollegeUniversity","schoolName2":"Institute College 2","degree2":"Bachelor","major2":"Major2","schoolCountry2":"IN","schoolCity2":"instcity2","schoolState2":"Karnataka","schoolPhone2":null,"schoolZip2":null,"schoolTerritory2":"","firstNameWhileAttendingschool2":"First name 2","lastNameWhileAttendingschool2":"Last name 2","lastUseDate2":"6/4/2017 8:03:00 AM","hasGraduatedschool2":"True","graduationDateschool2":"6/1/2008 12:00:00 AM","graduationStartDateschool2":"8/1/2004 12:00:00 AM","graduationEndDateschool2":"6/1/2008 12:00:00 AM","schoolType3":"TradeBusiness","schoolName3":"Institute Trade School 3","degree3":"Other","major3":"Major3","schoolCountry3":"US","schoolCity3":"instcity3","schoolState3":"Massachusetts","schoolPhone3":null,"schoolZip3":"231123","schoolTerritory3":"","firstNameWhileAttendingschool3":"First name 3","lastNameWhileAttendingschool3":"Last name 3","lastUseDate3":"11/4/2017 8:03:00 AM","hasGraduatedschool3":"True","graduationDateschool3":"6/1/2009 12:00:00 AM","graduationStartDateschool3":"8/1/2008 12:00:00 AM","graduationEndDateschool3":"6/1/2009 12:00:00 AM","schoolType4":"CollegeUniversity","schoolName4":"Institute Grad School 4","degree4":"Master","major4":"Major4","schoolCountry4":"US","schoolCity4":"instcity4","schoolState4":"Massachusetts","schoolPhone4":null,"schoolZip4":"213123123","schoolTerritory4":"","firstNameWhileAttendingschool4":"First name 4","lastNameWhileAttendingschool4":"Last name 4","lastUseDate4":"10/4/2017 8:03:00 AM","hasGraduatedschool4":"True","graduationDateschool4":"6/1/2011 12:00:00 AM","graduationStartDateschool4":"8/1/2009 12:00:00 AM","graduationEndDateschool4":"6/1/2011 12:00:00 AM","schoolType5":"TradeBusiness","schoolName5":"Institute Trade School 5","degree5":"Other","major5":"Major5","schoolCountry5":"US","schoolCity5":"Boston","schoolState5":"Massachusetts","schoolPhone5":null,"schoolZip5":"12312","schoolTerritory5":"","firstNameWhileAttendingschool5":"First name 5","lastNameWhileAttendingschool5":"Last name 5","lastUseDate5":"10/4/2017 8:03:00 AM","hasGraduatedschool5":"False","graduationDateschool5":"6/1/2012 12:00:00 AM","graduationStartDateschool5":"8/1/2011 12:00:00 AM","graduationEndDateschool5":"6/1/2012 12:00:00 AM"}},"SendDocument":2,"SourceProduct":"CBES","SourceUserId":"3016","Email":"gaurav@mailinator.com"}

       

       

       

      DMS Response URL:

      https://dmsstage.workterra.net/basicIntegration?Token=28a7330513794e609756767d48920eb4&IsDMSAPI=0bcc291a2891d0a9bd9306cfaa749077&key=1a33285d8f5b754430f06656a21cd9fa8ebc8896b5b5202704d14f0781cfc9d0&Id=a307ed340927d2e57a4b7132c13eeaf9

       

       

      cc Samir Harshveer Singh Nishant.Kondapaneni Narendra Kumar

        Attachments

          Activity

          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited

          Hi All

          As per discussion with Gaurav from CBES team. We have remove existing sent documents for AUSTRALIA ICRIM template only

          CC-Samir,Mohd Belal,Harshveer Singh

          Thanks,

          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited Hi All As per discussion with Gaurav from CBES team. We have remove existing sent documents for  AUSTRALIA ICRIM  template only CC- Samir , Mohd Belal , Harshveer Singh Thanks, Ganesh
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited

          Hi All,

          We have checked above payload. Above payload having below fields in different case and in system in different case. We need to change payload as per attached excel CBES Payload Fields Details.xls

          We have verified this on local its working fine.

          CC-Samir,Mohd Belal

          Thanks,

          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited Hi All, We have checked above payload. Above payload having below fields in different case and in system in different case. We need to change payload as per attached excel  CBES Payload Fields Details.xls We have verified this on local its working fine. CC- Samir , Mohd Belal Thanks, Ganesh
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited

          Hi  Harshveer Singh

          We need to fix case comparing while fetching fields. Adding some more finding.

          • Country need to checked code, as of in system it validating against name
          • Gender also not work when we pass as  'Male'
          • Custom and system mapping fetching by ignoring the case. 

          CC-Samir,Mohd Belal

          Thanks,

          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited Hi   Harshveer Singh We need to fix case comparing while fetching fields. Adding some more finding. Country need to checked code, as of in system it validating against name Gender also not work when we pass as  'Male' Custom and system mapping fetching by ignoring the case.  CC- Samir , Mohd Belal Thanks, Ganesh
          Hide
          harshveer.singh Harshveer Singh (Inactive) added a comment -

          Hi Nishant, Issues reported in this with mappings are fixed, can you please have it checked on your side?

          Show
          harshveer.singh Harshveer Singh (Inactive) added a comment - Hi Nishant, Issues reported in this with mappings are fixed, can you please have it checked on your side?
          Hide
          NalinB Nalin.Bhayana (Inactive) added a comment -

          This has been verified by Dushyant on CBES side.

          It is working fine now, so closing the ticket.

          Show
          NalinB Nalin.Bhayana (Inactive) added a comment - This has been verified by Dushyant on CBES side. It is working fine now, so closing the ticket.

            People

            Assignee:
            NishantK Nishant.Kondapaneni (Inactive)
            Reporter:
            mohd.belal Mohd Belal (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 8h Original Estimate - 8h
                8h
                Remaining:
                Time Spent - 12h 38m Remaining Estimate - 0.5h
                0.5h
                Logged:
                Time Spent - 12h 38m Remaining Estimate - 0.5h
                12h 38m