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

          mohd.belal Mohd Belal (Inactive) created issue -
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Field Original Value New Value
          Assignee Samir [ samir ] Ganesh Sadawarte [ ganesh.sadawarte ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 05/Dec/19 02:16 AM - edited
          • Time Spent:
            7h 8m
             
            • Analysis & Discussion
            • Call with Gaurav & Belal
            • Checked template on dms stage
            • Clearing data for single template.
            • Checked payload and debug on local
            • Identified issue and try out solution on local
            • Provided corrected filed name details to client
            • Jira updates
          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
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status To Do [ 10000 ] In Progress [ 3 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 4h [ 14400 ]
          Worklog Id 215744 [ 215744 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Attachment CBES Payload Fields Details.xls [ 128381 ]
          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
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Issue Type New Feature [ 2 ] Bug [ 1 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Priority Critical [ 1 ] Medium [ 3 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Time Spent 4h [ 14400 ] 7h [ 25200 ]
          Worklog Id 215744 [ 215744 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Time Spent 7h [ 25200 ] 7h 8m [ 25680 ]
          Worklog Id 215744 [ 215744 ]
          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
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status In Progress [ 3 ] On Hold [ 10507 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Harshveer Singh [ harshveer.singh ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status On Hold [ 10507 ] To Do [ 10000 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 06/Dec/19 01:56 AM - edited
          • Time Spent:
            5.5h
             
            • Source field id correction on preproduction
            • Call with CBES team
            • Testing and payload correction provide to CBES team member.
            • Jira updates.
            • Call with Gaurav after field updation and checked contry and state issue.

             

          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Time Spent 7h 8m [ 25680 ] 10h 8m [ 36480 ]
          Worklog Id 215982 [ 215982 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Time Spent 10h 8m [ 36480 ] 11h 38m [ 41880 ]
          Worklog Id 215982 [ 215982 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Time Spent 11h 38m [ 41880 ] 13h 8m [ 47280 ]
          Worklog Id 215982 [ 215982 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 0.5h [ 1800 ]
          Time Spent 13h 8m [ 47280 ] 12h 38m [ 45480 ]
          Worklog Id 215982 [ 215982 ]
          narendra.kumar Narendra Kumar made changes -
          Sprint Winter-2020 Sprint 5 [ 189 ]
          Original Estimate 8h [ 28800 ]
          harshveer.singh Harshveer Singh (Inactive) made changes -
          Status To Do [ 10000 ] In Progress [ 3 ]
          Ashish.Durani Ashish Durani made changes -
          Status In Progress [ 3 ] In QA Testing [ 11901 ]
          Ashish.Durani Ashish Durani made changes -
          Assignee Harshveer Singh [ harshveer.singh ] Prateek [ prateeks ]
          harshveer.singh Harshveer Singh (Inactive) made changes -
          Status In QA Testing [ 11901 ] In Progress [ 3 ]
          harshveer.singh Harshveer Singh (Inactive) made changes -
          Assignee Prateek [ prateeks ] Harshveer Singh [ harshveer.singh ]
          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?
          harshveer.singh Harshveer Singh (Inactive) made changes -
          Assignee Harshveer Singh [ harshveer.singh ] Nishant.Kondapaneni [ nishantk ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint Winter-2020 Sprint 5 [ 189 ] Winter-2020 Sprint 5, Winter-2020 Sprint 6 [ 189, 190 ]
          harshveer.singh Harshveer Singh (Inactive) made changes -
          Status In Progress [ 3 ] In QA Testing [ 11901 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint Winter-2020 Sprint 5, Winter-2020 Sprint 6 [ 189, 190 ] Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7 [ 189, 190, 193 ]
          narendra.kumar Narendra Kumar made changes -
          Assignee Nishant.Kondapaneni [ nishantk ] Prateek [ prateeks ]
          narendra.kumar Narendra Kumar made changes -
          Sprint Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7 [ 189, 190, 193 ] Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8 [ 189, 190, 193, 197 ]
          narendra.kumar Narendra Kumar made changes -
          Sprint Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8 [ 189, 190, 193, 197 ] Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Winter-2020 Sprint 9 [ 189, 190, 193, 197, 198 ]
          PrateekS Prateek made changes -
          Assignee Prateek [ prateeks ] Nishant.Kondapaneni [ nishantk ]
          narendra.kumar Narendra Kumar made changes -
          Sprint Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2 [ 189, 190, 193, 197, 198 ] Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2, Spring-2020 - Sprint 3 [ 189, 190, 193, 197, 198, 199 ]
          narendra.kumar Narendra Kumar made changes -
          Sprint Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2, Spring-2020 - Sprint 3 [ 189, 190, 193, 197, 198, 199 ] Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2, Spring-2020 - Sprint 3, Spring-2020 - Sprint 4 [ 189, 190, 193, 197, 198, 199, 200 ]
          narendra.kumar Narendra Kumar made changes -
          Sprint Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2, Spring-2020 - Sprint 3, Spring-2020 - Sprint 4 [ 189, 190, 193, 197, 198, 199, 200 ] Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2, Spring-2020 - Sprint 3, Spring-2020 - Sprint 4, Spring-2020 - Sprint 5 [ 189, 190, 193, 197, 198, 199, 200, 202 ]
          narendra.kumar Narendra Kumar made changes -
          Sprint Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2, Spring-2020 - Sprint 3, Spring-2020 - Sprint 4, Spring-2020 - Sprint 5 [ 189, 190, 193, 197, 198, 199, 200, 202 ] Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2, Spring-2020 - Sprint 3, Spring-2020 - Sprint 4, Spring-2020 - Sprint 5, Spring-2020 - Sprint 6 [ 189, 190, 193, 197, 198, 199, 200, 202, 203 ]
          narendra.kumar Narendra Kumar made changes -
          Assignee Nishant.Kondapaneni [ nishantk ] Prateek [ prateeks ]
          narendra.kumar Narendra Kumar made changes -
          Sprint Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2, Spring-2020 - Sprint 3, Spring-2020 - Sprint 4, Spring-2020 - Sprint 5, Spring-2020 - Sprint 6 [ 189, 190, 193, 197, 198, 199, 200, 202, 203 ] April 2020 Release - Sprint 1 [ 206 ]
          PrateekS Prateek made changes -
          Assignee Prateek [ prateeks ] Nishant.Kondapaneni [ nishantk ]
          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.
          NalinB Nalin.Bhayana (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In QA Testing [ 11901 ] Done [ 10001 ]
          Transition Time In Source Status Execution Times
          Ganesh Sadawarte (Inactive) made transition -
          In Progress On Hold
          18h 49m 1
          Ganesh Sadawarte (Inactive) made transition -
          On Hold To Do
          40m 31s 1
          Harshveer Singh (Inactive) made transition -
          To Do In Progress
          5d 5h 59m 2
          Harshveer Singh (Inactive) made transition -
          In QA Testing In Progress
          1d 15h 57m 1
          Harshveer Singh (Inactive) made transition -
          In Progress In QA Testing
          18d 1h 14m 2
          Nalin.Bhayana (Inactive) made transition -
          In QA Testing Done
          108d 23h 23m 1

            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