[DMS-2003] DMS API: To pull data that is collected in forms - Workterra Jira

Details

Type: New Feature
Status: In QA Testing
Priority: High
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: DMS Monthly Release - June 2020
Labels:
- DMS-CBAT

Company:
All Clients/Multiple Clients

Sprint:
April 2020 Release - Sprint 1, April 2020 Release - Sprint 2, May 2020 Release - Sprint 1, May 2020 Release - Sprint 2, June 2020 Release - Sprint 1, June 2020 Release - Sprint 2

Description

Objective: As an HR Manager, I want to be able to pull data that is collected in forms and be able to send it to a 3rd party so that I can integrate with a 3rd party HRIS/Onboarding solution.

Pre-requisites- I have DMS. I have a form set up in DMS that is collecting data.

Entry: A candidate fills out a form.

Exit: the data populates a table that is supported by an API/Webservice so it can be accessed by an integration provider

Acceptance criteria:

the API data structure is flexible to support the naming of custom fields.

Can key off of form e.g. Get FormName_FieldName

creates a unique candidate id(preferably not email address) to tie candidate from form to candidate in CBAT

Allows an API user to extract any field name captured

Allows API user to extract the form itself

Existing API : GET Url : /api/candidateProfile/{emailAddress}

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

apiresponse.json
376 kB
25/Jun/20 07:09 AM
DMS2003Json.Json
19 kB
01/Apr/20 11:46 PM
res_22042020.json
55 kB
22/Apr/20 03:48 AM
response.json
2 kB
17/Mar/20 03:56 AM

Issue Links

relates to

DMS-2233 Required non-mapped fields are stored and accessible via API

In QA Testing

Activity

Ascending order - Click to sort in descending order

Samir created issue - 13/Nov/19 12:29 PM

Samir made changes - 13/Nov/19 12:29 PM

Field	Original Value	New Value
Assignee	Samir [ samir ]	Harshveer Singh [ harshveer.singh ]

Narendra Kumar made changes - 24/Nov/19 08:52 PM

Sprint		Winter-2020 Sprint 4 [ 187 ]
Remaining Estimate		24h [ 86400 ]
Original Estimate		24h [ 86400 ]

Narendra Kumar made changes - 24/Nov/19 08:52 PM

Fix Version/s

Winter 2020 Enhancements [ 11314 ]

Narendra Kumar made changes - 24/Nov/19 08:52 PM

Fix Version/s		Winter 2020 CBAT Integration [ 11316 ]
Fix Version/s	Winter 2020 Enhancements [ 11314 ]

ShashiKant Mishra (Inactive) made changes - 08/Dec/19 08:55 PM

Sprint

Winter-2020 Sprint 4 [ 187 ]

Winter-2020 Sprint 4, Winter-2020 Sprint 5 [ 187, 189 ]

ShashiKant Mishra (Inactive) made changes - 22/Dec/19 08:36 PM

Sprint

Winter-2020 Sprint 4, Winter-2020 Sprint 5 [ 187, 189 ]

Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6 [ 187, 189, 190 ]

ShashiKant Mishra (Inactive) made changes - 05/Jan/20 08:38 PM

Sprint

Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6 [ 187, 189, 190 ]

Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7 [ 187, 189, 190, 193 ]

Narendra Kumar made changes - 27/Jan/20 09:04 PM

Sprint

Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7 [ 187, 189, 190, 193 ]

Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8 [ 187, 189, 190, 193, 197 ]

Narendra Kumar made changes - 02/Feb/20 08:43 PM

Sprint

Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8 [ 187, 189, 190, 193, 197 ]

Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Winter-2020 Sprint 9 [ 187, 189, 190, 193, 197, 198 ]

Narendra Kumar made changes - 03/Feb/20 01:01 AM

Sprint

Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Winter-2020 Sprint 2 [ 187, 189, 190, 193, 197, 198 ]

Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8 [ 187, 189, 190, 193, 197 ]

Narendra Kumar made changes - 19/Feb/20 08:46 PM

Sprint

Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8 [ 187, 189, 190, 193, 197 ]

Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 3 [ 187, 189, 190, 193, 197, 199 ]

Narendra Kumar made changes - 19/Feb/20 08:46 PM

Assignee

Harshveer Singh [ harshveer.singh ]

Harish.Sharma [ harishs ]

Narendra Kumar made changes - 02/Mar/20 01:23 AM

Sprint

Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 3 [ 187, 189, 190, 193, 197, 199 ]

Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 3, Spring-2020 - Sprint 4 [ 187, 189, 190, 193, 197, 199, 200 ]

Narendra Kumar made changes - 17/Mar/20 03:53 AM

Assignee

Harish.Sharma [ harishs ]

Narendra Kumar [ narendra.kumar ]

Narendra Kumar made changes - 17/Mar/20 03:53 AM

Status

To Do [ 10000 ]

In Progress [ 3 ]

Narendra Kumar made changes - 17/Mar/20 03:55 AM

Description

Objective: As an HR Manager, I want to be able to pull data that is collected in forms and be able to send it to a 3rd party so that I can integrate with a 3rd party HRIS/Onboarding solution.

Pre-requisities- I have DMS. I have a form set up in DMS that is collecting data.

Entry: A candidate fills out a form.

Exit: the data populates a table that is suported by an API/webservice so it can be accessed by an integration provider

Acceptance criteria:

* the API data structure is flexible to support the naming of custom fields.

* Can key off of form e.g. Get FormName_FieldName

* creates a unique candidate id(preferably not email address) to tie candidate from form to candidate in CBAT

* Allows an api user to extract any field name captured

* Allows API user to extract the form itself

Existing API : GET Url : /api/candidateProfile/\{emailAddress}

Objective: As an HR Manager, I want to be able to pull data that is collected in forms and be able to send it to a 3rd party so that I can integrate with a 3rd party HRIS/Onboarding solution.

Pre-requisites- I have DMS. I have a form set up in DMS that is collecting data.

Entry: A candidate fills out a form.

Exit: the data populates a table that is supported by an API/Webservice so it can be accessed by an integration provider

Acceptance criteria:

* the API data structure is flexible to support the naming of custom fields.

* Can key off of form e.g. Get FormName_FieldName

* creates a unique candidate id(preferably not email address) to tie candidate from form to candidate in CBAT

* Allows an API user to extract any field name captured

* Allows API user to extract the form itself

Existing API : GET Url : /api/candidateProfile/\{emailAddress}

Narendra Kumar made changes - 17/Mar/20 03:56 AM

Attachment

response.json [ 137987 ]

Hide

Permalink

Narendra Kumar added a comment - 17/Mar/20 03:58 AM

Hi Samir

Right now we are getting this response response.json. Now tell me which more information need to be added in this response.

Thanks

Narendra

Show

Narendra Kumar added a comment - 17/Mar/20 03:58 AM Hi Samir Right now we are getting this response response.json . Now tell me which more information need to be added in this response. Thanks Narendra

Permalink

Narendra Kumar logged work - 17/Mar/20 06:22 AM - edited

Time Spent:

3h

I tried with the existing API and find out the sp to make changes.

Narendra Kumar made changes - 17/Mar/20 09:45 PM

Sprint

Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 3, Spring-2020 - Sprint 4 [ 187, 189, 190, 193, 197, 199, 200 ]

Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 3, Spring-2020 - Sprint 4, Spring-2020 - Sprint 5 [ 187, 189, 190, 193, 197, 199, 200, 202 ]

Narendra Kumar made changes - 18/Mar/20 12:23 AM

Remaining Estimate	24h [ 86400 ]	21h [ 75600 ]
Time Spent		3h [ 10800 ]
Worklog Id	232946 [ 232946 ]

Narendra Kumar made changes - 18/Mar/20 12:23 AM

Worklog Id

232946 [ 232946 ]

Narendra Kumar made changes - 18/Mar/20 01:06 AM

Attachment

response.json [ 138048 ]

Narendra Kumar made changes - 18/Mar/20 01:07 AM

Attachment

response.json [ 138048 ]

Narendra Kumar made changes - 18/Mar/20 01:07 AM

Attachment

Response_New.json [ 138049 ]

Hide

Permalink

Narendra Kumar added a comment - 18/Mar/20 01:09 AM - edited

Hi Patrick Phillips

Please have a look at the attached response of the Existing API: GET Url: /api/candidateProfile/{emailAddress}

response.json is the old response

[^Response_New.json] is the new response that we will provide. I have added the documents also for that particular candidate. Please check it and let me know if you need any other things in the response.

cc: Samir, Shamooka Mohapatra

Show

Narendra Kumar added a comment - 18/Mar/20 01:09 AM - edited Hi Patrick Phillips Please have a look at the attached response of the Existing API: GET Url: /api/candidateProfile/{emailAddress} response.json is the old response [^Response_New.json] is the new response that we will provide. I have added the documents also for that particular candidate. Please check it and let me know if you need any other things in the response. cc: Samir , Shamooka Mohapatra

Permalink

Narendra Kumar logged work - 18/Mar/20 01:10 AM

Time Spent:

2h

Prepared the new response

Narendra Kumar made changes - 18/Mar/20 01:10 AM

Remaining Estimate	21h [ 75600 ]	19h [ 68400 ]
Time Spent	3h [ 10800 ]	5h [ 18000 ]
Worklog Id	232954 [ 232954 ]

Narendra Kumar made changes - 19/Mar/20 11:17 PM

Status

In Progress [ 3 ]

To Do [ 10000 ]

Hide

Permalink

Narendra Kumar added a comment - 23/Mar/20 09:42 PM

Hi Patrick Phillips

Have you checked this? Or any update on this?

cc: Amrendra Kumar, Samir

Show

Narendra Kumar added a comment - 23/Mar/20 09:42 PM Hi Patrick Phillips Have you checked this? Or any update on this? cc: Amrendra Kumar , Samir

Narendra Kumar made changes - 25/Mar/20 11:42 PM

Assignee

Narendra Kumar [ narendra.kumar ]

Patrick Phillips [ patrick.phillips ]

Narendra Kumar made changes - 31/Mar/20 12:22 AM

Assignee

Patrick Phillips [ patrick.phillips ]

Harish.Sharma [ harishs ]

Hide

Permalink

Narendra Kumar added a comment - 31/Mar/20 12:25 AM

Hi Harish.Sharma

We have to pull the complete data of a candidate as much as possible. Also please do not return any Id field or any integer value instead of returning its description. Like, do not return latestStatus as 11 just return latestStatus as "In Progress".

Show

Narendra Kumar added a comment - 31/Mar/20 12:25 AM Hi Harish.Sharma We have to pull the complete data of a candidate as much as possible. Also please do not return any Id field or any integer value instead of returning its description. Like, do not return latestStatus as 11 just return latestStatus as "In Progress".

Narendra Kumar made changes - 31/Mar/20 03:53 AM

Sprint

Permalink

Harish.Sharma (Inactive) logged work - 31/Mar/20 09:23 PM

Time Spent:

4h

<No comment>

Harish.Sharma (Inactive) made changes - 31/Mar/20 09:23 PM

Status

To Do [ 10000 ]

In Progress [ 3 ]

Harish.Sharma (Inactive) made changes - 31/Mar/20 09:23 PM

Remaining Estimate	19h [ 68400 ]	15h [ 54000 ]
Time Spent	5h [ 18000 ]	9h [ 32400 ]
Worklog Id	235534 [ 235534 ]

Permalink

Harish.Sharma (Inactive) logged work - 01/Apr/20 11:27 PM

Time Spent:

5h

<No comment>

Harish.Sharma (Inactive) made changes - 01/Apr/20 11:27 PM

Remaining Estimate	15h [ 54000 ]	10h [ 36000 ]
Time Spent	9h [ 32400 ]	14h [ 50400 ]
Worklog Id	235698 [ 235698 ]

Harish.Sharma (Inactive) made changes - 01/Apr/20 11:42 PM

Attachment

DMS2003Json.txt [ 139372 ]

Harish.Sharma (Inactive) made changes - 01/Apr/20 11:46 PM

Attachment

DMS2003Json.Json [ 139375 ]

Hide

Permalink

Harish.Sharma (Inactive) added a comment - 01/Apr/20 11:46 PM

Hi Narendra Kumar

Please verify the attached json file and let me know if any change required.

DMS2003Json.Json

Show

Harish.Sharma (Inactive) added a comment - 01/Apr/20 11:46 PM Hi Narendra Kumar Please verify the attached json file and let me know if any change required. DMS2003Json.Json

Harish.Sharma (Inactive) made changes - 01/Apr/20 11:46 PM

Attachment

DMS2003Json.txt [ 139372 ]

Permalink

Harish.Sharma (Inactive) logged work - 05/Apr/20 10:13 PM

Time Spent:

3h

<No comment>

Harish.Sharma (Inactive) made changes - 05/Apr/20 10:13 PM

Remaining Estimate	10h [ 36000 ]	7h [ 25200 ]
Time Spent	14h [ 50400 ]	17h [ 61200 ]
Worklog Id	236167 [ 236167 ]

Narendra Kumar made changes - 13/Apr/20 09:57 PM

Sprint

April 2020 Release - Sprint 1 [ 206 ]

Permalink

Harshveer Singh (Inactive) logged work - 15/Apr/20 11:30 AM

Time Spent:

2h

<No comment>

Narendra Kumar made changes - 15/Apr/20 09:47 PM

Assignee

Harish.Sharma [ harishs ]

Narendra Kumar [ narendra.kumar ]

Narendra Kumar made changes - 16/Apr/20 12:53 AM

Status

In Progress [ 3 ]

To Do [ 10000 ]

Harshveer Singh (Inactive) made changes - 16/Apr/20 01:18 AM

Remaining Estimate	7h [ 25200 ]	5h [ 18000 ]
Time Spent	17h [ 61200 ]	19h [ 68400 ]
Worklog Id	237977 [ 237977 ]

Narendra Kumar made changes - 16/Apr/20 11:14 PM

Status

To Do [ 10000 ]

In Progress [ 3 ]

Narendra Kumar made changes - 16/Apr/20 11:14 PM

Assignee

Narendra Kumar [ narendra.kumar ]

Harshveer Singh [ harshveer.singh ]

Narendra Kumar made changes - 19/Apr/20 10:54 PM

Sprint

April 2020 Release - Sprint 1 [ 206 ]

April 2020 Release - Sprint 1, April 2020 Release - Sprint 2 [ 206, 207 ]

Ashish Durani made changes - 21/Apr/20 11:14 PM

Status

In Progress [ 3 ]

In QA Testing [ 11901 ]

Ashish Durani made changes - 21/Apr/20 11:16 PM

Assignee

Harshveer Singh [ harshveer.singh ]

Prateek [ prateeks ]

Narendra Kumar made changes - 22/Apr/20 03:46 AM

Attachment

Response_New.json [ 138049 ]

Narendra Kumar made changes - 22/Apr/20 03:48 AM

Attachment

res_22042020.json [ 141694 ]

Hide

Permalink

Narendra Kumar added a comment - 22/Apr/20 03:50 AM

Hi Patrick Phillips

Now we are returning everything in the response. Just have a look at this res_22042020.json.

Amrendra Kumar please have a look at the attached response and let me know if anything needs to change.

cc: Samir

Show

Narendra Kumar added a comment - 22/Apr/20 03:50 AM Hi Patrick Phillips Now we are returning everything in the response. Just have a look at this res_22042020.json . Amrendra Kumar please have a look at the attached response and let me know if anything needs to change. cc: Samir

Narendra Kumar made changes - 22/Apr/20 03:50 AM

Assignee

Prateek [ prateeks ]

Patrick Phillips [ patrick.phillips ]

Narendra Kumar made changes - 29/Apr/20 11:35 PM

Link

This issue relates to DMS-2233 [ DMS-2233 ]

Narendra Kumar made changes - 06/May/20 11:02 PM

Sprint

April 2020 Release - Sprint 1, April 2020 Release - Sprint 2 [ 206, 207 ]

April 2020 Release - Sprint 1, April 2020 Release - Sprint 2, May 2020 Release - Sprint 1 [ 206, 207, 219 ]

Narendra Kumar made changes - 18/May/20 09:54 PM

Sprint

April 2020 Release - Sprint 1, April 2020 Release - Sprint 2, May 2020 Release - Sprint 1 [ 206, 207, 219 ]

April 2020 Release - Sprint 1, April 2020 Release - Sprint 2, May 2020 Release - Sprint 1, May 2020 Release - Sprint 2 [ 206, 207, 219, 220 ]

Narendra Kumar made changes - 31/May/20 10:59 PM

Sprint

April 2020 Release - Sprint 1, April 2020 Release - Sprint 2, May 2020 Release - Sprint 1, May 2020 Release - Sprint 2 [ 206, 207, 219, 220 ]

April 2020 Release - Sprint 1, April 2020 Release - Sprint 2, May 2020 Release - Sprint 1, May 2020 Release - Sprint 2, June 2020 Release - Sprint 1 [ 206, 207, 219, 220, 221 ]

Narendra Kumar made changes - 02/Jun/20 04:00 AM

Labels

DMS-CBAT

Narendra Kumar made changes - 02/Jun/20 04:00 AM

Fix Version/s		DMS Monthly Release - June 2020 [ 11906 ]
Fix Version/s	Winter 2020 CBAT Integration [ 11316 ]

Narendra Kumar made changes - 14/Jun/20 09:04 PM

Sprint

April 2020 Release - Sprint 1, April 2020 Release - Sprint 2, May 2020 Release - Sprint 1, May 2020 Release - Sprint 2, June 2020 Release - Sprint 1 [ 206, 207, 219, 220, 221 ]

April 2020 Release - Sprint 1, April 2020 Release - Sprint 2, May 2020 Release - Sprint 1, May 2020 Release - Sprint 2, June 2020 Release - Sprint 1, June 2020 Release - Sprint 2 [ 206, 207, 219, 220, 221, 222 ]

Narendra Kumar made changes - 14/Jun/20 09:11 PM

Assignee

Patrick Phillips [ patrick.phillips ]

Utkarsh.Katiyar [ utkarshk ]

Samir made changes - 17/Jun/20 09:51 PM

Assignee

Utkarsh.Katiyar [ utkarshk ]

Patrick Phillips [ patrick.phillips ]

Harshveer Singh (Inactive) made changes - 25/Jun/20 07:09 AM

Attachment

apiresponse.json [ 148971 ]

Hide

Permalink

Harshveer Singh (Inactive) added a comment - 25/Jun/20 07:10 AM

Added latest apiresponse.json response file.

CC: Samir Patrick Phillips

Show

Harshveer Singh (Inactive) added a comment - 25/Jun/20 07:10 AM Added latest apiresponse.json response file. CC: Samir Patrick Phillips

Transition	Time In Source Status	Execution Times

Narendra Kumar made transition - 16/Apr/20 12:53 AM

In Progress

To Do

17d 22h 53m

Narendra Kumar made transition - 16/Apr/20 11:14 PM

To Do

In Progress

137d 10h 51m

Ashish Durani made transition - 21/Apr/20 11:14 PM

In Progress

In QA Testing

People

Assignee:: Patrick Phillips (Inactive)

Reporter:: Samir

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 13/Nov/19 12:29 PM

Updated:: 25/Jun/20 07:10 AM

Time Tracking

Estimated:

24h

Remaining:

Logged:

19h