-
Type:
New Feature
-
Status: Done
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: Enhancements - Fall
-
Labels:None
-
Company:All Clients/Multiple Clients
-
Epic Link:
Task Done:
- Call with Samir and Narendra for jira requirement
- Code debugging for company creation, person creation and file upload
- Prepare API documentation
Komal Barde (Inactive)
added a comment - Task Done :
Call with Samir and Narendra for jira requirement
Code debugging for company creation, person creation and file upload
Prepare API documentation
Hi
Please find attached DMS-1169_ETA.xls
document that contains ETA for DMS-1169.
Thanks,
Komal
CC:Samir, Swapnil Pandhare,Rohan J Khandave,Ganesh Sadawarte,Narendra Kumar
Komal Barde (Inactive)
added a comment - Hi
Please find attached DMS-1169_ETA.xls document that contains ETA for DMS-1169 .
Thanks,
Komal
CC: Samir , Swapnil Pandhare , Rohan J Khandave , Ganesh Sadawarte , Narendra Kumar Task Done:
- Analysis to get company data and insert it
- Analysis to get company person and insert it
- Analysis to move base64 string file to server
- Prepare ETA
Komal Barde (Inactive)
added a comment - Task Done:
Analysis to get company data and insert it
Analysis to get company person and insert it
Analysis to move base64 string file to server
Prepare ETA
Task Done:
- Register new company or get existing company id
- Register new person with email address or get existing person
- Unit testing
- Discussion with Swapnil
Komal Barde (Inactive)
added a comment - Task Done:
Register new company or get existing company id
Register new person with email address or get existing person
Unit testing
Discussion with Swapnil
Hi Samir,
Please find Candiadate Attachement Data.xls file that contains details of candidate upload file.
Thanks,
Komal
CC:Rohan J Khandave, Ganesh Sadawarte, Swapnil Pandhare
Komal Barde (Inactive)
added a comment - Hi Samir ,
Please find Candiadate Attachement Data.xls file that contains details of candidate upload file.
Thanks,
Komal
CC: Rohan J Khandave , Ganesh Sadawarte , Swapnil Pandhare
Hi Samir,
Please find updated DMS-1169_Updated_API.doc document for API details of upload files for a candidate.
Thanks,
Komal
CC:Rohan J Khandave, Swapnil Pandhare,Ganesh Sadawarte
Komal Barde (Inactive)
added a comment - Hi Samir ,
Please find updated DMS-1169_Updated_API.doc document for API details of upload files for a candidate.
Thanks,
Komal
CC: Rohan J Khandave , Swapnil Pandhare , Ganesh Sadawarte Timing of API:
- Register new person: 7 Sec
- Upload attachment (Given 3 files) : 75 Sec (1 File: 25 Sec) (This will vary depending on file size.)
CC:Rohan J Khandave,Swapnil Pandhare, Ganesh Sadawarte,Samir
Komal Barde (Inactive)
added a comment - - edited Timing of API :
Register new person: 7 Sec
Upload attachment (Given 3 files) : 75 Sec (1 File: 25 Sec) (This will vary depending on file size.)
CC: Rohan J Khandave , Swapnil Pandhare , Ganesh Sadawarte , Samir List of modified/added files:
- DMS/DMS.App/src/DMS_AppLogic/IntegrationLogic/ProvisioningApiLogic.cs
- DMS/DMS.App/src/DMS_AppLogic/Repository/IGenRepository.cs
- DMS/DMS.App/src/DMS_WebApi/Controllers/IntegrationAPI/ProvisioningAPIController.cs
- DMS/DMS.App/src/Entities/IntegrationDtos/CandidateFileDTO.cs
- DMS/DMS_App_Tests/ProvisioningApiTest.cs
Komal Barde (Inactive)
added a comment - - edited List of modified/added files :
DMS/DMS.App/src/DMS_AppLogic/IntegrationLogic/ProvisioningApiLogic.cs
DMS/DMS.App/src/DMS_AppLogic/Repository/IGenRepository.cs
DMS/DMS.App/src/DMS_WebApi/Controllers/IntegrationAPI/ProvisioningAPIController.cs
DMS/DMS.App/src/Entities/IntegrationDtos/CandidateFileDTO.cs
DMS/DMS_App_Tests/ProvisioningApiTest.cs
Hi Jilna,
Please find below end point object details:
Request Body:
{
CompanySourceProduct: "CBES",
CompanyLanguage: "EN",
CompanyName: "Harbinger Systems",
personemailAddress: "hbcandidate@hb.com" ,
uploadFilelist:[
,
{ file_name: "CandiadateProfileIDProof.gif", file_description: "Candidate DProof", file_content: "data:image/gif;base64,(Please Put base64 string)", orderID: 1, releaseID: 3, uploaderusername: "Career Builder" }]
}
Response Body:
{ "status": "success", "message": "File uploaded successfully.", "errorLevel1": "Information", "code": 201, "description": "File uploaded successfully." }Thanks,
Komal
Komal Barde (Inactive)
added a comment - - edited Hi Jilna ,
Please find below end point object details:
Request Body:
{
CompanySourceProduct: "CBES",
CompanyLanguage: "EN",
CompanyName: "Harbinger Systems",
personemailAddress: "hbcandidate@hb.com" ,
uploadFilelist:[
{ file_name: "CandiadateProfilePhoto.gif", file_description: "Candidate Profile Photo", file_content: "data:image/gif;base64,(Please Put base64 string)", orderID: 1, releaseID: 3, uploaderusername: "Career Builder" }
,
{ file_name: "CandiadateProfileIDProof.gif", file_description: "Candidate DProof", file_content: "data:image/gif;base64,(Please Put base64 string)", orderID: 1, releaseID: 3, uploaderusername: "Career Builder" }
]
}
Response Body:
{
"status": "success",
"message": "File uploaded successfully.",
"errorLevel1": "Information",
"code": 201,
"description": "File uploaded successfully."
}
Thanks,
Komal
CC: Samir , Swapnil Pandhare , Ganesh Sadawarte , Ravi Banda Hi Jilna,
Please find updated request body of file upload API :
HTTP Method : POST
Host: https://dmsapistage.workterra.net/
URL : /api/candidate/upload
Request body(Payload) :
{
"companyName": "Company Name",
"companySourceProduct": "CBSE",
"companyLanguage": "EN",
"personEmailAddress": "candidate@acc.com",
"uploadFileList":
[
{ "fileName": "file name", "fileDescription": "file description", "fileContent": "base 64 encoded file content", "orderId": "Order ID", "releaseId": "Release ID", "uploaderUserName": "File Uploader user name" }]
}
Thanks,
Komal
CC:Swapnil Pandhare,Ganesh Sadawarte,Samir
Komal Barde (Inactive)
added a comment - Hi Jilna ,
Please find updated request body of file upload API :
HTTP Method : POST
Host : https://dmsapistage.workterra.net/
URL : /api/candidate/upload
Request body(Payload) :
{
"companyName": "Company Name",
"companySourceProduct": "CBSE",
"companyLanguage": "EN",
"personEmailAddress": "candidate@acc.com",
"uploadFileList":
[
{
"fileName": "file name",
"fileDescription": "file description",
"fileContent": "base 64 encoded file content",
"orderId": "Order ID",
"releaseId": "Release ID",
"uploaderUserName": "File Uploader user name" }
]
}
Thanks,
Komal
CC: Swapnil Pandhare , Ganesh Sadawarte , Samir Hi Harshveer Singh,
Please find below details of upload file of candidate:
API Endpoint details:
HTTP Method : POST
Host: https://dmsapistage.workterra.net/
URL : /api/candidate/upload
Request body(Payload) :
{
"companyName": "Company Name",
"companySourceProduct": "CBSE",
"companyLanguage": "EN",
"personEmailAddress": "candidate@acc.com",
"uploadFileList":
[
{ "fileName": "file name", "fileDescription": "file description", "fileContent": "base 64 encoded file content", "orderId": "Order ID", "releaseId": "Release ID", " uploaderUserName": "File Uploader user name" }]
}
API Response:
On success below response will be return:
Table Structure Used:
| Table Name | Column Name | Comment |
|---|---|---|
| Person | ID | This API will check if person with given candidate email address is present in system, if present then upload file against id of that email address or create new person. |
| Attachment | ID | Identify column to refer each file upload. |
| Attachmentdetails | DocumentPath | File server path where candidate file is stored. |
| Attachmentdetails | DocumentName | DMS generated file name for upload purpose. |
| Attachmentdetails | PhysicalDocumentName | Actual file name given by API. |
| Attachmentdetails | AttachmentId | It will refer 'ID' column of 'Attachment' table. |
| Useruploadpostcomment | PersonID | It will refer 'ID' column of 'Person' table. |
| Useruploadpostcomment | PostComment | This field will store uploaded file description. |
| Useruploadpostcomment | AttachmentID | It will refer 'ID' column of 'Attachment' table. |
| Useruploadpostcomment | Uplodername | This field will store file up loader name. |
| Useruploadpostcomment | OrderID | This field will store file Order ID. |
| Useruploadpostcomment | ReleaseID | This field will store file Release ID. |
Thanks,
Komal
Komal Barde (Inactive)
added a comment - Hi Harshveer Singh ,
Please find below details of upload file of candidate:
API Endpoint details:
HTTP Method : POST
Host: https://dmsapistage.workterra.net/
URL : /api/candidate/upload
Request body(Payload) :
{
"companyName": "Company Name",
"companySourceProduct": "CBSE",
"companyLanguage": "EN",
"personEmailAddress": "candidate@acc.com",
"uploadFileList":
[
{
"fileName": "file name",
"fileDescription": "file description",
"fileContent": "base 64 encoded file content",
"orderId": "Order ID",
"releaseId": "Release ID", "
uploaderUserName": "File Uploader user name" }
]
}
API Response:
On success below response will be return:
{
"status": "success",
"message": "File uploaded successfully.",
"errorLevel1": "Information",
"code": 201,
"description": "File uploaded successfully."
}
Table Structure Used:
Table Name
Column Name
Comment
Person
ID
This API will check if person with given candidate email address is present in system, if present then upload file against id of that email address or create new person.
Attachment
ID
Identify column to refer each file upload.
Attachmentdetails
DocumentPath
File server path where candidate file is stored.
Attachmentdetails
DocumentName
DMS generated file name for upload purpose.
Attachmentdetails
PhysicalDocumentName
Actual file name given by API.
Attachmentdetails
AttachmentId
It will refer 'ID' column of 'Attachment' table.
Useruploadpostcomment
PersonID
It will refer 'ID' column of 'Person' table.
Useruploadpostcomment
PostComment
This field will store uploaded file description.
Useruploadpostcomment
AttachmentID
It will refer 'ID' column of 'Attachment' table.
Useruploadpostcomment
Uplodername
This field will store file up loader name.
Useruploadpostcomment
OrderID
This field will store file Order ID.
Useruploadpostcomment
ReleaseID
This field will store file Release ID.
Thanks,
Komal
CC: Swapnil Pandhare , Ganesh Sadawarte , Samir Hi Harshveer Singh,
Can you please look into Jilna's https://jira.workterra.net/browse/DMS-1169?focusedCommentId=264176&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-264176 comment ?
Thanks,
Komal
Komal Barde (Inactive)
added a comment - - edited Hi Harshveer Singh ,
Can you please look into Jilna 's https://jira.workterra.net/browse/DMS-1169?focusedCommentId=264176&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-264176 comment ?
Thanks,
Komal
CC: Swapnil Pandhare , Ganesh Sadawarte , Samir , Jilna File base 64 format:
data:[file type]/[file extension];base64,[base 64 content]
For eg. "data:file/txt;base64,VGVzdCBmaWxl"
Link used for getting base 64 content:
https://www.browserling.com/tools/file-to-base64
CC: Samir
Komal Barde (Inactive)
added a comment - File base 64 format:
data: [file type] / [file extension] ;base64, [base 64 content]
For eg. "data:file/txt;base64,VGVzdCBmaWxl"
Link used for getting base 64 content:
https://www.browserling.com/tools/file-to-base64
CC: Samir
Environment: OneIM-Preprod
API: api/candidate/upload
The API is verified for adding attachment. Able to add successfully. Refer screen capture.
So, marking jira Done.
Samir Sachin Hingole Hrishikesh Deshpande Rohan J Khandave Harshveer Singh
Hi Samir,
Please find DMS-1169.doc
document for API details of upload files for a candidate.
Thanks,
Komal
CC:Swapnil Pandhare, Ganesh Sadawarte, Rohan J Khandave, Narendra Kumar