[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 ]

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 ]

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 ]

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 ]

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

Sprint

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 ]

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 ]

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

Attachment

DMS2003Json.txt [ 139372 ]

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 ]

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 ]

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 ]

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