My requirement is like in database some defects are present
and i need to clean them.To be brief for example every
employee should have active assigments.So for those records
which are not having status as active or null ,i need to
update the roecords using API with the correct value.
Client will provide a flat file for the records whch are
defected.So i need to run the API for those records (flat
file)and update the data in database.
So my question is how to handle this requirement.Is there
any existing API for this purpose?If yes then please send
me the NAME.
How to update the records in the database using flatfile.
Any pointer will be appreciated.Thanks in advance.
- 1 Answers
- 2303 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / Vishakha Dutt
To handle this requirement, you can create a custom API using Oracle's REST Data Services (ORS) or SQL Developer Data Provider (SDDP). The API should accept the flat file as input and process each record to update the database. If you are using SDDP, you can use its data manipulation language (DML) capabilities to perform database operations. A sample API name could be 'UpdateEmployeeStatusAPI'. You would need to implement the necessary logic to read the flat file, validate the records, and execute the SQL update statement using your chosen development environment.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
